[jira] [Updated] (TAJO-848) PreLogicalPlanVerifier::visitInsert need to find smaller expressions than target columns for a partitioned table.

["Jaehwa Jung (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TAJO-848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jaehwa Jung updated TAJO-848:
-----------------------------

    Fix Version/s:     (was: 0.8.1)

> PreLogicalPlanVerifier::visitInsert need to find smaller expressions than target columns for a partitioned table.
> -----------------------------------------------------------------------------------------------------------------
>
>                 Key: TAJO-848
>                 URL: https://issues.apache.org/jira/browse/TAJO-848
>             Project: Tajo
>          Issue Type: Bug
>          Components: planner/optimizer
>            Reporter: Jaehwa Jung
>            Assignee: Jaehwa Jung
>             Fix For: 0.9.0
>
>         Attachments: TAJO-848.patch, TAJO-848_2.patch
>
>
> Currently, user can insert data even if  there is small columns compare to target columns as follows:
> {code:xml}
> create table table1 (id int, name text, score float, type text) using csv with ('csvfile.delimiter'='|') ;
> create table table3 (id int, name text, score float, type text) using csv with ('csvfile.delimiter'='|') ;
> create table table4 (id int, name text, score float, type text) using csv with ('csvfile.delimiter'='|') partition by column(part text);
> default> insert overwrite into table3 select id, name from table1;
> Progress: 0%, response time: 0.544 sec
> Progress: 100%, response time: 1.158 sec
> (5 rows, 1.158 sec, 60 B inserted)
> default> insert overwrite into table4 select id, name from table1;
> Progress: 100%, response time: 0.468 sec
> (5 rows, 0.468 sec, 65 B inserted)
> {code}
> As above, tajo can run a query for inserting data. But in partitioned table, tajo made null value for partition column as follows:
> {code:xml}
> hdfs dfs -ls /tajo/warehouse/default/table4
> Found 1 items
> drwxr-xr-x   - blrunner supergroup          0 2014-05-26 16:27 /tajo/warehouse/default/table4/part=
> {code}
> Thus we need to make a syntax exception for blocking null partition value.



--
This message was sent by Atlassian JIRA
(v6.2#6252)