When we add extra predicate on a column used in the index, cassandra returns 0 records despite the predicate returns True.
We have the issue with spark-cassandra-connector:2.3.1-s_2.11 and spark 2.2.0 and cassandra-lucene-index-plugin-3.11.1.0. To repeat it just use earthquakes.csv from: https://docs.datastax.com/en/tutorials/gis.zip
When we add extra predicate on a column used in the index, cassandra returns 0 records despite the predicate returns
True
.We have the issue with
spark-cassandra-connector:2.3.1-s_2.11
andspark 2.2.0
andcassandra-lucene-index-plugin-3.11.1.0
. To repeat it just useearthquakes.csv
from: https://docs.datastax.com/en/tutorials/gis.zipThen
To create the index:
Query 1 (returns 28 records):
Query 2 (should also return 28 records, return 0 records):
The predicate
and latitude > 0.0
returnsTrue
, we do not understand why it leads to a result of 0 records.