GET_ITEM

SyntaxSyntax

GET_ITEM( array, index )

DescriptionDescription

Returns the element with the index index from the array array. Index must be any integer. Indexes in an array begin with one. Returns the last item from the array if index is -1.

Argument types:

• array — Array of fractional numbers | Array of integers | Array of strings
• index — Integer

Return type: Depends on argument types

ExampleExample

GET_ITEM([array_field], 2)

Data source supportData source support

ClickHouse 21.8, Files, Google Sheets, PostgreSQL 9.3, Yandex Documents.