[ https://issues.apache.org/jira/browse/CASSANDRA-4987?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14229918#comment-14229918 ]
Rajanarayanan Thottuvaikkatumana commented on CASSANDRA-4987: ------------------------------------------------------------- [~ slebresne] In the Video table example of CASSANDRA-4915, if we issue a command {{SELECT * FROM videos WHERE tags = 'Cassandra';}}, then it will give error {{code=2200 [Invalid query] message="No secondary indexes on the restricted columns support the provided operators: "}}. Is the idea to have {{ALLOW FILTERING}} option in the SELECT statements to support these kinds of WHERE clauses and the like otherwise NOT supported by Cassandra now? Thanks > Support more queries when ALLOW FILTERING is used. > -------------------------------------------------- > > Key: CASSANDRA-4987 > URL: https://issues.apache.org/jira/browse/CASSANDRA-4987 > Project: Cassandra > Issue Type: Improvement > Reporter: Sylvain Lebresne > Labels: cql > Fix For: 3.0 > > > Even after CASSANDRA-4915, there is still a bunch of queries that we don't > support even if {{ALLOW FILTERING}} is used. Typically, pretty much any > queries with restriction on a non-primary-key column unless we have one of > those restriction that is an EQ on an indexed column. > If {{ALLOW FILTERING}} is used, we could allow those queries out of > convenience. -- This message was sent by Atlassian JIRA (v6.3.4#6332)