You can also explore HDFS ACLs to solve this problem. This is something we use to give different user groups different privileges. See https://hadoop.apache.org/docs/r2.6.0/hadoop-project-dist/hadoop-hdfs/HdfsPermissionsGuide.html#ACLs_Shell_Commands
Br, Petter 2017-12-06 1:12 GMT+01:00 Jim Apple <[email protected]>: > I'm not sure. Some things that come to mind: > > Did you try setting a umask for the impala user? > > Did you try setting the parent directory mode bits to 764 and then using > the insert_inherit_permissions flag? > > On Tue, Dec 5, 2017 at 1:27 PM, Sunil Parmar <[email protected]> > wrote: > >> 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. >> >> Sunil Parmar >> > >
