hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sunderlin, Mark" <>
Subject Question on converting an array of structs into a map
Date Tue, 08 Apr 2014 16:31:38 GMT
I have data in two tables that looks like this:

Sequence_num		int,
User_id			string

Sequence_num		int
User_attributes		array<struct<keyid:bigint,valueid:bigint>>

Sequence number joins the two and it is a one to one and only one relationship.

Where I want to end up:  A single result set that looks like:

Sequence_num	int
User_id		string
User-attributes	map /* A map of  keyid=valueid for each struct from the original array */

Can this be done in Hive? Is inline() the key to doing this?

Mark E. Sunderlin
Data Architect // AOL Platforms
P: 703-265-6935 // C: 540-327-6222 // 22000 AOL Way,  Dulles, VA  20166
AIM: MESunderlin

View raw message