Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C113E1002D for ; Mon, 16 Sep 2013 21:45:57 +0000 (UTC) Received: (qmail 83392 invoked by uid 500); 16 Sep 2013 21:45:56 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 83246 invoked by uid 500); 16 Sep 2013 21:45:56 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 83007 invoked by uid 500); 16 Sep 2013 21:45:55 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 82991 invoked by uid 99); 16 Sep 2013 21:45:55 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 Sep 2013 21:45:55 +0000 Date: Mon, 16 Sep 2013 21:45:55 +0000 (UTC) From: "Vikram Dixit K (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (HIVE-5297) Hive does not honor type for partition columns MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-5297?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vikram Dixit K updated HIVE-5297: --------------------------------- Description: 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. was: 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 load happens. > 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 > Attachments: HIVE-5297.1.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 is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira