[HIVE-28148] Implement array_compact UDF to remove all nulls from an array

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.1.0
• Component/s: Hive
• Labels: pull-request-available
• Assignee: Taraka Rama Rao Lethavadla
• Reporter: Taraka Rama Rao Lethavadla
• Created: 25/Mar/24 16:38
• Updated: 05/Apr/24 11:16
• Resolved: 05/Apr/24 11:16

Description

array_compact(array)

Removes NULL elements from array.

 

SELECT array_compact(array(1, 2, NULL, 3, NULL, 3));
=> [1, 2, 3, 3]

 

Issue Links

• links to: GitHub Pull Request #5161