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 98167200C76 for ; Sat, 13 May 2017 19:40:08 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 96A48160BBB; Sat, 13 May 2017 17:40:08 +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 DDC8E160BB2 for ; Sat, 13 May 2017 19:40:07 +0200 (CEST) Received: (qmail 88721 invoked by uid 500); 13 May 2017 17:40:07 -0000 Mailing-List: contact issues-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 issues@drill.apache.org Received: (qmail 88709 invoked by uid 99); 13 May 2017 17:40:07 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 13 May 2017 17:40:07 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id BC49BC3B07 for ; Sat, 13 May 2017 17:40:06 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -100.002 X-Spam-Level: X-Spam-Status: No, score=-100.002 tagged_above=-999 required=6.31 tests=[RP_MATCHES_RCVD=-0.001, SPF_PASS=-0.001, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id 3sX24S2bjce4 for ; Sat, 13 May 2017 17:40:06 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id 2B99D60DA1 for ; Sat, 13 May 2017 17:40:05 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 6345CE002A for ; Sat, 13 May 2017 17:40:04 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 25FFF242F5 for ; Sat, 13 May 2017 17:40:04 +0000 (UTC) Date: Sat, 13 May 2017 17:40:04 +0000 (UTC) From: "ASF GitHub Bot (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (DRILL-5429) Improve query performance for MapR DB JSON Tables MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Sat, 13 May 2017 17:40:08 -0000 [ https://issues.apache.org/jira/browse/DRILL-5429?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16009431#comment-16009431 ] ASF GitHub Bot commented on DRILL-5429: --------------------------------------- Github user asfgit closed the pull request at: https://github.com/apache/drill/pull/817 > Improve query performance for MapR DB JSON Tables > ------------------------------------------------- > > Key: DRILL-5429 > URL: https://issues.apache.org/jira/browse/DRILL-5429 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization, Storage - MapRDB > Affects Versions: 1.10.0 > Reporter: Padma Penumarthy > Assignee: Padma Penumarthy > Labels: ready-to-commit > Fix For: 1.11.0 > > > For MapR DB JSON Tables, cache (per query) and reuse table and tabletInfo, instead of fetching the same information multiple times from DB server. Also, getting tableStats is an expensive operation. We can avoid doing that and instead, get total rowCount from tabletInfo instead. -- This message was sent by Atlassian JIRA (v6.3.15#6346)