You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Khurram Faraaz (JIRA)" <ji...@apache.org> on 2016/02/24 13:35:18 UTC
[jira] [Created] (DRILL-4428) Need a better error message when
GROUPS keyword used in window frame-clause
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)