incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jimmy Lin <>
Subject get all row keys of a table using CQL3
Date Wed, 24 Jul 2013 05:18:09 GMT
I want to fetch all the row keys of a table using CQL3:

select id from mytable limit 9999999

For this query, does the node need to wait for all rows return from all
other nodes before returning the data to the client(I am using astyanax) ?
In other words, will this operation create a lot of load to the initial
node receiving the request?

if my table is big, I have to make sure the limit is set to a big enough
number, such that I can get all the result. Seems like I have to do a
count(*) to be sure....
is there any alternative(always return all the rows)?

if my id is a timeuuid, is it better to  combine the result from couple of
the following cql to obtain all keys?
select id from mytable where id t < minTimeuuid('2013-02-02 10:00+0000')
limit 20000
select id from mytable where id t > maxTimeuuid('2013-02-02 10:00+0000')
limit 20000


View raw message