[HIVE-26744] Add array_max and array_min UDFs

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-beta-1
• Component/s: Hive
• Labels: pull-request-available
• Assignee: Taraka Rama Rao Lethavadla
• Reporter: Taraka Rama Rao Lethavadla
• Created: 16/Nov/22 13:45
• Updated: 15/Aug/23 06:33
• Resolved: 24/Nov/22 12:33

Description

1. array_max(array(obj1, obj2,...)) - The function returns the maximum value in an array with elements for which order is supported, returns null if array is empty

Example:

> SELECT array_max(array(1, 3, 0, NULL)) FROM src LIMIT 1;
3

 

2. array_min(array(obj1, obj2,...)) - The function returns the minimum value in an array with elements for which order is supported, returns null if array is empty
Example:  

> SELECT array_min(array(1, 3, 0, NULL)) FROM src LIMIT 1;
0

 

Issue Links

• is depended upon by: HIVE-26754 Implement array_distinct UDF to return an array after removing duplicates in it
• links to: GitHub Pull Request #3774