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.
Oh ...I might have missed something. Just wanted to make sure I am not missing anything.
1. Add --insert_inherit_permissions=true for impalad safety valve
2. Set partition directory permission to 764 ( or whatever required ? )
3. Insert into partition directory
4. Check file permission ; it should be same as folder ? 764 ?