Yan Yao created CASSANDRA-14808:
-----------------------------------
Summary: Support ORDER BY with 2ndary Indexes
Key: CASSANDRA-14808
URL: https://issues.apache.org/jira/browse/CASSANDRA-14808
Project: Cassandra
Issue Type: Bug
Components: CQL
Environment: Apache Cassandra 3.11.3
Reporter: Yan Yao
Fix For: 3.11.4, 4.0
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?
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
