[ https://issues.apache.org/jira/browse/HIVE-10427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14549780#comment-14549780 ]
Chao Sun commented on HIVE-10427: --------------------------------- Hi [~apivovarov], since you have contributed a lot to this area, I wonder if you could give a review for this patch. Thanks. > collect_list() and collect_set() should accept struct types as argument > ----------------------------------------------------------------------- > > Key: HIVE-10427 > URL: https://issues.apache.org/jira/browse/HIVE-10427 > Project: Hive > Issue Type: Wish > Components: UDF > Reporter: Alexander Behm > Assignee: Chao Sun > Attachments: HIVE-10427.1.patch > > > The collect_list() and collect_set() functions currently only accept scalar > argument types. It would be very useful if these functions could also accept > struct argument types for creating nested data from flat data. > For example, suppose I wanted to create a nested customers/orders table from > two flat tables, customers and orders. Then it'd be very convenient to write > something like this: > {code} > insert into table nested_customers_orders > select c.*, collect_list(named_struct("oid", o.oid, "order_date": o.date...)) > from customers c inner join orders o on (c.cid = o.oid) > group by c.cid > {code} > Thanks you for your consideration. -- This message was sent by Atlassian JIRA (v6.3.4#6332)