How to execute cassandra query using where clause. about elassandra HOT 5 CLOSED

Hi,

With CQL, you cannot use a WHERE clause to search in your cassandra table. You should use the elasticsearch API https://www.elastic.co/guide/en/elasticsearch/reference/current/docs.html#docs or the JDBC driver for elasticsearch sql4es.

Thanks.

from elassandra.

Hi,

Thanks for the reply.
Can we create the cassandra index instead of elasticsearch index on the user_name so that I can perform the simple CQL query ?

from elassandra.

Hi,
Yes, you should be able to do it for a column indexed with a cassandra index, but i just found a bug in elassandra by checking it. It is fixed and i will release a new version Thursday.
Thanks for your request.
Vincent.

from elassandra.

Hi,
Thanks.Will wait for the Thursday release.

from elassandra.

Fixed with release 2.1.1-16.

from elassandra.