How to list all the available keyspaces in Cassandra

Question

I am newbie in Cassandra and trying to implement one toy application using Cassandra  I had created one keyspace and few column families in my Cassandra DB but I forgot the name of my cluster   I am trying to find if there is any query which can list down all the available keyspaces   Anybody knows such a query or command

User · Answer

The DESCRIBE command is your friend  You can describe one keyspace  list keyspaces  one table or list all tables in keyspace  the cluster and much more   You can get the full idea by typing  HELP DESCRIBE in cqlsh      Connected to mscluster at 127 0 0 1 9042   cqlsh 5 0 1   Cassandra 3 8     CQL spec 3 4 2   Native protocol v4  Use HELP for help        cqlsh  HELP DESCRIBE       DESCRIBE  cqlsh only        DESC may be used as a shorthand          Outputs information about the connected Cassandra cluster  or about       the data objects stored in the cluster  Use in one of the following ways     lt omitted for brevity gt      DESCRIBE  lt your key space name gt  - describes the command used to create keyspace      cqlsh  DESCRIBE testkeyspace       CREATE KEYSPACE testkeyspace WITH   replication     class   SimpleStrategy    replication factor    3      AND durable writes   true     DESCRIBE keyspaces -  lists all keyspaces       cqlsh  DESCRIBE KEYSPACES       system schema  system              testkeyspace  system auth   system distributed  system traces    DESCRIBE TABLES - List all tables in current keyspace      cqlsh system  DESCRIBE TABLES       available ranges          peers               paxos   range xfers batches                   compaction history  batchlog   local        IndexInfo                sstable activity   size estimates  hints       views builds in progress  peer events   built views    DESCRIBE your table name or DESCRIBE TABLE your table name - Gives the table details    cqlsh system  DESCRIBE TABLE batchlog      CREATE TABLE system batchlog         id uuid PRIMARY KEY        data blob        version int        written at timestamp   WITH bloom filter fp chance   0 01       AND caching     keys    ALL    rows per partition    NONE         AND comment    DEPRECATED batchlog entries      omitted for brevity

User · Answer

DESCRIBE keyspaces to list all keysapces DESCRIBE keyspace https   docs datastax com en dse 5 1 cql cql cql reference cqlsh commands cqlshDescribeKeyspace html

User · Answer

Once logged in to cqlsh or cassandra-cli  run below commands   On cqlsh   desc keyspaces   or  describe keyspaces   or  select   from system schema keyspaces    On cassandra-cli   show keyspaces

User · Answer

Apart from above method  if you have opscenter installed    Go to data tab   there you will see all keyspcaces created by you and some system keyspaces  You can see all tables under individual keyspaces and also replicator factor for keyspace    for more details check below link  https   docs datastax com en opscenter 6 1 opsc online help opscDataModelingManagingKeyspace t html

User · Answer

Found it   show keyspaces command lists down all the keyspaces  I think earlier when I tried this command  I forgot to give last  s  in  keyspaces

User · Answer

login to cqlsh use below command to get names list of keyspaces present        SELECT keyspace name FROM system schema keyspaces

User · Answer

desc keyspaces will do it for you

User · Answer

DESC KEYSPACES will do the job    Also  If you want to describe schema of a particular keyspace you can use  DESC

User · Answer

describes and desc command will give list of keyspaces in the cluster Please find below output for more details   cqlsh gt  describe keyspaces reaper db      system auth  system distributed system schema  system       system traces   OR  cqlsh gt  desc keyspaces reaper db      system auth  system distributed system schema  system       system traces

User · Answer

To List all the available keyspaces in cassandra using cqlsh in CLI mode   Command   DESCRIBE keyspaces   Example   cqlsh gt  DESCRIBE keyspaces

User · Answer

Its very simple  Just give the below command for listing all keyspaces   Cqlsh  Describe keyspaces   If you want to check the keyspace in the system schema using the SQL query  below is the command    SELECT   FROM system schema keyspaces    Hope this will answer your question      You can go through the explanation on understanding and creating the keyspaces from below resources    Documentation   https   docs datastax com en cql 3 1 cql cql reference create keyspace r html https   www i2tutorials com cassandra-tutorial cassandra-create-keyspace

User · Answer

cqlsh 4 1 0   Cassandra 2 0 4   CQL spec 3 1 1   Thrift protocol 19 39 0   Currently  the command to use is   DESCRIBE keyspaces

User · Answer

To see all the keyspaces on your Apache Cassandra NoSQL Database Server use the command    gt  DESCRIBE KEYSPACES

User · Answer

login to cqlsh  desc keyspaces  select   from system schema keyspaces

User · Answer

I suggest a combination of grep and awk   root DC1-Node1  home  nodetool tablestats   grep  Keyspace      awk -F       print  2    system traces  system  system distributed  system schema  device tool  system tool

User · Answer

If you want to do this outside of the cqlsh tool you can query the schema keyspaces table in the system keyspace  There s also a table called schema columnfamilies which contains information about all tables   The DESCRIBE and SHOW commands only work in cqlsh and cassandra-cli

[cassandra] How to list all the available keyspaces in Cassandra?

Examples related to cassandra

Examples related to cassandra-cli