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)
