You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jinfeng Ni (JIRA)" <ji...@apache.org> on 2015/03/13 23:50:38 UTC
[jira] [Updated] (DRILL-2335) Error message must be updated to
exclude unsupported operators when queries fail to parse
[ https://issues.apache.org/jira/browse/DRILL-2335?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jinfeng Ni updated DRILL-2335:
------------------------------
Fix Version/s: 1.1.0
> 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
> Fix For: 1.1.0
>
>
> 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)