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

Throw unsupported exception for Window functions that are not currently supported

    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

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

              Dates

              • Created:
                Updated:
                Resolved: