phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Can I get row No.X with Phoeix?
Date Tue, 05 Aug 2014 05:03:58 GMT
Hi Michael,
Take a look at Paged Queries here:
http://phoenix.apache.org/paged.html as well as this email thread:
http://s.apache.org/Dct. Phoenix does not support the OFFSET keyword
in SQL and likely never will as it cannot be implemented efficiently.
Thanks,
James

On Mon, Aug 4, 2014 at 8:36 PM, Michael.Calvin <77231541@qq.com> wrote:
> "SELECT MAX(id) FROM table LIMIT X" doesn't work, it returns the last id of
> whole table.‍‍
> "SELECT MAX(id) FROM table ORDER BY id‍ LIMIT X" throws an exepction I don't
> Understand : "Aggregate may not contain columns not in GROUP BY. ID".
> Aggregate should work without phrase "GROUP BY". Maybe there's a bug parsing
> this command. Same happends without phrase "LIMIT X".
> ‍‍
> I know there's no such concept of row number in hbase, what about phoenix ?
>
> ------------------
> Michael.Calvin.Shi
>

Mime
View raw message