Use https://issues.apache.org/jira/secure/RapidBoard.jspa?rapidView=185&projectKey=DRILL&quickFilter=1039
You need to click on the red Create button at the top to create the JIRA. Please provide as much detail as you can of the issue, including the version numbers of the components, (e.g. Drill, Hbase, Hadoop, etc). -----Original Message----- From: Dor Ben Dov [mailto:dor.ben-...@amdocs.com] Sent: Wednesday, December 13, 2017 11:57 PM To: dev@drill.apache.org Subject: RE: Drill over Hive Aman Can you give me the link to jira so I will be able to file the bug. Regards, Dor -----Original Message----- From: Aman Sinha [mailto:amansi...@apache.org] Sent: יום ד 13 דצמבר 2017 19:46 To: dev@drill.apache.org Subject: Re: Drill over Hive I don't think we test Drill in this 3-tier configuration .. i.e Drill-->Hive-->Hbase. It is mainly Drill-->Hive or Drill-->Hbase. We would need to investigate why the filter pushdown did not get completely propagated down to Hbase. Can you pls file a JIRA ? -Aman On Wed, Dec 13, 2017 at 4:00 AM, Dor Ben Dov <dor.ben-...@amdocs.com> wrote: > Kunal > Correct this is the exact issue, it looks like drill is trying to push > while hive doesn't pass it. > When you work without hive, it works fine. > + > As result - you get very bad performance. > > Regards, > Dor > > -----Original Message----- > From: Kunal Khatua [mailto:kkha...@mapr.com] > Sent: יום ד 13 דצמבר 2017 09:43 > To: dev@drill.apache.org > Subject: RE: Drill over Hive > > It appears you are trying to use Drill to query an Hbase via Hive. It > is possible that Drill is not able to push down the filters to Hive, > though I'm not sure why. > > Aman/Chunhui > Any idea why is Drill triggering a full table scan? > > From: Dor Ben Dov [mailto:dor.ben-...@amdocs.com] > Sent: Tuesday, December 12, 2017 11:39 PM > To: dev@drill.apache.org > Subject: Drill over Hive > > 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<https://urldefense.proofpoint.com/v2/url?u=http- > 3A__www.facebook.com_amdocs_&d=DwMFAg&c=cskdkSMqhcnjZxdQVpwTXg&r=- > cT6otg6lpT_XkmYy7yg3A&m=DAE0fF7_P8TSmHMGxIfhw27jKB1kOw1D8qaGAn > 6q32M&s=bS0vtglEQKbSVkT6_3T5N1ckKa-48J2rFdz0A-GkFxg&e=>, Twitter< > https://urldefense.proofpoint.com/v2/url?u=http-3A__twitter.com_amdocs > &d= > DwMFAg&c=cskdkSMqhcnjZxdQVpwTXg&r=-cT6otg6lpT_XkmYy7yg3A&m=DAE0fF7_ > P8TSmHMGxIfhw27jKB1kOw1D8qaGAn6q32M&s=HwJx9gvHHvHV9u0nW_ > 0dLjEPhSGcfsWLH-iTUFNV6mc&e=>, > LinkedIn<https://urldefense.proofpoint.com/v2/url?u=https-3A__urldefense&d=DwIGaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=-cT6otg6lpT_XkmYy7yg3A&m=uWQC-v7AY6D84a58sK9tkykiGsF-OB22e_QbM4Aw1pw&s=NrK7-hvnHqwvLKK08mRHFoesNPQPoAoNh_zSG-1hZu8&e=. > proofpoint.com/v2/url?u=http-3A__www.linkedin.com_company_ > amdocs&d=DwMFAg&c=cskdkSMqhcnjZxdQVpwTXg&r=-cT6otg6lpT_XkmYy7yg3A&m= > DAE0fF7_P8TSmHMGxIfhw27jKB1kOw1D8qaGAn6q32M&s= > cjcmCjbbkgov6zg8GJnuJOOAm6G9HTtY4ppZ170IDb4&e=>, YouTube< > https://urldefense.proofpoint.com/v2/url?u=http- > 3A__www.youtube.com_amdocsinc&d=DwMFAg&c=cskdkSMqhcnjZxdQVpwTXg&r=- > cT6otg6lpT_XkmYy7yg3A&m=DAE0fF7_P8TSmHMGxIfhw27jKB1kOw1D8qaGAn6q32M&s= > fp9qmbPyYRdiNYDwUDH44HUALaqsbKvfWBv_Dcy7UAo&e=>, Google+< > https://urldefense.proofpoint.com/v2/url?u=https-3A__plus.google.com_ > 105657940751678445194&d=DwMFAg&c=cskdkSMqhcnjZxdQVpwTXg&r=- > cT6otg6lpT_XkmYy7yg3A&m=DAE0fF7_P8TSmHMGxIfhw27jKB1kOw1D8qaGAn > 6q32M&s=n0coUEV3Sf7O_MbrqI7cAr5f6d7OG_vL1jK2n3z-AvM&e=> and the Amdocs > blog network<https://urldefense.proofpoint.com/v2/url?u=http- > 3A__blogs.amdocs.com_&d=DwMFAg&c=cskdkSMqhcnjZxdQVpwTXg&r=- > cT6otg6lpT_XkmYy7yg3A&m=DAE0fF7_P8TSmHMGxIfhw27jKB1kOw1D8qaGAn > 6q32M&s=RxKGDS-92_svSBQlnTdpn8NSr3-1A9Mcp7UbmZsv1bE&e=>| Digital BSS > Research@Yammer<https://urldefense.proofpoint.com/v2/ > url?u=https-3A__www.yammer.com_amdocs.com_-23_threads_ > inGroup-3Ftype-3Din-5Fgroup-26feedId-3D7043838&d=DwMFAg&c= > cskdkSMqhcnjZxdQVpwTXg&r=-cT6otg6lpT_XkmYy7yg3A&m=DAE0fF7_ > P8TSmHMGxIfhw27jKB1kOw1D8qaGAn6q32M&s=A20YnBgQgpBLzoXN- > rOK49KCStW9haqs7atynBoQz-s&e=> > > This message and the information contained herein is proprietary and > confidential and subject to the Amdocs policy statement, you may > review at > https://urldefense.proofpoint.com/v2/url?u=https-3A__www.amdocs.com_about_email-2Ddisclaimer&d=DwIGaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=-cT6otg6lpT_XkmYy7yg3A&m=uWQC-v7AY6D84a58sK9tkykiGsF-OB22e_QbM4Aw1pw&s=oUCLboGr0De82Rrplnox2wXWwYiKhfvtpRfaepKc3Vc&e=<https:// > urldefense.proofpoint.com/v2/url?u=https-3A__www.amdocs. > com_about_email-2Ddisclaimer&d=DwMFAg&c=cskdkSMqhcnjZxdQVpwTXg&r=- > cT6otg6lpT_XkmYy7yg3A&m=DAE0fF7_P8TSmHMGxIfhw27jKB1kOw1D8qaGAn6q32M&s= > xqkKqSeAK9HGozYmTy7lO0eKTkY4CG5npyWKUM9XeAY&e=> > This message and the information contained herein is proprietary and > confidential and subject to the Amdocs policy statement, > > you may review at > https://urldefense.proofpoint.com/v2/url?u=https-3A__www.amdocs.com_about_email-2Ddisclaimer&d=DwIGaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=-cT6otg6lpT_XkmYy7yg3A&m=uWQC-v7AY6D84a58sK9tkykiGsF-OB22e_QbM4Aw1pw&s=oUCLboGr0De82Rrplnox2wXWwYiKhfvtpRfaepKc3Vc&e= > < > https://urldefense.proofpoint.com/v2/url?u=https-3A__www.amdocs.com_about_email-2Ddisclaimer&d=DwIGaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=-cT6otg6lpT_XkmYy7yg3A&m=uWQC-v7AY6D84a58sK9tkykiGsF-OB22e_QbM4Aw1pw&s=oUCLboGr0De82Rrplnox2wXWwYiKhfvtpRfaepKc3Vc&e=> > This message and the information contained herein is proprietary and confidential and subject to the Amdocs policy statement, you may review at https://urldefense.proofpoint.com/v2/url?u=https-3A__www.amdocs.com_about_email-2Ddisclaimer&d=DwIGaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=-cT6otg6lpT_XkmYy7yg3A&m=uWQC-v7AY6D84a58sK9tkykiGsF-OB22e_QbM4Aw1pw&s=oUCLboGr0De82Rrplnox2wXWwYiKhfvtpRfaepKc3Vc&e= <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.amdocs.com_about_email-2Ddisclaimer&d=DwIGaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=-cT6otg6lpT_XkmYy7yg3A&m=uWQC-v7AY6D84a58sK9tkykiGsF-OB22e_QbM4Aw1pw&s=oUCLboGr0De82Rrplnox2wXWwYiKhfvtpRfaepKc3Vc&e=>
