[BEAM-9984] Support BIT_OR aggregation function in Beam SQL

• Type: Task
• Status: Resolved
• Priority: P2
• Resolution: Fixed
• Fix Version/s: 2.23.0
• Component/s: dsl-sql, dsl-sql-zetasql
• Labels: starter
• Assignee: Omar Ismail
• Reporter: Kenneth Knowles
• Created: 13/May/20 17:12
• Updated: 20/May/20 14:41
• Resolved: 20/May/20 14:41

Description

Performs a bitwise OR operation on expression and returns the result.

Supported Argument Types: INT64
Returned Data Types: INT64

Examples

SELECT BIT_OR(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_or

Issue Links

• is a clone of: BEAM-9890 Support BIT_AND aggregation function in BeamSQL
• links to: GitHub Pull Request #11737