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/11/23 19:32:59 UTC

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

Abhishek Girish created DRILL-5065:
--------------------------------------

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