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