[
https://issues.apache.org/jira/browse/TAJO-891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14051463#comment-14051463
]
Hudson commented on TAJO-891:
-----------------------------
SUCCESS: Integrated in Tajo-master-build #274 (See
[https://builds.apache.org/job/Tajo-master-build/274/])
TAJO-891: Complex join conditions with UNION or inline should be supported.
(hyunsik: rev eae4c132363a63240d93c5522e48b44e45d9553d)
* tajo-core/src/main/java/org/apache/tajo/engine/planner/PlannerUtil.java
*
tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition5.result
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/rewrite/ProjectionPushDownRule.java
*
tajo-core/src/test/resources/queries/TestJoinQuery/testComplexJoinCondition6.sql
*
tajo-core/src/test/resources/queries/TestJoinQuery/testComplexJoinCondition5.sql
*
tajo-core/src/test/resources/queries/TestJoinQuery/testComplexJoinCondition7.sql
* CHANGES
*
tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition6.result
*
tajo-catalog/tajo-catalog-common/src/main/java/org/apache/tajo/catalog/Schema.java
*
tajo-core/src/test/resources/results/TestJoinQuery/testComplexJoinCondition7.result
* tajo-core/src/test/java/org/apache/tajo/engine/query/TestJoinQuery.java
> Complex join conditions with UNION or inline should be supported
> ----------------------------------------------------------------
>
> Key: TAJO-891
> URL: https://issues.apache.org/jira/browse/TAJO-891
> Project: Tajo
> Issue Type: Bug
> Components: distributed query plan, planner/optimizer
> Reporter: Hyunsik Choi
> Assignee: Hyunsik Choi
> Fix For: 0.9.0
>
>
> Please see the following two example queries. Currently, they will cause
> planning exception. This patch fixes the bugs.
> {code}
> select
> n1.n_nationkey,
> substr(n1.n_name, 1, 4) name1,
> substr(n2.n_name, 1, 4) name2
> from nation n1 join (select * from nation) n2 on substr(n1.n_name, 1, 4) =
> substr(n2.n_name, 1, 4)
> order by n1.n_nationkey;
> {code}
> {code}
> select
> n1.n_nationkey,
> substr(n1.n_name, 1, 4) name1,
> substr(n2.n_name, 1, 4) name2
> from nation n1 join (select * from nation union select * from nation) n2 on
> substr(n1.n_name, 1, 4) = substr(n2.n_name, 1, 4)
> order by n1.n_nationkey;
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
