[ https://issues.apache.org/jira/browse/CASSANDRA-6377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15180478#comment-15180478 ]
Benjamin Lerer commented on CASSANDRA-6377: ------------------------------------------- As filtering on non primary-key columns for queries without secondary index was already supported since 3.0 (as a side effect of CASSANDRA-8099) and the patches for 3.0 and 3.x mostly fixes some issues with validation and filtering on static columns. I think it is best to push the patches into {{3.0.5}} and {{3.5}}. > ALLOW FILTERING should allow seq scan filtering > ----------------------------------------------- > > Key: CASSANDRA-6377 > URL: https://issues.apache.org/jira/browse/CASSANDRA-6377 > Project: Cassandra > Issue Type: Improvement > Components: CQL > Reporter: Jonathan Ellis > Assignee: Benjamin Lerer > Labels: cql > Fix For: 3.0.x, 3.x > > > CREATE TABLE emp_table2 ( > empID int PRIMARY KEY, > firstname text, > lastname text, > b_mon text, > b_day text, > b_yr text, > ); > INSERT INTO emp_table2 (empID,firstname,lastname,b_mon,b_day,b_yr) > VALUES (100,'jane','doe','oct','31','1980'); > INSERT INTO emp_table2 (empID,firstname,lastname,b_mon,b_day,b_yr) > VALUES (101,'john','smith','jan','01','1981'); > INSERT INTO emp_table2 (empID,firstname,lastname,b_mon,b_day,b_yr) > VALUES (102,'mary','jones','apr','15','1982'); > INSERT INTO emp_table2 (empID,firstname,lastname,b_mon,b_day,b_yr) > VALUES (103,'tim','best','oct','25','1982'); > > SELECT b_mon,b_day,b_yr,firstname,lastname FROM emp_table2 > WHERE b_mon='oct' ALLOW FILTERING; > Bad Request: No indexed columns present in by-columns clause with Equal > operator -- This message was sent by Atlassian JIRA (v6.3.4#6332)