Getting Cassandra datacenter name in cqlsh

cassandra cqlsh
palacsint picture palacsint · Oct 21, 2013 · Viewed 12.4k times · Source

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

Answer

palacsint picture palacsint · Oct 21, 2013 
cqlsh> use system;
cqlsh:system> select data_center from local;

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

Related questions

Cassandra cqlsh - connection refused

I've just started working with Cassandra (datastax), version 2.1.3 and cqlsh version 5.0.1. Cassandra starts up fine and the cluster is operational instantly. Cqlsh is not working (on any of the nodes) and emits the following error: Connection error: ('Unable to connect …

Read More
Cassandra cqlsh Unable to connect to any servers - 127.0.0.1:9160 (closed)> is already closed

I installed Cassandra on OSX. When trying to run cqlsh from /bin/, I get the following error: > Connection error: ('Unable to connect to any servers', {'127.0.0.1': > ConnectionShutdown('Connection <AsyncoreConnection(4522252560) > 127.0.0.1:9160 (closed)> is already closed',)}) I …

Read More
How to connect Cassandra to localhost using cqlsh?

I set rpc_port to the public IP address, and now I can connect to Cassandra just fine from an outside server. However, I cannot connect from the Cassandra server itself, using cqlsh I am getting an error.Thar are: …

Read More