Harish Butani created HIVE-4966: ----------------------------------- Summary: Introduce Collect_Map UDAF Key: HIVE-4966 URL: https://issues.apache.org/jira/browse/HIVE-4966 Project: Hive Issue Type: Bug Reporter: Harish Butani Assignee: Harish Butani
Similar to Collect_Set. For e.g. on a Txn table {noformat} Txn(customer, product, amt) select customer, collect_map(product, amt) from txn group by customer {noformat} 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. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira