I have data in two tables that looks like this: Table_1 Sequence_num int, User_id string
Table_2 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
