cqlsh connecting to remote node

Question

question

pramod.dba31_92912 asked Feb 10, '20 Cedrick Lunven edited Feb 10, '20

cqlsh connecting to remote node

How to enable cqlsh connecting to remote node.

Is it only possible by enabling thrift(confused as thrift was depreciated).

cassandra

10 |1000

Attachments: Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

DataStax Enterprise is powered by the best distribution of Apache Cassandra ™

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.

Privacy Policy Terms of Use

Answer 1 · 2020-02-10T16:02:12Z

Cedrick Lunven answered Feb 10, '20 Cedrick Lunven edited Feb 10, '20

Hi @pramod.dba31_92912 thank you for message,

Cqlsh interact with Cassandra node through CQL Binary Protocol. As such its communicate with native_transport_port port (default is 9042) and not THRIFT (which used to be something like 9160).

To connect CQLSH to remote node simply use

cqlsh <public_ip_node>

You can find more Documentation here : https://docs.datastax.com/en/ddaccql/doc/cql/cql_reference/cqlsh_commands/cqlsh.html

As a side note Datastax provides a standalone version of cqlsh, you don't have to install Cassandra locally anymore : https://downloads.datastax.com/#cqlsh

Share

10 |1000

Attachments: Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

question