You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2015/02/27 04:41:04 UTC
[jira] [Created] (DRILL-2335) Error message must be updated to
exclude unsupported operators when queries fail to parse
Abhishek Girish created DRILL-2335:
--------------------------------------
Summary: Error message must be updated to exclude unsupported operators when queries fail to parse
Key: DRILL-2335
URL: https://issues.apache.org/jira/browse/DRILL-2335
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Reporter: Abhishek Girish
Assignee: Jinfeng Ni
Priority: Minor
When queries fail to parse due to errors in query syntax, an error is thrown with a list of expected operators, which include some which we do not support at present.
I understand that the SQL validation errors come from the Calcite layer. But since we do not support all operators for now (for example: INTERSECT), the message must be updated if possible, to correctly reflect what is supported.
This would make sure contradicting messages aren't thrown (for example: first complaining with parse error indicating INTERSECT is a valid operator and then upon correction, failing saying INTERSECT isn't supported).
{code:sql}
Query failed: ParseException: Encountered ";" at line 1, column 89.
Was expecting one of:
<EOF>
"ORDER" ...
"LIMIT" ...
"OFFSET" ...
"FETCH" ...
"UNION" ...
"INTERSECT" ...
"EXCEPT" ...
"NOT" ...
"IN" ...
"BETWEEN" ...
"LIKE" ...
"SIMILAR" ...
"=" ...
">" ...
"<" ...
"<=" ...
">=" ...
"<>" ...
"+" ...
"-" ...
"*" ...
"/" ...
"||" ...
"AND" ...
"OR" ...
"IS" ...
"MEMBER" ...
"SUBMULTISET" ...
"MULTISET" ...
"[" ...
"OVERLAPS" ...
"YEAR" ...
"MONTH" ...
"DAY" ...
"HOUR" ...
"MINUTE" ...
"SECOND" ...
Error: exception while executing query: Failure while executing query. (state=,code=0)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)