[
https://issues.apache.org/jira/browse/CASSANDRA-6377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14087826#comment-14087826
]
Jack Krupansky commented on CASSANDRA-6377:
-------------------------------------------
[~ztyx], here's the relevant restriction from the DataStax CQL doc:
bq. The WHERE clause is composed of conditions on the columns that are part of
the primary key or are indexed.
See:
http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/select_r.html
And the same restriction from the project spec for CQL3:
bq. The <where-clause> specifies which rows must be queried. It is composed of
relations on the columns that are part of the PRIMARY KEY and/or have a
secondary index defined on them.
See:
https://cassandra.apache.org/doc/cql3/CQL.html
Was there part of either of those two statements that is maybe worded too
vaguely, or is the issue how you would have found those statements more easily?
Improving doc usability is a priority.
> ALLOW FILTERING should allow seq scan filtering
> -----------------------------------------------
>
> Key: CASSANDRA-6377
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6377
> Project: Cassandra
> Issue Type: Bug
> Components: API
> Reporter: Jonathan Ellis
> Assignee: Sylvain Lebresne
> Labels: cql
> Fix For: 3.0
>
>
> 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.2#6252)
