Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-2770

Add bitwise aggregate functions BIT_AND, BIT_OR

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.19.0
    • Component/s: core
    • Labels:
      None

      Description

      Almost all major database vendors provide bitwise aggregate functions such as BIT_AND, BIT_OR. It would be nice if Calcite has these as built-in aggregate functions.

       

      [1]. https://docs.aws.amazon.com/redshift/latest/dg/c_bitwise_aggregate_functions.html

      [2]. https://www.postgresql.org/docs/9.1/functions-aggregate.html

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mmior Michael Mior
                Reporter:
                hyuan Haisheng Yuan
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: