[HIVE-26754] Implement array_distinct UDF to return an array after removing duplicates in it

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0
• Component/s: Hive
• Labels: pull-request-available
• Assignee: Taraka Rama Rao Lethavadla
• Reporter: Taraka Rama Rao Lethavadla
• Created: 17/Nov/22 10:00
• Updated: 23/Dec/22 14:04
• Resolved: 22/Dec/22 19:08

Description

array_distinct(array(obj1, obj2,...)) - The function returns an array of the same type as the input argument where all duplicate values have been removed.

Example:
> SELECT array_distinct(array('b', 'd', 'd', 'a')) FROM src LIMIT 1;
['a', 'b', 'c']

Issue Links

• depends upon: HIVE-26744 Add array_max and array_min UDFs
• links to: GitHub Pull Request #3806