make_array_range(start: int64, end: int64) -> array of int64

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.

Domain

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

Categories

• Semistructured

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.