[jira] [Created] (CASSANDRA-11031) Support “ALLOW FILTERING" for Partition Key

["ZhaoYang (JIRA)" <ji...@apache.org>]

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)