You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/12/21 09:38:58 UTC
[jira] [Commented] (DRILL-5137) Optimize count(*) queries on
MapR-DB Binary Tables
[ https://issues.apache.org/jira/browse/DRILL-5137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15766601#comment-15766601 ]
ASF GitHub Bot commented on DRILL-5137:
---------------------------------------
GitHub user spanchamiamapr opened a pull request:
https://github.com/apache/drill/pull/699
DRILL-5137 - Optimize count(*) queries for MapR-DB Binary Tables
This diff uses the same optimization as that for the rowKeyOnly queries.
We use the FirstKeyOnlyFilter for count(*) queries.
This fix will optimize these queries for HBase tables, as well as MapR-DB Binary tables.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/spanchamiamapr/drill md1230
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/drill/pull/699.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 #699
----
commit 3d12a9526365bcc96c605fc30f3b6fbe4961b97d
Author: Smidth Panchamia <sp...@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)
commit 6b5923e383e2add4b3042248e5f389d32936a5b7
Author: Smidth Panchamia <sp...@mapr.com>
Date: 2016-11-29T07:48:36Z
Change the format plugin config parameter name.
commit 8897b8fb15eb76c4b89270456b6b4d86696e7b38
Author: Smidth Panchamia <sp...@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.
commit d1d05e8bd4b96fd1bd144c50ddf20466a4bfda16
Author: Smidth Panchamia <sp...@mapr.com>
Date: 2016-12-05T18:55:14Z
Merge branch 'master' of github.com:spanchamiamapr/drill
commit ab8e728d7ed3fcd8c27243462bea42b7d2ea29c5
Author: Smidth Panchamia <sp...@mapr.com>
Date: 2016-12-14T20:01:06Z
Merge remote-tracking branch 'upstream/master'
Conflicts:
contrib/format-maprdb/src/main/java/org/apache/drill/exec/store/mapr/db/MapRDBFormatPluginConfig.java
commit c84464f8fd099cb17a573faa4310a70eada3b49e
Author: Smidth Panchamia <sp...@mapr.com>
Date: 2016-12-20T07:10:17Z
Merge remote-tracking branch 'upstream/master'
commit 72bd06c744dd71ad9a1aa87c91dabcd89eb4fa36
Author: Smidth Panchamia <sp...@mapr.com>
Date: 2016-12-21T09:29:45Z
DRILL-5137 - Optimize count(*) queries on MapR-DB Binary tables
----
> Optimize count(*) queries on MapR-DB Binary Tables
> --------------------------------------------------
>
> Key: DRILL-5137
> URL: https://issues.apache.org/jira/browse/DRILL-5137
> Project: Apache Drill
> Issue Type: Improvement
> Components: Storage - HBase, Storage - MapRDB
> Affects Versions: 1.9.0
> Reporter: Abhishek Girish
> Assignee: Smidth Panchamia
>
> This is related to DRILL-5065, but applies to MapR-DB Binary tables
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)