cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "DOAN DuyHai (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-11133) [SASI Pre-QA] Creating SPARSE index with Analyzer fails silently when using =
Date Mon, 08 Feb 2016 08:56:39 GMT

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

DOAN DuyHai commented on CASSANDRA-11133:
-----------------------------------------

Tested and OK for me

> [SASI Pre-QA] Creating SPARSE index with Analyzer fails silently when using =
> -----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-11133
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11133
>             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,
>     year int
> );
> INSERT INTO music.albums(id, artist, title, year) 
> VALUES (1, 'Bullets and Octane', 'In the Mouth of the Young', 2006);
> INSERT INTO music.albums(id, artist, title, year) 
> VALUES (2, 'Quantic', 'Look Around The Corner', 2012);
> INSERT INTO music.albums(id, artist, title, year) 
> VALUES (3, 'America', 'View From the Ground', 1982);
> CREATE CUSTOM INDEX ON music.albums (year) USING 'org.apache.cassandra.index.sasi.SASIIndex'
WITH OPTIONS = {'mode': 'SPARSE', 'analyzer_class': 'org.apache.cassandra.index.sasi.analyzer.NonTokenizingAnalyzer'};
> SELECT artist,title,year FROM music.albums;
> artist             | title                      | year
> -------------------+----------------------------+------
> Bullets and Octane |  In the Mouth of the Young | 2006
>            Quantic |     Look Around the Corner | 2012
>            America |       View From the Ground | 1982
> {code}
> The index was properly created. It can be found calling *DESCRIBE TABLE albums;* as well
as in *system_schema.indexes*. 
> Strangely, the index does not return any data:
> {code:sql}
> SELECT * FROM music.albums WHERE year=2006;
> (0 rows)
> {code}
> However range query using the index fails with a cryptic exception:
> {code:sql}
> SELECT * FROM music.albums WHERE year>=1981 AND year<=1990 LIMIT 10;
> Traceback (most recent call last):
>     File "/opt/apps/apache-cassandra-3.4/bin/cqlsh.py", line 1250, in perform_simple_statement
> result = future.result()
>     File "/opt/apps/apache-cassandra-3.4/bin/../lib/cassandra-driver-internal-only-3.0.0-6af642d.zip/cassandra-driver-3.0.0-6af642d/cassandra/cluster.py",
line 3122, in result
> raise self._final_exception
>     ReadFailure: code=1300 [Replica(s) failed to execute read] message="Operation failed
- received 0 responses and 1 failures" info={'failures': 1, 'received_responses': 0, 'required_responses':
1, 'consistency': 'ONE'}
> {code}
> The real exception message in _/var/log/cassandra/system.log_ is:
> {code}
> Caused by: java.lang.IllegalArgumentException: null
>     at org.apache.cassandra.index.sasi.memory.SkipListMemIndex.search(SkipListMemIndex.java:75)
~[main/:na]
>     at org.apache.cassandra.index.sasi.memory.IndexMemtable.search(IndexMemtable.java:69)
~[main/:na]
>     at org.apache.cassandra.index.sasi.conf.ColumnIndex.searchMemtable(ColumnIndex.java:107)
~[main/:na]
>     at org.apache.cassandra.index.sasi.TermIterator.build(TermIterator.java:87) ~[main/:na]
>     at org.apache.cassandra.index.sasi.plan.QueryController.getIndexes(QueryController.java:146)
~[main/:na]
>     at org.apache.cassandra.index.sasi.plan.Operation$Builder.complete(Operation.java:423)
~[main/:na]
>     at org.apache.cassandra.index.sasi.plan.QueryPlan.analyze(QueryPlan.java:57) ~[main/:na]
>     at org.apache.cassandra.index.sasi.plan.QueryPlan.execute(QueryPlan.java:68) ~[main/:na]
>     at org.apache.cassandra.index.sasi.SASIIndex.lambda$searcherFor$241(SASIIndex.java:256)
~[main/:na]
>     at org.apache.cassandra.index.sasi.SASIIndex$$Lambda$248/1287847768.search(Unknown
Source) ~[na:na]
>     at org.apache.cassandra.db.ReadCommand.executeLocally(ReadCommand.java:354) ~[main/:na]
> {code}



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

Mime
View raw message