[
https://issues.apache.org/jira/browse/CASSANDRA-12149?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15371429#comment-15371429
]
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: https://issues.apache.org/jira/browse/CASSANDRA-12149
> 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
(v6.3.4#6332)
