[
https://issues.apache.org/jira/browse/CALCITE-5830?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ran Tao updated CALCITE-5830:
-----------------------------
Description:
array_insert(x, pos, val) - Places val into index pos of array x. Array indices
start at 1, or start from the end if index is negative. Index above array size
appends the array, or prepends the array if index is negative, with 'null'
elements
*Examples:*
> SELECT array_insert(array(1, 2, 3, 4), 5, 5); [1,2,3,4,5]
> SELECT array_insert(array(5, 3, 2, 1), -3, 4); [5,4,3,2,1]
https://spark.apache.org/docs/latest/api/sql/index.html#array_insert
was:
array_insert(x, pos, val) - Places val into index pos of array x. Array indices
start at 1, or start from the end if index is negative. Index above array size
appends the array, or prepends the array if index is negative, with 'null'
elements
*Examples:*
> SELECT array_insert(array(1, 2, 3, 4), 5, 5); [1,2,3,4,5]
> SELECT array_insert(array(5, 3, 2, 1), -3, 4); [5,4,3,2,1]
> Add ARRAY_INSERT function(enabled in Spark library)
> ---------------------------------------------------
>
> Key: CALCITE-5830
> URL: https://issues.apache.org/jira/browse/CALCITE-5830
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.34.0
> Reporter: Ran Tao
> Assignee: Ran Tao
> Priority: Major
>
> array_insert(x, pos, val) - Places val into index pos of array x. Array
> indices start at 1, or start from the end if index is negative. Index above
> array size appends the array, or prepends the array if index is negative,
> with 'null' elements
> *Examples:*
> > SELECT array_insert(array(1, 2, 3, 4), 5, 5); [1,2,3,4,5]
> > SELECT array_insert(array(5, 3, 2, 1), -3, 4); [5,4,3,2,1]
> https://spark.apache.org/docs/latest/api/sql/index.html#array_insert
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
