Hi, I am using hive 0.14 which runs over hbase (having ~10 GB of data). I am facing issues in terms of slowness when querying over Hbase. My query looks like following:
select * from table1 where id > 'zzzz'; (id is the row-key) As per the hive-code, id > 'zzz', is getting pushed to Hbase scanner as 'startKey'. Now given there are no such rows-keys (id) which satisfies this criteria, this query should be extremely fast. But hive is taking a lot of time, looks like full hbase table scan. Can someone let me know where am I wrong in understanding the whole thing? -- Abhishek
