INLINE

​

Syntax

​

Table

inline(collection)

​

Arguments

​

Returns

• Type: TABLE with the struct field types
• NULL behavior: NULL array emits no rows. A NULL struct element emits one all-NULL row.
• Empty input: No rows 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(ARRAY(named_struct('a', 1, 'b', 'x'), named_struct('a', 2, 'b', 'y')))) AS t(a, b) ORDER BY a;

​

Expand structs with boolean fields

SELECT name, active FROM TABLE(inline(ARRAY(named_struct('name', 'Ada', 'active', TRUE), named_struct('name', 'Lin', 'active', FALSE)))) AS t(name, active) ORDER BY name;

​

Limitations

• Exactly one ARRAY<STRUCT> argument is required.

​

Related functions

• inline_outer
• explode