Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 98E87200D56 for ; Tue, 12 Dec 2017 12:28:26 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 97278160C0F; Tue, 12 Dec 2017 11:28:26 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id DCD78160BE7 for ; Tue, 12 Dec 2017 12:28:25 +0100 (CET) Received: (qmail 88177 invoked by uid 500); 12 Dec 2017 11:28:20 -0000 Mailing-List: contact dev-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list dev@drill.apache.org Received: (qmail 88165 invoked by uid 99); 12 Dec 2017 11:28:19 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Dec 2017 11:28:19 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 5E41C180715 for ; Tue, 12 Dec 2017 11:28:19 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.999 X-Spam-Level: ** X-Spam-Status: No, score=2.999 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=2, KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_NONE=-0.0001, RP_MATCHES_RCVD=-0.001] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id sH3oYlLVwJG8 for ; Tue, 12 Dec 2017 11:28:17 +0000 (UTC) Received: from mx3.amdocs.com (ramail2.amdocs.com [193.43.244.136]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id BBC1E5FB5F for ; Tue, 12 Dec 2017 11:28:15 +0000 (UTC) amddisc: amdocs_ Received: from unknown (HELO ILHFDAGDRFE2.corp.amdocs.com) ([10.224.0.130]) by ilmail02.corp.amdocs.com with ESMTP; 12 Dec 2017 13:28:07 +0200 Received: from ILRAADAGBE4.corp.amdocs.com ([fe80::d43c:760e:c647:805e]) by ILHFDAGDRFE2.corp.amdocs.com ([fe80::60cc:c7e4:5eac:4ff2%13]) with mapi id 14.03.0352.000; Tue, 12 Dec 2017 13:28:07 +0200 From: Dor Ben Dov To: "dev@drill.apache.org" Subject: drill vs hive vs native hbase count Thread-Topic: drill vs hive vs native hbase count Thread-Index: AdNzPBoKMyyubzFSR3OEeJ754jNLhw== Date: Tue, 12 Dec 2017 11:28:06 +0000 Message-ID: <14840688A62CAA4197A28AACCDA9D2DB4E8CFE75@ILRAADAGBE4.corp.amdocs.com> Accept-Language: he-IL, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.234.8.214] Content-Type: multipart/alternative; boundary="_000_14840688A62CAA4197A28AACCDA9D2DB4E8CFE75ILRAADAGBE4corp_" MIME-Version: 1.0 archived-at: Tue, 12 Dec 2017 11:28:26 -0000 --_000_14840688A62CAA4197A28AACCDA9D2DB4E8CFE75ILRAADAGBE4corp_ Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Hi Everyone, I tried the same query of 'select count(*) from table x' from hive, drill g= ui (no hive) and natively using hbase count. The hive and hbase native got the same result, but in Drill - I got a diffe= rent (higher) result. What might be or causing this gap ? Regards, Dor This message and the information contained herein is proprietary and confid= ential and subject to the Amdocs policy statement, you may review at https://www.amdocs.com/about/email-disclaimer --_000_14840688A62CAA4197A28AACCDA9D2DB4E8CFE75ILRAADAGBE4corp_--