[ https://issues.apache.org/jira/browse/HIVE-27663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17824213#comment-17824213 ]
Sai Hemanth Gantasala commented on HIVE-27663: ---------------------------------------------- [~tarak271] - Thanks for the contribution. The patch has been merged into the master branch. > 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 > Fix For: 4.1.0 > > > 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)