Eric Lin created HIVE-16029:
-------------------------------
Summary: 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
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] |
+---------------+
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
