Uploaded image for project: 'Beam'
  1. Beam
  2. BEAM-9984

Support BIT_OR aggregation function in Beam SQL

    XMLWordPrintableJSON

    Details

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                ismailo Omar Ismail
                Reporter:
                kenn Kenneth Knowles
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 2h 40m
                  2h 40m