array_repeat function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns an array containing element count times.

Syntax 

array_repeat(element, count)

Arguments

  • element: An expression of any type.

  • count: An INTEGER greater or equal to 0.

Returns

An array of the elements of the element type.

Examples 

> SELECT array_repeat('123', 2);
 [123, 123]