Cassandra Exec CQL

The Cassandra Exec CQL action executes one or more CassandraQL statements on a Cassandra cluster.

You can use it to create or drop key spaces, 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. ;