[jira] [Commented] (DRILL-1912) Throw unsupported error message for window functions

["Victoria Markman (JIRA)" <ji...@apache.org>]

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