question Re: Is there any way to do pagination in phoenix 4.4.1 in Archives of Support Questions (Read Only)

Is there any way to do pagination in phoenix 4.4.1

rathnamohan_b — Wed, 28 Dec 2016 19:08:30 GMT

Hi,

I am to trying to do offset in phoenix and find that offset support the version 4.4.8, but current version is 4.4.1.

Is there any possibility to perform offset or pagination in phoenix for version 4.4.1 code: SELECT Name, Age, DOJ, Salary, Country, State FROM PersonalDetails WHERE COUNTRY IN('IND') ORDER BY DOJ DESC LIMIT 100 OFFSET 2;

Error: Error: ERROR 602 (42P00): Syntax error. Missing "EOF" at line 1, column 58 (state=42P00,code=602) org.apache.phoenix.exception.PhoenixParserException: ERROR 602 (42P00): Syntax error. Missing "EOF" at line 1, column58

Thanks

Mohan

Re: Is there any way to do pagination in phoenix 4.4.1

aervits — Wed, 28 Dec 2016 21:49:42 GMT

Offset functionality is available in Phoenix as of 4.8, there are no plans to backport to to 4.4. What is limiting you from upgrading to the latest?

Re: Is there any way to do pagination in phoenix 4.4.1

rathnamohan_b — Thu, 29 Dec 2016 21:40:52 GMT

Thanks for update, I just want to confirm if there is any alternate way to do above.

As there is no other option i will upgrade my phoenix version.

Re: Is there any way to do pagination in phoenix 4.4.1

aervits — Thu, 29 Dec 2016 22:42:10 GMT

@rathna mohan I have not tested this but it may be possible to use HBase API to achieve what you're asking, https://hbase.apache.org/apidocs/org/apache/hadoop/hbase/filter/ColumnPaginationFilter.html. I am just guessing and I don't think it will be a trivial effort as you're going to have to access Phoenix from HBase API. Again, I hesitate to suggest this route as effort to develop this functionality can be quite involved.