"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
