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-5065) Optimize count( *) queries on MapR-DB JSON Tables
Date Mon, 05 Dec 2016 19:01:01 GMT

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

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

GitHub user spanchamiamapr opened a pull request:

    https://github.com/apache/drill/pull/677

    DRILL-5065 - Optimize count( * ) queries on MapR-DB JSON Tables

    In MapR-DB v5.2.0, we enabled '_id' only projection for JSON tables.
    Hence, we can now optimize the following queries:
    a. count(*) by projecting only the '_id' column.
    b. '_id' only projections, including count(_id)
    
    Change the format plugin config parameter name.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/spanchamiamapr/drill drill-5065

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/drill/pull/677.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #677
    
----
commit 0c07e2857f09e6f262b246e795f10901ed744e3d
Author: Smidth Panchamia <spanchamia@mapr.com>
Date:   2016-11-28T21:59:34Z

    DRILL-5065 - Optimize count( * ) queries on MapR-DB JSON Tables
    In MapR-DB v5.2.0, we enabled '_id' only projection for JSON tables.
    Hence, we can now optimize the following queries:
    a. count(*) by projecting only the '_id' column.
    b. '_id' only projections, including count(_id)
    
    Change the format plugin config parameter name.

----


> Optimize count( *) queries on MapR-DB JSON Tables
> -------------------------------------------------
>
>                 Key: DRILL-5065
>                 URL: https://issues.apache.org/jira/browse/DRILL-5065
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Storage - MapRDB
>    Affects Versions: 1.9.0
>         Environment: Clusters with MapR v5.2.0 and above
>            Reporter: Abhishek Girish
>            Assignee: Smidth Panchamia
>
> The JSON FileReader optimizes count(* ) queries, by only counting the number of records
in the files and discarding the data. This makes the query execution faster & efficient.

> We need a similar feature in the MapR format plugin (maprdb) to optimize _id only projection
& count(* ) queries on MapR-DB JSON Tables.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message