hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric Lin (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (HIVE-16029) COLLECT_SET and COLLECT_LIST does not return NULL in the result
Date Thu, 23 Feb 2017 22:18:44 GMT

     [ 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)

Mime
View raw message