drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-5429) Improve query performance for MapR DB JSON Tables
Date Fri, 28 Apr 2017 15:10:04 GMT

    [ https://issues.apache.org/jira/browse/DRILL-5429?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15988974#comment-15988974
] 

ASF GitHub Bot commented on DRILL-5429:
---------------------------------------

Github user ppadma commented on the issue:

    https://github.com/apache/drill/pull/817
  
    I changed as per your suggestion to use clone. We should recompute regionsToScan as it
depends upon scanSpec. We can skip init by copying table and tabletInfo from old scan. Also,
we can skip getting tableStats altogether as rowCount can be obtained from tabletInfo. 
    Please review new diffs.


> 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
>             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)

Mime
View raw message