Ran Tao created CALCITE-5830:
--------------------------------
Summary: Add ARRAY_INSERT for Spark dialect
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
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]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
