[
https://issues.apache.org/jira/browse/TAJO-1800?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14730382#comment-14730382
]
ASF GitHub Bot commented on TAJO-1800:
--------------------------------------
GitHub user hyunsik opened a pull request:
https://github.com/apache/tajo/pull/727
TAJO-1800: WHERE clause is ignored with UNION.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/hyunsik/tajo TAJO-1800
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/727.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 #727
----
commit 9bb6f58e2ebd3ee280d6804239c65fcc4e69a10a
Author: Hyunsik Choi <[email protected]>
Date: 2015-09-04T06:30:36Z
TAJO-1800: WHERE clause is ignored with UNION.
----
> WHERE clause is ignored with UNION
> ----------------------------------
>
> Key: TAJO-1800
> URL: https://issues.apache.org/jira/browse/TAJO-1800
> Project: Tajo
> Issue Type: Bug
> Reporter: Jihoon Son
> Assignee: Hyunsik Choi
> Fix For: 0.11.0
>
>
> You can reproduce as follows:
> {noformat}
> tpch> select c_custkey, ret
> > from (select c_custkey, ROUND(sum(c_acctbal*15000000)/sum(15000000),4) as
> > ret from customer group by c_custkey
> > union
> > select c_custkey, ROUND(sum(c_acctbal*15000000)/sum(15000000),4) as ret
> > from customer group by c_custkey) a
> > where ret > 0.02;
> c_custkey, ret
> -------------------------------
> 64568, 3631.24
> 26627, 9070.85
> 105296, 2863.05
> 51704, 7404.84
> 111424, -977.6
> 32824, 3718.26
> 138521, -510.01
> ...
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
