You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Adam Kramer (JIRA)" <ji...@apache.org> on 2011/07/27 01:05:09 UTC
[jira] [Updated] (HIVE-1955) Support non-constant expressions for
array indexes.
[ 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