[jira] [Created] (DRILL-7404) window function RANGE with compound ORDER BY

["benj (Jira)" <ji...@apache.org>]

benj created DRILL-7404:
---------------------------

             Summary: window function RANGE with compound ORDER BY
                 Key: DRILL-7404
                 URL: https://issues.apache.org/jira/browse/DRILL-7404
             Project: Apache Drill
          Issue Type: Improvement
          Components: Documentation
    Affects Versions: 1.16.0
            Reporter: benj


When creating a ticket CALCITE-3402 (to ask for improve the window functions), it's appears that the documentation of drill seems not up to date

[https://drill.apache.org/docs/aggregate-window-functions/]
{code:java}
frame_clause
If an ORDER BY clause is used for an aggregate function, an explicit frame clause is required. The frame clause refines the set of rows in a function's window, including or excluding sets of rows within the ordered result. The frame clause consists of the ROWS or RANGE keyword and associated specifiers.
{code}
 But it's currently (1.16) possible to write ORDER BY clause in window function +without+ specify an explicit RANGE clause.

In this case, an +implicit+ frame clause is used.

And normally the default/implicit framing option is {{RANGE UNBOUNDED PRECEDING}}, which is the same as {{RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW (and should perhaps also be more explicitly specified) }}

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)