[
https://issues.apache.org/jira/browse/TAJO-848?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14040363#comment-14040363
]
Hudson commented on TAJO-848:
-----------------------------
SUCCESS: Integrated in Tajo-master-build #251 (See
[https://builds.apache.org/job/Tajo-master-build/251/])
TAJO-848: PreLogicalPlanVerifier::visitInsert need to find smaller expressions
than target columns for a partitioned table. (jaehwa) (jhjung: rev
1613cd2c7917ffa8ecc8aee24729bd670f3b0ac8)
* tajo-core/src/test/java/org/apache/tajo/engine/query/TestTablePartitions.java
* tajo-core/src/test/resources/queries/TestTablePartitions/case14.sql
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/PreLogicalPlanVerifier.java
* CHANGES
* tajo-core/src/test/resources/results/TestTablePartitions/case14.result
* tajo-core/src/test/resources/queries/TestTablePartitions/case15.sql
* tajo-core/src/test/resources/results/TestTablePartitions/case15.result
> 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, TAJO-848_3.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)
