[
https://issues.apache.org/jira/browse/TAJO-680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14611545#comment-14611545
]
ASF GitHub Bot commented on TAJO-680:
-------------------------------------
GitHub user jihoonson opened a pull request:
https://github.com/apache/tajo/pull/620
TAJO-680: Improve the IN operator to support sub queries.
This patch is based on #593, so please review it first.
This work includes:
* Improving the IN expression to allow uncorrelated subquery
* Throwing an exception in the case of correlated subquery
* Improving the join ordering to allow semi and anti joins
* Set of query result tests
This work does not include the query plan tests because it makes the patch
size huge.
I'll add them at https://issues.apache.org/jira/browse/TAJO-1671.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/jihoonson/tajo-2 TAJO-680_3
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/620.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 #620
----
commit b165abcd3bac5feb2cd26ae1cc4713c5f2596014
Author: Jihoon Son <[email protected]>
Date: 2015-03-14T08:57:01Z
TAJO-1352_3
commit d6e22ae056cf695a92306e008a2d941ca372519f
Author: Jihoon Son <[email protected]>
Date: 2015-03-15T02:49:53Z
problems in join tree building
commit 213c09ba79b800c57397c55f1d4f5b96519f7f50
Author: Jihoon Son <[email protected]>
Date: 2015-03-15T04:30:54Z
TAJO-1352_3
commit 60d250dce16d11693c3a1b5a87cb04bb7102deb3
Author: Jihoon Son <[email protected]>
Date: 2015-03-15T05:47:28Z
TAJO-1352_3
commit f8638cf981954a51a5feefbf5de2982dc7c07078
Author: Jihoon Son <[email protected]>
Date: 2015-03-15T06:02:13Z
TAJO-1352_3
commit 9ec987711d969be423d4dfb8de9bc07adf3b4082
Author: Jihoon Son <[email protected]>
Date: 2015-03-15T11:09:13Z
Finished join order improvement
commit d774b455b89cc2cbf38f1fd37c987e43bfc57072
Author: Jihoon Son <[email protected]>
Date: 2015-03-16T11:37:15Z
TAJO-1352_4
commit f27cec3db9d1683fabe11dc0115306c92b06e500
Author: Jihoon Son <[email protected]>
Date: 2015-03-16T14:59:51Z
Merge branch 'TAJO-1352_4' of https://github.com/jihoonson/tajo-2 into
TAJO-1352_4
commit 140bc3de2faf227dd5cbd84d81c5368efa1fd587
Author: Jihoon Son <[email protected]>
Date: 2015-03-16T15:10:22Z
TAJO-1352_4
commit 7112eb935fe749f0ad656d02a2ec2a8decad8e48
Author: Jihoon Son <[email protected]>
Date: 2015-03-17T01:06:36Z
Merge branch 'TAJO-1352_4' of https://github.com/jihoonson/tajo-2 into
TAJO-1352_4
commit 7ac215a283094356909ce3220eb8cf9d9b6af629
Author: Jihoon Son <[email protected]>
Date: 2015-03-17T05:04:43Z
TAJO-1352_4
commit 5e4de3d2b735fd907f64a27e02c74873c54eb95d
Author: Jihoon Son <[email protected]>
Date: 2015-03-17T08:10:22Z
TAJO-1352_4
commit 3dca1b763a4a3d4ac9bd9f4541754bef8628f5cf
Author: Jihoon Son <[email protected]>
Date: 2015-03-18T01:36:08Z
TAJO-1352_4
commit 8ebf859c3f142d673fbb2b03109ca1d7b894b167
Author: Jihoon Son <[email protected]>
Date: 2015-03-18T01:44:51Z
TAJO-1352_4
commit 393dd555e19c36a942b49e4f9ccf88fd1a3508ca
Author: Jihoon Son <[email protected]>
Date: 2015-03-18T09:46:38Z
TAJO-1352_4
commit 8bd027bec0cfe30379a71c914ba292d2766a7afc
Author: Jihoon Son <[email protected]>
Date: 2015-03-18T12:21:13Z
TAJO-1352_4
commit 8dce54401006d70b9207cc5fd5823f92fc004b36
Author: Jihoon Son <[email protected]>
Date: 2015-03-18T15:24:57Z
Must resolve broadcast join bugs
commit dcc6e8ac7adae598062386c30a387cf87954fa1e
Author: Jihoon Son <[email protected]>
Date: 2015-03-18T16:21:20Z
TAJO-1352_4
commit f7d6c6b3db91ef36609e362941ef84e43b9e1144
Author: Jihoon Son <[email protected]>
Date: 2015-03-18T17:25:57Z
Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo into
TAJO-1352_4
commit 91b6551ee538dbd5f8de3f68434e5fbfa73bb5c4
Author: Jihoon Son <[email protected]>
Date: 2015-03-19T02:32:05Z
TAJO-1352_4
commit 3cb707187136c28da2c2406ccbb3ad9f76735043
Author: Jihoon Son <[email protected]>
Date: 2015-03-19T12:16:37Z
TAJO-1352_4
commit 1cef1668e2915f67b2fab919e38c20b96e3b63ac
Author: Jihoon Son <[email protected]>
Date: 2015-03-20T05:43:40Z
Fix JoinBroadcast test
commit 7470270abcae4e678a24b4a7b2705ae96a831264
Author: Jihoon Son <[email protected]>
Date: 2015-03-20T06:02:44Z
Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo into
TAJO-1352_4
Conflicts:
tajo-plan/src/main/java/org/apache/tajo/plan/expr/RowConstantEval.java
tajo-plan/src/main/java/org/apache/tajo/plan/joinorder/GreedyHeuristicJoinOrderAlgorithm.java
commit 38fb013fb530720dda03182f009f9cf3a0d53ea0
Author: Jihoon Son <[email protected]>
Date: 2015-03-20T10:07:28Z
TAJO-1352_4
commit 321450872ad25bd2b3352e411dc03e21e3bd3f67
Author: Jihoon Son <[email protected]>
Date: 2015-03-21T01:24:14Z
TAJO-1352_4
commit 4439a6fbc9def860494d4130e7024d15452df7c8
Author: Jihoon Son <[email protected]>
Date: 2015-03-21T04:27:23Z
TAJO-1352_4
commit f42b4cebc1ebb2bf4aedb84fb7941673ed04004a
Author: Jihoon Son <[email protected]>
Date: 2015-03-22T14:51:28Z
Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo into
TAJO-1352_4
commit f626a93f2a89b45f12e2d0ec13a4c4e3c960d03c
Author: Jihoon Son <[email protected]>
Date: 2015-03-23T03:07:03Z
Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo into
TAJO-1352_4
commit bb27e0fceb8702eb7218ecdb01f57a8ec5927397
Author: Jihoon Son <[email protected]>
Date: 2015-03-25T01:30:21Z
Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo into
TAJO-1352_4
commit 34515d995d15be6350e5a15da39fe95f2d4ce5f8
Author: Jihoon Son <[email protected]>
Date: 2015-03-26T06:38:23Z
Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo into
TAJO-1352_4
----
> Improve the IN operator to support sub queries
> ----------------------------------------------
>
> Key: TAJO-680
> URL: https://issues.apache.org/jira/browse/TAJO-680
> Project: Tajo
> Issue Type: Improvement
> Components: distributed query plan, SQL Parser
> Reporter: Jihoon Son
> Assignee: Jihoon Son
> Fix For: 0.11.0
>
> Attachments: Distributed plan.png, Logical plan.png
>
>
> Currently, the IN operator can be used with only sets of values.
> We need to improve it to support sub queries as the following example query.
> {noformat}
> tajo> select * from nation where n_regionkey in (select r_regionkey from
> region);
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
