Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/1152#discussion_r175137249
--- Diff:
exec/java-exec/src/test/java/org/apache/drill/exec/store/parquet/TestPushDownAndPruningWithItemStar.java
---
@@ -180,4 +248,38 @@ public void testFilterPushDownMultipleConditions()
throws Exception {
.build();
}
+ @Test
+ public void testFilterPushDownWithSeveralNestedStarSubQueries() throws
Exception {
+ String subQuery = String.format("select * from `%s`.`%s`",
DFS_TMP_SCHEMA, TABLE_NAME);
+ String query = String.format("select * from (select * from (select *
from (%s))) where o_orderdate = date '1992-01-01'", subQuery);
+
+ String[] expectedPlan = {"numFiles=1, numRowGroups=1,
usedMetadataFile=false, columns=\\[`\\*\\*`, `o_orderdate`\\]"};
+ String[] excludedPlan = {};
+
+ PlanTestBase.testPlanMatchingPatterns(query, expectedPlan,
excludedPlan);
+
+ testBuilder()
+ .sqlQuery(query)
+ .unOrdered()
+ .sqlBaselineQuery("select * from `%s`.`%s` where o_orderdate =
date '1992-01-01'", DFS_TMP_SCHEMA, TABLE_NAME)
+ .build();
+ }
+
+ @Test
+ public void
testFilterPushDownWithSeveralNestedStarSubQueriesWithAdditionalColumns() throws
Exception {
+ String subQuery = String.format("select * from `%s`.`%s`",
DFS_TMP_SCHEMA, TABLE_NAME);
+ String query = String.format("select * from (select * from (select *,
o_orderdate from (%s))) where o_orderdate = date '1992-01-01'", subQuery);
--- End diff --
Done.
---
