/
Access to Cassandra

Access to Cassandra

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 :