[
https://issues.apache.org/jira/browse/DRILL-8057?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17450906#comment-17450906
]
ASF GitHub Bot commented on DRILL-8057:
---------------------------------------
dzamo commented on a change in pull request #2388:
URL: https://github.com/apache/drill/pull/2388#discussion_r758981355
##########
File path:
exec/java-exec/src/test/java/org/apache/drill/exec/sql/TestInfoSchema.java
##########
@@ -64,13 +64,13 @@ public static void setupFiles() {
@Test
public void selectFromAllTables() throws Exception{
- test("select * from INFORMATION_SCHEMA.SCHEMATA");
- test("select * from INFORMATION_SCHEMA.CATALOGS");
- test("select * from INFORMATION_SCHEMA.VIEWS");
- test("select * from INFORMATION_SCHEMA.`TABLES`");
- test("select * from INFORMATION_SCHEMA.COLUMNS");
- test("select * from INFORMATION_SCHEMA.`FILES`");
- test("select * from INFORMATION_SCHEMA.`PARTITIONS`");
+// test("select * from INFORMATION_SCHEMA.SCHEMATA");
+// test("select * from INFORMATION_SCHEMA.CATALOGS");
+// test("select * from INFORMATION_SCHEMA.VIEWS");
+ test("select * from INFORMATION_SCHEMA.`TABLES` where table_schema =
'cp.default'");
+// test("select * from INFORMATION_SCHEMA.COLUMNS");
+// test("select * from INFORMATION_SCHEMA.`FILES`");
+// test("select * from INFORMATION_SCHEMA.`PARTITIONS`");
Review comment:
@vvysotskyi thanks, this was definitely not supposed to be included in
what I pushed. Reverted this test, another new one is already present.
--
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)
