Sample Header Ad - 728x90

Why do batch updates to a CQL list merge the data?

2 votes
2 answers
176 views
I have created the following table CONSISTENCY LOCAL_QUORUM; drop keyspace if exists cycling; CREATE KEYSPACE IF NOT EXISTS cycling WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 3 } and durable_writes = true; CREATE TABLE IF NOT EXISTS cycling.rider ( rider_id int PRIMARY KEY, rider_name list, rider_name2 frozen> ); Do the following sequence of batch operations CONSISTENCY LOCAL_QUORUM; BEGIN BATCH UPDATE cycling.rider SET rider_name = ['a2'], rider_name2 = ['b2'] WHERE rider_id = 100; UPDATE cycling.rider SET rider_name = ['a3'], rider_name2 = ['b3'] WHERE rider_id = 100; APPLY BATCH; I get merged data in my list (rider_name) select * from cycling.rider; rider_id | rider_name | rider_name2 ----------+--------------+------------- 100 | ['a2', 'a3'] | ['b3'] Do you know why? I was expecting rider_id | rider_name | rider_name2 ----------+--------------+------------- 100 | ['a3'] | ['b3']
Asked by gudge (133 rep)
Nov 15, 2022, 09:31 PM
Last activity: Nov 21, 2022, 01:17 PM