Posts: 25
Registered: ‎09-25-2016

Permissions for file generated by insert query

Environment CDH 5.12

When running INSERT query on the table all files are always owned by user impala i.e. 744, all for impala read for everyone else . We have externally running compaction process which needs to read/write/replace this files. Is there a way to change this default behavior to have the file permission different than 744 ? I'd prefer if it's 764 ( group read/write ) so we can add the user to the same group as Impala who run the compaction process


I tried change Impala Daemon Environment Advanced Configuration Snippet (Safety Valve) property and added



The upstream directory was 774 but files created were still 744. So other users can not write/edit those files.