Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of nagapad.0904@gmail.com
 designates 74.125.82.180 as permitted sender)
MIME-Version: 1.0
Date: Tue, 18 Feb 2014 19:54:09 +0900
Message-ID: 
 <CALzFYOrCe++BELHt=kSGFFYsFSrr-3OHjPG_fPVzC2C7HvdpJA@mail.gmail.com>
Subject: paging state will not work
From: Katsutoshi <nagapad.0904@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=047d7bfd05fc870e4704f2ac173a

--047d7bfd05fc870e4704f2ac173a
Content-Type: text/plain; charset=ISO-8859-1

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

--047d7bfd05fc870e4704f2ac173a
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi.<br><br>I am using Cassandra 2.0.5 version. If null is =
explicitly set to a column, paging_state will not work. My test procedure i=
s as follows:<br><br>------<br>create a table and insert 10 records using c=
qlsh. the query is as follows:<br>
<br>=A0=A0=A0 cqlsh:test&gt; CREATE TABLE mytable (id int, range int, value=
 text, PRIMARY KEY (id, range));<br>=A0=A0=A0 cqlsh:test&gt; INSERT INTO my=
table (id, range) VALUES (0, 0);<br>=A0=A0=A0 cqlsh:test&gt; INSERT INTO my=
table (id, range) VALUES (0, 1);<br>
=A0=A0=A0 cqlsh:test&gt; INSERT INTO mytable (id, range) VALUES (0, 2);<br>=
=A0=A0=A0 cqlsh:test&gt; INSERT INTO mytable (id, range) VALUES (0, 3);<br>=
=A0=A0=A0 cqlsh:test&gt; INSERT INTO mytable (id, range) VALUES (0, 4);<br>=
=A0=A0=A0 cqlsh:test&gt; INSERT INTO mytable (id, range, value) VALUES (0, =
5, null);<br>
=A0=A0=A0 cqlsh:test&gt; INSERT INTO mytable (id, range, value) VALUES (0, =
6, null);<br>=A0=A0=A0 cqlsh:test&gt; INSERT INTO mytable (id, range, value=
) VALUES (0, 7, null);<br>=A0=A0=A0 cqlsh:test&gt; INSERT INTO mytable (id,=
 range, value) VALUES (0, 8, null);<br>
=A0=A0=A0 cqlsh:test&gt; INSERT INTO mytable (id, range, value) VALUES (0, =
9, null);<br><br>select data using datastax driver. the pseudocode is as fo=
llows:<br><br>=A0=A0=A0 Statement statement =3D QueryBuilder.select().from(=
&quot;mytable&quot;).setFetchSize(1);<br>
=A0=A0=A0 ResultSet rs =3D session.execute(statement);<br>=A0=A0=A0 for(Row=
 row : rs){<br>=A0=A0=A0=A0=A0=A0=A0 System.out.println(String.format(&quot=
;id=3D%s, range=3D%s, value=3D%s&quot;, <br>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0 row.getInt(&quot;id&quot;), row.getInt(&quot;range&quot;), row.getStrin=
g(&quot;value&quot;)));<br>
=A0=A0=A0 }<br><br>the result is as follows:<br><br>=A0=A0=A0 id=3D0, range=
=3D0, value=3Dnull<br>=A0=A0=A0 id=3D0, range=3D1, value=3Dnull<br>=A0=A0=
=A0 id=3D0, range=3D2, value=3Dnull<br>=A0=A0=A0 id=3D0, range=3D3, value=
=3Dnull<br>=A0=A0=A0 id=3D0, range=3D4, value=3Dnull<br>=A0=A0=A0 id=3D0, r=
ange=3D5, value=3Dnull<br>
=A0=A0=A0 id=3D0, range=3D7, value=3Dnull<br>=A0=A0=A0 id=3D0, range=3D9, v=
alue=3Dnull<br>------<br><br>Result is 8 records although 10 records were e=
xpected. Does anyone has a similar issue? <br><br>Thanks,<br>Katsutoshi<br>=
</div>

--047d7bfd05fc870e4704f2ac173a--