Delete Cassandra (NoSQL)

Synopsis

This operator deletes data from a Cassandra table. The input example set is expected to have an ID attribute which is used to define the rows that will be deleted from Cassandra.

Description

The Delete Cassandra operator is used to delete data from a Cassandra table.

The data to be deleted is defined by the ID attribute of the provided example set. If the selected table contains a compound primary key, additional attributes can be added to the key with the parameter 'additional_primary_keys'.

Input

  • input (Data Table)

    The example set that defines which data should be deleted from the Cassandra database.

Output

  • output (Data Table)

    The passed through example set.

Parameters

  • conncetion The connection details for the Cassandra connection have to be specified. If you have already configured a Cassandra connection, you can select it from the drop-down list. If you have not configured a Cassandra connection yet, select the Cassandra icon right to the drop-down list. Create a new Cassandra connection in the Manage connections box. The contact points and keyspace name are mandatory. Range: configurable
  • consistency_level The consistency level for the Cassandra query. The consistency level defines how many Cassandra nodes have to respond to the query in order to be successful. Possible levels are: ONE, TWO, THREE, QUORUM, ALL, ANY
    • ONE: A write must be written at least to one node.
    • TWO: A write must be written at least to two nodes.
    • THREE: A write must be written at least to three nodes.
    • QUORUM: A write must be written at least on a quorum of nodes. A quorum is calculated as (rounded down to a whole number): (replication_factor / 2) + 1. For example, with a replication factor of 3, a quorum is 2 (can tolerate 1 node down). With a replication factor of 6, a quorum is 4 (can tolerate 2 nodes down).
    • ALL: A write must be written on all nodes in the cluster for that row key.
    • ANY: A write must be written to at least one node
    Range: selection
  • table_name Specify the table from which data should be deleted. Range: string
  • batch_size Define the maximum number of rows which should be deleted with one request. Range: integer
  • primary_key_attributes If the selected Cassandra table has a compound primary key this parameter allows you to add more attributes to the primary key. Range: enumeration