You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2014/06/02 08:54:01 UTC
[jira] [Commented] (TAJO-853) Refactoring FilterPushDown for OUTER
JOIN
[ https://issues.apache.org/jira/browse/TAJO-853?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14015209#comment-14015209 ]
ASF GitHub Bot commented on TAJO-853:
-------------------------------------
GitHub user babokim opened a pull request:
https://github.com/apache/tajo/pull/28
TAJO-853: Refactoring FilterPushDown for OUTER JOIN
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/babokim/tajo TAJO-853
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/28.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #28
----
commit 922e4b9d820d7f1330097f16392e3c0c65f2e23b
Author: 김형준 <ba...@babokim-macbook-pro.local>
Date: 2014-05-20T17:30:38Z
TAJO-830
commit e8e8efe933269abd147dfb0504f7b57e65a08183
Author: 김형준 <ba...@babokim-macbook-pro.local>
Date: 2014-05-20T17:37:21Z
Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo
commit d8b4fa9b046c8a04cbd6fcd7a5b6724068ff8b1b
Author: 김형준 <ba...@babokim-macbook-pro.local>
Date: 2014-05-20T17:42:14Z
Tajo 830: Some filter conditions with a SUBQUERY are removed by optimizer. => Remove unused test code
commit 3f6b6d0918645de5b27ef748f30c3beb733d6894
Author: 김형준 <ba...@babokim-macbook-pro.local>
Date: 2014-05-25T05:10:57Z
TAJO-830:Some filter conditions with a SUBQUERY are removed by optimizer(remove the korean comment)
commit e87b72725b384496b7e7667e85a5032270ac21af
Author: 김형준 <ba...@babokim-macbook-pro.local>
Date: 2014-05-26T13:18:40Z
TAJO-850: OUTER JOIN does not properly handle a NULL.
commit 9215829f52130ce7c8b31fd49c794865a4924e15
Author: 김형준 <ba...@babokim-macbook-pro.local>
Date: 2014-05-27T01:09:41Z
Merge branch 'TAJO-830' of https://github.com/babokim/tajo
Conflicts:
tajo-common/src/main/java/org/apache/tajo/conf/TajoConf.java
commit eda038cc492dba0e8a8e914bfaf95158aea31807
Author: 김형준 <ba...@babokim-macbook-pro.local>
Date: 2014-05-27T01:34:10Z
Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo
Conflicts:
tajo-core/src/main/java/org/apache/tajo/engine/planner/LogicalPlan.java
tajo-core/src/main/java/org/apache/tajo/engine/planner/logical/GroupbyNode.java
tajo-core/src/main/java/org/apache/tajo/engine/planner/rewrite/FilterPushDownRule.java
commit a88333fa2f05882ab5f850ead56b740512ee48d6
Author: 김형준 <ba...@babokim-macbook-pro.local>
Date: 2014-05-27T14:39:14Z
TAJO-850: OUTER JOIN does not properly handle a NULL.
commit d965111729ca65bfc9b74b9f4e4dfd252dc75230
Author: 김형준 <ba...@babokim-macbook-pro.local>
Date: 2014-05-27T14:39:58Z
Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo into TAJO-850
commit 63199d4576ce10a4af7d1d4bd7464a1270f4520f
Author: 김형준 <ba...@babokim-macbook-pro.local>
Date: 2014-05-29T01:21:58Z
Merge branch 'TAJO-850' of https://github.com/babokim/tajo
commit efb0c104ea853d5264dea9afabebbc7980d7b7a3
Author: 김형준 <ba...@babokim-macbook-pro.local>
Date: 2014-05-30T07:25:46Z
TAJO-853: Refactoring FilterPushDown for OUTER JOIN
Test succeeded in the case of LEFT OUTER
commit 0fb926875cd0b9d9a404ee4e7b8caebfa850fdef
Author: 김형준 <ba...@babokim-macbook-pro.local>
Date: 2014-05-30T13:38:00Z
TAJO-853: Refactoring FilterPushDown for OUTER JOIN
Test succeeded in the case of RIGHT OUTER and SortJoin
commit 15517b84afb8bae8b3cef70f68f1d5f57ee52ae7
Author: 김형준 <ba...@babokim-macbook-pro.local>
Date: 2014-05-31T10:58:17Z
TAJO-853: Refactoring FilterPushDown for OUTER JOIN
Add tajo.optimizer.join.enable session property
commit b7c3fd23d111f03c5f45235495f49635dbf0dac4
Author: 김형준 <ba...@babokim-macbook-pro.local>
Date: 2014-05-31T11:00:11Z
Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo
Conflicts:
tajo-common/src/main/java/org/apache/tajo/conf/TajoConf.java
----
> 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: Minor
>
> 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)