cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "DOAN DuyHai (JIRA)" <>
Subject [jira] [Commented] (CASSANDRA-12149) NullPointerException on SELECT with SASI index
Date Mon, 11 Jul 2016 19:09:11 GMT


DOAN DuyHai commented on CASSANDRA-12149:

bq. How could I partition SELECT results hitting a single large Cassandra partition, when
I do not know values of clustering columns?

 Use server-side paging:

 "SELECT * FROM mytable WHERE partition = 'xxx'"

 Then set a fetchSize on the statement using the driver and then retrieve an Iterator from
the ResultSet and start iterating with {{while(iterator.hasNext())}}

> NullPointerException on SELECT with SASI index
> ----------------------------------------------
>                 Key: CASSANDRA-12149
>                 URL:
>             Project: Cassandra
>          Issue Type: Bug
>          Components: sasi
>            Reporter: Andrey Konstantinov
>         Attachments: CASSANDRA-12149.txt
> If I execute the sequence of queries (see the attached file), Cassandra aborts a connection
reporting NPE on server side. SELECT query without token range filter works, but does not
work when token range filter is specified. My intent was to issue multiple SELECT queries
targeting the same single partition, filtered by a column indexed by SASI, partitioning results
by different token ranges.
> Output from cqlsh on SELECT is the following:
> cqlsh> SELECT namespace, entity, timestamp, feature1, feature2 FROM mykeyspace.myrecordtable
WHERE namespace = 'ns2' AND entity = 'entity2' AND feature1 > 11 AND feature1 < 31 
AND token(namespace, entity) <= 9223372036854775807;
> ServerError: <ErrorMessage code=0000 [Server error] message="java.lang.NullPointerException">

This message was sent by Atlassian JIRA

View raw message