[
https://issues.apache.org/jira/browse/DRILL-3195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14592817#comment-14592817
]
Victoria Markman commented on DRILL-3195:
-----------------------------------------
Verified fixed in: 1.1.0
#Thu Jun 18 16:36:49 EDT 2015
git.commit.id.abbrev=a027f69
{code}
0: jdbc:drill:schema=dfs> select ntile(3) over (partition by a1 order by a1)
from t1;
Error: UNSUPPORTED_OPERATION ERROR: The window function NTILE is not supported
See Apache Drill JIRA: DRILL-3195
[Error Id: eeffb188-ff60-4e34-bf71-dc22d6b2c899 on atsqa4-133.qa.lab:31010]
(state=,code=0)
0: jdbc:drill:schema=dfs> select last_value(a1) over (partition by a1) from t1;
Error: UNSUPPORTED_OPERATION ERROR: The window function LAST_VALUE is not
supported
See Apache Drill JIRA: DRILL-3195
[Error Id: fdb908fa-a79c-4928-b01a-8aef8862a832 on atsqa4-133.qa.lab:31010]
(state=,code=0)
0: jdbc:drill:schema=dfs> select lag(a1) over (partition by a1 order by b1)
from t1;
Error: UNSUPPORTED_OPERATION ERROR: The window function LAG is not supported
See Apache Drill JIRA: DRILL-3195
[Error Id: 6bb1bf76-a515-4ad0-bf2d-209a035c82e9 on atsqa4-133.qa.lab:31010]
(state=,code=0)
0: jdbc:drill:schema=dfs> select lead(a1) over (partition by a1 order by b1)
from t1;
Error: UNSUPPORTED_OPERATION ERROR: The window function LEAD is not supported
See Apache Drill JIRA: DRILL-3195
[Error Id: 1cb99b61-2e60-42f9-93e4-a37283afc61e on atsqa4-133.qa.lab:31010]
(state=,code=0)
0: jdbc:drill:schema=dfs> select first_value(a1) over (partition by a1 order by
b1) from t1;
Error: UNSUPPORTED_OPERATION ERROR: The window function FIRST_VALUE is not
supported
See Apache Drill JIRA: DRILL-3195
[Error Id: 626ed14e-e558-4bc1-9c62-a545b47d0895 on atsqa4-133.qa.lab:31010]
(state=,code=0)
{code}
> 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)
