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

["Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-3195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14582361#comment-14582361 ] 

Sean Hsuan-Yi Chu commented on DRILL-3195:
------------------------------------------

https://reviews.apache.org/r/35365/

> 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: Sean Hsuan-Yi Chu
>              Labels: window_function
>             Fix For: 1.1.0
>
>
> 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)