Cassandra Connector > Virtual Table Operations > Virtual table operations
  

Virtual table operations

You can use virtual table operations to read, insert, upsert, or update rows in a virtual table.
You can perform the following operations in a virtual table:
Read
Use the read operation to retrieve rows from a virtual table.
Insert
Use the insert operation to add one or more rows to a virtual table. Each row that you insert must correspond to a primary key in the source table. If you insert data into a row key that contains data, Cassandra overwrites the original data in the row with the new data.
Note: Cassandra database treats all insert operations as upsert operations.
Upsert
Use the upsert operation to update rows in a virtual table.
Select Update as Insert in the UpdateMode target advanced properties to upsert rows in a virtual table.
Update
Use the update operation to update rows in a virtual table.
Select Update as Update in the UpdateMode target advanced properties to update rows in a virtual table.
Note: You cannot configure the Truncate Target Table option to truncate a target virtual table before writing data to the virtual table.