Reading data from the Cassandra keyspace

Procedure

Double-click the tCassandraInput component to open its Component view.
Type in required information for the connection or use the existing connection you have configured before. In this scenario, the Use existing connection check box is selected.
In the Keyspace configuration area, type in the name of the keyspace: Employee in this example.
In the Column family configuration area, type in the name of the column family: Employee_Info in this example.
Select Edit schema to define the data structure to be read from the Cassandra keyspace. In this example, three columns id, name and age are defined.
If needed, select the Include key in output columns check box, and then select the key column of the column family you want to include from the Key column list.
From the Row key type list, select Integer because id is of integer type in this example.
Keep the Default option for the row key Cassandra type because its value will become the corresponding Cassandra type Int32 automatically.
In the Query configuration area, select the Specify row keys check box and specify the row keys directly. In this example, three rows will be read. Next, select the Specify columns check box and specify the column names of the column family directly. This scenario will read three columns from the keyspace: id, name and age.
If needed, the Key start and the Key end fields allow you to define the range of rows, and the Key limit field allows you to specify the number of rows within the range of rows to be read. Similarly, the Columns range start and the Columns range end fields allow you to define the range of columns of the column family, and the Columns range limit field allows you to specify the number of columns within the range of columns to be read.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here