[TAJO-560] CTAS PARTITION BY with UNION can cause invalid global plan

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Component/s: distributed query plan, Planner/Optimizer
• Assignee: Hyunsik Choi
• Reporter: Hyunsik Choi
• Created: 28/Jan/14 02:48
• Updated: 28/Jan/14 12:40
• Resolved: 28/Jan/14 12:19

Description

Take a look at the following query. This kind of queries can cause invalid distributed plans.

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;