[ https://issues.apache.org/jira/browse/HIVE-1955?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13530678#comment-13530678 ]
Navis commented on HIVE-1955: ----------------------------- Is there any reason index value should be constant? > Support non-constant expressions for array indexes. > --------------------------------------------------- > > Key: HIVE-1955 > URL: https://issues.apache.org/jira/browse/HIVE-1955 > Project: Hive > Issue Type: Improvement > Reporter: Adam Kramer > > FAILED: Error in semantic analysis: line 4:8 Non Constant Expressions for > Array Indexes not Supported dut > ...just wrote my own UDF to do this, and it is trivial. We should support > this natively. > Let foo have these rows: > arr i > [1,2,3] 1 > [3,4,5] 2 > [5,4,3] 2 > [0,0,1] 0 > Then, > SELECT arr[i] FROM foo > should return: > 2 > 5 > 3 > 1 > Similarly, for the same table, > SELECT 3 IN arr FROM foo > should return: > true > true > true > false > ...these use cases are needless limitations of functionality. We shouldn't > need UDFs to accomplish these goals. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira