Reply
Highlighted
New Contributor
Posts: 5
Registered: ‎11-29-2018
Accepted Solution

Simple Query With Complex Type of MAP<string, float>

Hi,

I have a simple question about querying complex types.  The schema, raw table and desired result is listed below.  Could someone help me craft this query in Impala? CDH 5.15

 

I can get it to work in Hive, but it seems like Impala uses a join-like syntax to access complex columns.  Many Thanks!!

schema:
	snum int
	items map<string, float>


raw parquet table:
	1, {"a": 1.3, "b", 9.1}
	2, {"c", 84.9, "b", 1.1}
	3, {}
	4, {"x", 42.5,"p", 0.08}


desired result:
	1,a,1.3
	1,b,9.1
	2,c,84.9
	2,b,1.1
	3,null,null
	4,x,42.5
	4,p,0.08

 

 

New Contributor
Posts: 5
Registered: ‎11-29-2018

Re: Simple Query With Complex Type of MAP<string, float>

This seems to work.

 

select 
    snum, m.key, m.value
from table, table.items m;