Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

SOLVED Go to solution

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

New Contributor

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

Accepted Solutions

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

New Contributor

This seems to work.

 

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

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

New Contributor

This seems to work.

 

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