Return-Path: X-Original-To: apmail-drill-dev-archive@www.apache.org Delivered-To: apmail-drill-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id DFF83188B2 for ; Fri, 19 Feb 2016 18:16:35 +0000 (UTC) Received: (qmail 62629 invoked by uid 500); 19 Feb 2016 18:16:35 -0000 Delivered-To: apmail-drill-dev-archive@drill.apache.org Received: (qmail 62572 invoked by uid 500); 19 Feb 2016 18:16:35 -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 62561 invoked by uid 99); 19 Feb 2016 18:16:35 -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; Fri, 19 Feb 2016 18:16:35 +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 F349C18051D for ; Fri, 19 Feb 2016 18:16:34 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.68 X-Spam-Level: X-Spam-Status: No, score=0.68 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=2, KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_MED=-2.3, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01] autolearn=disabled Received: from mx2-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id Rd_9-69t4VCr for ; Fri, 19 Feb 2016 18:16:32 +0000 (UTC) Received: from p01c11o145.mxlogic.net (p01c11o145.mxlogic.net [208.65.144.68]) by mx2-lw-us.apache.org (ASF Mail Server at mx2-lw-us.apache.org) with ESMTPS id D37B25F1B4 for ; Fri, 19 Feb 2016 18:16:31 +0000 (UTC) Received: from unknown [199.255.244.181] (EHLO POST-1.gp.cv.commvault.com) by p01c11o145.mxlogic.net(mxl_mta-8.5.0-6) over TLS secured channel with ESMTP id 8fb57c65.0.7626600.00-183.21367450.p01c11o145.mxlogic.net (envelope-from ); Fri, 19 Feb 2016 11:16:31 -0700 (MST) X-MXL-Hash: 56c75bff22aaf74e-534e61542dc87c28d620f44103dccd2449065cf8 Received: from POST-1.gp.cv.commvault.com (172.19.59.252) by POST-1.gp.cv.commvault.com (172.19.59.252) with Microsoft SMTP Server (TLS) id 15.0.1076.9; Fri, 19 Feb 2016 13:16:23 -0500 Received: from POST-1.gp.cv.commvault.com ([fe80::f4d4:bcf9:5eab:192a]) by POST-1.gp.cv.commvault.com ([fe80::f4d4:bcf9:5eab:192a%21]) with mapi id 15.00.1076.000; Fri, 19 Feb 2016 13:16:23 -0500 From: Sudip Mukherjee To: "dev@drill.apache.org" Subject: Optimizing SUM(1) query Thread-Topic: Optimizing SUM(1) query Thread-Index: AdFrQU4tRSihXJ7NTsumvU+Qu7uzWg== Date: Fri, 19 Feb 2016 18:16:23 +0000 Message-ID: <173831dc752d40b28c477215f50815bc@POST-1.gp.cv.commvault.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [172.16.26.77] Content-Type: multipart/alternative; boundary="=_reb-r753CCA32-t56C75C00" MIME-Version: 1.0 X-Processed-By: Rebuild v2.0-0 X-AnalysisOut: [v=2.1 cv=INgEf1bG c=1 sm=1 tr=0 a=KkXCHsHC3+RvsKXbCvF0Ig==] X-AnalysisOut: [:117 a=KkXCHsHC3+RvsKXbCvF0Ig==:17 a=sN01QWlQhc8A:10 a=xqW] X-AnalysisOut: [C_Br6kY4A:10 a=jFJIQSaiL_oA:10 a=qKdt7GHHEA_Sg_vKUTUA:9 a=] X-AnalysisOut: [pFyw_tIh7lTD1U8U:21 a=rcXFAKI_0HJZDrB2:21 a=CjuIK1q_8ugA:1] X-AnalysisOut: [0 a=CezEO-gv0XkA:10 a=yMhMjlubAAAA:8 a=SSmOFEACAAAA:8 a=gK] X-AnalysisOut: [O2Hq4RSVkA:10 a=UiCQ7L4-1S4A:10 a=hTZeC7Yk6K0A:10 a=frz4Au] X-AnalysisOut: [Cg-hUA:10] X-Spam: [F=0.5000000000; CM=0.500; MH=0.500(2016021908); S=0.200(2015072901)] X-MAIL-FROM: X-SOURCE-IP: [199.255.244.181] --=_reb-r753CCA32-t56C75C00 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, Have anyone tried optimizing SUM(1) query in drill? Or is it implemented? Getting these query while using Tableau. Mostly probably it is trying to fi= gure out NUMBER_OF_RECORDS. Thanks, Sudip ***************************Legal Disclaimer*************************** "This communication may contain confidential and privileged material for the sole use of the intended recipient. Any unauthorized review, use or distrib= ution by others is strictly prohibited. If you have received the message by mista= ke, please advise the sender by reply email and delete the message. Thank you." ********************************************************************** --=_reb-r753CCA32-t56C75C00--