[
https://issues.apache.org/jira/browse/DRILL-1912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14541068#comment-14541068
]
Victoria Markman commented on DRILL-1912:
-----------------------------------------
Verified fixed in 1.0.0
0: jdbc:drill:schema=dfs> select count(*) over(partition by c1) from t1;
Error: SYSTEM ERROR:
org.apache.drill.exec.work.foreman.UnsupportedFunctionException: Window
functions are disabled
See Apache Drill JIRA: DRILL-2559
[Error Id: 8a04ef36-be3b-4a55-8f0d-704e178c0803 on atsqa4-133.qa.lab:31010]
(state=,code=0)
> Throw unsupported error message for window functions
> -----------------------------------------------------
>
> Key: DRILL-1912
> URL: https://issues.apache.org/jira/browse/DRILL-1912
> Project: Apache Drill
> Issue Type: Bug
> Components: SQL Parser
> Affects Versions: 0.8.0
> Reporter: Victoria Markman
> Assignee: Deneche A. Hakim
> Fix For: 0.8.0
>
> Attachments: DRILL-1912.1.patch.txt, DRILL-1912.2.patch.txt
>
>
> Window functions below are currently:
> * Supported in Calcite
> * Not supported in DRILL
> * Not documented in DRILL documentation
> ROW_NUMBER()
> FIRST_VALUE()
> LAST_VALUE()
> PERCENT_RANK()
> DENSE_RANK()
> Spoke to Jacques: Window function implementation is not targeted until after
> 1.0 release. Therefore, for 0.8.0 release we are going to throw "Unsupported"
> error message for these functions as well as for every other function that
> supports OVER clause due to two critical bugs below:
> DRILL-1487 - window functions return wrong result
> DRILL-1908 - new implementation of window functions
> Assigning to Jacques on his request, targeting 0.8.0
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
