[jira] [Created] (DRILL-4428) Need a better error message when GROUPS keyword used in window frame-clause

[Khurram Faraaz (JIRA)]

Khurram Faraaz created DRILL-4428:
-------------------------------------

             Summary: Need a better error message when GROUPS keyword used in 
window frame-clause
                 Key: DRILL-4428
                 URL: https://issues.apache.org/jira/browse/DRILL-4428
             Project: Apache Drill
          Issue Type: Bug
          Components: SQL Parser
    Affects Versions: 1.6.0
            Reporter: Khurram Faraaz
            Priority: Minor


We need to report a better message to user that we do not support (today) the 
use of GROUPS keyword as the window frame unit, in the window frame clause.

commit ID: 6d5f4983
Drill version : 1.6.0

{noformat}
0: jdbc:drill:schema=dfs.tmp> select count(*) OVER(PARTITION BY CAST(columns[0] 
as integer) GROUPS) from dfs.tmp.`t_alltype.csv`;
Error: PARSE ERROR: Encountered "GROUPS" at line 1, column 63.
Was expecting one of:
    ")" ...
    "," ...
    "ORDER" ...
    "ROWS" ...
    "RANGE" ...
    "ALLOW" ...
    "DISALLOW" ...
    "NOT" ...
    "IN" ...
    "BETWEEN" ...
    "LIKE" ...
    "SIMILAR" ...
    "=" ...
    ">" ...
    "<" ...
    "<=" ...
    ">=" ...
    "<>" ...
    "+" ...
    "-" ...
    "*" ...
    "/" ...
    "||" ...
    "AND" ...
    "OR" ...
    "IS" ...
    "MEMBER" ...
    "SUBMULTISET" ...
    "MULTISET" ...
    "[" ...


while parsing SQL query:
select count(*) OVER(PARTITION BY CAST(columns[0] as integer) GROUPS) from 
dfs.tmp.`t_alltype.csv`
                                                              ^

[Error Id: f08e924a-bde9-48c4-bc7b-cb32c96908f2 on centos-04.qa.lab:31010] 
(state=,code=0)
{noformat}



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