You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tajo.apache.org by "Min Zhou (JIRA)" <ji...@apache.org> on 2013/12/29 00:49:50 UTC

[jira] [Created] (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

Min Zhou created TAJO-462:
-----------------------------

             Summary: What will happen if the output schema of the insert clause is different than the target schema of an insert into partitioned table statement 
                 Key: TAJO-462
                 URL: https://issues.apache.org/jira/browse/TAJO-462
             Project: Tajo
          Issue Type: Bug
          Components: planner/optimizer
    Affects Versions: 0.8-incubating
            Reporter: Min Zhou


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
{noformat}
insert overwrite into tbl(col1, col2) select l_orderkey, l_quantity from lineitem
{noformat}

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.

{noformat}
insert overwrite into tbl(col1, col2, key) select l_orderkey, l_partkey, l_quantitym, l_col1, l_col2 from lineitem
{noformat}
Which column would be chose as the partition key? 



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)