Kenneth Knowles created BEAM-9984:
-------------------------------------

             Summary: Support BIT_OR aggregation function in Beam SQL
                 Key: BEAM-9984
                 URL: https://issues.apache.org/jira/browse/BEAM-9984
             Project: Beam
          Issue Type: Task
          Components: dsl-sql, dsl-sql-zetasql
            Reporter: Rui Wang


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

Supported Argument Types: INT64
Returned Data Types: INT64

Examples

{code:sql}
SELECT BIT_AND(c) as bit_and FROM UNNEST([0xF001, 0x00A1]) as c;

+---------+
| bit_and |
+---------+
| 1       |
+---------+
{code}



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)

Reply via email to