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

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 0.9.0
• Fix Version/s: Future
• Component/s: SQL Parser
• Labels: error_message_must_fix
• Assignee: Unassigned
• Reporter: Abhishek Girish
• Created: 18/Apr/15 00:22
• Updated: 01/Oct/15 16:37

Description

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

> 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 |
+------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+

This should be updated to:

> show files from dfs.tmp.drill.tpch;
Query failed: Schema 'dfs.tmp.drill.tpch' does not exist.