[ https://issues.apache.org/jira/browse/HIVE-27663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated HIVE-27663: ---------------------------------- Labels: pull-request-available (was: ) > implement array_position UDF in Hive > ------------------------------------ > > Key: HIVE-27663 > URL: https://issues.apache.org/jira/browse/HIVE-27663 > Project: Hive > Issue Type: Sub-task > Reporter: Taraka Rama Rao Lethavadla > Assignee: Taraka Rama Rao Lethavadla > Priority: Major > Labels: pull-request-available > > array_position(array, element) - Returns the position of the first occurrence > of element in array. > Array indexing starts at 1. If the element value is NULL, a NULL is returned. > > Example: > {noformat} > > SELECT array_position(array(1, 2, 3,4,2), 2) FROM src; > 2{noformat} -- This message was sent by Atlassian Jira (v8.20.10#820010)