[
https://issues.apache.org/jira/browse/HIVE-11622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jimmy Xiang resolved HIVE-11622.
--------------------------------
Resolution: Duplicate
This is a duplicate of HIVE-11288 which is already fixed. Thanks.
> Creating an Avro table with a complex map-typed column leads to incorrect
> column type.
> --------------------------------------------------------------------------------------
>
> Key: HIVE-11622
> URL: https://issues.apache.org/jira/browse/HIVE-11622
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema
> Affects Versions: 1.1.0
> Reporter: Alexander Behm
> Assignee: Jimmy Xiang
> Labels: AvroSerde
>
> In the following CREATE TABLE the following map-typed column leads to the
> wrong type. I suspect some problem with inferring the Avro schema from the
> column definitions, but I am not sure.
> Reproduction:
> {code}
> hive> create table t (c map<string,array<int>>) stored as avro;
> OK
> Time taken: 0.101 seconds
> hive> desc t;
> OK
> c array<map<string,int>> from deserializer
> Time taken: 0.135 seconds, Fetched: 1 row(s)
> {code}
> Note how the type shown in DESCRIBE is not the type originally passed in the
> CREATE TABLE.
> However, *sometimes* the DESCRIBE shows the correct output. You may also try
> these steps which produce a similar problem to increase the chance of hitting
> this issue:
> {code}
> hive> create table t (c array<map<string,int>>) stored as avro;
> OK
> Time taken: 0.063 seconds
> hive> desc t;
> OK
> c map<string,array<int>> from deserializer
> Time taken: 0.152 seconds, Fetched: 1 row(s)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
