You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "George Chow (JIRA)" <ji...@apache.org> on 2014/05/31 03:57:01 UTC
[jira] [Commented] (DRILL-879) SHOW FILES does not work correctly
for non-default DFS workspaces
[ https://issues.apache.org/jira/browse/DRILL-879?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14014463#comment-14014463 ]
George Chow commented on DRILL-879:
-----------------------------------
There is a work-around for this.
Instead of this (using the logical root):
{code}
show files from `dfs.JSON-files`.`/`
{code}
Use this (current directory):
{code}
show files from `dfs.JSON-files`.`./`
{code}
It is a good idea to guard against a user inadvertently stepping outside of the file location.
> SHOW FILES does not work correctly for non-default DFS workspaces
> -----------------------------------------------------------------
>
> Key: DRILL-879
> URL: https://issues.apache.org/jira/browse/DRILL-879
> Project: Apache Drill
> Issue Type: Bug
> Reporter: George Chow
> Assignee: Mehant Baid
> Priority: Minor
>
> Given a storage-plugsins.json that looks like the following:
> {code}
> "storage":{
> dfs: {
> type: "file",
> connection: "maprfs:///",
> workspaces: {
> "MFS root" : {
> location: "/mapr/summit-drill/JSON",
> writable: false
> },
> "JSON-files" : {
> location: "/JSON",
> writable: false
> }
> },
> {code}
> SHOW FILES of dfs.default and dfs.JSON-files should be different. But they're not.
> {code}
> 0: jdbc:drill:zk=localhost:5181> show files from `dfs.default`.`/`;
> +------------+-------------+------------+------------+------------+------------+-------------+-+
> | name | isDirectory | isFile | length | owner | group | permissions | |
> +------------+-------------+------------+------------+------------+------------+-------------+-+
> | etc | true | false | 4096 | root | root | rwxr-xr-x | |
> | tmp | true | false | 4096 | root | root | rwxrwxrwt | |
> | boot | true | false | 4096 | root | root | rwxr-xr-x | |
> | mavenoutput.txt | false | true | 333790 | root | root | rw-r--r- |
> | RPMS | true | false | 4096 | root | root | rwxr-xr-x | |
> | sys | true | false | 0 | root | root | rwxr-xr-x | |
> ...
> | media | true | false | 4096 | root | root | rwxr-xr-x | |
> | opt | true | false | 4096 | root | root | rwxr-xr-x | |
> +------------+-------------+------------+------------+------------+------------+-------------+-+
> 27 rows selected (0.394 seconds)
> {code}
> {code}
> 0: jdbc:drill:zk=localhost:5181> show files from `dfs.JSON-files`.`/`;
> +------------+-------------+------------+------------+------------+------------+-------------+-+
> | name | isDirectory | isFile | length | owner | group | permissions | |
> +------------+-------------+------------+------------+------------+------------+-------------+-+
> | etc | true | false | 4096 | root | root | rwxr-xr-x | |
> | tmp | true | false | 4096 | root | root | rwxrwxrwt | |
> | boot | true | false | 4096 | root | root | rwxr-xr-x | |
> | mavenoutput.txt | false | true | 333790 | root | root | rw-r--r- |
> | RPMS | true | false | 4096 | root | root | rwxr-xr-x | |
> | sys | true | false | 0 | root | root | rwxr-xr-x | |
> ...
> | media | true | false | 4096 | root | root | rwxr-xr-x | |
> | opt | true | false | 4096 | root | root | rwxr-xr-x | |
> +------------+-------------+------------+------------+------------+------------+-------------+-+
> 27 rows selected (0.347 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)