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:18:44 UTC
[jira] [Assigned] (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 reassigned HIVE-16029:
-------------------------------
> 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)