[jira] [Resolved] (BEAM-9984) Support BIT_OR aggregation function in Beam SQL

["Omar Ismail (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/BEAM-9984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Omar Ismail resolved BEAM-9984.
-------------------------------
    Fix Version/s: 2.23.0
       Resolution: Fixed

PR is now merged 

> 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: Kenneth Knowles
>            Assignee: Omar Ismail
>            Priority: P2
>              Labels: starter
>             Fix For: 2.23.0
>
>          Time Spent: 2h 40m
>  Remaining Estimate: 0h
>
> Performs a bitwise OR operation on expression and returns the result.
> Supported Argument Types: INT64
> Returned Data Types: INT64
> Examples
> {code:sql}
> SELECT BIT_OR(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_or



--
This message was sent by Atlassian Jira
(v8.3.4#803005)