You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Igor Guzenko (JIRA)" <ji...@apache.org> on 2019/05/20 11:12:00 UTC
[jira] [Assigned] (DRILL-2000) Hive generated parquet files with
maps show up in drill as map(key value)
[ https://issues.apache.org/jira/browse/DRILL-2000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Igor Guzenko reassigned DRILL-2000:
-----------------------------------
Assignee: Bohdan Kazydub
> 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: Bohdan Kazydub
> Priority: Major
> 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
(v7.6.3#76005)