[
https://issues.apache.org/jira/browse/DRILL-6869?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bohdan Kazydub updated DRILL-6869:
----------------------------------
Description:
Parameter 'allowAccessOutsideWorkspace' is false for tested workspaces.
On MaprFS and S3 storages Drill allows to create views outside workspace.
*Example on MapRFS:*
create view dfs.tmp.`{color:#d04437}*/*{color}testbugonmfs` as SELECT * FROM
cp.`employee.json` LIMIT 20;
|ok|summary|
|true|View '/testbugonmfs' *created successfully in 'dfs.tmp' schema*|
1 row selected (0.93 seconds)
The file "testbugonmfs.view.drill" was *created* in the *root "/" folder,* but
not in used workspace "/tmp" folder.
Select query works with root "/" folder {color:#d04437}*outside*{color} the
dfs.tmp workspace:
select count * from dfs.tmp.`{color:#d04437}*/*{color}testbugonmfs`;
|EXPR$0|
|20|
1 row selected (1.813 seconds)
*Example on S3*:
create view s3.tmp.`{color:#d04437}*/*{color}testbugons3` as SELECT * FROM
cp.`employee.json` LIMIT 20;
|ok|summary|
|true|View '/testbugons3' *created successfully in 's3.tmp' schema*|
1 row selected (3.455 seconds)
The file "testbugons3.view.drill" was *created* in the *root "/" bucket
folder*, but not in used workspace "/tmp" folder.
Select query also works with root "/" bucket folder
{color:#d04437}*outside*{color} the s3.tmp workspace:
select count * from s3.tmp.`/testbugons3`;
|EXPR$0|
|20|
1 row selected (3.209 seconds)
*Expected result:*
View should be created within workspace
On FileSystem storage plugin Drill doesn't allow to create views outside
workspace.
Query "create view dfs.tmp.`/testbugonfs` as SELECT * FROM cp.`employee.json`
LIMIT 20;"
Returns an error: "{color:#d04437}Error: SYSTEM ERROR: FileNotFoundException:
/testbugonfs.view.drill (Permission denied){color}".
was:
Parameter 'allowAccessOutsideWorkspace' is false for tested workspaces.
On MaprFS and S3 storages Drill allows to create views outside workspace.
*Example on MapRFS:*
create view dfs.tmp.`{color:#d04437}*/*{color}testbugonmfs` as SELECT * FROM
cp.`employee.json` LIMIT 20;
|ok|summary|
|true|View '/testbugonmfs' *created successfully in 'dfs.tmp' schema*|
1 row selected (0.93 seconds)
The file "testbugonmfs.view.drill" was *created* in the *root "/" folder,* but
not in used workspace "/tmp" folder.
Select query works with root "/" folder {color:#d04437}*outside*{color} the
dfs.tmp workspace:
select count * from dfs.tmp.`{color:#d04437}*/*{color}testbugonmfs`;
|EXPR$0|
|20|
1 row selected (1.813 seconds)
*Example on S3*:
create view s3.tmp.`{color:#d04437}*/*{color}testbugons3` as SELECT * FROM
cp.`employee.json` LIMIT 20;
|ok|summary|
|true|View '/testbugons3' *created successfully in 's3.tmp' schema*|
1 row selected (3.455 seconds)
The file "testbugons3.view.drill" was *created* in the *root "/" bucket
folder*, but not in used workspace "/tmp" folder.
Select query also works with root "/" bucket folder
{color:#d04437}*outside*{color} the s3.tmp workspace:
select count * from s3.tmp.`/testbugons3`;
|EXPR$0|
|20|
1 row selected (3.209 seconds)
*Expected result:* should be like on FileSystem storage:
On FileSystem storage plugin Drill doesn't allow to create views outside
workspace.
Query "create view dfs.tmp.`/testbugonfs` as SELECT * FROM cp.`employee.json`
LIMIT 20;"
Returns an error: "{color:#d04437}Error: SYSTEM ERROR: FileNotFoundException:
/testbugonfs.view.drill (Permission denied){color}".
> Drill allows to create views outside workspace
> ----------------------------------------------
>
> Key: DRILL-6869
> URL: https://issues.apache.org/jira/browse/DRILL-6869
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.15.0
> Reporter: Denys Ordynskiy
> Assignee: Bohdan Kazydub
> Priority: Minor
> Fix For: 1.16.0
>
> Attachments: Amazon_S3_FS_stor_plugin.json,
> FileSystem_stor_plugin.json, MapR_FS_stor_plugin.json
>
>
> Parameter 'allowAccessOutsideWorkspace' is false for tested workspaces.
> On MaprFS and S3 storages Drill allows to create views outside workspace.
> *Example on MapRFS:*
> create view dfs.tmp.`{color:#d04437}*/*{color}testbugonmfs` as SELECT * FROM
> cp.`employee.json` LIMIT 20;
> |ok|summary|
> |true|View '/testbugonmfs' *created successfully in 'dfs.tmp' schema*|
> 1 row selected (0.93 seconds)
> The file "testbugonmfs.view.drill" was *created* in the *root "/" folder,*
> but not in used workspace "/tmp" folder.
> Select query works with root "/" folder {color:#d04437}*outside*{color} the
> dfs.tmp workspace:
> select count * from dfs.tmp.`{color:#d04437}*/*{color}testbugonmfs`;
> |EXPR$0|
> |20|
> 1 row selected (1.813 seconds)
>
> *Example on S3*:
> create view s3.tmp.`{color:#d04437}*/*{color}testbugons3` as SELECT * FROM
> cp.`employee.json` LIMIT 20;
> |ok|summary|
> |true|View '/testbugons3' *created successfully in 's3.tmp' schema*|
> 1 row selected (3.455 seconds)
>
> The file "testbugons3.view.drill" was *created* in the *root "/" bucket
> folder*, but not in used workspace "/tmp" folder.
> Select query also works with root "/" bucket folder
> {color:#d04437}*outside*{color} the s3.tmp workspace:
> select count * from s3.tmp.`/testbugons3`;
> |EXPR$0|
> |20|
> 1 row selected (3.209 seconds)
>
> *Expected result:*
> View should be created within workspace
> On FileSystem storage plugin Drill doesn't allow to create views outside
> workspace.
> Query "create view dfs.tmp.`/testbugonfs` as SELECT * FROM
> cp.`employee.json` LIMIT 20;"
> Returns an error: "{color:#d04437}Error: SYSTEM ERROR:
> FileNotFoundException: /testbugonfs.view.drill (Permission denied){color}".
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
