Using HBase 0.98-hadoop-1, phoenix 4.0.0-incubating.
I have a table(named moninorlog, pk is id) created by phoenix with 13 columns and 1 secondary-index(named interfaceid).
Then I tried query like "SELECT id,interfaceid FROM moninorlog WHERE (id,interfaceid) > (?,?) ORDER BY id,interfaceid LIMIT 10".
I ran this query twice in the same connection with same variables (even in same SreparedStatement object) , but they retuned the same results.
Did I missed something?