cassandra source Cassandra Source

Provided by: "Apache Software Foundation"

Support Level for this Kamelet is: "Stable"

Send a query to an Apache Cassandra cluster table.

Configuration Options

The following table summarizes the configuration options available for the cassandra-source Kamelet:

Property Name Description Type Default Example

connectionHost

Connection Host

Required The hostname(s) for the Cassandra server(s). Use a comma to separate multiple hostnames.

string

localhost

connectionPort

Connection Port

Required The port number(s) of the cassandra server(s). Use a comma to separate multiple port numbers.

string

9042

keyspace

Keyspace

Required The keyspace to use.

string

customers

query

Query

Required The query to execute against the Cassandra cluster table.

string

consistencyLevel

Consistency Level

The consistency level to use.

Enum values:

* ONE * TWO * THREE * QUORUM * ALL * LOCAL_QUORUM * EACH_QUORUM * SERIAL * LOCAL_SERIAL * LOCAL_ONE

string

QUORUM

extraTypeCodecs

Extra Type Codecs

To use a specific comma separated list of Extra Type codecs.

Enum values:

* BLOB_TO_ARRAY * BOOLEAN_LIST_TO_ARRAY * BYTE_LIST_TO_ARRAY * SHORT_LIST_TO_ARRAY * INT_LIST_TO_ARRAY * LONG_LIST_TO_ARRAY * FLOAT_LIST_TO_ARRAY * DOUBLE_LIST_TO_ARRAY * TIMESTAMP_UTC * TIMESTAMP_MILLIS_SYSTEM * TIMESTAMP_MILLIS_UTC * ZONED_TIMESTAMP_SYSTEM * ZONED_TIMESTAMP_UTC * ZONED_TIMESTAMP_PERSISTED * LOCAL_TIMESTAMP_SYSTEM * LOCAL_TIMESTAMP_UTC

string

password

Password

The password for accessing a secured Cassandra cluster.

string

resultStrategy

Result Strategy

The strategy to convert the result set of the query.

Enum values:

* ALL * ONE * LIMIT_10 * LIMIT_100

string

ALL

username

Username

The username for accessing a secured Cassandra cluster.

string

Dependencies

At runtime, the cassandra-source Kamelet relies upon the presence of the following dependencies:

  • camel:jackson

  • camel:kamelet

  • camel:cassandraql

Camel JBang usage

Prerequisites

  • You’ve installed JBang.

  • You have executed the following command:

jbang app install camel@apache/camel

Supposing you have a file named route.yaml with this content:

- route:
    from:
      uri: "kamelet:timer-source"
      parameters:
        period: 10000
        message: 'test'
      steps:
        - to:
            uri: "kamelet:log-sink"

You can now run it directly through the following command

camel run route.yaml

Camel K Environment Usage

This section describes how you can use the cassandra-source.

Knative source

You can use the cassandra-source Kamelet as a Knative source by binding it to a Knative object.

cassandra-source-binding.yaml
apiVersion: camel.apache.org/v1
kind: KameletBinding
metadata:
  name: cassandra-source-binding
spec:
  source:
    ref:
      kind: Kamelet
      apiVersion: camel.apache.org/v1
      name: cassandra-source
    properties:
      connectionHost: localhost
      connectionPort: "9042"
      keyspace: customers
      query: The Query
  sink:
    ref:
      kind: Channel
      apiVersion: messaging.knative.dev/v1
      name: mychannel

Prerequisite

You have Camel K installed on the cluster.

Procedure for using the cluster CLI

  1. Save the cassandra-source-binding.yaml file to your local drive, and then edit it as needed for your configuration.

  2. Run the source by using the following command:

    kubectl apply -f cassandra-source-binding.yaml

Procedure for using the Kamel CLI

Configure and run the source by using the following command:

kamel bind channel:mychannel -p "source.connectionHost=localhost" -p "source.connectionPort=9042" -p "source.keyspace=customers" -p "source.query=The Query" cassandra-source

This command creates the KameletBinding in the current namespace on the cluster.

Kafka source

You can use the cassandra-source Kamelet as a Kafka source by binding it to a Kafka topic.

cassandra-source-binding.yaml
apiVersion: camel.apache.org/v1
kind: KameletBinding
metadata:
  name: cassandra-source-binding
spec:
  source:
    ref:
      kind: Kamelet
      apiVersion: camel.apache.org/v1
      name: cassandra-source
    properties:
      connectionHost: localhost
      connectionPort: "9042"
      keyspace: customers
      query: The Query
  sink:
    ref:
      kind: KafkaTopic
      apiVersion: kafka.strimzi.io/v1beta1
      name: my-topic

Prerequisites

  • You’ve installed Strimzi.

  • You’ve created a topic named my-topic in the current namespace.

  • You have Camel K installed on the cluster.

Procedure for using the cluster CLI

  1. Save the cassandra-source-binding.yaml file to your local drive, and then edit it as needed for your configuration.

  2. Run the source by using the following command:

    kubectl apply -f cassandra-source-binding.yaml

Procedure for using the Kamel CLI

Configure and run the source by using the following command:

kamel bind kafka.strimzi.io/v1beta1:KafkaTopic:my-topic -p "source.connectionHost=localhost" -p "source.connectionPort=9042" -p "source.keyspace=customers" -p "source.query=The Query" cassandra-source

This command creates the KameletBinding in the current namespace on the cluster.