Hi,
1.Image we create the test table with following sql:
CREATE TABLE library (
title varchar not null,
author varchar not null,
isbn varchar not null,
published_date integer,
description varchar,
CONSTRAINT pk PRIMARY KEY(title, author, isbn)
)
2.After insert some test data, our table may looks like,
title author isbn published_date description
1 aaa1 aaa aaa 2010 NULL
2 aaa2 aaa aaa 2008 NULL
3 aaa3 aaa aaa 2007 NULL
4 bbb1 aaa bbb 2009 NULL
5 ccc1 aaa ccc 2011 NULL
6 ccc2 bbb ccc 2012 NULL
7 ccc3 bbb ccc 2006 NULL
8 ccc4 bbb ccc 2014 NULL
3.Then we use the query sql (from http://phoenix.apache.org/paged.html)
SELECT title, author, isbn, description
FROM library
WHERE published_date > 2010
AND (title, author, isbn) > (?, ?, ?) //this row value
constructors will specify the start row
ORDER BY title, author, isbn //In our case ORDER BY
is ignored (CONSTRAINT pk PRIMARY KEY(title, author, isbn))
LIMIT 20
1) SELECT title, author, isbn, description FROM library WHERE
published_date > 2010 LIMIT 20;
should return:
title author isbn published_date description
1 aaa1 aaa aaa 2010 NULL
5 ccc1 aaa ccc 2011 NULL
6 ccc2 bbb ccc 2012 NULL
8 ccc4 bbb ccc 2014 NULL
2)SELECT title, author, isbn, description FROM library WHERE
published_date > 2010
AND (title, author, isbn) > ('ccc1', 'aaa', 'ccc') //this means
we skip all rows in front of "record 5"(ccc2 bbb ccc 2012
NULL)
//and return matched records below "record 5" (exclude)
LIMIT 20;
should return:
7 ccc2 bbb ccc 2012 NULL
8 ccc4 bbb ccc 2014 NULL
Sorry I dont't have a running cluster around, correct me if I was wrong.
:)
Thanks.
2015-08-11 22:43 GMT+08:00 Hafiz Mujadid <[email protected]>:
> Yes I want to do pagination and I am confused how to achieve pagination?
>
> On Tue, Aug 11, 2015 at 7:08 PM, Yuhao Bi <[email protected]> wrote:
>
>> Hi,
>>
>> Here is some official document which may help.
>>
>> 1. http://phoenix.apache.org/skip_scan.html
>> 2. Wanna do some Pagination-like scan?
>> Please refer to http://phoenix.apache.org/paged.html
>>
>> Thanks.
>>
>> 2015-08-11 20:47 GMT+08:00 Hafiz Mujadid <[email protected]>:
>>
>>> Hi all!
>>>
>>>
>>> Can we use spark_phoenix in a way just like in normal java api we can
>>> pass start row to filter data as follow
>>> *//creating a scan object with start and stop row keys*
>>> *Scan scan = new
>>> Scan(Bytes.ToBytes("a.b.x|1"),Bytes.toBytes("a.b.x|2"); *
>>>
>>>
>>>
>>
>
>
> --
> Regards: HAFIZ MUJADID
>
