...
Note: Apache Cassandra v. 2.1.0 is currently the only supported version of Apache Cassandra.
Configuration
Property | Macro Enabled? | Description |
---|---|---|
Reference Name | No | Required. Used to uniquely identify this source for lineage, annotating metadata, etc. |
Initial Address | Yes | Required. The initial address to connect to. |
Port | Yes | Optional. The RPC port for Cassandra. Check the configuration to make sure that |
Username | Yes | Optional. The username for the keyspace (if one exists). If this is not empty, then you must supply a password. |
Password | Yes | Optional. The password for the keyspace (if one exists). If this is not empty, then you must supply a username. |
Other Properties | No | Optional. Any extra properties to include. The property-value pairs should be comma-separated, and each property should be separated by a colon from its corresponding value. |
Keyspace | Yes | Required. The keyspace to select data from. |
Partitioner | Yes | Required. The partitioner for the keyspace. |
Column Family | Yes | Required. The column family or table to select data from. |
CQL Query | Yes | Required. The query to select data on. |
Example
This example connects to Apache Cassandra, which is running locally, and reads in records in the specified keyspace (megacorp) and column family (employee) which match the query to (in this case) select all records. All data from the column family will be read on each run.
Property | Value |
---|---|
Initial Address | localhost |
Port | 9160 |
Keyspace | megacorp |
Partitioner |
|
Column Family | employees |
Query |
|