[jira] [Resolved] (HIVE-11622) Creating an Avro table with a complex map-typed column leads to incorrect column type.

["Jimmy Xiang (JIRA)" <ji...@apache.org>]

     [ 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)