Cassandra CQL查询检查多个值

Question

CREATE TABLE my_table (
  my_field text,
  my_field2 text,
  PRIMARY KEY (my_field)
);

1> SELECT * FROM my_table WHERE my_field2 IN ('A', 'B');

2> SELECT * FROM my_table WHERE my_field2 = 'A' OR my_field = 'B' ;

Bad Request: IN predicates on non-primary-key columns (my_field2) is not yet supported

Answer 1

null

CREATE TABLE my_table (
  my_field2 text,
  my_field text,
  PRIMARY KEY (my_field2)
);

CREATE TABLE my_table (
  my_field text,
  my_field2 text,
  PRIMARY KEY (my_field, my_field2)
);

SELECT * FROM my_table WHERE my_field2 IN ('A', 'B') ALLOW FILTERING;