How to switch Keyspace in Cassandra using CQL?

database cassandra cql cassandra-2.0 cql3
Pankaj picture Pankaj · Jan 4, 2017 · Viewed 22.8k times · Source

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 and then I have to connect again.

Answer

Pankaj picture Pankaj · Jan 4, 2017

To switch keyspaces I didn't find any other way but to use USE otherKeySpace;.

Related questions

Difference between partition key, composite key and clustering key in Cassandra?

I have been reading articles around the net to understand the differences between the following key types. But it just seems hard for me to grasp. Examples will definitely help make understanding better. primary key, partition key, composite key clustering …

Read More
How to define dynamic column families in cassandra

Here it is said, that no special effort is need to get a dynamic column family. But I always get an exception, when I try to set a value for an undefined column. I created a column family like this: …

Read More
Cassandra IN clause on index

Assume a simple table with one insert (or without this insert, doesn't really matter). CREATE TABLE test ( x int, y int, z int, PRIMARY KEY (x, y, z) ); create index z_index on test (z); insert into test(x, y, …

Read More