Denys Ordynskiy created DRILL-6869: -------------------------------------- Summary: 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 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* 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}". -- This message was sent by Atlassian JIRA (v7.6.3#76005)