STACK

​

Syntax

​

Table

STACK(rows, value1 [, value2 ...])

​

Arguments

​

Returns

• Type: TABLE with ceil(number of values / rows) columns
• NULL behavior: NULL values remain NULL; missing cells in the final row are padded with NULL.
• Empty input: At least one value is required; unused cells in the final generated row are NULL.
• Shape: rows generated rows per input row; column count is ceil(number of supplied values / rows).
• Ordering: Values are placed row-major; SQL row order requires ORDER BY.

​

Properties

​

Usage notes

• INTEGER and INT mean the same type; STRING means VARCHAR text. NULL can be used with a supported type. Cast NULL explicitly when its type would otherwise be unclear.
• Deterministic: The same inputs and settings produce the same result.

​

Examples

​

Typical behavior

SELECT a, b FROM TABLE(stack(2, 1, 'x', 2)) AS t(a, b) ORDER BY a;

​

Arrange values into rows

SELECT label, amount FROM TABLE(stack(2, 'a', 10, 'b', 20)) AS t(label, amount) ORDER BY label;

​

Limitations

• Values in the same output column must have the same type after conversion.
• rows must be a positive literal; at least one value is required.