Hi Hafiz,
Sorry about the mistake, In 2), the returned records should be
6 ccc2 bbb ccc 2012 NULL
8 ccc4 bbb ccc 2014 NULL
I hope I did not confuse you.
Thanks.
2015-08-12 3:16 GMT+08:00 Hafiz Mujadid <[email protected]>:
> Hi Yuhao!
>
> Why record number 6 should be omitted?
>
> On Tue, Aug 11, 2015 at 9:08 PM, Yuhao Bi <[email protected]> wrote:
>
>> 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
>>>
>>
>>
>
>
> --
> Regards: HAFIZ MUJADID
>
