BITORAGG

​

Syntax

​

Aggregate

bitoragg([DISTINCT] value)

​

Window

bitoragg(value) OVER ([PARTITION BY key] [ORDER BY ordering_key] [ROWS BETWEEN UNBOUNDED PRECEDING AND bound])

• Use a frame that includes all rows in the group or starts at the first row (UNBOUNDED PRECEDING). Sliding frames that drop earlier rows are not supported. RANGE frames with a numeric or time offset are not supported.

​

Arguments

​

Aggregate and window

​

Returns

• Type: Same SQL type as value
• NULL behavior: NULLs are ignored; an all-NULL group or frame returns NULL.
• Empty input: Returns NULL on an empty global aggregate or empty frame.

​

Properties

​

Usage notes

• Use DISTINCT in grouped aggregation only. It does not provide duplicate removal in a window call.

​

Examples

​

Combine bits

WITH t("value") AS (VALUES (3), (5)) SELECT bitoragg("value") AS result FROM t;

​

Ignore NULLs

WITH t("value") AS (VALUES (1), (CAST(NULL AS INTEGER)), (2)) SELECT bitoragg("value") AS result FROM t;

​

All NULL values

WITH t("value") AS (VALUES (CAST(NULL AS INTEGER)), (CAST(NULL AS INTEGER))) SELECT bitoragg("value") AS result FROM t;

​

Limitations

• FLOAT, DOUBLE, and DECIMAL inputs are not supported. Cast to an integer type before calling the function if integer conversion is appropriate for your data.
• BITORAGG returns the input integer type, although query tools may report BIGINT. The reported type does not widen the returned value.
• Use a frame that includes all rows in the group or starts at the first row (UNBOUNDED PRECEDING). Sliding frames that drop earlier rows are not supported. RANGE frames with a numeric or time offset are not supported.