Apache Cassandra

Execute queries to a cassandra cluster with cqlsh.

Type: bash

Configuration

Name	Required	Description
`CQLSH_KEYSPACE`	yes	The keyspace target
`CQLSH_HOST`	yes	The host of the Cassandra cluster
`CQLSH_PORT`	no	The Vault Token. Defaults to `9043`
`CQLSH_USER`	no	The user to connect in the Cassandra cluster.
`CQLSH_PASSWD`	no	The password to connect in the Cassandra cluster.

Create a connection

shell
hoop admin create conn my-cqlsh-test -a <agent> \
  -e CQLSH_KEYSPACE=<keyspace> \
  -e CQLSH_HOST=<host> \
  -e CQLSH_USER=<user> \
  -e CQLSH_PASSWD=<user> \
 -- cqlsh

To add more options to the command line, update the command of the connection.

Examples

Then it's possible to run queries into a Cassandra connection

shell
hoop exec my-cqlsh-test -i 'SELECT * FROM table1;'