Guillaume Xavier Taillon created HIVE-21876:
-----------------------------------------------
Summary: Documentation : collect_list documentation does not
mention it silently ignores nulls
Key: HIVE-21876
URL: https://issues.apache.org/jira/browse/HIVE-21876
Project: Hive
Issue Type: Bug
Components: Documentation
Environment: select version()
_c0▼
2.1.0.2.6.5.1050-37 rb49a1217fdf463c41661ec6512348ff9ef4706a9
Reporter: Guillaume Xavier Taillon
Documentation at
[https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-Built-inAggregateFunctions(UDAF)]
For collect_list is currently only
|array|collect_list(col)|Returns a list of objects with duplicates. (As of Hive
0.13.0.)|
However it should mention that nulls are not captured, at least on Hive 2.1
select collect_list(v) from (
select 1 as v
union all select null as v
union all select 3 as v
) t
Result
_c0
[1,3]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
