Hi Arina, I am using 3 driibits on my 3 instances of cloudera cluster. The data is located in Hbase and of course at the end as a file. How many columns - 10. The data is regular data but also jsons. Does this helps ?
Regards, Dor -----Original Message----- From: Arina Yelchiyeva [mailto:arina.yelchiy...@gmail.com] Sent: יום ד 13 דצמבר 2017 19:21 To: dev@drill.apache.org Subject: Re: drill vs hive vs native hbase count Hi Dor, I guess you need to provide more information. Environment are using (how many drillbits, where data is located (fs, dfs))? Data format you are querying? How many columns in file? Kind regards Arina On Wed, Dec 13, 2017 at 2:06 PM, Dor Ben Dov <dor.ben-...@amdocs.com> wrote: > Anyone ? > This is major integrity issue. > > > Regards, > Dor > > -----Original Message----- > From: Dor Ben Dov > Sent: יום ג 12 דצמבר 2017 13:28 > To: dev@drill.apache.org > Subject: drill vs hive vs native hbase count > > Hi Everyone, > > I tried the same query of 'select count(*) from table x' from hive, > drill gui (no hive) and natively using hbase count. > > The hive and hbase native got the same result, but in Drill - I got a > different (higher) result. > > What might be or causing this gap ? > > Regards, > Dor > > 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> > 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> > 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>
