You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Victoria Markman (JIRA)" <ji...@apache.org> on 2014/12/31 02:46:13 UTC

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

Victoria Markman created DRILL-1912:
---------------------------------------

             Summary: 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


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)