[jira] [Updated] (DRILL-2000) Hive generated parquet files with maps show up in drill as map(key value)

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-2000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Nadeau updated DRILL-2000:
----------------------------------
    Issue Type: Improvement  (was: Bug)

> Hive generated parquet files with maps show up in drill as map(key value)
> -------------------------------------------------------------------------
>
>                 Key: DRILL-2000
>                 URL: https://issues.apache.org/jira/browse/DRILL-2000
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Storage - Parquet
>    Affects Versions: 0.7.0
>            Reporter: Ramana Inukonda Nagaraj
>            Assignee: Parth Chandra
>             Fix For: Future
>
>
> Created a parquet file in hive having the following DDL
> hive> desc alltypesparquet; 
> OK
> c1 int 
> c2 boolean 
> c3 double 
> c4 string 
> c5 array<int> 
> c6 map<int,string> 
> c7 map<string,string> 
> c8 struct<r:string,s:int,t:double>	
> c9 tinyint 
> c10 smallint 
> c11 float 
> c12 bigint 
> c13 array<array<string>>	
> c15 struct<r:int,s:struct<a:int,b:string>>	
> c16 array<struct<m:map<string,string>,n:int>>	
> Time taken: 0.076 seconds, Fetched: 15 row(s)
> Columns which are maps such as c6 map<string,string> 
> show up as 
> 0: jdbc:drill:> select c6 from `/user/hive/warehouse/alltypesparquet`;
> +------------+
> |     c6     |
> +------------+
> | {"map":[]} |
> | {"map":[]} |
> | {"map":[{"key":1,"value":"eA=="},{"key":2,"value":"eQ=="}]} |
> +------------+
> 3 rows selected (0.078 seconds)
> hive> select c6 from alltypesparquet;   
> NULL
> NULL
> {1:"x",2:"y"}
> Ignore the wrong values, I have raised DRILL-1997 for the same. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)