tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Min Zhou (JIRA)" <j...@apache.org>
Subject [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
Date Sat, 28 Dec 2013 23:49:50 GMT
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)

Mime
View raw message