[
https://issues.apache.org/jira/browse/HIVE-5297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14522699#comment-14522699
]
Lefty Leverenz commented on HIVE-5297:
--------------------------------------
Doc note: This added *hive.typecheck.on.insert* to HiveConf.java, so it needs
to be documented in the wiki. (HIVE-10307 extends the parameter in release
1.2.0.)
* [Configuration Properties -- Query and DDL Execution |
https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-QueryandDDLExecution]
> Hive does not honor type for partition columns
> ----------------------------------------------
>
> Key: HIVE-5297
> URL: https://issues.apache.org/jira/browse/HIVE-5297
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.11.0
> Reporter: Vikram Dixit K
> Assignee: Vikram Dixit K
> Labels: TODOC12
> Fix For: 0.12.0
>
> Attachments: HIVE-5297.1.patch, HIVE-5297.2.patch, HIVE-5297.3.patch,
> HIVE-5297.4.patch, HIVE-5297.5.patch, HIVE-5297.6.patch, HIVE-5297.7.patch,
> HIVE-5297.8.patch
>
>
> Hive does not consider the type of the partition column while writing
> partitions. Consider for example the query:
> {noformat}
> create table tab1 (id1 int, id2 string) PARTITIONED BY(month string,day int)
> row format delimited fields terminated by ',';
> alter table tab1 add partition (month='June', day='second');
> {noformat}
> Hive accepts this query. However if you try to select from this table and
> insert into another expecting schema match, it will insert nulls instead. We
> should throw an exception on such user error at the time the partition
> addition/load happens.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
