cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Philip Thompson (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-8408) limit appears to replace page size under certain conditions
Date Thu, 18 Dec 2014 20:37:13 GMT

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

Philip Thompson updated CASSANDRA-8408:
---------------------------------------
    Reproduced In: 2.1.2, 2.0.12  (was: 2.0.12, 2.1.2)
    Fix Version/s: 2.1.3
                   2.0.12

> limit appears to replace page size under certain conditions
> -----------------------------------------------------------
>
>                 Key: CASSANDRA-8408
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8408
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Russ Hatch
>            Assignee: Tyler Hobbs
>            Priority: Minor
>             Fix For: 2.0.12, 2.1.3
>
>
> This seems it could be related to CASSANDRA-8403.
> When paging a query with:
> limit < page size << data size, and querying using an 'IN' clause across several
partitions, I get back several pages of size=limit (instead of the page size being used).
So the limit is being exceeded and it seems to supplant the page size value, but something
is still keeping the total rows returned down.
> To repro, create a table:
> CREATE TABLE paging_test ( id int, value text, PRIMARY KEY (id, value) )
> And add data across several partitions (I used 6 partitions). Add a bunch of rows to
each partition (I have 80 total across all partitions).
> Perform a paged query using an 'IN' clause across all the partitions, where:
> limit < page_size << data size. I used something like:
> SELECT * FROM paging_test where id in (1,2,3,4,5,6) LIMIT 9;
> (with a page_size of 20 for the query).
> What I get returned is three pages of sizes: 9, 9, 8 -- 26 rows in total but I'm uncertain
why.



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

Mime
View raw message