[jira] [Commented] (TAJO-560) CTAS PARTITION BY with UNION can cause invalid global plan

["Hyunsik Choi (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TAJO-560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13883911#comment-13883911 ] 

Hyunsik Choi commented on TAJO-560:
-----------------------------------

Created a review request against branch master in reviewboard 
https://reviews.apache.org/r/17448/


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