tCassandraRow
Acts on the actual DB structure or on the data, depending on the nature of the
query and the database.
tCassandraRow is the specific component
for this database query. It executes the Cassandra Query Language (CQL) query stated in
the specified database. The row suffix means the component implements a flow in the Job
design although it does not provide output.
tCassandraRow Standard properties
These properties are used to configure tCassandraRow running in the Standard Job framework.
The Standard
tCassandraRow component belongs to the Big Data and the Databases NoSQL families.
The component in this framework is available in all Talend products with Big Data
and in Talend Data Fabric.
Basic settings
Property type |
Either Built-In or Repository. Built-In: No property data stored centrally.
Repository: Select the repository file where the |
Use existing connection |
Select this check box and in the Component List click the relevant connection component to |
DB Version | Select the Cassandra version you are using. |
Host |
Type in the IP address or hostname of the Cassandra server. |
Port |
Type in the listening port number of the Cassandra server. |
Required Authentication |
Select this check box to provide credentials for the Cassandra This check box appears only if you do not select the Use existing connection check box. |
Username |
Fill in this field with the username for the Cassandra |
Password |
Fill in this field with the password for the Cassandra To enter the password, click the […] button next to the |
Keyspace |
Type in the name of the keyspace on which you want to execute the |
Column family |
Name of the column family. |
Schema and Edit Schema |
A schema is a row description. It defines the number of fields Click Edit
|
Query |
Type in the CQL command to be executed. By default, the query is not case-sensitive. This means that at runtime, the column names |
Die on error |
This check box is cleared by default, meaning to skip the row on |
Advanced settings
tStatCatcher Statistics |
Select this check box to gather the Job processing metadata at the |
Global Variables
Global Variables |
ERROR_MESSAGE: the error message generated by the A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see |