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

Labels

None

PM Priority

None

Reproduced in

None

Affects versions

Fix versions

None

Pull Request

None

Doc Impact

None

Size

None

External issue ID

None

External issue ID

None

Components

Priority

Major
Configure