[
https://issues.apache.org/jira/browse/HIVE-1955?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Adam Kramer updated HIVE-1955:
------------------------------
Description:
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.
was:
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.
> 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
