Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Mon, 7 Dec 2015 15:03:11 +0000 (UTC)
From: "Benjamin Lerer (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12834370.1433192809000.289935.1449500591004@Atlassian.JIRA>
In-Reply-To: <JIRA.12834370.1433192809000@Atlassian.JIRA>
References: <JIRA.12834370.1433192809000@Atlassian.JIRA>
 <JIRA.12834370.1433192809289@arcas>
Subject: [jira] [Updated] (CASSANDRA-9527) Cannot create secondary index on
 a table WITH COMPACT STORAGE
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/CASSANDRA-9527?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Benjamin Lerer updated CASSANDRA-9527:
--------------------------------------
    Component/s: CQL

> 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: CQL
>         Environment: cassandra v2.0.13
>            Reporter: fuggy_yama
>            Assignee: Benjamin Lerer
>            Priority: Minor
>             Fix For: 2.0.17, 2.1.8, 2.2.0 rc2
>
>         Attachments: 9527-2.0-V2.txt, 9527-2.1-V2.txt, 9527.txt
>
>
> 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)