DataStax Support Forums » Topic: Can I get number of columns by rowkey in CQL?

DataStax Support Forums » Topic: Can I get number of columns by rowkey in CQL? http://www.datastax.com/support-forums/topic/can-i-get-number-of-columns-by-rowkey-in-cql Software, Support, and Training for Apache Cassandra en-US Mon, 20 May 2013 12:48:11 +0000 http://bbpress.org/?v=1.0.3 <![CDATA[Search]]> q http://www.datastax.com/support-forums/search.php Anonymous on "Can I get number of columns by rowkey in CQL?" http://www.datastax.com/support-forums/topic/can-i-get-number-of-columns-by-rowkey-in-cql#post-1918 Wed, 16 May 2012 01:50:10 +0000 Anonymous 1918@http://www.datastax.com/support-forums/ <a href="http://www.clearance-polo-shirts.com" title="clearance polo shirts ">clearance polo shirts</a> are also referred to as "polos" in addition to grew to become so famous about world of golf training; men and women started out getting in touch with them world of golf shirts. However the thoughts "<a href="http://www.clearance-polo-shirts.com" title="polo ralph lauren outlet online ">polo ralph lauren outlet online </a> " in addition to "golf shirt" are used interchangeably, the word "polo shirt" is actually more popular. Embroidered <a href="http://www.clearance-polo-shirts.com" title="hollister outlet online">hollister outlet online</a> tend to be used with regard to organization, casual in addition to recreational activities<a href="http://www.clearance-polo-shirts.com">http://www.clearance-polo-shirts.com</a>. thepaul on "Can I get number of columns by rowkey in CQL?" http://www.datastax.com/support-forums/topic/can-i-get-number-of-columns-by-rowkey-in-cql#post-1824 Wed, 02 May 2012 19:31:20 +0000 thepaul 1824@http://www.datastax.com/support-forums/ Confirmed, there's a bug here in the CQL3 parser- it doesn't treat the * right. Use "count(1)" instead for now; it is precisely equivalent. This is fixed in <a href="https://issues.apache.org/jira/browse/CASSANDRA-4185" rel="nofollow">https://issues.apache.org/jira/browse/CASSANDRA-4185</a> . Anonymous on "Can I get number of columns by rowkey in CQL?" http://www.datastax.com/support-forums/topic/can-i-get-number-of-columns-by-rowkey-in-cql#post-1816 Tue, 01 May 2012 20:56:43 +0000 Anonymous 1816@http://www.datastax.com/support-forums/ [cqlsh 2.2.0 | Cassandra 1.1.0 | CQL spec 3.0.0 | Thrift protocol 19.30.0] Use HELP for help. cqlsh> use demo; drop COLUMNFAMILY isbn_price_v3k3; CREATE COLUMNFAMILY isbn_price_v3k3 (isbn varchar, price float, listing_id int, qty int, obj varchar, PRIMARY KEY (isbn, price, listing_id) ); insert into isbn_price_v3k3(isbn, price, listing_id, obj) values ('111222333444',1.2,1001,'axxxxxxxxx'); insert into isbn_price_v3k3(isbn, price, listing_id, obj) values ('111222333444',1.2,1002,'axxxxxxxxx'); insert into isbn_price_v3k3(isbn, price, listing_id, obj) values ('111222333444',1.2,1003,'axxxxxxxxx'); insert into isbn_price_v3k3(isbn, price, listing_id, obj) values ('111222333444',5.5,1004,'axxxxxxxxx'); insert into isbn_price_v3k3(isbn, price, listing_id, obj) values ('111222333444',5.5,1005,'axxxxxxxxx'); insert into isbn_price_v3k3(isbn, price, listing_id, obj) values ('111222333444',1.2, 995,'axxxxxxxxx'); insert into isbn_price_v3k3(isbn, price, listing_id, obj) values ('111222333444',5.5, 978,'bxxxxxxxxx'); cqlsh:demo> SELECT isbn, price FROM isbn_price_v3 where isbn='111222333444'; isbn | price --------------+------- 111222333444 | 2.2 111222333444 | 3.4 111222333444 | 5.5 111222333444 | 7.1 111222333444 | 7.2 111222333444 | 7.3 111222333444 | 9.8 cqlsh:demo> SELECT count(*) FROM isbn_price_v3 where isbn='111222333444'; Bad Request: Only COUNT(*) and COUNT(1) operations are currently supported. cqlsh:demo> SELECT count(1) FROM isbn_price_v3 where isbn='111222333444'; count ------- 1 It still didn't work. Thanks, Charlie|DBA Anonymous on "Can I get number of columns by rowkey in CQL?" http://www.datastax.com/support-forums/topic/can-i-get-number-of-columns-by-rowkey-in-cql#post-1815 Tue, 01 May 2012 20:51:30 +0000 Anonymous 1815@http://www.datastax.com/support-forums/ It didn't work on my local CQL 3.0. FYI, $>cqlsh --cql3 Connected to MyCluster at xxx:9160. [cqlsh 2.2.0 | Cassandra 1.1.0 | CQL spec 3.0.0 | Thrift protocol 19.30.0] Use HELP for help. cqlsh> use demo; cqlsh:demo> SELECT count(*) FROM demo.c1 where id=1; Bad Request: Only COUNT(*) and COUNT(1) operations are currently supported. cqlsh:demo> SELECT count(1) FROM demo.c1 where id=1; count ------- 1 Thanks, Charlie | DBA Anonymous on "Can I get number of columns by rowkey in CQL?" http://www.datastax.com/support-forums/topic/can-i-get-number-of-columns-by-rowkey-in-cql#post-1338 Thu, 08 Mar 2012 18:01:18 +0000 Anonymous 1338@http://www.datastax.com/support-forums/ Sure. I'll test it after CQL3.0 is released. jbellis on "Can I get number of columns by rowkey in CQL?" http://www.datastax.com/support-forums/topic/can-i-get-number-of-columns-by-rowkey-in-cql#post-1335 Thu, 08 Mar 2012 05:00:23 +0000 jbellis 1335@http://www.datastax.com/support-forums/ Like I said, you need to declare a composite PK for this, which is only supported in 1.1. Anonymous on "Can I get number of columns by rowkey in CQL?" http://www.datastax.com/support-forums/topic/can-i-get-number-of-columns-by-rowkey-in-cql#post-1334 Wed, 07 Mar 2012 23:48:33 +0000 Anonymous 1334@http://www.datastax.com/support-forums/ Hi Jonathan Ellis and Nickmbailey, Thanks for the reply. I'll try composite PK on Cassandra 1.1 later. FYI, It doesn't work on Cassandra 1.0.7. ;) /home/cassandra>cqlsh Connected to Test Cluster at localhost:9160. [cqlsh 2.0.0 | Cassandra 1.0.7 | CQL spec 2.0.0 | Thrift protocol 19.20.0] Use HELP for help. cqlsh> cqlsh> CREATE KEYSPACE demo with strategy_class = 'SimpleStrategy' and strategy_options:replication_factor=1; cqlsh> use demo; cqlsh:demo> CREATE COLUMNFAMILY c1 (id int PRIMARY KEY) ... WITH comparator=varchar AND default_validation=int; cqlsh:demo> update c1 set a01 =1 where id = 1; cqlsh:demo> update c1 set a02 =1 where id = 1; cqlsh:demo> update c1 set a03 =1 where id = 1; cqlsh:demo> update c1 set a04 =1 where id = 1; cqlsh:demo> update c1 set a05 =1 where id = 1; cqlsh:demo> update c1 set a06 =1 where id = 1; cqlsh:demo> update c1 set a07 =1 where id = 1; cqlsh:demo> update c1 set a08 =1 where id = 1; cqlsh:demo> update c1 set a09 =1 where id = 1; ... cqlsh:demo> update c1 set a25 =1 where id = 1; cqlsh:demo> cqlsh:demo> cqlsh:demo> SELECT count(*) FROM demo.c1 where id=1; count | 1 | Thanks, Charlie | DBA jbellis on "Can I get number of columns by rowkey in CQL?" http://www.datastax.com/support-forums/topic/can-i-get-number-of-columns-by-rowkey-in-cql#post-1328 Wed, 07 Mar 2012 18:29:37 +0000 jbellis 1328@http://www.datastax.com/support-forums/ That's correct, but to elaborate, you would need to define a composite PK on that columnfamily and then use the *partition key* in the WHERE clause. See <a href="http://www.datastax.com/dev/blog/schema-in-cassandra-1-1" rel="nofollow">http://www.datastax.com/dev/blog/schema-in-cassandra-1-1</a> for an explanation. Composite PK is only supported in Cassandra 1.1. nickmbailey on "Can I get number of columns by rowkey in CQL?" http://www.datastax.com/support-forums/topic/can-i-get-number-of-columns-by-rowkey-in-cql#post-1327 Wed, 07 Mar 2012 16:42:12 +0000 nickmbailey 1327@http://www.datastax.com/support-forums/ <a href="http://www.datastax.com/docs/1.0/references/cql/SELECT" rel="nofollow">http://www.datastax.com/docs/1.0/references/cql/SELECT</a> You should be able to do: SELECT count(*) FROM <keyspace>.<columnfamily> WHERE KEY = <key> Anonymous on "Can I get number of columns by rowkey in CQL?" http://www.datastax.com/support-forums/topic/can-i-get-number-of-columns-by-rowkey-in-cql#post-1310 Tue, 06 Mar 2012 19:14:46 +0000 Anonymous 1310@http://www.datastax.com/support-forums/ E.g. like get_count(key) in pycassa. Or, when will this be implemented in CQL? Thanks, Charlie | DBA