Access to Cassandra

Owned by Olivier Tavard
Last updated: 20 Mar, 2024 by Cedric
1 min read

Valid from Datafari X.X

If you need to access to Cassandra (into main server if you are in multiservers mode), this is how to do it.

Do a SSH connection to the server than go to Cassandra folder (replace $DATAFARI_HOME with the path to your Datafari) :

cd $DATAFARI_HOME/cassandra

Connect to Cassandra thanks to cqlsh :

bin/cqlsh

You will obtain this screen with the cqlsh prompt :

Then enter this command to be connected to the datafari keyspace :

USE datafari ;

To see all the tables present, use this command :

Finally to do a select query into a table, you can use SELECT command. For example, if I want to display all the users the command will be :