[jira] [Updated] (DRILL-5429) Improve query performance for MapR DB JSON Tables

["Padma Penumarthy (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-5429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Padma Penumarthy updated DRILL-5429:
------------------------------------
    Description: 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.  (was: For MapR DB JSON Tables, cache (per query) and reuse tableStats. Getting tableStats is an expensive operation. Saving it and reusing it helps reduce query latency. )
        Summary: Improve query performance for MapR DB JSON Tables  (was: Cache tableStats per query for MapR DB JSON Tables)

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