This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.

ARRAY_DISTINCT

Returns an array containing only the unique elements of the given array. If the given array contains multiple identical members, the returned array will include only a single member of that value.

Syntax

ARRAY_DISTINCT(<array>)

Parameters

Return Type

ARRAY of the same type as the input array

Example

In the following example, the unique levels of the game are returned in an array called levels:

SELECT
	ARRAY_DISTINCT([ 1, 1, 2, 2, 3, 4 ]) AS levels;

Returns: [1,2,3,4]