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

PERCENTILE_CONT for BigQuery dialect has different syntax and is parsed incorrectly

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      For Big Query syntax, PERCENTILE_CONT uses the key word OVER instead of WITHIN GROUP 

      See documentation here.

      There are a couple of issues incorrect with current parsing

      • Parser.jj currently will incorrectly parses OVER into SqlOverOperator (which is correct for other dialects, however not entirely correct for Big Query)
      • Should support:  OVER(PARTITION BY y ORDER BY x)

      Attachments

        Issue Links

          incorporates

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-5955 BigQuery PERCENTILE functions are unparsed incorrectly

          • Major - Major loss of function.
          • Closed

          Activity

            People

              tanclary Tanner Clary
              oliverlee Oliver Lee
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: