Reading data from the Cassandra keyspace - 7.2

Cassandra

author
Talend Documentation Team
EnrichVersion
7.2
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Open Studio for Big Data
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Database components > Cassandra components
Data Quality and Preparation > Third-party systems > Database components > Cassandra components
Design and Development > Third-party systems > Database components > Cassandra components
EnrichPlatform
Talend Studio

Procedure

  1. Double-click the tCassandraInput component to open its Component view.
  2. 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.
  3. In the Keyspace configuration area, type in the name of the keyspace: Employee in this example.
  4. In the Column family configuration area, type in the name of the column family: Employee_Info in this example.
  5. 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.
  6. 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.
  7. 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.
  8. 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.
  9. 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.