Scalars

Subtopics

Closely related to scalars are arrays, which are ordered collections of scalar values. All elements in an array have to be the same type:

Input

Run

select [1, 1, 2, 3, 5];

select [1, 1, 2, 3, 5];

Output Objects

Press the 'Run' button to evaluate the input

Array elements can be accessed by giving an index (starting with 0) enclosed in []:

Input

Run

# access index 4 of the array [1, 1, 2, 3, 5]
select [1, 1, 2, 3, 5] [4];

# access index 4 of the array [1, 1, 2, 3, 5]
select [1, 1, 2, 3, 5] [4];

Output Objects

Press the 'Run' button to evaluate the input

You can also cast arrays from one type to another by using a "nested" cast notation. In the example below a nested <array<str>> cast is used to transform an array of <int64> into an array of <str>:

Input

Run

select <array<str>>[1, 2, 3];

select <array<str>>[1, 2, 3];

Output Objects

Press the 'Run' button to evaluate the input

Prev Next