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