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
