How to list all the available keyspaces in Cassandra?

cassandra cassandra-cli
Shekhar picture Shekhar · Sep 10, 2013 · Viewed 206.6k times · Source

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?

Answer

Marco Ponzi picture Marco Ponzi · Jan 17, 2014

[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;

Related questions

How to configure cassandra for remote connection

I am trying to configure Cassandra Datastax Community Edition for remote connection on windows, Cassandra Server is installed on a Windows 7 PC, With the local CQLSH it connects perfectly to the local server. But when i try to connect with …

Read More
How to select data from a table and insert into another table?

I want to select specific fields of a table in cassandra and insert them into another table. I do this in sql server like this: INSERT INTO Users(name,family) SELECT name,family FROM Users How to to this in …

Read More
Cassandra read timeout

I am pulling big amount of data from cassandra 2.0, but unfortunately getting timeout exception. My table: CREATE KEYSPACE StatisticsKeyspace WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 3 }; CREATE TABLE StatisticsKeyspace.HourlyStatistics( KeywordId text, Date timestamp, HourOfDay int, Impressions int, Clicks int, AveragePosition …

Read More