phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Pagination with Phoenix
Date Wed, 17 Feb 2016 19:15:40 GMT
See https://phoenix.apache.org/paged.html and the unit test for
QueryMoreIT. The row value constructor (RVC) was implemented specifically
to provide an efficient means of pagination over HBase data.

Thanks,
James

On Wed, Feb 17, 2016 at 10:54 AM, Steve Terrell <sterrell@oculus360.us>
wrote:

> I was just thinking about this today.  I was going to try to implement it
> by using a LIMIT <number of rows> on every query, with an addition of
>
>   WHERE (rowkey_field_1 > last_rowkey_field_1_value_from_previous_query)
> OR (rowkey_field_2 > last_rowkey_field_2_value_from_previous_query) OR …
>
> But I haven't tried it yet.
>
> On Wed, Feb 17, 2016 at 12:47 PM, Subramanyam Satyanarayana <
> ssatyanarayana@metabiota.com> wrote:
>
>> We have micro services built within Play  that generate Phoenix queries
>> to serve RESTful requests. We are trying to figure a good way to implement
>> pagination in the services.
>>
>> We were curious to know if there is any prescribed way of implementing
>> either Row Keys ( to determine start & stop conditions for scan)  and/or
>> indexes to help support this. Happy to share more details.
>> —
>> Regards,
>>
>> Subbu
>>
>> Manager, Platform Services
>>
>> Metabiota, Inc. (www.metabiota.com)
>>
>>
>>
>>
>> *CONFIDENTIALITY NOTICE: The information contained in this electronic
>> mail (email) transmission (including attachments), is intended by Metabiota
>> for the use of the named individual or entity to which it is addressed and
>> may contain information that is privileged or otherwise confidential. It is
>> not intended for transmission to, or receipt by, any individual or entity
>> other than the named addressee except as otherwise expressly permitted in
>> this email transmission. If you have received this email in error, please
>> delete it without copying or forwarding it, and notify the sender of the
>> error by email reply.*
>>
>
>

Mime
View raw message