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 <spancha...@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 <spancha...@mapr.com>
Date: 2016-11-29T07:48:36Z
Change the format plugin config parameter name.
commit 8897b8fb15eb76c4b89270456b6b4d86696e7b38
Author: Smidth Panchamia <spancha...@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 <spancha...@mapr.com>
Date: 2016-12-05T18:55:14Z
Merge branch 'master' of github.com:spanchamiamapr/drill
commit ab8e728d7ed3fcd8c27243462bea42b7d2ea29c5
Author: Smidth Panchamia <spancha...@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 <spancha...@mapr.com>
Date: 2016-12-20T07:10:17Z
Merge remote-tracking branch 'upstream/master'
commit 72bd06c744dd71ad9a1aa87c91dabcd89eb4fa36
Author: Smidth Panchamia <spancha...@mapr.com>
Date: 2016-12-21T09:29:45Z
DRILL-5137 - Optimize count(*) queries on MapR-DB Binary tables
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---
