[
https://issues.apache.org/jira/browse/TAJO-903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14056046#comment-14056046
]
Hudson commented on TAJO-903:
-----------------------------
SUCCESS: Integrated in Tajo-master-build #281 (See
[https://builds.apache.org/job/Tajo-master-build/281/])
TAJO-903: Some left outer join cases are not optimized as the broadcast join.
(Hyoungjun Kim via hyunsik) (hyunsik: rev
a5d14f8082fed000835520df6c9f12476039aea1)
*
tajo-core/src/test/java/org/apache/tajo/master/querymaster/TestQueryUnitStatusUpdate.java
* tajo-core/src/main/java/org/apache/tajo/worker/Task.java
* CHANGES
*
tajo-core/src/test/resources/queries/TestJoinBroadcast/testBroadcastSubquery.sql
* tajo-core/src/main/java/org/apache/tajo/engine/planner/logical/JoinNode.java
*
tajo-core/src/test/resources/results/TestJoinBroadcast/testLeftOuterJoin2.result
* tajo-core/src/test/java/org/apache/tajo/engine/query/TestJoinBroadcast.java
* tajo-core/src/test/resources/queries/TestJoinBroadcast/testLeftOuterJoin3.sql
* tajo-core/src/main/java/org/apache/tajo/master/DefaultTaskScheduler.java
*
tajo-core/src/test/resources/queries/TestJoinOnPartitionedTables/testFilterPushDownPartitionColumnCaseWhen.sql
* tajo-core/src/main/java/org/apache/tajo/worker/TaskAttemptContext.java
* tajo-core/src/main/java/org/apache/tajo/engine/planner/logical/ScanNode.java
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/BroadcastJoinPlanVisitor.java
* tajo-core/src/main/java/org/apache/tajo/master/querymaster/Repartitioner.java
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/BroadcastJoinMarkCandidateVisitor.java
*
tajo-core/src/test/java/org/apache/tajo/engine/planner/global/TestBroadcastJoinPlan.java
*
tajo-core/src/test/resources/queries/TestJoinBroadcast/create_orders_large_ddl.sql
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/PhysicalPlannerImpl.java
*
tajo-core/src/test/resources/results/TestJoinBroadcast/testLeftOuterJoin3.result
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/global/GlobalPlanner.java
* tajo-core/src/test/java/org/apache/tajo/master/TestExecutionBlockCursor.java
* tajo-core/src/test/resources/queries/TestJoinBroadcast/testLeftOuterJoin2.sql
*
tajo-core/src/test/resources/results/TestJoinBroadcast/testBroadcastSubquery.result
* tajo-core/src/test/resources/dataset/TestJoinBroadcast/orders_large/orders.tbl
* tajo-core/src/main/java/org/apache/tajo/master/querymaster/SubQuery.java
> Some left outer join cases are not optimized as the broadcast join.
> -------------------------------------------------------------------
>
> Key: TAJO-903
> URL: https://issues.apache.org/jira/browse/TAJO-903
> Project: Tajo
> Issue Type: Improvement
> Reporter: Hyoungjun Kim
> Assignee: Hyoungjun Kim
> Fix For: 0.9.0
>
>
> The next query has three small tables and expected broadcast join, but not.
> {code:sql}
> select count(*) from large1
> left outer join large2 on large1_id = large2_id
> left outer join small1 on large1_id = small1_id
> left outer join small2 on large1_id = small2_id
> left outer join small3 on large1_id = small3_id
> {code}
> The next is the upper query's plan.
> {noformat}
> |-eb_1404411535695_0000_000011
> |-eb_1404411535695_0000_000010
> |-eb_1404411535695_0000_000009 (join)
> |-eb_1404411535695_0000_000008 (small)
> |-eb_1404411535695_0000_000007 (join)
> |-eb_1404411535695_0000_000006 (small)
> |-eb_1404411535695_0000_000005 (join)
> |-eb_1404411535695_0000_000004 (small)
> |-eb_1404411535695_0000_000003 (join)
> |-eb_1404411535695_0000_000002 (large)
> |-eb_1404411535695_0000_000001 (large)
> {noformat}
> Optimized plan should be the next.
> {noformat}
> |-eb_1404411906426_0000_000005
> |-eb_1404411906426_0000_000004
> |-eb_1404411906426_0000_000003 (broadcast small1, small2, small3)
> |-eb_1404411906426_0000_000002 (large)
> |-eb_1404411906426_0000_000001 (large)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
