Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3195

Throw unsupported exception for Window functions that are not currently supported

    XMLWordPrintableJSON

Details

    Description

      List of window functions that are currently supported by Calcite, that we don't plan to support in 1.1 release: ntile(), lag(), lead(), first_value(), last_value()

      Examples of behavior if not disabled:

      IOBE with NTILE:

      0: jdbc:drill:schema=dfs> select ntile(3) over (partition by a1 order by a1) from t1;
Error: SYSTEM ERROR: java.lang.IndexOutOfBoundsException: index (1) must be less than size (1)
[Error Id: 99f1a074-0e68-400e-9c68-d3c623f85a9f on atsqa4-133.qa.lab:31010] (state=,code=0)

      Schema change exception:

      0: jdbc:drill:schema=dfs> select last_value(a1) over (partition by a1) from t1;
Error: SYSTEM ERROR: org.apache.drill.exec.exception.SchemaChangeException: Failure while materializing expression. 
Error in expression at index -1.  Error: Missing function implementation: [last_value(INT-OPTIONAL)].  Full expression: --UNKNOWN EXPRESSION--.
Fragment 0:0
[Error Id: b5fac51d-0977-4641-9ead-0c98892d123a on atsqa4-133.qa.lab:31010] (state=,code=0)

      Attachments

        Activity

          People

            seanhychu Sean Hsuan-Yi Chu
            vicky Victoria Markman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: