You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2016/12/20 00:19:58 UTC

[jira] [Updated] (DRILL-5065) Optimize count(*) queries on MapR-DB JSON Tables

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

Abhishek Girish updated DRILL-5065:
-----------------------------------
    Summary: Optimize count(*) queries on MapR-DB JSON Tables  (was: Optimize count( *) queries on MapR-DB JSON Tables)

> 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
>              Labels: ready-to-commit
>             Fix For: 1.10.0
>
>
> 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)