InvalidQueryException when leveraging solr_query WHERE clause predicates against Search enabled datacenter and the requirement to use ALLOW FILTERING

Description

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,

Environment

None

Pull Requests

None

Assignee

Unassigned

Reporter

Madhavan Sridharan

Affects versions