[ https://issues.apache.org/jira/browse/DRILL-6869?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arina Ielchiieva updated DRILL-6869: ------------------------------------ Reviewer: Vitalii Diravka > 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)