[CASSANDRA-9527] Cannot create secondary index on a table WITH COMPACT STORAGE

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.0.17, 2.1.8, 2.2.0 rc2
• Component/s: Feature/2i Index, Legacy/CQL

Environment

cassandra v2.0.13

• Severity: Low
• Assignee: Benjamin Lerer
• Reporter: fuggy_yama

Authors

Benjamin Lerer

Reviewers

Tom Hobbs

• Created: 01/Jun/15 21:06
• Updated: 16/Apr/19 09:31
• Resolved: 26/Jun/15 18:06

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