[ https://issues.apache.org/jira/browse/HIVE-10427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14553898#comment-14553898 ]
Hive QA commented on HIVE-10427: -------------------------------- {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12734347/HIVE-10427.2.patch {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 8969 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_udaf_collect_set_2 {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3982/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3982/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-3982/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 1 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12734347 - PreCommit-HIVE-TRUNK-Build > 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, HIVE-10427.2.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)