GitHub user ppadma opened a pull request:
https://github.com/apache/drill/pull/1038
DRILL-5972: Slow performance for query on INFORMATION_SCHEMA.TABLE
Please see DRILL-5972.
Problem is while evaluating "boolean and", we are returning as soon as
expression result is not TRUE. We should go through all the expressions and if
any of them is FALSE, return FALSE. If any of them is INCONCLUSIVE, return
INCONCLUSIVE.
Tested the fix with lot of hive tables and verified that it fixes the
performance problem.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/ppadma/drill DRILL-5972
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/drill/pull/1038.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 #1038
----
commit 70f489098acc94d9e1af1aa05c35e2dfe01198c6
Author: Padma Penumarthy <[email protected]>
Date: 2017-11-16T04:31:23Z
DRILL-5972: Slow performance for query on INFORMATION_SCHEMA.TABLE
----
---
