[HIVE-16029] COLLECT_SET and COLLECT_LIST does not return NULL in the result

• Type: Bug
• Status: Patch Available
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 2.1.1
• Assignee: Eric Lin
• Reporter: Eric Lin
• Created: 23/Feb/17 22:18
• Updated: 23/May/17 07:16

Description

See the test case below:

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]  |
+---------------+

The correct result should be:

0: jdbc:hive2://localhost:10000/default> select collect_set(a) from collect_set_test;
+---------------+
|      _c0      |
+---------------+
| [1,2,null,4]  |
+---------------+