Return-Path: 
 <commits-return-160427-apmail-cassandra-commits-archive=cassandra.apache.org@cassandra.apache.org>
X-Original-To: apmail-cassandra-commits-archive@www.apache.org
Delivered-To: apmail-cassandra-commits-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id C1C601785D
	for <apmail-cassandra-commits-archive@www.apache.org>;
 Mon,  8 Feb 2016 05:26:40 +0000 (UTC)
Received: (qmail 23600 invoked by uid 500); 8 Feb 2016 05:26:40 -0000
Delivered-To: apmail-cassandra-commits-archive@cassandra.apache.org
Received: (qmail 23561 invoked by uid 500); 8 Feb 2016 05:26:40 -0000
Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:commits-help@cassandra.apache.org>
List-Unsubscribe: <mailto:commits-unsubscribe@cassandra.apache.org>
List-Post: <mailto:commits@cassandra.apache.org>
List-Id: <commits.cassandra.apache.org>
Reply-To: dev@cassandra.apache.org
Delivered-To: mailing list commits@cassandra.apache.org
Received: (qmail 23535 invoked by uid 99); 8 Feb 2016 05:26:40 -0000
Received: from arcas.apache.org (HELO arcas) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 08 Feb 2016 05:26:40 +0000
Received: from arcas.apache.org (localhost [127.0.0.1])
	by arcas (Postfix) with ESMTP id 4D9E52C1F58
	for <commits@cassandra.apache.org>; Mon,  8 Feb 2016 05:26:40 +0000 (UTC)
Date: Mon, 8 Feb 2016 05:26:40 +0000 (UTC)
From: "Pavel Yaskevich (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12937351.1454849534000.326016.1454909200314@Atlassian.JIRA>
In-Reply-To: <JIRA.12937351.1454849534000@Atlassian.JIRA>
References: <JIRA.12937351.1454849534000@Atlassian.JIRA>
 <JIRA.12937351.1454849534602@arcas>
Subject: [jira] [Commented] (CASSANDRA-11132) [SASI Pre-QA] Creating SPARSE
 index with non literal type leaves the index in a stalled state
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394


    [ https://issues.apache.org/jira/browse/CASSANDRA-11132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15136599#comment-15136599 ] 

Pavel Yaskevich commented on CASSANDRA-11132:
---------------------------------------------

Branch [sasi_validation|https://github.com/xedin/cassandra/tree/sasi_validation] addresses this by preventing SPARSE mode on literal columns.

> [SASI Pre-QA] Creating SPARSE index with non literal type leaves the index in a stalled state
> ---------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-11132
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11132
>             Project: Cassandra
>          Issue Type: Bug
>          Components: CQL
>         Environment: Tested from build [CASSANDRA-11067|https://issues.apache.org/jira/browse/CASSANDRA-11067]
>            Reporter: DOAN DuyHai
>            Assignee: Pavel Yaskevich
>             Fix For: 3.4
>
>
> Tested from build [CASSANDRA-11067|https://issues.apache.org/jira/browse/CASSANDRA-11067]
> {code:sql}
> CREATE KEYSPACE music WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'}  AND durable_writes = true;
> CREATE TABLE music.albums (
>     id int PRIMARY KEY,
>     artist text,
>     title text
> );
> CREATE CUSTOM INDEX ON music.albums (title) USING 'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = {'mode': 'SPARSE'};
> ServerError: <ErrorMessage code=0000 [Server error] message="java.lang.RuntimeException: java.util.concurrent.ExecutionException: java.lang.RuntimeException:   java.lang.reflect.InvocationTargetException">
> {code}
> The real exception message in _/var/log/cassandra/system.log_ is : *Caused by: java.lang.IllegalStateException: Unsupported mode: SPARSE.*
> Worst, the index is created but not visible when calling *DESCRIBE TABLE albums;*. It is visible though in the *system_keyspace.indexs* table.
> Any further attempt to create a correct index on the same column fails:
> {code:sql}
> CREATE CUSTOM INDEX ON music.albums (title) USING 'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = {'mode': 'PREFIX', 'analyzer_class': 'org.apache.cassandra.index.sasi.analyzer.NonTokenizingAnalyzer', 'case_sensitive': 'false'};
> InvalidRequest: code=2200 [Invalid query] message="Index albums_title_idx already exists"
> {code}
> We need to drop the invisible index before being able to create another index on the same column



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