Automatic pagination does not get all results

[Sid Tantia <si...@baseboxsoftware.com>]

Hello,

Has anyone had a problem with automatic pagination returning different
results everytime (this is for a table with ~180,000 rows)? I'm going
through each page and inserting the results into an array and each time I
go through all the pages, the resultant array has a different size.

This happens whether I use a SELECT query with automatic paging using the
Ruby driver or a COPY to CSV command with cqlsh.

-Sid

Re: Automatic pagination does not get all results

[Sid Tantia <si...@baseboxsoftware.com>]

Hello Jeff,

I'm using Cassandra v2.1.4
I'm expecting the amount of results to be the same every time I use the
COPY command (specifically I'm using `COPY <tablename> TO stdout`). However
here are the counts of rows exported each time I ran COPY:
1) 180389 rows exported
2) 181212 rows exported
3) 178641 rows exported
4) 176688 rows exported
5) 175433 rows exported

So it's found a different amount of rows to export every single time I've
run the command, even though its on the same table and no additional writes
have been made.

CL for read is ALL
CL for write is ONE
Yes, I've run repair since last writing data.

On Thu, Oct 22, 2015 at 9:02 PM, Jeff Jirsa <je...@crowdstrike.com>
wrote:

> It’s possible that it could be different depending on your consistency
> level (on write and on read).
>
> It’s also possible it’s a bug, but you didn’t give us much information –
> here are some questions to help us help you:
>
> What version?
> What results are you seeing?
> What’s the “right” result?
> What CL did you use to write the data?
> What CL did you use to read the data?
> Have you run repair since writing the data?
>
>
> From: Sid Tantia
> Reply-To: "user@cassandra.apache.org"
> Date: Thursday, October 22, 2015 at 5:49 PM
> To: user
> Subject: Automatic pagination does not get all results
>
> Hello,
>
> Has anyone had a problem with automatic pagination returning different
> results everytime (this is for a table with ~180,000 rows)? I'm going
> through each page and inserting the results into an array and each time I
> go through all the pages, the resultant array has a different size.
>
> This happens whether I use a SELECT query with automatic paging using the
> Ruby driver or a COPY to CSV command with cqlsh.
>
> -Sid
>
>

Re: Automatic pagination does not get all results

[Jeff Jirsa <je...@crowdstrike.com>]

It’s possible that it could be different depending on your consistency level (on write and on read).

It’s also possible it’s a bug, but you didn’t give us much information – here are some questions to help us help you:

What version? 
What results are you seeing? 
What’s the “right” result? 
What CL did you use to write the data? 
What CL did you use to read the data? 
Have you run repair since writing the data?


From:  Sid Tantia
Reply-To:  "user@cassandra.apache.org"
Date:  Thursday, October 22, 2015 at 5:49 PM
To:  user
Subject:  Automatic pagination does not get all results

Hello,

Has anyone had a problem with automatic pagination returning different results everytime (this is for a table with ~180,000 rows)? I'm going through each page and inserting the results into an array and each time I go through all the pages, the resultant array has a different size. 

This happens whether I use a SELECT query with automatic paging using the Ruby driver or a COPY to CSV command with cqlsh.

-Sid