You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Russ Hatch (JIRA)" <ji...@apache.org> on 2014/02/18 22:29:25 UTC
[jira] [Created] (CASSANDRA-6722) cross-partition ordering should
have warning or be disallowed when paging
Russ Hatch created CASSANDRA-6722:
-------------------------------------
Summary: cross-partition ordering should have warning or be disallowed when paging
Key: CASSANDRA-6722
URL: https://issues.apache.org/jira/browse/CASSANDRA-6722
Project: Cassandra
Issue Type: Bug
Reporter: Russ Hatch
Priority: Minor
consider this schema/data/query:
{noformat}
CREATE TABLE paging_test (
id int,
value text,
PRIMARY KEY (id, value)
) WITH CLUSTERING ORDER BY (value ASC)
|id|value|
|1 |a |
|2 |b |
|1 |c |
|2 |d |
|1 |e |
|2 |f |
|1 |g |
|2 |h |
|1 |i |
|2 |j |
select * from paging_test where id in (1,2) order by value asc;
{noformat}
When paging the above query I get the sorted results from id=1 first, then the sorted results from id=2 after that. I was testing this because I was curious if the paging system could somehow globally sort the results but it makes sense that we can't do that, since that would require all results to be collated up front.
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)