You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "C. Scott Andreas (Jira)" <ji...@apache.org> on 2019/12/18 23:17:00 UTC
[jira] [Updated] (CASSANDRA-14808) Support ORDER BY with 2ndary
Indexes
[ https://issues.apache.org/jira/browse/CASSANDRA-14808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
C. Scott Andreas updated CASSANDRA-14808:
-----------------------------------------
Fix Version/s: (was: 3.11.x)
(was: 4.0)
> Support ORDER BY with 2ndary Indexes
> ------------------------------------
>
> Key: CASSANDRA-14808
> URL: https://issues.apache.org/jira/browse/CASSANDRA-14808
> Project: Cassandra
> Issue Type: Bug
> Components: Legacy/CQL
> Environment: Apache Cassandra 3.11.3
> Reporter: Yan Yao
> Priority: Normal
>
> Suppose we have a generic table:
> {code:java}
> CREATE TABLE base_table(
> partition1 uuid,
> ...
> partitionN uuid,
> static_column text static,
> clustering1 uuid,
> ...
> clusteringM uuid,
> regular text,
> list_text list,
> set_text set,
> map_int_text map<int, text>,
> PRIMARY KEY((partition1, ..., partitionN), clustering1, ... , clusteringN)
> );
> {code}
>
> And create an index on _regular text_ column, the schema of the index table will be:
> {code:java}
> CREATE TABLE regular_idx(
> regular text,
> partitionColumns blob,
> clustering1 uuid,
> ...
> clusteringM uuid,
> PRIMARY KEY((regular), partitionColumns, clustering1, ..., clusteringM)
> );
> {code}
>
> Then it's possible to execute queries like:
> {code:java}
> SELECT * FROM base_table WHERE regular = <some_value_0> AND partition1 = <some_value_1> AND ... AND partitionN = <some_value_N> ORDER BY clustering1;{code}
>
> However, CQL3 would check if the _secondary index_ is used WITH _order by_ during prepare a select statement, and throw an exception at once for queries like above.
> Could we support ORDER BY with 2ndary Indexes at least for above query pattern?
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org