Cassandra Exec CQL

This action allows you to execute one or more CassandraQL statements on a Cassandra cluster. You can use it to create or drop keyspaces, tables, indexes and so on. If all statements executed successfully the result will be true (success).

Options

  • Cassandra Connection: You can specify the name of the connection to use either as a fixed value or as a variable expression. There are buttons to the right of the input field to hel you manage the metadata.

  • CQL Script: You can enter one or more CQL statements ending with a semi-colon on a new line.

Example:

  1. CREATE KEYSPACE IF NOT EXISTS hop
  2. WITH replication = {'class':'SimpleStrategy', 'replication_factor' : 3}
  3. ;