Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 065CB11BC0 for ; Fri, 21 Feb 2014 05:22:46 +0000 (UTC) Received: (qmail 26646 invoked by uid 500); 21 Feb 2014 05:22:42 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 26611 invoked by uid 500); 21 Feb 2014 05:22:42 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 26599 invoked by uid 99); 21 Feb 2014 05:22:42 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 21 Feb 2014 05:22:42 +0000 X-ASF-Spam-Status: No, hits=1.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of nagapad.0904@gmail.com designates 74.125.82.170 as permitted sender) Received: from [74.125.82.170] (HELO mail-we0-f170.google.com) (74.125.82.170) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 21 Feb 2014 05:22:36 +0000 Received: by mail-we0-f170.google.com with SMTP id w62so2226719wes.15 for ; Thu, 20 Feb 2014 21:22:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=0WWpVO8QiYx7OKwmaqshUEkr/Z2Hz5zR6MErMCodQ5I=; b=mXcY/+JyqY2DGHSkqcyN0+FeT2NgGihOrylwhctr1UmHzfWy/Op5A8XyJg1XXV8x+f eD6iIInDqJY65ksSoMsN1zUiVxoAGA0fbtxnSOY/D9xN8INIFeqrrsXxbZiA326sC+00 sztB/5ErDqc7xCvWKmi0FKsXlN6vRyIBIJMT6/+ziGkUwhYRnwlC5l+nt1gEnxBdJA76 d23zwwtaRp9Id5tfezGIew54OSAbm8hJyUTDnYjeZDHsV58/fTBaYe0RIADjtfhzdrIy u3IFP0jbycBeq6zIew7D63e85ot0tl7wQc/M3Fmvgnlk4pDye+qg9/2XLV3h/v5YT7BD RGVg== MIME-Version: 1.0 X-Received: by 10.180.98.199 with SMTP id ek7mr1458463wib.21.1392960135793; Thu, 20 Feb 2014 21:22:15 -0800 (PST) Received: by 10.217.65.199 with HTTP; Thu, 20 Feb 2014 21:22:15 -0800 (PST) In-Reply-To: References: Date: Fri, 21 Feb 2014 14:22:15 +0900 Message-ID: Subject: Re: paging state will not work From: Katsutoshi To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=f46d041826a014918104f2e3ce95 X-Virus-Checked: Checked by ClamAV on apache.org --f46d041826a014918104f2e3ce95 Content-Type: text/plain; charset=ISO-8859-1 Thank you for the reply. Added: https://issues.apache.org/jira/browse/CASSANDRA-6748 Katsutoshi 2014-02-21 2:14 GMT+09:00 Sylvain Lebresne : > That does sound like a bug. Would you mind opening a JIRA ( > https://issues.apache.org/jira/browse/CASSANDRA) ticket for it? > > > On Thu, Feb 20, 2014 at 3:06 PM, Edward Capriolo wrote: > >> I would try a fetch size other then 1. Cassandras slices are start >> inclusive so maybe that is a bug. >> >> >> On Tuesday, February 18, 2014, Katsutoshi wrote: >> > Hi. >> > >> > I am using Cassandra 2.0.5 version. If null is explicitly set to a >> column, paging_state will not work. My test procedure is as follows: >> > >> > ------ >> > create a table and insert 10 records using cqlsh. the query is as >> follows: >> > >> > cqlsh:test> CREATE TABLE mytable (id int, range int, value text, >> PRIMARY KEY (id, range)); >> > cqlsh:test> INSERT INTO mytable (id, range) VALUES (0, 0); >> > cqlsh:test> INSERT INTO mytable (id, range) VALUES (0, 1); >> > cqlsh:test> INSERT INTO mytable (id, range) VALUES (0, 2); >> > cqlsh:test> INSERT INTO mytable (id, range) VALUES (0, 3); >> > cqlsh:test> INSERT INTO mytable (id, range) VALUES (0, 4); >> > cqlsh:test> INSERT INTO mytable (id, range, value) VALUES (0, 5, >> null); >> > cqlsh:test> INSERT INTO mytable (id, range, value) VALUES (0, 6, >> null); >> > cqlsh:test> INSERT INTO mytable (id, range, value) VALUES (0, 7, >> null); >> > cqlsh:test> INSERT INTO mytable (id, range, value) VALUES (0, 8, >> null); >> > cqlsh:test> INSERT INTO mytable (id, range, value) VALUES (0, 9, >> null); >> > >> > select data using datastax driver. the pseudocode is as follows: >> > >> > Statement statement = >> QueryBuilder.select().from("mytable").setFetchSize(1); >> > ResultSet rs = session.execute(statement); >> > for(Row row : rs){ >> > System.out.println(String.format("id=%s, range=%s, value=%s", >> > row.getInt("id"), row.getInt("range"), >> row.getString("value"))); >> > } >> > >> > the result is as follows: >> > >> > id=0, range=0, value=null >> > id=0, range=1, value=null >> > id=0, range=2, value=null >> > id=0, range=3, value=null >> > id=0, range=4, value=null >> > id=0, range=5, value=null >> > id=0, range=7, value=null >> > id=0, range=9, value=null >> > ------ >> > >> > Result is 8 records although 10 records were expected. Does anyone has >> a similar issue? >> > >> > Thanks, >> > Katsutoshi >> > >> >> -- >> Sorry this was sent from mobile. Will do less grammar and spell check >> than usual. >> > > --f46d041826a014918104f2e3ce95 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Thank you for the reply. Added: https://issues.apache.org/jira/brows= e/CASSANDRA-6748

Katsutoshi
=

2014-02-21 2:14 GMT+09:00 Sylvain Lebresne <= span dir=3D"ltr"><sylvain@datastax.com>:
That does sound like a bug. Would you mind opening a JIRA = (https://issues.apache.org/jira/browse/CASSANDRA) ticket for it?


On Thu, Feb 20, 2014 at 3:06 PM, Edward = Capriolo <edlinuxguru@gmail.com> wrote:
I would try a fetch size other then 1. Cassandras slices are start inclusiv= e so maybe that is a bug.


On Tuesday, February 18, 2014, K= atsutoshi <n= agapad.0904@gmail.com> wrote:
> Hi.
>
> I am using Cassandra 2.0.5 version. If null is exp= licitly set to a column, paging_state will not work. My test procedure is a= s follows:
>
> ------
> create a table and insert 10 reco= rds using cqlsh. the query is as follows:
>
> =A0=A0=A0 cqlsh:test> CREATE TABLE mytable (id int, range i= nt, value text, PRIMARY KEY (id, range));
> =A0=A0=A0 cqlsh:test> = INSERT INTO mytable (id, range) VALUES (0, 0);
> =A0=A0=A0 cqlsh:test= > INSERT INTO mytable (id, range) VALUES (0, 1);
> =A0=A0=A0 cqlsh:test> INSERT INTO mytable (id, range) VALUES (0, 2)= ;
> =A0=A0=A0 cqlsh:test> INSERT INTO mytable (id, range) VALUES (= 0, 3);
> =A0=A0=A0 cqlsh:test> INSERT INTO mytable (id, range) VAL= UES (0, 4);
> =A0=A0=A0 cqlsh:test> INSERT INTO mytable (id, range, value) VALUES= (0, 5, null);
> =A0=A0=A0 cqlsh:test> INSERT INTO mytable (id, ra= nge, value) VALUES (0, 6, null);
> =A0=A0=A0 cqlsh:test> INSERT IN= TO mytable (id, range, value) VALUES (0, 7, null);
> =A0=A0=A0 cqlsh:test> INSERT INTO mytable (id, range, value) VALUES= (0, 8, null);
> =A0=A0=A0 cqlsh:test> INSERT INTO mytable (id, ra= nge, value) VALUES (0, 9, null);
>
> select data using datastax= driver. the pseudocode is as follows:
>
> =A0=A0=A0 Statement statement =3D QueryBuilder.select().from(&= quot;mytable").setFetchSize(1);
> =A0=A0=A0 ResultSet rs =3D ses= sion.execute(statement);
> =A0=A0=A0 for(Row row : rs){
> =A0= =A0=A0=A0=A0=A0=A0 System.out.println(String.format("id=3D%s, range=3D= %s, value=3D%s",
> =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 row.getInt("id"), row.getI= nt("range"), row.getString("value")));
> =A0=A0= =A0 }
>
> the result is as follows:
>
> =A0=A0=A0 i= d=3D0, range=3D0, value=3Dnull
> =A0=A0=A0 id=3D0, range=3D1, value= =3Dnull
> =A0=A0=A0 id=3D0, range=3D2, value=3Dnull
> =A0=A0=A0 id=3D0, ra= nge=3D3, value=3Dnull
> =A0=A0=A0 id=3D0, range=3D4, value=3Dnull
= > =A0=A0=A0 id=3D0, range=3D5, value=3Dnull
> =A0=A0=A0 id=3D0, ra= nge=3D7, value=3Dnull
> =A0=A0=A0 id=3D0, range=3D9, value=3Dnull
> ------
>
> Result is 8 records although 10 records were ex= pected. Does anyone has a similar issue?
>
> Thanks,
> Ka= tsutoshi
>

--
Sorry this was sent from mobile. Will do less grammar and spell check than = usual.


--f46d041826a014918104f2e3ce95--