[
https://issues.apache.org/jira/browse/TAJO-560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13884069#comment-13884069
]
Hudson commented on TAJO-560:
-----------------------------
ABORTED: Integrated in Tajo-master-build #37 (See
[https://builds.apache.org/job/Tajo-master-build/37/])
TAJO-560: CTAS PARTITION BY with UNION can cause invalid global plan. (hyunsik)
(hyunsik:
https://git-wip-us.apache.org/repos/asf?p=incubator-tajo.git&a=commit&h=6aa96fa9bc58d002efeae03f775162ccee6545e5)
*
tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/query/TestSelectQuery.java
*
tajo-core/tajo-core-backend/src/test/resources/queries/TestCTASQuery/CtasWithGroupby.sql
*
tajo-core/tajo-core-backend/src/test/resources/queries/TestCTASQuery/check1.sql
*
tajo-core/tajo-core-backend/src/test/resources/results/TestCTASQuery/testCtasWithLimit.result
*
tajo-core/tajo-core-backend/src/test/resources/queries/TestSelectQuery/testSelectAsterisk1.sql
* CHANGES.txt
*
tajo-core/tajo-core-backend/src/test/resources/queries/TestSelectQuery/testSelectAsterisk2.sql
*
tajo-core/tajo-core-backend/src/test/resources/queries/TestCTASQuery/testCtasWithColumnedPartition.sql
*
tajo-core/tajo-core-backend/src/test/resources/queries/TestCTASQuery/testCtasWithLimit.sql
*
tajo-core/tajo-core-backend/src/test/resources/results/TestCTASQuery/testCtasWithUnion.result
*
tajo-core/tajo-core-backend/src/test/resources/queries/TestCTASQuery/testCtasWithGroupby.sql
*
tajo-core/tajo-core-backend/src/test/resources/queries/TestCTASQuery/check2.sql
*
tajo-core/tajo-core-backend/src/test/resources/queries/TestCTASQuery/CtasWithOrderby.sql
*
tajo-core/tajo-core-backend/src/test/resources/queries/TestCTASQuery/testCtasWithUnion.sql
*
tajo-core/tajo-core-backend/src/test/resources/queries/TestSelectQuery/testSelectAsterisk3.sql
*
tajo-core/tajo-core-backend/src/test/resources/queries/TestCTASQuery/CtasWithLimit.sql
*
tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelectAsterik.result
*
tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/global/GlobalPlanner.java
*
tajo-core/tajo-core-backend/src/test/resources/queries/TestCTASQuery/testCtasWithoutTableDefinition.sql
*
tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/query/TestCTASQuery.java
*
tajo-core/tajo-core-backend/src/test/resources/queries/TestCTASQuery/testCtasWithOrderby.sql
*
tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelectAsterisk2.result
*
tajo-core/tajo-core-backend/src/test/resources/queries/TestCTASQuery/CtasWithUnion.sql
*
tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelectAsterisk3.result
*
tajo-core/tajo-core-backend/src/test/resources/results/TestCTASQuery/testCtasWithOrderby.result
*
tajo-core/tajo-core-backend/src/test/resources/results/TestSelectQuery/testSelectAsterisk1.result
*
tajo-core/tajo-core-backend/src/test/resources/results/TestCTASQuery/testCtasWithGroupby.result
> CTAS PARTITION BY with UNION can cause invalid global plan
> -----------------------------------------------------------
>
> Key: TAJO-560
> URL: https://issues.apache.org/jira/browse/TAJO-560
> Project: Tajo
> Issue Type: Bug
> Components: distributed query plan, planner/optimizer
> Reporter: Hyunsik Choi
> Assignee: Hyunsik Choi
> Fix For: 0.8-incubating
>
> Attachments: TAJO-560.patch, TAJO-560_2.patch
>
>
> Take a look at the following query. This kind of queries can cause invalid
> distributed plans.
> {code}
> create table testCtasWithUnion (col1 int4, col2 int4) partition by column(key
> float8) as
> select
> *
> from (
> select
> sum(l_orderkey) as total1,
> avg(l_partkey) as total2,
> l_quantity as key
> from
> lineitem
> group by
> l_quantity
> order by
> l_quantity
> limit
> 3
> union
> select
> sum(l_orderkey) as total1,
> avg(l_partkey) as total2,
> l_quantity as key
> from
> lineitem
> group by
> l_quantity
> order by
> l_quantity
> limit
> 3
> ) t1;
> {code}
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
