[jira] [Created] (DRILL-2820) Error message must be updated when show files is executed on a non-existent workspace

["Abhishek Girish (JIRA)" <ji...@apache.org>]

Abhishek Girish created DRILL-2820:
--------------------------------------

             Summary: Error message must be updated when show files is executed on a non-existent workspace
                 Key: DRILL-2820
                 URL: https://issues.apache.org/jira/browse/DRILL-2820
             Project: Apache Drill
          Issue Type: Bug
          Components: SQL Parser
    Affects Versions: 0.9.0
            Reporter: Abhishek Girish
            Assignee: Aman Sinha


The following message is thrown when SHOW FILES is executed on an existing directory, which is not configured as a workspace:

{code:sql}
> show files from dfs.tmp.drill.tpch;
+------------+------------+
|     ok     |  summary   |
+------------+------------+
| false      | Current schema 'dfs.tmp.drill.tpch' is not a file system schema. Can't execute show files on this schema. |
+------------+------------+
1 row selected (0.375 seconds)

(Query executes when the following syntax is used:)
0: jdbc:drill:zk=local> show files from dfs.tmp.`drill/tpch`;
+------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+
|    name    | isDirectory |   isFile   |   length   |   owner    |   group    | permissions | accessTime | modificationTime |
+------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+
| customer.psv | false       | true       | 239490     | agirish    | wheel      | rwxr-xr-x   | 1969-12-31 16:00:00.0 | 2015-04-17 15:37:31.0 |
| lineitem.psv | false       | true       | 7204075    | agirish    | wheel      | rwxr-xr-x   | 1969-12-31 16:00:00.0 | 2015-04-17 15:37:30.0 |
+------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+
{code}

This should be updated to:
{code:sql}
> show files from dfs.tmp.drill.tpch;
Query failed: Workspace dfs.tmp.drill.tpch does not exist.
{code}



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