... |
ARRAYTABLE is effectively a shortcut for using the [Miscellaneous Functions#array_get|Miscellaneous Functions#array_get] function in a nested table. For example |
{code:lang=SQL}ARRAYGET(val {code:lang=SQL}ARRAYTABLE(val COLUMNS col1 string, col2 integer) AS X{code} |
is the same as |
... |
The ARRAYTABLE function processes an array input to produce tabular output. The function itself defines what columns it projects. The ARRAYTABLE function is implicitly a nested table and may be correlated to preceding FROM clause entries.
Usage:
ARRAYTABLE(expression COLUMNS <COLUMN>, ...) AS name COLUMN := name datatype
Parameters
Examples
select x.* from (call source.invokeMDX('some query')) r, arraytable(r.tuple COLUMNS first string, second bigdecimal) x
ARRAYTABLE is effectively a shortcut for using the Miscellaneous Functions#array_get function in a nested table. For example
ARRAYTABLE(val COLUMNS col1 string, col2 integer) AS X
is the same as
TABLE(SELECT cast(array_get(val, 1) AS string) AS col1, cast(array_get(val, 2) AS integer) AS col2) AS X