[
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)
