Update Activity
Update is an asynchronous activity that helps to create, insert, update, batch update, or remove data to and from a Cassandra table or other write operations.
General
The General tab contains the following fields:
Advanced
This tab has the following fields:
Field | Literal Value/Process Property/Module Property? | Description |
---|---|---|
Write Consistency | All | Refers to how up-to-date and synchronized a row of Cassandra data is on all of its replicas. |
Tracing | None | The check box for turning the tracing for activity on or off. Checking this box turns the tracing on, which helps you understand Cassandra's internal operations and troubleshoot performance related issues. |
Input
This tab has the following fields:
Input Item | Data Type | Mandatory? | Description |
---|---|---|---|
Statement | String | No | |
ServerTimeZone | String | No | The ServerTimeZone is used for the timestamp data type. If you use Prepared Statements to insert timestamp data, map it to ServerTimeZone. It is the database server machine time zone, for example: America/New_York |
Output
The following is the output for the activity:
Output Item | Data Type | Description |
---|---|---|
ExecutionInfo | The information for Update activity executed. | |
QueriedHost | String | Return the Cassandra host that coordinated this execution. |
Applied | Boolean | If the query that produced this ResultSet was a conditional update, return whether it was successfully applied. |
TraceID | String |
Return the operation message data ID that is saved in the database. You can use this ID to query the database. For example: SELECT * FROM system_traces.sessions WHERE session_id =? |
Fault
The Fault tab lists exceptions that are thrown by this activity:
Error Schema Element | Data Type | Description |
---|---|---|
CassandraPluginException | Any exception thrown by the activity after execution. It has a msg and msgCode field for the exception. | |
DriverException | Any exception thrown by Cassandra driver. It has a msg and msgCode field for the exception. | |
msg | string | The error message returned by the plug-in. |
msgCode | string | The error code returned by the plug-in. |
Copyright © Cloud Software Group, Inc. All rights reserved.