[CASSANDRA-11310] Allow filtering on clustering columns for queries without secondary indexes

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.6
• Component/s: Feature/2i Index, Legacy/CQL
• Labels: doc-impacting
• Assignee: Alex Petrov
• Reporter: Benjamin Lerer

Authors

Alex Petrov

Reviewers

Sam Tunnicliffe

• Created: 07/Mar/16 09:29
• Updated: 02/Jul/20 12:31
• Resolved: 19/Apr/16 17:19

Description

Since CASSANDRA-6377 queries without index filtering non-primary key columns are fully supported.

It makes sense to also support filtering on clustering-columns.

CREATE TABLE emp_table2 (
empID int,
firstname text,
lastname text,
b_mon text,
b_day text,
b_yr text,
PRIMARY KEY (empID, b_yr, b_mon, b_day));

SELECT b_mon,b_day,b_yr,firstname,lastname FROM emp_table2
WHERE b_mon='oct' ALLOW FILTERING;

Issue Links

• depends upon: CASSANDRA-11354 PrimaryKeyRestrictionSet should be refactored
• duplicates: CASSANDRA-15911 Allow partition scan, querying cluster keys out of order