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

Support BIT_AND aggregation function in BeamSQL

    XMLWordPrintableJSON

    Details

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                fuyuwei Yuwei Fu
                Reporter:
                amaliujia Rui Wang
              • Votes:
                0 Vote for this issue
                Watchers:
                2 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 - 4.5h
                  4.5h