GitHub user babokim opened a pull request:
https://github.com/apache/tajo/pull/48
TAJO-881: JOIN with union query occurs NPE
Join with tableC and result of union tableA, tableB is expected the
following physical plan. But Union execution block is not necessary.
```
|-eb_0001_000006 (Terminal)
|-eb_0001_000005 (Join eb_0001_000003, eb_0001_000004)
|-eb_0001_000004 (Scan TableC)
|-eb_0001_000003 (Union TableA, TableB)
|-eb_0001_000002 (Scan TableB)
|-eb_0001_000001 (Scan TableA)
```
The above plan can be changed to the following plan.
```
|-eb_0001_000005 (Terminal)
|-eb_0001_000003 (Join [eb_0001_000001, eb_0001_000002],
eb_0001_000004)
|-eb_0001_000004 (Scan TableC)
|-eb_0001_000002 (Scan TableB)
|-eb_0001_000001 (Scan TableA)
```
eb_0001_000003's left child should be eb_0001_000001 + eb_0001_000001 and
right child should be eb_0001_000004.
For this eb_0001_000001 is representative of eb_0001_000001, eb_0001_000002.
So eb_0001_000003's left child is eb_0001_000001
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/babokim/tajo TAJO-881
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/48.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 #48
----
commit 4d495e6f1ac29f255b08c4d2025e0d954b23e984
Author: ê¹íì¤ <[email protected]>
Date: 2014-06-25T07:58:47Z
TAJO-881: JOIN with union query occurs NPE
commit 2e6f50939b26aecb33911fbcbfa2b912f708e0e8
Author: ê¹íì¤ <[email protected]>
Date: 2014-06-25T07:59:36Z
TAJO-881: JOIN with union query occurs NPE
Remove unnecessary comment.
commit aec5f9ade653b9c78b5a3c4b016f51561c04a126
Author: ê¹íì¤ <[email protected]>
Date: 2014-06-25T08:01:56Z
Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo into
TAJO-881
commit 04b4854f86996475250a4c96f7069169187c62f0
Author: ê¹íì¤ <[email protected]>
Date: 2014-06-25T13:35:06Z
TAJO-881: JOIN with union query occurs NPE
Add some comment
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
