cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "fuggy_yama (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-9527) Cannot create secondary index on a table WITH COMPACT STORAGE
Date Mon, 01 Jun 2015 21:09:17 GMT

     [ 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 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*


  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 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*



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message