InvalidQueryException when leveraging solr_query WHERE clause predicates against Search enabled datacenter and the requirement to use ALLOW FILTERING
I’m trying to leverage Java Driver 4.8.0 to build a search query with solr_query in the where clause and it’s giving me the following errors.
SELECT * FROM ks.tbl WHERE solr_query = ? LIMIT 50 and I wanted to build the prepared statement and this would look something like
in it and I’m getting,
Why does it require ALLOW FILTERING when it’s running fine in CQLSH? Am I missing to set some configuration property that should state this is a search query?
I've set basic.load-balancing-policy.local-datacenter = SearchDC and doing my code like below,
Here is a snippet of my reference.conf file,
and of course, my table definition also has the following,