Skip to main content

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.

Databricks raises COLLECTION_SIZE_LIMIT_EXCEEDED if count exceeds the array size limit.

Common error conditions​

Examples​

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