[
https://issues.apache.org/jira/browse/DRILL-1635?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14197343#comment-14197343
]
Jinfeng Ni commented on DRILL-1635:
-----------------------------------
BTW: the original query failed because you use smart quota ’Restaurants’, which
Optiq could not parse correctly.
Agree that Drill should report the location in the query where the parer error
happens.
> Details on SQL error doesn't propagate
> ---------------------------------------
>
> Key: DRILL-1635
> URL: https://issues.apache.org/jira/browse/DRILL-1635
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Neeraja
> Assignee: Jinfeng Ni
> Priority: Critical
>
> Executing any SQL query with incorrect syntax produces errors that do not
> pinpoint the problem areas , but throws a generic failure parsing sql
> exception.
> Expect to see more specific/actionable message.
> 0: jdbc:drill:zk=local> select count(*) from
> dfs.`/users/nrentachintala/Downloads/yelp_dataset_challenge_academic_dataset/yelp_academic_dataset_business.json`
> b where true=repeated_contains(b.categories,’Restaurants’);
> Query failed: Failure while parsing sql.
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
