hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lefty Leverenz (JIRA)" <>
Subject [jira] [Commented] (HIVE-5297) Hive does not honor type for partition columns
Date Fri, 01 May 2015 02:59:05 GMT


Lefty Leverenz commented on HIVE-5297:

Doc note:  This added *hive.typecheck.on.insert* to, 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 |]

> Hive does not honor type for partition columns
> ----------------------------------------------
>                 Key: HIVE-5297
>                 URL:
>             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

View raw message