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

Posted to issues@tajo.apache.org by "Jihoon Son (JIRA)" <ji...@apache.org> on 2015/08/24 05:16:47 UTC

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

Jihoon Son created TAJO-1800:
--------------------------------

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