[HIVE-4966] Introduce Collect_Map UDAF

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: pull-request-available
• Assignee: Shohei Okumiya
• Reporter: Harish Butani
• Created: 31/Jul/13 06:03
• Updated: 19/Nov/23 00:21

Description

Similar to Collect_Set. For e.g. on a Txn table

Txn(customer, product, amt)

select customer, collect_map(product, amt)
from txn
group by customer

Would give you an activity map for each customer.

Other thoughts:

• have explode do the inverse on maps just as it does for sets today.
• introduce a table function that outputs each value as a column. So in the e.g. above you get an activity matrix instead of a map.

Issue Links

• links to: GitHub Pull Request #4679