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

Add support for WEEK(WEEKDAY) for custom time frames to relevant functions

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 1.33.0
    • None
    • None

    Description

      Some BigQuery functions, such as EXTRACT and DATE_TRUNC, accept the operand WEEK(weekday), where weekday is one of SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY. After this change, any function that accepts WEEK or ISOWEEK timeframe will also accept WEEK(SUNDAY) etc.
       
      Note that WEEK is equivalent to WEEK(SUNDAY) and ISOWEEK is equivalent to WEEK(MONDAY).

      In this change we also allow WEEKS as a synonym for WEEK, and QUARTERS as a synonym for QUARTER.

      Attachments

        Issue Links

          depends upon

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-5341 Upgrade Calcite to Avatica 1.23.0

          • Major - Major loss of function.
          • Closed
          is a child of

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-5447 Add DATE_TRUNC for BigQuery

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-5505 JavaCC warns about missing LOOKAHEAD directives in Parser.jj

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              oliverlee Oliver Lee
              oliverlee Oliver Lee
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: