You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Eric Lin (JIRA)" <ji...@apache.org> on 2017/02/23 22:19:44 UTC
[jira] [Updated] (HIVE-16029) COLLECT_SET and COLLECT_LIST does not
return NULL in the result
[ https://issues.apache.org/jira/browse/HIVE-16029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eric Lin updated HIVE-16029:
----------------------------
Description:
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}
was:
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] |
+---------------+
> 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:
> {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)