ZhaoYang created CASSANDRA-11031:
------------------------------------
Summary: Support “ALLOW FILTERING" for Partition Key
Key: CASSANDRA-11031
URL: https://issues.apache.org/jira/browse/CASSANDRA-11031
Project: Cassandra
Issue Type: New Feature
Components: CQL
Reporter: ZhaoYang
Assignee: ZhaoYang
Fix For: 2.1.x, 3.x
Currently, Allow Filtering only works for secondary Index column or clustering
columns. And it's slow, because Cassandra will read all data from SSTABLE from
hard-disk to memory to filter.
But we can support allow filtering on Partition Key, as far as I know,
Partition Key is in memory, so we can easily filter them, and then read
required data from SSTable.
This will similar to "Select * from table" which scan through entire cluster.
CREATE TABLE my_table (
pk1 text,
pk2 text,
c1 text,
c2 text,
v1 text,
v2 text,
PRIMARY KEY ((pk1,pk2),c1,c2)
) ;
Select * from my_table where pk1 = "partition key part 1" allow filtering;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
