Is there a way to scan a HBase table getting, for example, the first 100results, then later get the next 100 and so on... Just like in SQL we dowith LIMIT and OFFSET?*Jonathan Cardoso** **Universidade Federal de Goias*

On Thu, Aug 1, 2013 at 10:31 PM, Jonathan Cardoso<[EMAIL PROTECTED]> wrote:> Hi!>> Is there a way to scan a HBase table getting, for example, the first 100> results, then later get the next 100 and so on... Just like in SQL we do> with LIMIT and OFFSET?>>> *Jonathan Cardoso** **> Universidade Federal de Goias*

> Hi!>> Is there a way to scan a HBase table getting, for example, the first 100> results, then later get the next 100 and so on... Just like in SQL we do> with LIMIT and OFFSET?>>> *Jonathan Cardoso** **> Universidade Federal de Goias*>

On Thu, Aug 1, 2013 at 10:46 PM, Ted Yu <[EMAIL PROTECTED]> wrote:> Take a look at ColumnPaginationFilter.java and its unit test.>> Cheers>> On Thu, Aug 1, 2013 at 10:01 AM, Jonathan Cardoso> <[EMAIL PROTECTED]>wrote:>>> Hi!>>>> Is there a way to scan a HBase table getting, for example, the first 100>> results, then later get the next 100 and so on... Just like in SQL we do>> with LIMIT and OFFSET?>>>>>> *Jonathan Cardoso** **>> Universidade Federal de Goias*>>

You might have to pay special attention to the OFFSET part though. OFFSETof nth row will not remain n forever. As you insert new rows ordering willget changed as rows are not arranged in the order of insertion in HBase.Warm Regards,Tariqcloudfront.blogspot.comOn Thu, Aug 1, 2013 at 11:27 PM, Jonathan Cardoso<[EMAIL PROTECTED]>wrote: