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 C884317CD3 for ; Wed, 8 Oct 2014 02:34:35 +0000 (UTC) Received: (qmail 2955 invoked by uid 500); 8 Oct 2014 02:34:35 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 2882 invoked by uid 500); 8 Oct 2014 02:34:35 -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 2869 invoked by uid 500); 8 Oct 2014 02:34:35 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 2866 invoked by uid 99); 8 Oct 2014 02:34:35 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Oct 2014 02:34:35 +0000 Date: Wed, 8 Oct 2014 02:34:35 +0000 (UTC) From: "Ashish Kumar Singh (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Assigned] (HIVE-6056) The AvroSerDe gives out BadSchemaException if a partition is added to the table 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-6056?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashish Kumar Singh reassigned HIVE-6056: ---------------------------------------- Assignee: Ashish Kumar Singh > The AvroSerDe gives out BadSchemaException if a partition is added to the table > ------------------------------------------------------------------------------- > > Key: HIVE-6056 > URL: https://issues.apache.org/jira/browse/HIVE-6056 > Project: Hive > Issue Type: Bug > Components: Database/Schema > Affects Versions: 0.11.0 > Environment: amazon EMR (hadoop Amazon 1.0.3), avro-1.7.5 > Reporter: Rushil Gupta > Assignee: Ashish Kumar Singh > > While creating an external table if I do not add a partition, I am able to read files using following format: > {code} > CREATE external TABLE event > ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' > STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat' > OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat' > LOCATION 's3n://test-event/input/2013/14/10' > TBLPROPERTIES ('avro.schema.literal' = '..some schema..'); > {code} > but if I add a partition based on date > {code} > CREATE external TABLE event > PARTITIONED BY (ds STRING) > ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' > STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat' > OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat' > LOCATION 's3n://test-event/input/' > TBLPROPERTIES ('avro.schema.literal' = '..some schema..'); > ALTER TABLE event ADD IF NOT EXISTS PARTITION (ds = '2013_12_16') LOCATION '2013/12/16/'; > {code} > I get the following exception: > {code} > java.io.IOException:org.apache.hadoop.hive.serde2.avro.BadSchemaException > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)