You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@tajo.apache.org by "Hyunsik Choi (JIRA)" <ji...@apache.org> on 2015/09/04 05:39:45 UTC

[jira] [Assigned] (TAJO-1800) WHERE clause is ignored with UNION

     [ https://issues.apache.org/jira/browse/TAJO-1800?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hyunsik Choi reassigned TAJO-1800:
----------------------------------

    Assignee: Hyunsik Choi

> 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)