DataStax Support Forums » Topic: Question for hector CQL driver API

DataStax Support Forums » Topic: Question for hector CQL driver API http://www.datastax.com/support-forums/topic/question-for-hector-cql-driver-api Software, Support, and Training for Apache Cassandra en-US Wed, 19 Jun 2013 16:18:32 +0000 http://bbpress.org/?v=1.0.3 <![CDATA[Search]]> q http://www.datastax.com/support-forums/search.php mailme365 on "Question for hector CQL driver API" http://www.datastax.com/support-forums/topic/question-for-hector-cql-driver-api#post-6533 Mon, 17 Sep 2012 14:21:38 +0000 mailme365 6533@http://www.datastax.com/support-forums/ Thank you Srini, I updated code following the link you provided, it worked. Thanks. Srini on "Question for hector CQL driver API" http://www.datastax.com/support-forums/topic/question-for-hector-cql-driver-api#post-6477 Fri, 14 Sep 2012 10:56:16 +0000 Srini 6477@http://www.datastax.com/support-forums/ Already answered here, <a href="http://stackoverflow.com/questions/7732651/how-to-use-cql-queries-to-get-different-datatypes-out-of-cassandra-with-java-cli" rel="nofollow">http://stackoverflow.com/questions/7732651/how-to-use-cql-queries-to-get-different-datatypes-out-of-cassandra-with-java-cli</a> mailme365 on "Question for hector CQL driver API" http://www.datastax.com/support-forums/topic/question-for-hector-cql-driver-api#post-6475 Fri, 14 Sep 2012 09:14:12 +0000 mailme365 6475@http://www.datastax.com/support-forums/ Hi All, Following Hector's cql code examples, I created an example and I could execute this example successfully. However, when reviewing the source code, I have a question for it. Here is the source code I created: Cluster tutorialCluster = HFactory.getOrCreateCluster("TutorialCluster", "16.158.81.59:9160"); ConfigurableConsistencyLevel ccl = new ConfigurableConsistencyLevel(); ccl.setDefaultReadConsistencyLevel(HConsistencyLevel.ONE); Keyspace keyspace = HFactory.createKeyspace("Tutorial", tutorialCluster, ccl); CqlQuery<String,String,String> cqlQuery = new CqlQuery<String,String,String>(keyspace, se, se, se); cqlQuery.setQuery("select * from testcql"); QueryResult<CqlRows<String,String,String>> result = cqlQuery.execute(); CqlRows<String,String,String> rows = result.get(); System.out.println("size is: " + rows.getList().size()); And here is the testcql column family I created for this example: create column family testcql with comparator = 'UTF8Type' and default_validation_class = 'UTF8Type' and key_validation_class = 'UTF8Type'; As I said, the code could run successfully, and I'm able to get the total rows for the column family testcql. However, I'm very confused with "CqlQuery<String,String,String>" declaration, I know the three <String> is for the key type, value name type and value type, but if I create a column family with multiple column name type and column value type, then, how do I declare CqlQuery? For example, when I create a table using cqlsh as below: create table temptest (id int, value1 varchar, value2 int, primary key (id)); And I describe the table in cassandra-cli: [default@demodb] describe temptest; ColumnFamily: temptest Key Validation Class: org.apache.cassandra.db.marshal.Int32Type Default column value validator: org.apache.cassandra.db.marshal.UTF8Type Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type GC grace seconds: 864000 Compaction min/max thresholds: 4/32 Read repair chance: 0.1 DC Local Read repair chance: 0.0 Replicate on write: true Caching: KEYS_ONLY Bloom Filter FP chance: default Built indexes: [] Column Metadata: Column Name: value2 Validation Class: org.apache.cassandra.db.marshal.Int32Type Column Name: value1 Validation Class: org.apache.cassandra.db.marshal.UTF8Type Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy Compression Options: sstable_compression: org.apache.cassandra.io.compress.SnappyCompressor For this table(column family), how do we declare CqlQuery since the value could be a number or a String ? Thanks.