[jira] [Created] (HIVE-10427) collect_list() and collect_set() should accept struct types as argument

["Alexander Behm (JIRA)" <ji...@apache.org>]

Alexander Behm created HIVE-10427:
-------------------------------------

             Summary: 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


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)