You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Danny Wang (JIRA)" <ji...@apache.org> on 2011/06/29 01:40:28 UTC
[jira] [Created] (CASSANDRA-2838) Query indexed column with key
filte
Query indexed column with key filte
-----------------------------------
Key: CASSANDRA-2838
URL: https://issues.apache.org/jira/browse/CASSANDRA-2838
Project: Cassandra
Issue Type: New Feature
Components: Core
Reporter: Danny Wang
To be able to support query like this,
(KEY> foo AND KEY< bar and name1 = value1
Currently I found this code
// Start and finish keys, *and* column relations (KEY> foo AND KEY< bar and name1 = value1).
if (select.isKeyRange()&& (select.getKeyFinish() != null)&& (select.getColumnRelations().size()> 0))
throw new InvalidRequestException("You cannot combine key range and by-column clauses in a SELECT");
in
http://svn.apache.org/repos/asf/cassandra/trunk/src/java/org/apache/cassandra/cql/QueryProcessor.java
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (CASSANDRA-2838) Query indexed column with key
filte
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis resolved CASSANDRA-2838.
---------------------------------------
Resolution: Won't Fix
> Query indexed column with key filte
> -----------------------------------
>
> Key: CASSANDRA-2838
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2838
> Project: Cassandra
> Issue Type: New Feature
> Components: Core
> Reporter: Danny Wang
>
> To be able to support query like this,
> (KEY> foo AND KEY< bar and name1 = value1
> Currently I found this code
>
> // Start and finish keys, *and* column relations (KEY> foo AND KEY< bar and name1 = value1).
> if (select.isKeyRange()&& (select.getKeyFinish() != null)&& (select.getColumnRelations().size()> 0))
> throw new InvalidRequestException("You cannot combine key range and by-column clauses in a SELECT");
>
> in
>
> http://svn.apache.org/repos/asf/cassandra/trunk/src/java/org/apache/cassandra/cql/QueryProcessor.java
>
>
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2838) Query indexed column with key
filte
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2838?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13057345#comment-13057345 ]
Jonathan Ellis commented on CASSANDRA-2838:
-------------------------------------------
1600 is about map/reduce, this is about CQL
> Query indexed column with key filte
> -----------------------------------
>
> Key: CASSANDRA-2838
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2838
> Project: Cassandra
> Issue Type: New Feature
> Components: Core
> Reporter: Danny Wang
>
> To be able to support query like this,
> (KEY> foo AND KEY< bar and name1 = value1
> Currently I found this code
>
> // Start and finish keys, *and* column relations (KEY> foo AND KEY< bar and name1 = value1).
> if (select.isKeyRange()&& (select.getKeyFinish() != null)&& (select.getColumnRelations().size()> 0))
> throw new InvalidRequestException("You cannot combine key range and by-column clauses in a SELECT");
>
> in
>
> http://svn.apache.org/repos/asf/cassandra/trunk/src/java/org/apache/cassandra/cql/QueryProcessor.java
>
>
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Reopened] (CASSANDRA-2838) Query indexed column with key
filte
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis reopened CASSANDRA-2838:
---------------------------------------
> Query indexed column with key filte
> -----------------------------------
>
> Key: CASSANDRA-2838
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2838
> Project: Cassandra
> Issue Type: New Feature
> Components: Core
> Reporter: Danny Wang
>
> To be able to support query like this,
> (KEY> foo AND KEY< bar and name1 = value1
> Currently I found this code
>
> // Start and finish keys, *and* column relations (KEY> foo AND KEY< bar and name1 = value1).
> if (select.isKeyRange()&& (select.getKeyFinish() != null)&& (select.getColumnRelations().size()> 0))
> throw new InvalidRequestException("You cannot combine key range and by-column clauses in a SELECT");
>
> in
>
> http://svn.apache.org/repos/asf/cassandra/trunk/src/java/org/apache/cassandra/cql/QueryProcessor.java
>
>
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (CASSANDRA-2838) Query indexed column with key
filte
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis resolved CASSANDRA-2838.
---------------------------------------
Resolution: Fixed
key comparisons are only useful for OPP, which you shouldn't be using.
> Query indexed column with key filte
> -----------------------------------
>
> Key: CASSANDRA-2838
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2838
> Project: Cassandra
> Issue Type: New Feature
> Components: Core
> Reporter: Danny Wang
>
> To be able to support query like this,
> (KEY> foo AND KEY< bar and name1 = value1
> Currently I found this code
>
> // Start and finish keys, *and* column relations (KEY> foo AND KEY< bar and name1 = value1).
> if (select.isKeyRange()&& (select.getKeyFinish() != null)&& (select.getColumnRelations().size()> 0))
> throw new InvalidRequestException("You cannot combine key range and by-column clauses in a SELECT");
>
> in
>
> http://svn.apache.org/repos/asf/cassandra/trunk/src/java/org/apache/cassandra/cql/QueryProcessor.java
>
>
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-2838) Query indexed column with key
filte
Posted by "Stu Hood (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2838?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13056971#comment-13056971 ]
Stu Hood commented on CASSANDRA-2838:
-------------------------------------
Isn't this CASSANDRA-1600?
> Query indexed column with key filte
> -----------------------------------
>
> Key: CASSANDRA-2838
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2838
> Project: Cassandra
> Issue Type: New Feature
> Components: Core
> Reporter: Danny Wang
>
> To be able to support query like this,
> (KEY> foo AND KEY< bar and name1 = value1
> Currently I found this code
>
> // Start and finish keys, *and* column relations (KEY> foo AND KEY< bar and name1 = value1).
> if (select.isKeyRange()&& (select.getKeyFinish() != null)&& (select.getColumnRelations().size()> 0))
> throw new InvalidRequestException("You cannot combine key range and by-column clauses in a SELECT");
>
> in
>
> http://svn.apache.org/repos/asf/cassandra/trunk/src/java/org/apache/cassandra/cql/QueryProcessor.java
>
>
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira