I'm not sure. When you tried it, what did you see?
On Wed, Dec 6, 2017 at 10:49 AM, Sunil Parmar <[email protected]> wrote: > Sure got it! > One more related Impala question. The documentation for insert inherit > permissions says. > > "If true, new directories created by INSERTs will inherit the permissions of > their parent directories" > > Does it also applies to the files ? > > > Sunil Parmar > > On Wed, Dec 6, 2017 at 10:27 AM, Jim Apple <[email protected]> wrote: >> >> That sounds right to me, but we try to keep this list focused on Apache >> Impala and not any proprietary tools around it. You might have more success >> here: >> http://community.cloudera.com/t5/Interactive-Short-cycle-SQL/bd-p/Impala >> >> On Wed, Dec 6, 2017 at 10:13 AM, Sunil Parmar <[email protected]> >> wrote: >>> >>> Thanks !! How to set insert_inherit_permissions from Cloudera manager / >>> which security valve config to use and what to set in the value ? >>> >>> Impala Daemon Environment Advanced Configuration Snippet (Safety Valve) ? >>> >>> Sunil Parmar >>> >>> On Wed, Dec 6, 2017 at 6:50 AM, Petter von Dolwitz (Hem) >>> <[email protected]> wrote: >>>> >>>> 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 >>>>> >>>>> >>>> >>> >> >
