RE: CQL get unique row keys ?

2014-02-15 Thread Andrew Cobley
Thanks, worked a treat ! Andy From: DuyHai Doan Sent: 15 February 2014 18:51 To: user@cassandra.apache.org Subject: Re: CQL get unique row keys ? Hello Andy Since C* 2.0.1 it is possible to list all distinct partition keys (not clustering keys) with

Re: CQL get unique row keys ?

2014-02-15 Thread DuyHai Doan
Hello Andy Since C* 2.0.1 it is possible to list all distinct partition keys (not clustering keys) with: SELECT DISTINCT pk FROM More info on the feature here: https://issues.apache.org/jira/browse/CASSANDRA-4536 This query is quite efficient because the key cache is used most of the tim

CQL get unique row keys ?

2014-02-15 Thread Andrew Cobley
I may be missing something here, but is there a way in cql to get all unique row keys in a column family(table) ? I’ve created a table like this: CREATE TABLE totp ( artist varchar, track varchar, appearance_type varchar, PRIMARY KEY ((artist),track) ) WITH CLUSTERING ORDER BY (track asc); an