Return-Path: 
 <user-return-19792-apmail-hive-user-archive=hive.apache.org@hive.apache.org>
X-Original-To: apmail-hive-user-archive@www.apache.org
Delivered-To: apmail-hive-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id ADBDA17F56
	for <apmail-hive-user-archive@www.apache.org>;
 Wed, 27 May 2015 08:27:08 +0000 (UTC)
Received: (qmail 37043 invoked by uid 500); 27 May 2015 08:27:07 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 36978 invoked by uid 500); 27 May 2015 08:27:07 -0000
Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hive.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hive.apache.org>
List-Post: <mailto:user@hive.apache.org>
List-Id: <user.hive.apache.org>
Reply-To: user@hive.apache.org
Delivered-To: mailing list user@hive.apache.org
Received: (qmail 36967 invoked by uid 99); 27 May 2015 08:27:07 -0000
Received: from Unknown (HELO spamd4-us-west.apache.org) (209.188.14.142)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 27 May 2015 08:27:07 +0000
Received: from localhost (localhost [127.0.0.1])
	by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org)
 with ESMTP id 9BC51C093B
	for <user@hive.apache.org>; Wed, 27 May 2015 08:27:06 +0000 (UTC)
X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org
X-Spam-Flag: NO
X-Spam-Score: -0.11
X-Spam-Level: 
X-Spam-Status: No, score=-0.11 tagged_above=-999 required=6.31
	tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1,
	T_RP_MATCHES_RCVD=-0.01] autolearn=disabled
Authentication-Results: spamd4-us-west.apache.org (amavisd-new);
	dkim=pass (2048-bit key) header.d=iij.ad.jp
Received: from mx1-us-west.apache.org ([10.40.0.8])
	by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new,
 port 10024)
	with ESMTP id pO0jDuJwB4kP for <user@hive.apache.org>;
	Wed, 27 May 2015 08:27:01 +0000 (UTC)
Received: from omgo.iij.ad.jp (mo901.iij.ad.jp [202.232.31.77])
	by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with
 ESMTPS id 4C21020F8D
	for <user@hive.apache.org>; Wed, 27 May 2015 08:27:01 +0000 (UTC)
DKIM-Signature: v=1;a=rsa-sha256;c=relaxed/simple;d=iij.ad.jp;h=Date:From:To:
	Subject:Message-Id:MIME-Version:Content-Type:Content-Transfer-Encoding;i=
	shu-imin@iij.ad.jp;s=omgo2;t=1432715213;x=1433924813;bh=zKqcwb048wYiax6yjFxm2
	K3AZyhjoVJh3XGvMvRfFy4=;b=LazaDnbcxH51R8mFt28uNU9V81Cqbau/FqVf3+T//W/KqAgeO91
	Zd0Py25eEiTM1Re02gWX41c+PO/V35lcrr+dC2L6qGwM1xXUZsPCIEl8EB3SElC1JP1Y8nejzieGi
	X+1Y5c65V1V3jGQXT9sSPrX3iOMq3UiDyj7R0tv4ewht4ahFyxhRkbBiluSp9VPo2uzWRqviBmppe
	1pih16qpeDbq1XyB5SU3QlHYc7eSj0SLjNL/Z9vb9DrN/vsjFejtVjeRyGSe7kqLVFn1fhNtSjwRp
	Lc5TMMum++2MWC+9Ow6hYxl5gVMf/6d3ikLZjLJmNSN4b8nlEhDWyDcplttA==;
Received: by omgo.iij.ad.jp (mo901) id t4R8Qrvc023787;
 Wed, 27 May 2015 17:26:53 +0900
X-MXL-Hash: 55657fcd5c34f6c7-60b72bd09a9e1fa326fc6ef6498a28edcfeb2501
Date: Wed, 27 May 2015 17:26:53 +0900
From: =?ISO-2022-JP?B?GyRCPGsbKEIgGyRCME5MMRsoQg==?= <shu-imin@iij.ad.jp>
To: user@hive.apache.org
Subject: An error occured when writing tables to avro files
Message-Id: <20150527172653.E346.8295C6F4@iij.ad.jp>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-2022-JP"
Content-Transfer-Encoding: 7bit
X-Mailer: Becky! ver. 2.57.01 [ja]

hi

I  create an avro format table follow the wiki
https://cwiki.apache.org/confluence/display/Hive/AvroSerDe#AvroSerDe-Hive0.14andlater

An error occured when insert data from another table that created by previous steps.
I am using hive-0.14.0/hive-1.2.0 + hadoop-2.6.0.
Do you have any idea?

hive> CREATE TABLE as_avro(string1 STRING,
    >                      int1 INT,
    >                      tinyint1 TINYINT,
    >                      smallint1 SMALLINT,
    >                      bigint1 BIGINT,
    >                      boolean1 BOOLEAN,
    >                      float1 FLOAT,
    >                      double1 DOUBLE,
    >                      list1 ARRAY<STRING>,
    >                      map1 MAP<STRING,INT>,
    >                      struct1 STRUCT<sint:INT,sboolean:BOOLEAN,sstring:STRING>,
    >                      union1 uniontype<FLOAT, BOOLEAN, STRING>,
    >                      enum1 STRING,
    >                      nullableint INT,
    >                      bytes1 BINARY,
    >                      fixed1 BINARY)
    > STORED AS AVRO;
OK
Time taken: 0.11 seconds

hive> INSERT OVERWRITE TABLE as_avro SELECT * FROM test_serializer;
FAILED: SemanticException [Error 10044]: Line 1:23 Cannot insert into target table because column number/types are different 'as_avro': Cannot convert column 11 from uniontype<float,boolean,string> to uniontype<void,float,boolean,string>.

I do not understand Why the column union1 look like this
       uniontype<void,float,boolean,string>

Thanks
zhuweimin