INLINE_OUTER

​

Syntax

​

Table

inline_outer(collection)

​

Arguments

​

Returns

• Type: TABLE with the struct field types
• NULL behavior: NULL array emits one all-NULL output row. A NULL struct element emits one all-NULL row.
• Empty input: One all-NULL row for an empty array.
• Shape: The output has one column for each struct field, with the element field types.
• Ordering: Input element order is preserved by expansion; SQL output order requires ORDER BY.

​

Properties

​

Usage notes

• Deterministic: The same inputs and settings produce the same result.

​

Examples

​

Typical behavior

SELECT a, b FROM TABLE(inline_outer(ARRAY(named_struct('a', 1, 'b', 'x'), named_struct('a', 2, 'b', 'y')))) AS t(a, b) ORDER BY a;

​

Preserve a NULL struct element

SELECT a, b FROM TABLE(inline_outer(ARRAY(named_struct('a', 1, 'b', 'x'), CAST(NULL AS STRUCT<a:INT,b:STRING>)))) AS t(a, b) ORDER BY a NULLS LAST;

​

Limitations

• Exactly one ARRAY<STRUCT> argument is required.

​

Related functions

• inline
• explode