[jira] [Created] (DRILL-1999) Hive parquet file containing array of strings or integers shows up as bags of array elements in drill

["Ramana Inukonda Nagaraj (JIRA)" <ji...@apache.org>]

Ramana Inukonda Nagaraj created DRILL-1999:
----------------------------------------------

             Summary: Hive parquet file containing array of strings or integers shows up as bags of array elements in drill
                 Key: DRILL-1999
                 URL: https://issues.apache.org/jira/browse/DRILL-1999
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - Parquet
            Reporter: Ramana Inukonda Nagaraj
            Assignee: Parth Chandra
         Attachments: hive_alltypes.parquet

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)

column5 which is an array of integers shows up as a bag when querying through drill 
0: jdbc:drill:> select c5 from `/user/hive/warehouse/alltypesparquet`;
+------------+
|     c5     |
+------------+
| {"bag":[]} |
| {"bag":[]} |
| {"bag":[{"array_element":1},{"array_element":2}]} |
+------------+
3 rows selected (0.085 seconds)

While from hive
hive> select c5 from alltypesparquet;  
OK
NULL
NULL
[1,2]




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