Impala Public Jenkins has submitted this change and it was merged. ( http://gerrit.cloudera.org:8080/24870 )
Change subject: IMPALA-15334: Decompose unrewritable CTE suggestions to explore more rewrites ...................................................................... IMPALA-15334: Decompose unrewritable CTE suggestions to explore more rewrites In some cases the suggester returns CTEs that are not rewritable (cannot be used by the rewrite algorithm). Although, the entire CTE may not be rewritable parts of it are so by decomposing it further we can find more sharing opportunities. The commits adds MaterializedViewSubTreeSplitter to decompose a plan into maximal rewritable trees following the limitations imposed by Calcite's materialized view rules. Change-Id: I5aa335a0d61ea4b4a85a22f57e13e1e2083d0736 Reviewed-on: http://gerrit.cloudera.org:8080/24870 Reviewed-by: Impala Public Jenkins <[email protected]> Tested-by: Impala Public Jenkins <[email protected]> --- A java/calcite-planner/src/main/java/org/apache/impala/calcite/rel/MaterializedViewSubTreeSplitter.java M java/calcite-planner/src/main/java/org/apache/impala/calcite/service/CalciteOptimizer.java M testdata/workloads/functional-planner/queries/PlannerTest/tpcds_cte/tpcds-q02.test M testdata/workloads/functional-planner/queries/PlannerTest/tpcds_cte/tpcds-q14a.test M testdata/workloads/functional-planner/queries/PlannerTest/tpcds_cte/tpcds-q14b.test M testdata/workloads/functional-planner/queries/PlannerTest/tpcds_cte/tpcds-q23a.test M testdata/workloads/functional-planner/queries/PlannerTest/tpcds_cte/tpcds-q23b.test M testdata/workloads/functional-planner/queries/PlannerTest/tpcds_cte/tpcds-q44.test M testdata/workloads/functional-planner/queries/PlannerTest/tpcds_cte/tpcds-q56.test M testdata/workloads/functional-planner/queries/PlannerTest/tpcds_cte/tpcds-q58.test M testdata/workloads/functional-planner/queries/PlannerTest/tpcds_cte/tpcds-q60.test M testdata/workloads/functional-planner/queries/PlannerTest/tpcds_cte/tpcds-q64.test M testdata/workloads/functional-planner/queries/PlannerTest/tpcds_cte/tpcds-q83.test A testdata/workloads/functional-query/queries/QueryTest/cte_decompose.test M tests/query_test/test_calcite_planner.py 15 files changed, 27,807 insertions(+), 23,052 deletions(-) Approvals: Impala Public Jenkins: Looks good to me, approved; Verified -- To view, visit http://gerrit.cloudera.org:8080/24870 To unsubscribe, visit http://gerrit.cloudera.org:8080/settings Gerrit-Project: Impala-ASF Gerrit-Branch: master Gerrit-MessageType: merged Gerrit-Change-Id: I5aa335a0d61ea4b4a85a22f57e13e1e2083d0736 Gerrit-Change-Number: 24870 Gerrit-PatchSet: 4 Gerrit-Owner: Stamatis Zampetakis <[email protected]> Gerrit-Reviewer: Aman Sinha <[email protected]> Gerrit-Reviewer: Impala Public Jenkins <[email protected]> Gerrit-Reviewer: Joe McDonnell <[email protected]> Gerrit-Reviewer: Michael Smith <[email protected]> Gerrit-Reviewer: Stamatis Zampetakis <[email protected]> Gerrit-Reviewer: Steve Carlin <[email protected]>
