You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@impala.apache.org by "Baike Xia (Code Review)" <ge...@cloudera.org> on 2022/12/06 11:05:04 UTC

[Impala-ASF-CR] IMPALA-11485: Pushdown LIMIT through UNION ALL and LEFT/RIGHT OUTER JOIN

Baike Xia has uploaded a new patch set (#8). ( http://gerrit.cloudera.org:8080/18862 )

Change subject: IMPALA-11485: Pushdown LIMIT through UNION ALL and LEFT/RIGHT OUTER JOIN
......................................................................

IMPALA-11485: Pushdown LIMIT through UNION ALL and LEFT/RIGHT OUTER JOIN

Pushdown LIMIT through UNION ALL:
Transforms:
   - Limit
      - Union
         - relation1
         - relation2
         ..
Into:
   - Limit
      - Union
         - Limit
            - relation1
         - Limit
            - relation2
         ..

Pushdown LIMIT through LEFT/RIGHT OUTER JOIN:
Transforms:
   - Limit
      - Join
         - left source
         - right source
Into:
   - Limit
      - Join
         - Limit (present if Join is left outer)
            - left source
         - Limit (present if Join is right outer)
            - right source

Change-Id: Ia5d040c0a98e60639d7ce4b25ecf07a859c8a32c
---
M fe/src/main/java/org/apache/impala/planner/SingleNodePlanner.java
M fe/src/test/java/org/apache/impala/planner/PlannerTest.java
M testdata/workloads/functional-planner/queries/PlannerTest/aggregation.test
M testdata/workloads/functional-planner/queries/PlannerTest/iceberg-v2-tables.test
M testdata/workloads/functional-planner/queries/PlannerTest/joins.test
A testdata/workloads/functional-planner/queries/PlannerTest/limit-pushdown-outer-join.test
A testdata/workloads/functional-planner/queries/PlannerTest/limit-pushdown-union.test
M testdata/workloads/functional-planner/queries/PlannerTest/topn.test
M testdata/workloads/functional-planner/queries/PlannerTest/union.test
M testdata/workloads/functional-query/queries/QueryTest/joins.test
A testdata/workloads/functional-query/queries/limit-pushdown-outer-join.test
A testdata/workloads/functional-query/queries/limit-pushdown-union.test
A tests/query_test/test_limit_pushdown.py
M tests/query_test/test_observability.py
14 files changed, 469 insertions(+), 39 deletions(-)


  git pull ssh://gerrit.cloudera.org:29418/Impala-ASF refs/changes/62/18862/8
-- 
To view, visit http://gerrit.cloudera.org:8080/18862
To unsubscribe, visit http://gerrit.cloudera.org:8080/settings

Gerrit-Project: Impala-ASF
Gerrit-Branch: master
Gerrit-MessageType: newpatchset
Gerrit-Change-Id: Ia5d040c0a98e60639d7ce4b25ecf07a859c8a32c
Gerrit-Change-Number: 18862
Gerrit-PatchSet: 8
Gerrit-Owner: Baike Xia <xi...@163.com>
Gerrit-Reviewer: Aman Sinha <am...@cloudera.com>
Gerrit-Reviewer: Baike Xia <xi...@163.com>
Gerrit-Reviewer: Csaba Ringhofer <cs...@cloudera.com>
Gerrit-Reviewer: Impala Public Jenkins <im...@cloudera.com>
Gerrit-Reviewer: Jian Zhang <zj...@gmail.com>
Gerrit-Reviewer: Quanlong Huang <hu...@gmail.com>