-
Type:
Task
-
Status: Resolved
-
Priority:
P2
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: Not applicable
-
Component/s: dsl-sql, dsl-sql-zetasql
-
Labels:
Performs a bitwise AND operation on expression and returns the result.
Supported Argument Types: INT64
Returned Data Types: INT64
Examples
SELECT BIT_AND(c) as bit_and FROM UNNEST([0xF001, 0x00A1]) as c; +---------+ | bit_and | +---------+ | 1 | +---------+
What is expected: should include both Calcite and ZetaSQL dialects.
How to test: unit tests
Reference: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#bit_and
- is cloned by
-
BEAM-9984 Support BIT_OR aggregation function in Beam SQL
-
- Resolved
-
- links to