You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2015/04/18 02:22:59 UTC
[jira] [Updated] (DRILL-2820) Error message must be updated when
show files is executed on a non-existent workspace
[ https://issues.apache.org/jira/browse/DRILL-2820?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Abhishek Girish updated DRILL-2820:
-----------------------------------
Description:
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}
was:
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}
> 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)