Hi Cassandra-users, my name is Michael Mirwaldt and I work for financial.com.
I have encountered this problem with Cassandra 3.7 running 4 nodes: Given the data model CREATE KEYSPACE mykeyspace WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '2'} AND durable_writes = true; CREATE TABLE mykeyspace.mytable (partitionkey text, mylist list<text>, PRIMARY KEY (partitionkey)); If I add the value INSERT INTO mykeyspace.mytable(partitionkey,mylist) VALUES('A',['1']); and query select * from mykeyspace.mytable; I get partitionkey | mylist --------------+-------- A | ['1'] and If I query select * from mykeyspace.mytable where partitionkey='A' and mylist contains '1' allow filtering; I get partitionkey | mylist --------------+-------- A | ['1'] But if I add INSERT INTO mykeyspace.mytable(partitionkey) VALUES('B'); so that select * from mykeyspace.mytable; gives me partitionkey | mylist --------------+-------- B | null A | ['1'] then select * from mykeyspace.mytable where partitionkey='B' and mylist contains '2' allow filtering; leads to the error message ReadFailure: code=1300 [Replica(s) failed to execute read] message="Operation failed - received 0 responses and 2 failures" info={'failures': 2, 'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'} with the log message [...] AwareExecutorService$FutureTask.run|Uncaught exception on thread Thread[SharedPool-Worker-2,5,main]: java.lang.RuntimeException: java.lang.NullPointerException on one other node. Is that really logical and intended? Would you not expect an empty result for last query? I am confused. Can you help me? Brgds, Michael ________________________________ financial.com AG Munich Head Office/Hauptsitz M?nchen: Georg-Muche-Stra?e 3 | 80807 Munich | Germany | Tel. +49 89 318528-0 | Google Maps: http://goo.gl/maps/UHwj9 Frankfurt Branch Office/Niederlassung Frankfurt: Messeturm | Friedrich-Ebert-Anlage 49 | 60327 Frankfurt am Main | Germany | Google Maps: http://goo.gl/maps/oSGjR Management Board/Vorstand: Dr. Steffen Boehnert | Dr. Alexis Eisenhofer | Dr. Yann Samson Supervisory Board/Aufsichtsrat: Werner Engelhardt (Chairman/Vorsitzender), Eric Wasescha (Deputy Chairman/Stellv. Vorsitzender), Franz Baur Register Court/Handelsregister: Munich - HRB 128972 | Sales Tax ID Number/St.Nr.: DE205370553