[TAJO-462] What will happen if the output schema of the insert clause is different than the target schema of an insert into partitioned table statement

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.8.0
• Component/s: Planner/Optimizer
• Assignee: Unassigned
• Reporter: Min Zhou
• Created: 28/Dec/13 23:47
• Updated: 28/Dec/13 23:47

Description

As I described in TAJO-459, I have no idea that what will going on if we insert into a column partitioned table but with no partitioned key selected like the way below

insert overwrite into tbl(col1, col2) select l_orderkey, l_quantity from lineitem

Another potential bug is when the output columns of the select clause of a insert into statement is more than table columns and unfortunately the partition key is in the tail of those columns of that select clause.

insert overwrite into tbl(col1, col2, key) select l_orderkey, l_partkey, l_quantitym, l_col1, l_col2 from lineitem

Which column would be chose as the partition key?