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

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-1912?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Nadeau updated DRILL-1912:
----------------------------------
    Fix Version/s: 0.8.0
         Assignee: Deneche A. Hakim

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