cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pavel Yaskevich (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-11132) [SASI Pre-QA] Creating SPARSE index with non literal type leaves the index in a stalled state
Date Mon, 08 Feb 2016 09:14:39 GMT

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

Pavel Yaskevich updated CASSANDRA-11132:
----------------------------------------
    Issue Type: Sub-task  (was: Bug)
        Parent: CASSANDRA-11136

> [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: Sub-task
>          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)

Mime
View raw message