[ https://issues.apache.org/jira/browse/HIVE-26744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ayush Saxena resolved HIVE-26744. --------------------------------- Fix Version/s: 4.0.0 Resolution: Fixed > Add array_max and array_min UDFs > --------------------------------- > > Key: HIVE-26744 > URL: https://issues.apache.org/jira/browse/HIVE-26744 > Project: Hive > Issue Type: Sub-task > Components: Hive > Reporter: Taraka Rama Rao Lethavadla > Assignee: Taraka Rama Rao Lethavadla > Priority: Major > Labels: pull-request-available > Fix For: 4.0.0 > > Time Spent: 5.5h > Remaining Estimate: 0h > > *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: > {noformat} > > SELECT array_max(array(1, 3, 0, NULL)) FROM src LIMIT 1; > 3{noformat} > > *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: > {noformat} > > SELECT array_min(array(1, 3, 0, NULL)) FROM src LIMIT 1; > 0{noformat} > -- This message was sent by Atlassian Jira (v8.20.10#820010)