Constance Eustace created CASSANDRA-7054: --------------------------------------------
Summary: Enable allow filtering IN clause on compound cluster key Key: CASSANDRA-7054 URL: https://issues.apache.org/jira/browse/CASSANDRA-7054 Project: Cassandra Issue Type: New Feature Components: API Reporter: Constance Eustace Partition Key is P Cluster Key is C1, C2, C3 If you are allowed to do: SELECT P,C1,C2,C3 FROM table WHERE C1 = ? ALLOW FILTERING Why can't we do: SELET P,C1,C2,C3 FROM table WHERE C1 IN ('001','002','003) ALLOW FILTERING? Is there a fundamental theoretical issue with that? I assume ALLOW FILTERING is applying the where clause after the SELECT P1,C1,C2,C3 initial retrieval has occurred for the single-property equality clause, so an IN clause wouldn't be much different... I'm also assuming there is substantial network savings of issuing the general query to CASSANDRA rather than pelting the server with multiple requests. -- This message was sent by Atlassian JIRA (v6.2#6252)