Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Explorer

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

 

 

1 ACCEPTED SOLUTION

avatar
Explorer

This seems to work.

 

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

View solution in original post

1 REPLY 1

avatar
Explorer

This seems to work.

 

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