[
https://issues.apache.org/jira/browse/TAJO-848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jaehwa Jung updated TAJO-848:
-----------------------------
Attachment: TAJO-848.patch
> 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, 0.8.1
>
> Attachments: TAJO-848.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)
