Hi This is our query select * from hive.mytable where key >= '0001:10:2017:0410:0000000000003157781' and key < '0001:10:2017:0410:0000000000003157782';
Same query in Drill over hbase takes less than a sec, in hive it takes few seconds and with drill over hive it quits with a timeout. 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? Regards, Dor Ben Dov Research Manager, Digital - BSS - Research +972-9-7764043 (office) +972-52-3573492 (mobile) [cid:image001.png@01D28AC9.B559B360] Follow us on Facebook<http://www.facebook.com/amdocs/>, Twitter<http://twitter.com/amdocs>, LinkedIn<http://www.linkedin.com/company/amdocs>, YouTube<http://www.youtube.com/amdocsinc>, Google+<https://plus.google.com/105657940751678445194> and the Amdocs blog network<http://blogs.amdocs.com/>| Digital BSS Research@Yammer<https://www.yammer.com/amdocs.com/#/threads/inGroup?type=in_group&feedId=7043838> This message and the information contained herein is proprietary and confidential and subject to the Amdocs policy statement, you may review at https://www.amdocs.com/about/email-disclaimer <https://www.amdocs.com/about/email-disclaimer>
