Properties reference: Cassandra Connector

This topic lists all properties that you can set to configure the stage.

Connection

For more information, see the Defining a connection to Cassandra data source topic.

Cluster contact points
Multiple contact points (host names or IPs) of the target Cassandra cluster, separated by semicolon
  • Type: string
  • Default: hostname:port
Local datacenter
The name of the datacenter local to defined contact points
  • Type: string
  • Default: Cassandra
Protocol version
CQL native protocol version to connect to the Cassandra cluster
  • Type: selection
  • Default: Default
  • Values:
    • Default
    • Newest beta
    • DSE_V2 (DSE 6.0/6.7/6.8)
    • DSE_V1 (DSE 5.1)
    • V6 (4.0.0, beta)
    • V5 (3.10.0)
    • V4 (2.2.0, 3.0.0)
    • V3 (2.1.0)
    • V2 (2.0.0, not supported)
    • V1 (1.2.0, not supported)
Cassandra client jars
Provide the path (without wildcards) to the directory or directories containing Cassandra client jars or list of jars separated by semicolon
  • Type: string
  • Default: $(DSHOME)/../DSComponents/bin/cassandra/CassandraConnector-ThirdParty.jar
Authentication
Authentication configuration
  • Type: category
Authentication method
Authentication method used in connection to Cassandra cluster
  • Type: selection
  • Default: None
  • Values:
    • None
    • Password authentication
    • Kerberos
User name
The name of the user used to connect to Cassandra cluster
  • Type: string
  • Default: dsadm
Password
The user's password used to connect to Cassandra cluster
  • Type: protected string
  • Default: dsadm
The path to the JAAS configuration file
The path to the file containing Kerberos connection properties, like for example the path to the keytab file, the name of the principal used to login to Cassandra
  • Type: string
  • Default: /path_to_jaas_file
Use SSL/TLS
Use SSL/TLS to secure connection between client and Cassandra cluster
  • Type: boolean
  • Default: false
Use client-to-node encryption
The traffic between client and cluster nodes is encrypted and the client verifies the identity of the Cassandra nodes it connects to
  • Type: boolean
  • Default: false
Keystore path
The path to your keystore file
  • Type: string
Keystore password
Provide the password that was used when generating the keystore
  • Type: protected string
Use client certificate authentication
With this option Cassandra nodes verify the identity of the client
  • Type: boolean
  • Default: false
Truststore path
The path to your truststore file
  • Type: string
Truststore password
Provide the password that was used when generating the truststore
  • Type: protected string
Compression type
The type of compression of transport-level requests and responses
  • Type: selection
  • Default: No compression
  • Values:
    • No compression
    • LZ4
    • Snappy

Usage

Enable quoted identifiers
Specifies whether or not to enclose database object names in quotes when generating CQL statements
  • Type: boolean
  • Default: false
Keyspace name
The name of the keyspace in the target Cassandra database
  • Type: string
  • Default: default
Table name
The name of the table in the target Cassandra database
  • Type: string
  • Default: table
Use JSON encoded map for a single row
Enables selecting and inserting a single row as a JSON encoded map
  • Type: boolean
  • Default: false
Modification type
Chose the type of modification that you would like perform
  • Type: selection
  • Default: Insert
  • Values:
    • Insert
    • Update
    • Delete columns
    • Delete entire rows
Use parallel read
Split reading data to all available nodes to speed up the process
  • Type: boolean
  • Default: true
Parallel read strategy
Parallel read strategy determines how workload is distributed among players
  • Type: selection
  • Default: Equal Splitter
  • Values:
    • Equal Splitter
    • Host Aware
Data Consistency
Options related to the consistency of data
  • Type: category
Check schema agreement
Check if schema is exactly the same on all cluster nodes
  • Type: boolean
  • Default: true
Consistency level
The level of consistency used in the read or write operation
  • Type: selection
  • Default: Quorum
  • Values:
    • Quorum
    • Each data center quorum
    • Local quorum
    • All nodes
    • One node
    • Two nodes
    • Three nodes
    • Local one
Consistency level
The level of consistency used in the read or write operation
  • Type: selection
  • Default: Quorum
  • Values:
    • Quorum
    • Each data center quorum
    • Local quorum
    • All nodes
    • Any node
    • One node
    • Two nodes
    • Three nodes
    • Local one
Options
Additional connector options
  • Type: category
Ignore string column value truncation errors?
Should we ignore string truncation errors when value's length is bigger than column field length provided in link column definition
  • Type: boolean
  • Default: false
Ignore BLOB column value truncation errors?
Should we ignore BLOB truncation errors when value's length is bigger than column field length provided in link column definition
  • Type: boolean
  • Default: false
Save null values
Should we save null values in the target table (this will create tombstones for each null value)
  • Type: boolean
  • Default: true
Enable CQL statement tracing
With tracing enabled the connector provides execution plan for each CQL statement (SELECT, INSERT, UPDATE, DELETE)
  • Type: boolean
  • Default: false
Custom type codecs
You can provide list of type codec classes that can be used to support your custom mappings between Cassandra and DataStage (semicolon separated list of classes)
  • Type: string
Paging settings
The setting used in result set paging
  • Type: category
Page size
The size of page that is used to retrive a subset of data
  • Type: integer
  • Default: 10
Pre-fetching threshold
Start pre-fetching when current page contains less rows than the value set in this property
  • Type: integer
  • Default: 2
Java settings
Specify the customized Java settings for the stage.
  • Type: category
JVM options
Specify the additional Java Virtual Machine options.
  • Type: string