Skip to main content
Hitachi Vantara Lumada and Pentaho Documentation

SSTable Output

The SSTable Output step writes to a filesystem directory as an Apache Cassandra SSTable.

This step supports Cassandra 2.2 only.


SSTable Output Properties Dialog Box

The following options are available for the SSTable Output transformation step:

Option Description

Step name

Specifies the unique name of the SSTable Output step on the canvas. You can customize the name or leave it as the default.

Cassandra yami file

Specifies the location of YAML file. A cassandra.yaml file is the main configuration file for Cassandra. It defines node and cluster configuration details.


Specifies where to write the output. This directory points to the target table to load to and must match the Keyspace and Column family fields.


Specifies the keyspace (database) name of the target table to load. The name specified must match the Directory field.

Column family (table)

Specifies the column family (table) to upload. It assumes the metadata for this table was previously defined in Cassandra. The column family specified must match the Directory field.

Incoming field to use as the row key

Indicates which incoming row to use as the key. This list is populated with the names of incoming transformation fields.

Get fields Inserts the list of fields from the incoming rows into Incoming field to use as the row key.

Use CQL version 3

Queries with CQL version 3.

Buffer (MB)

Specifies buffer size to use. A new table file is written every time the buffer is full.