[
https://issues.apache.org/jira/browse/TAJO-853?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041835#comment-14041835
]
Hudson commented on TAJO-853:
-----------------------------
SUCCESS: Integrated in Tajo-master-build #254 (See
[https://builds.apache.org/job/Tajo-master-build/254/])
TAJO-853: Refactoring FilterPushDown for OUTER JOIN. (Hyoungjun Kim via
hyunsik) (hyunsik: rev 8cf508aad4cfa631f86229d7ed2875e2a0929c70)
* tajo-core/src/test/resources/queries/TestJoinQuery/testWhereClauseJoin2.sql
*
tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartialFilterPushDownOuterJoin2.result
* tajo-core/src/test/resources/queries/TestJoinQuery/testWhereClauseJoin3.sql
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/logical/join/GreedyHeuristicJoinOrderAlgorithm.java
* tajo-core/src/main/java/org/apache/tajo/engine/eval/CaseWhenEval.java
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/logical/join/JoinGraph.java
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/physical/RightOuterMergeJoinExec.java
*
tajo-core/src/test/java/org/apache/tajo/engine/query/TestJoinOnPartitionedTables.java
* tajo-core/src/main/java/org/apache/tajo/engine/planner/LogicalOptimizer.java
*
tajo-core/src/main/java/org/apache/tajo/master/querymaster/QueryMasterTask.java
* tajo-storage/src/main/java/org/apache/tajo/storage/StorageManager.java
* tajo-core/src/test/resources/results/TestJoinQuery/testWhereClauseJoin3.result
* tajo-storage/src/main/java/org/apache/tajo/storage/NullScanner.java
* tajo-core/src/main/java/org/apache/tajo/master/session/Session.java
*
tajo-core/src/test/resources/queries/TestJoinOnPartitionedTables/testPartialFilterPushDownOuterJoin.sql
*
tajo-core/src/test/resources/queries/TestJoinOnPartitionedTables/testPartialFilterPushDownOuterJoin2.sql
*
tajo-core/src/test/resources/queries/TestJoinOnPartitionedTables/testFilterPushDownPartitionColumnCaseWhen.sql
* tajo-storage/src/main/java/org/apache/tajo/storage/v2/StorageManagerV2.java
*
tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testFilterPushDownPartitionColumnCaseWhen.result
*
tajo-core/src/test/resources/results/TestJoinOnPartitionedTables/testPartialFilterPushDownOuterJoin.result
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/physical/HashLeftOuterJoinExec.java
* tajo-core/src/test/java/org/apache/tajo/QueryTestCaseBase.java
* CHANGES
* tajo-core/src/test/resources/queries/TestJoinQuery/testWhereClauseJoin4.sql
* tajo-core/src/test/resources/results/TestJoinQuery/testWhereClauseJoin4.result
* tajo-core/src/test/java/org/apache/tajo/engine/query/TestJoinQuery.java
* tajo-core/src/test/resources/queries/TestJoinQuery/testWhereClauseJoin1.sql
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/logical/join/JoinEdge.java
* tajo-core/src/test/resources/results/TestJoinQuery/testWhereClauseJoin2.result
* tajo-core/src/main/java/org/apache/tajo/master/GlobalEngine.java
* tajo-common/src/main/java/org/apache/tajo/conf/TajoConf.java
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/physical/SeqScanExec.java
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/rewrite/FilterPushDownRule.java
* tajo-core/src/test/java/org/apache/tajo/TajoTestingCluster.java
* tajo-core/src/test/resources/results/TestJoinQuery/testWhereClauseJoin1.result
> Refactoring FilterPushDown for OUTER JOIN
> -----------------------------------------
>
> Key: TAJO-853
> URL: https://issues.apache.org/jira/browse/TAJO-853
> Project: Tajo
> Issue Type: Improvement
> Reporter: Hyoungjun Kim
> Assignee: Hyoungjun Kim
> Priority: Critical
> Fix For: 0.9.0
>
>
> Currently Tajo doesn't support a filter OUTER JOIN's ON clause.
> or has some bugs. There is some rules for this in the following urls.
> -
> http://www.ibm.com/developerworks/data/library/techarticle/purcell/0112purcell.html
> - https://cwiki.apache.org/confluence/display/Hive/OuterJoinBehavior
> Briefly summarized as follows.
> - Join Predicate on Preserved Row Table: Used for join condition(not filter)
> - Join Predicate on Null Supplying Table: Can push down to the table scan
> - Where Predicate on Preserved Row Table: Can push down to the table scan
> - Where Predicate on Null Supplying Table: Used for filter with join result
> data. This filter condition is attached to SELECTION Node.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
