[DRILL-6869] Drill allows to create views outside workspace

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.15.0
• Fix Version/s: 1.16.0
• Assignee: Bohdan Kazydub
• Reporter: Denys Ordynskiy
• Reviewer: Vitalii Diravka
• Created: 23/Nov/18 13:41
• Updated: 08/Jul/19 16:29
• Resolved: 30/Nov/18 08:56

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.`/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 outside the dfs.tmp workspace:
select count * from dfs.tmp.`/testbugonmfs`;

EXPR$0

20

1 row selected (1.813 seconds)

 

Example on S3:

create view s3.tmp.`/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 outside 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: "Error: SYSTEM ERROR: FileNotFoundException: /testbugonfs.view.drill (Permission denied)".

Issue Links

• is related to: DRILL-6863 Drop table is not working if path within workspace starts with '/'
• links to: DRILL-6863