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] [Commented] (DRILL-1635) Details on SQL error doesn't propagate
Date Wed, 05 Nov 2014 01:54:34 GMT

    [ 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

View raw message