Unsupported consistency level: LOCAL_QUORUM. Supported consistency levels for Search are: ONE, LOCAL_ONE

Question

I faced an issue when using cqlsh to query on dse 6.7.

Invalid Request: Error from server: code=2200 [Invalid query] message="Unsupported consistency level: LOCAL_QUORUM. Supported consistency levels for Search are: ONE, LOCAL_ONE".

My query is very simple is:

Query :

select * from esc shipment . shipment search where shipper id like '1334';

I spent a lot of time to google but I did not find any use case same same my case.

Could anyone tell me the main reason and how to fix this issue. I'm a very beginner.

Answer 1

The problem is following - you're running your query with LIKE operator on the table that has DSE Search enabled. Because CQL doesn't have LIKE operator, this query is offloaded to the DSE Search that is able to answer queries only with consistency level ONE or LOCAL_ONE (as it's pointed in the error - it's a known limitation of DSE Search).

You need to change consistency level with the cqlsh command CONSISTENCY, lie this:

CONSISTENCY LOCAL_ONE

and then execute the query again.