[
https://issues.apache.org/jira/browse/DRILL-8057?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17450651#comment-17450651
]
ASF GitHub Bot commented on DRILL-8057:
---------------------------------------
dzamo opened a new pull request #2388:
URL: https://github.com/apache/drill/pull/2388
# [DRILL-8057](https://issues.apache.org/jira/browse/DRILL-8057):
INFORMATION_SCHEMA filter push down is inefficient
## Description
WHERE clauses in queries against INFORMATION_SCHEMA do not stop Drill from
fetching a schema hierarchy from all enabled storage configs. This results in
abysmal performance when unresponsive data sources are enabled, as reported by
users in the Apache Drill Slack channels. This PR teaches info schema to prune
irrelevant schema subtrees from the search tree.
## Documentation
No user-visible change
## Testing
Existing info schema unit tests + one addition for IN operator
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscr...@drill.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
> INFORMATION_SCHEMA filter push down is inefficient
> --------------------------------------------------
>
> Key: DRILL-8057
> URL: https://issues.apache.org/jira/browse/DRILL-8057
> Project: Apache Drill
> Issue Type: Improvement
> Components: Storage - Information Schema
> Affects Versions: 1.19.0
> Reporter: James Turton
> Assignee: James Turton
> Priority: Major
> Fix For: 1.20.0
>
>
> WHERE clauses in queries against INFORMATION_SCHEMA do not stop Drill from
> fetching a schema hierarchy from all enabled storage configs. This results
> in abysmal performance when unresponsive data sources are enabled, as
> reported by users in the Apache Drill Slack channels.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
