array_repeat function

Applies to: Databricks SQL 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

SQL

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

Related functions

• array function