[BEAM-9890] Support BIT_AND aggregation function in BeamSQL

• Type: Task
• Status: Resolved
• Priority: P2
• Resolution: Fixed
• Fix Version/s: Not applicable
• Component/s: dsl-sql, dsl-sql-zetasql
• Labels: starter
• Assignee: Yuwei Fu
• Reporter: Rui Wang
• Created: 05/May/20 20:04
• Updated: 30/Jun/20 06:10
• Resolved: 24/Jun/20 20:50

Description

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

Issue Links

• is cloned by: BEAM-9984 Support BIT_OR aggregation function in Beam SQL
• links to: GitHub Pull Request #12079
• links to: GitHub Pull Request #12110
• links to: GitHub Pull Request #12122