[
https://issues.apache.org/jira/browse/BEAM-9890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rui Wang updated BEAM-9890:
---------------------------
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
was:
Performs a bitwise AND operation on expression and returns the result.
Supported Argument Types: INT64
Returned Data Types: INT64
Examples
SELECT BIT_AND(x) as bit_and FROM UNNEST([0xF001, 0x00A1]) as x;
+---------+
| 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
> Support BIT_AND aggregation function in BeamSQL
> -----------------------------------------------
>
> Key: BEAM-9890
> URL: https://issues.apache.org/jira/browse/BEAM-9890
> Project: Beam
> Issue Type: Task
> Components: dsl-sql, dsl-sql-zetasql
> Reporter: Rui Wang
> Priority: Major
> Labels: starter
>
> 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
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
