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

Posted to issues@drill.apache.org by "Deneche A. Hakim (JIRA)" <ji...@apache.org> on 2015/10/20 20:30:27 UTC

[jira] [Created] (DRILL-3960) LEAD, LAG and NTILE should fail if ORDER BY clause is not present

Deneche A. Hakim created DRILL-3960:
---------------------------------------

             Summary: LEAD, LAG and NTILE should fail if ORDER BY clause is not present
                 Key: DRILL-3960
                 URL: https://issues.apache.org/jira/browse/DRILL-3960
             Project: Apache Drill
          Issue Type: Bug
          Components: SQL Parser
    Affects Versions: 1.2.0
            Reporter: Deneche A. Hakim


According to the SQL specification, LEAD, LAG and NTILE window functions require an ORDER BY clause in the window definition. Drill should throw an error if these window functions are used without an ORDER BY.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)