[jira] [Commented] (DRILL-2818) Error message must be updated when query fails with FileNotFoundException

["Deneche A. Hakim (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-2818?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14546127#comment-14546127 ] 

Deneche A. Hakim commented on DRILL-2818:
-----------------------------------------

Error message improved in 1.0.0:
{noformat}
0: jdbc:drill:zk=local> show files from dfs.tmp.`tpch`;
Error: SYSTEM ERROR: java.io.FileNotFoundException: File /tmp/tpch does not exist


[Error Id: 90e7550c-a756-490a-93e3-44790f6fb24d on abdel-11.qa.lab:31010] (state=,code=0)
{noformat}

Still need to be converted to a user error

> Error message must be updated when query fails with FileNotFoundException
> -------------------------------------------------------------------------
>
>                 Key: DRILL-2818
>                 URL: https://issues.apache.org/jira/browse/DRILL-2818
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: SQL Parser
>    Affects Versions: 0.9.0
>         Environment: exception branch
>            Reporter: Abhishek Girish
>            Assignee: Deneche A. Hakim
>              Labels: error_message_must_fix
>             Fix For: 1.2.0
>
>
> When user specifies a non-existent file/directory in a query, the following error is being thrown:
> {code:sql}
> > show files from dfs.tmp.`tpch`;
> Query failed: SYSTEM ERROR: Failure handling SQL.
> [9184097e-8339-42d3-96ce-1fba51c6bc78 on 192.168.158.107:31010]
> Error: exception while executing query: Failure while executing query. (state=,code=0)
> {code}
> This should be updated to 
> {code:sql}
> > show files from dfs.tmp.`tpch`;
> Query failed: File /tmp/tpch does not exist. 
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)