arrayPushFront
This section contains reference documentation for the arrayPushFront functions.
Prepends one element to the beginning of an array.
Supported Variants
Function
Signature
Return Type
arrayPushFrontInt
arrayPushFrontInt(values, element)
INT[]
arrayPushFrontLong
arrayPushFrontLong(values, element)
LONG[]
arrayPushFrontFloat
arrayPushFrontFloat(values, element)
FLOAT[]
arrayPushFrontDouble
arrayPushFrontDouble(values, element)
DOUBLE[]
arrayPushFrontString
arrayPushFrontString(values, element)
STRING[]
Usage Examples
These examples are based on the inputs used in Pinot's array function tests.
SELECT arrayPushFrontInt(intArray, 7) AS updatedArray
FROM myTableReturns [7, 3, 2, 10, 6, 1, 12] when intArray is [3, 2, 10, 6, 1, 12].
SELECT arrayPushFrontString(stringArray, 'x') AS updatedArray
FROM myTableReturns ['x', '3', '2', '10', '6', '1', '12'] when stringArray is ['3', '2', '10', '6', '1', '12'].
Last updated
Was this helpful?

