OR operation in cassandra cqlsh

Question

SELECT * FROM sample WHERE id = '2' OR uid = '1';

I got the error in cqlsh

Bad Request: line 1:36 missing EOF at 'OR'

Is It possible for or operator in Cassandra using cqlsh client?

Answer 1

@Hari

OR operation is not supported by CQL. Only AND operation is supported, with some restrictions.

Anyway, CQL language looks similar to SQL but the semantics are very different. I suggest to have a look at the documentation for more details.