Getting Cassandra datacenter name in cqlsh

cassandracqlsh

How can I get the name of the datacenter in cqlsh?
It's required for the constructor of DCAwareRoundRobinPolicy.

Best Answer

cqlsh> use system;
cqlsh:system> select data_center from local;

data_center
-------------
datacenter1

Related Solutions

Clear equivalent of ‘show keyspaces’ in cqlsh 2

Very simple. Just enter this command in your cqlsh shell and enjoy

 select * from system.schema_keyspaces;

In C*3.x, we can simply use

 describe keyspaces

How to connect Cassandra to localhost using cqlsh

Check the cassandra.yaml file on the line with rpc_port : normally by default = 9160
Login to the machine hosting cassandra
Try cqlsh 127.0.0.1 9160 : should be ok in any case
try cqlsh [IP of host] 9160 : if ok then cassandra reachable from lan, if ok then cassandra is not reachable from lan but only localhost 127.0.0.1

Related Topic