phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Is there any support for paging or offset like mysql limit m,n grammer?
Date Tue, 25 Nov 2014 02:29:04 GMT
To add to what Samarth said, please take a look also at the unit tests
in QueryMoreIT as they give you a pretty good idea on how to implement
paged queries in a scalable manner over big data.
Thanks,
James

On Sun, Nov 23, 2014 at 7:33 PM, Samarth Jain <samarth.jain@gmail.com> wrote:
> Supporting limit/offset like queries is inherently not efficient for HBase.
> Alternatively you could use Phoenix's support for row value constructors to
> page through query results. See http://phoenix.apache.org/paged.html for
> details.
>
>
> On Sunday, November 23, 2014, sunfl@certusnet.com.cn
> <sunfl@certusnet.com.cn> wrote:
>>
>> Hi, all,
>>    I just wonder if phoenix has such support cause we are considering to
>> utilize phoenix instead of mysql infobright
>> in our projects.
>>   Moreover, does phoenix  supports user-defined functions? If so, how to
>> use them?
>>
>>   Best thanks,
>>  Sun.
>>
>> ________________________________
>> ________________________________
>>
>> CertusNet

Mime
View raw message