[ https://issues.apache.org/jira/browse/HIVE-16029?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15969952#comment-15969952 ]
Edward Capriolo commented on HIVE-16029: ---------------------------------------- Code looks look, but some of the q test files run the explain command: https://builds.apache.org/job/PreCommit-HIVE-Build/4704/testReport/org.apache.hadoop.hive.cli/TestCliDriver/testCliDriver_udaf_collect_set_/ You need to update the .q.out files so they do not fil > COLLECT_SET and COLLECT_LIST does not return NULL in the result > --------------------------------------------------------------- > > Key: HIVE-16029 > URL: https://issues.apache.org/jira/browse/HIVE-16029 > Project: Hive > Issue Type: Bug > Affects Versions: 2.1.1 > Reporter: Eric Lin > Assignee: Eric Lin > Priority: Minor > Attachments: HIVE-16029.2.patch, HIVE-16029.patch > > > See the test case below: > {code} > 0: jdbc:hive2://localhost:10000/default> select * from collect_set_test; > +---------------------+ > | collect_set_test.a | > +---------------------+ > | 1 | > | 2 | > | NULL | > | 4 | > | NULL | > +---------------------+ > 0: jdbc:hive2://localhost:10000/default> select collect_set(a) from > collect_set_test; > +---------------+ > | _c0 | > +---------------+ > | [1,2,4] | > +---------------+ > {code} > The correct result should be: > {code} > 0: jdbc:hive2://localhost:10000/default> select collect_set(a) from > collect_set_test; > +---------------+ > | _c0 | > +---------------+ > | [1,2,null,4] | > +---------------+ > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)