Array Functions

Array functions operate on array values that are used in external tables. These functions allow you to access, compare and aggregate arrays.

In addition to these functions, arrays support comparison operators (=, <, and >) and can be dereferenced by index (ARRAY[index]).

Notes

  • Array functions are supported only for external tables containing Parquet files.
  • Arrays are 0-indexed. The first element's ordinal position in 0, second is 1, and so on.
  • These functions operate on one-dimensional (1D) arrays, except array dereference and array slice. To use multidimensional arrays, you must first dereference to a 1D array type.
  • Null semantics for arrays are consistent with normal columns. See NULL Sort Order for more information on null-handling.

In This Section