drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jinfeng Ni (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-2335) Error message must be updated to exclude unsupported operators when queries fail to parse
Date Fri, 13 Mar 2015 22:50:38 GMT

     [ 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)

Mime
View raw message