[CALCITE-5830] Add ARRAY_INSERT function(enabled in Spark library)

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.34.0
• Fix Version/s: 1.36.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Ran Tao
• Reporter: Ran Tao
• Created: 10/Jul/23 08:21
• Updated: 10/Nov/23 11:34
• Resolved: 18/Aug/23 10:41

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

Issue Links

• links to: GitHub Pull Request #3320