When I run the query "SELECT image FROM roll WHERE roll = :roll“ against this
table
CREATE TABLE roll (
roll INT,
image BIGINT,
data VARCHAR static,
mid VARCHAR,
imp_st VARCHAR,
PRIMARY KEY ((roll), image)
) WITH gc_grace_seconds = 3456000 AND compaction = { 'class' :
'LeveledCompactionStrategy', 'sstable_size_in_mb' : 160 };
I often get duplicate records back. Seems like a very simple query to botch.
I’m running 2.0.16 with RF=3 and CL=QUORUM and Java client 2.0.10.1. I don’t
see duplicates in cqlsh. Any thoughts?
Thanks
Robert