////
Licensed to the Apache Software Foundation (ASF) under one
or more contributor license agreements.  See the NOTICE file
distributed with this work for additional information
regarding copyright ownership.  The ASF licenses this file
to you under the Apache License, Version 2.0 (the
"License"); you may not use this file except in compliance
with the License.  You may obtain a copy of the License at
  http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing,
software distributed under the License is distributed on an
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
KIND, either express or implied.  See the License for the
specific language governing permissions and limitations
under the License.
////
:documentationPath: /technology/cassandra/
:language: en_US
:description: Apache Hop supports Apache Cassandra through a connection metadata type, actions and transforms.

= Cassandra Technology

From the https://cassandra.apache.org/[Apache Cassandra] website:

The database is the right choice when you need scalability and high availability without compromising performance. http://techblog.netflix.com/2011/11/benchmarking-cassandra-scalability-on.html[Linear scalability] and proven fault-tolerance on commodity hardware or cloud infrastructure make it the perfect platform for mission-critical data.
Cassandra's support for replicating across multiple datacenters is best-in-class, providing lower latency for your users and the peace of mind of knowing that you can survive regional outages.

From https://en.wikipedia.org/wiki/Apache_Cassandra[Wikipedia]:

Apache Cassandra is a free and open-source, distributed, wide-column store, NoSQL database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure.
Cassandra offers support for clusters spanning multiple datacenters,[2] with asynchronous masterless replication allowing low latency operations for all clients.
Cassandra was designed to implement a combination of Amazon's Dynamo distributed storage and replication techniques combined with Google's Bigtable data and storage engine model.[3]

== Cassandra Support in Hop

Hop supports Cassandra 4 (since version 2.2.0) with the following:

=== Metadata Types

* xref:metadata-types/cassandra/cassandra-connection.adoc[Cassandra Connection]: Create a connection to your Cassandra database cluster.

=== Workflow Actions

* xref:workflow/actions/cassandra-exec-cql.adoc[Cassandra Exec CQL]: Execute Cassandra https://cassandra.apache.org/doc/latest/cql/[CQL]

=== Pipeline Transforms

* xref:pipeline/transforms/cassandra-input.adoc[Cassandra Input]: Reads from a Cassandra cluster through a CQL query.
* xref:pipeline/transforms/cassandra-output.adoc[Cassandra Output]: Write data to a table in a Cassandra cluster.
* xref:pipeline/transforms/sstable-output.adoc[SSTable Output]: Write data to a filesystem directory as a Cassandra SSTable.
