SELECT * FROM sample WHERE id = '2' OR uid = '1';
我在cqlsh中遇到了错误
Bad Request: line 1:36 missing EOF at 'OR'
在使用时,Cassandra中是否可以使用运算符?
虽然doanduyhai的原则是正确的,但如果您需要限制在同一列上,则可以使用'IN'运算符:
cqlsh:demodb> SELECT * FROM sample WHERE id IN ('2','1');
SELECT * FROM sample WHERE id ='2';
和SELECT * FROM sample WHERE uid ='1';
。 - Ike Walker