[
https://issues.apache.org/jira/browse/CASSANDRA-9527?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
fuggy_yama updated CASSANDRA-9527:
----------------------------------
Description:
In CASSANDRA-8156 it is said that secondary indexes are not allowed on
clustering columns in COMPACT tables.
However, I found that it is not possible to create a secondary index on the
value column in a COMPACT table:
CREATE TABLE t (
a INT,
b INT,
c INT,
PRIMARY KEY (a, b)
) WITH COMPACT STORAGE;
CREATE INDEX ON t (c);
*Bad Request: Secondary indexes are not supported on PRIMARY KEY columns in
COMPACT STORAGE tables*
was:
In CASSANDRA-8156 it is said that secondary indexes are not allowed on PK
columns in COMPACT tables.
However, I found that it is not possible to create a secondary index on the
value column in a COMPACT table:
CREATE TABLE t (
a INT,
b INT,
c INT,
PRIMARY KEY (a, b)
) WITH COMPACT STORAGE;
CREATE INDEX ON t (c);
*Bad Request: Secondary indexes are not supported on PRIMARY KEY columns in
COMPACT STORAGE tables*
> Cannot create secondary index on a table WITH COMPACT STORAGE
> -------------------------------------------------------------
>
> Key: CASSANDRA-9527
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9527
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: cassandra v2.0.13
> Reporter: fuggy_yama
> Priority: Minor
>
> In CASSANDRA-8156 it is said that secondary indexes are not allowed on
> clustering columns in COMPACT tables.
> However, I found that it is not possible to create a secondary index on the
> value column in a COMPACT table:
> CREATE TABLE t (
> a INT,
> b INT,
> c INT,
> PRIMARY KEY (a, b)
> ) WITH COMPACT STORAGE;
> CREATE INDEX ON t (c);
> *Bad Request: Secondary indexes are not supported on PRIMARY KEY columns in
> COMPACT STORAGE tables*
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
