Details
Major Description
Using Drill hive connection to query Hbase table.
*Following query *
select * from hive.mytable where key >= '0001:10:2017:0410:0000000000003157781'
and key < '0001:10:2017:0410:0000000000003157782';
What happened
Failed with an error after timeout.
It seems that the word 'key' didn't push down to hive from drill.
What we also tried
Same query in Drill over hbase takes less than a sec,
In hue hive it takes few seconds
Debug trail
When you look in the sql profile of drill (using the web), you see a
table full scan for millions of records, while actually it was supposed to return
9 rows.
Does Drill on top of hive is using the key to access only the relevant
region of the table?