In addition, it would help if you can provide more details such as : - what version of Drill and HBase are you running ? - the EXPLAIN plan of the query you ran - what was the expected and actual result ?
On Wed, Dec 13, 2017 at 9:21 AM, Arina Yelchiyeva < arina.yelchiy...@gmail.com> wrote: > 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> > > >