[jira] [Updated] (DRILL-3195) Throw unsupported exception for Window functions that are not currently supported

["Jinfeng Ni (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-3195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jinfeng Ni updated DRILL-3195:
------------------------------
    Assignee: Deneche A. Hakim  (was: Jinfeng Ni)

> Throw unsupported exception for Window functions that are not currently supported
> ---------------------------------------------------------------------------------
>
>                 Key: DRILL-3195
>                 URL: https://issues.apache.org/jira/browse/DRILL-3195
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>    Affects Versions: 1.0.0
>            Reporter: Victoria Markman
>            Assignee: Deneche A. Hakim
>
> 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:
> {code}
> 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)
> {code}
> Schema change exception:
> {code}
> 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)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)