phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael.Calvin" <77231...@qq.com>
Subject Can I get row No.X with Phoeix?
Date Tue, 05 Aug 2014 03:36:45 GMT
"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