Details
-
Bug
-
Resolution: Unresolved
-
Major
-
None
-
None
-
None
Description
To update add/delete an item in a list/set/map column, there are two syntax to achieve this:
id | teams
---+-------------
1 |
{'ta', 'tb'}
1) Bulk operation:
UPDATE test_list_table SET teams = ['ta', 'tb', 'tc'] WHERE id = 1;
2) Single-cell operation:
UPDATE test_list_table SET teams = teams + ['tc'] WHERE id = 1;
Cassandra Connector can't provide correct change event information if the user chooses the latter kind of syntax, which unfortunately is the recommended one by Cassandra.
Currently users of Cassandra Connector will be restricted to update a collection-type column only using the bulk syntax.
Refer to:
https://docs.datastax.com/en/dse/5.1/cql/cql/cql_reference/cql_commands/cqlUpdate.html