How to list column families in keyspace?

cassandra cassandra-2.0 cql3 cqlsh
newbie picture newbie · Mar 29, 2014 · Viewed 34.4k times · Source

How can I get list of all column families in keyspace in Cassandra using CQL 3?

Answer

Aaron picture Aaron · Mar 31, 2014

Or even more simply (if you are using cqlsh), switch over to your keyspace with use and then execute describe tables:

cqlsh> use products;
cqlsh:products> describe tables;

itemmaster    itemhierarchy         companyitemfavorites
testtable

Note: The describe command is specific to cqlsh only.

Related questions

How do secondary indexes work in Cassandra?

Suppose I have a column family: CREATE TABLE update_audit ( scopeid bigint, formid bigint, time timestamp, record_link_id bigint, ipaddress text, user_zuid bigint, value text, PRIMARY KEY ((scopeid, formid), time) ) WITH CLUSTERING ORDER BY (time DESC) With two …

Read More
How to switch Keyspace in Cassandra using CQL?

I used USE billKeyspace; to enter a keyspace and start using it. Now I want to exit this keyspace and enter another keyspace. How to do that? If I use exit; or quit; it exits out of cql session itself …

Read More
Cassandra "no viable alternative at input"

I am trying to insert a simple row into the table. Can someone point out what is happening here ? CREATE TABLE recommendation_engine_poc.user_by_category ( game_category text, customer_id text, amount double, game_date timestamp, PRIMARY KEY (…

Read More