[
https://issues.apache.org/jira/browse/TAJO-1800?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14731751#comment-14731751
]
Hudson commented on TAJO-1800:
------------------------------
SUCCESS: Integrated in Tajo-0.11.0-build #13 (See
[https://builds.apache.org/job/Tajo-0.11.0-build/13/])
TAJO-1800: WHERE clause is ignored with UNION. (hyunsik: rev
0f5d97a0004e91d614fc8093b3f81b0bd8c93899)
*
tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAndFilter.plan
* tajo-core-tests/src/test/java/org/apache/tajo/engine/query/TestUnionQuery.java
*
tajo-plan/src/main/java/org/apache/tajo/plan/rewrite/rules/FilterPushDownRule.java
* CHANGES
*
tajo-core-tests/src/test/resources/queries/TestUnionQuery/testUnionAndFilter.sql
*
tajo-core-tests/src/test/resources/results/TestUnionQuery/testUnionAndFilter.result
> WHERE clause is ignored with UNION
> ----------------------------------
>
> Key: TAJO-1800
> URL: https://issues.apache.org/jira/browse/TAJO-1800
> Project: Tajo
> Issue Type: Bug
> Components: Planner/Optimizer
> 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)
