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] [Commented] (HIVE-16029) COLLECT_SET and COLLECT_LIST does not return NULL in the result
Date Tue, 23 May 2017 07:17:04 GMT

    [ https://issues.apache.org/jira/browse/HIVE-16029?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16020747#comment-16020747
] 

Eric Lin commented on HIVE-16029:
---------------------------------

Hi [~appodictic],

I have modified test so that it passes, please help to review the code at https://reviews.apache.org/r/57009/.

Thanks

> 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
>         Attachments: HIVE-16029.2.patch, HIVE-16029.3.patch, HIVE-16029.patch
>
>
> 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)

Mime
View raw message