drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ramana Inukonda Nagaraj (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2000) Hive generated parquet files with maps show up in drill as map(key value)
Date Tue, 13 Jan 2015 20:22:34 GMT
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)

Mime
View raw message