How do I get all the keys that are stored in the Cassandra column family with pycassa?

python cassandra pycassa
Switch picture Switch · Mar 12, 2010 · Viewed 7.7k times · Source

Is anyone having experience working with pycassa I have a doubt with it. How do I get all the keys that are stored in the database?

well in this small snippet we need to give the keys in order to get the associated columns (here the keys are 'foo' and 'bar'),that is fine but my requirement is to get all the keys (only keys) at once as Python list or similar data structure. 

cf.multiget(['foo', 'bar'])
{'foo': {'column1': 'val2'}, 'bar': {'column1': 'val3', 'column2': 'val4'}}

Thanks.

Answer

Jim Carroll picture Jim Carroll · Mar 29, 2010

try: 

    list(cf.get_range().get_keys())

more good stuff here: http://github.com/vomjom/pycassa

Related questions

best Cassandra library/wrapper for Python?

I found lazyboy and pycassa - maybe there are others too. I've seen many sites recommending lazyboy. IMHO the project seems dead, see https://www.ohloh.net/p/compare?project_0=pycassa&project_1=lazyboy So what's the best option for …

Read More
What causes "no viable alternative at input 'None'" error with Cassandra CQL

I'm attempting to insert a modified document back to Cassandra DB with a new key. I'm having hard time figuring out what is the issue the error message is pointing at. When looking for others that have had similar problems …

Read More
How to insert a datetime into a Cassandra 1.2 timestamp column

IMPORTANT If you are dealing with this problem today, use the new cassandra-driver from datastax (i.e. import cassandra) since it solves most of this common problems and don't use the old cql driver anymore, it is obsolete! This question …

Read More