make_array_range

Description

Returns an array that contains a list of consecutive integers ranging from start to end. Note the end is not included in the list and the largest element is end - 1. The size of the generated list is capped at 1000000.

Return type

array of int64

Domain

This is a scalar function (calculates a single output value for a single input row.)

Categories

Usage

make_array_range(start, end)

Argument

Type

Optional

Repeatable

Restrictions

start

int64

no

no

none

end

int64

no

no

none

Examples

make_col arr:make_array_range(2, 5)

Make a new column ‘arr’ containing [2, 3, 4].

make_col arr:make_array_range(10, 5)

make_array_range would return an empty array if end is less or equal to start, so this will create a new column ‘arr’ containing an empty array.