chucheng92 opened a new pull request, #3320:
URL: https://github.com/apache/calcite/pull/3320

   # What is the purpose of the change
   
   Add array_insert(x, pos, val) function(enabled in Spark library).
   
   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
   
   # Brief change log
   Add array_insert(x, pos, val) function(enabled in Spark library).
   
   # Verifying this change
   
   SqlOperatorTests#testArrayInsertFunc()
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to