You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Ramana Inukonda Nagaraj (JIRA)" <ji...@apache.org> on 2015/01/13 21:22:34 UTC
[jira] [Created] (DRILL-2000) Hive generated parquet files with
maps show up in drill as map(key value)
Ramana Inukonda Nagaraj created DRILL-2000:
----------------------------------------------
Summary: 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: Bug
Components: Storage - Parquet
Affects Versions: 0.7.0
Reporter: Ramana Inukonda Nagaraj
Assignee: Parth Chandra
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)