[DRILL-5391] CTAS: make folder and file permission configurable

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.9.0, 1.10.0
• Fix Version/s: 1.11.0
• Labels: doc-impacting ready-to-commit

Environment

CentOS 7, HDP 2.4

• Assignee: Arina Ielchiieva
• Reporter: Chua Tianxiang
• Reviewer: Paul Rogers
• Created: 28/Mar/17 08:45
• Updated: 01/May/17 17:24
• Resolved: 01/May/17 17:24

Description

In Drill 1.9, CREATE TABLE AS creates a folder with permissions 777, while on Drill 1.10, the same commands creates a folder with permission 775. Both drills are started with root user, installed on the same servers and accesses the same HDFS.

Scope:
Added new configuration option exec.persistent_table.umask which default to 002.
Default directory permission will be 775, file - 664.
User can modify this option on session or system level.
If umask was set incorrectly, default umask will be used (002) and error will be logged.

For example, if user wants to create table will full access to folders and files, he needs to update umask:
alter session set `exec.persistent_table.umask` = '000';
In this case folders will be created with 777 permission, files with 666.

Issue Links

• links to: GitHub Pull Request #820