question Re: hive.warehouse.subdir.inherit.perms=false in Archives of Support Questions (Read Only)

hive.warehouse.subdir.inherit.perms=false

balavignesh_nag — Fri, 10 Nov 2017 17:39:56 GMT

Could someone explain about this parameter?

Re: hive.warehouse.subdir.inherit.perms=false

tsharma — Fri, 10 Nov 2017 17:49:36 GMT

It is explained in detail here- https://cwiki.apache.org/confluence/display/Hive/Permission+Inheritance+in+Hive

Re: hive.warehouse.subdir.inherit.perms=false

balavignesh_nag — Fri, 10 Nov 2017 18:03:58 GMT

Thanks. I googled that already. Im looking for some detailed explanation.

Re: hive.warehouse.subdir.inherit.perms=false

james1 — Wed, 20 Dec 2017 04:44:22 GMT

This is a way in lieu of not having Ranger to set the permissions at the HDFS level of a database (and have it carry to all tables and files in that db) or directory (and have it carry to all subdirectories and files in that directory). For example, after setting that parameter, you can do a hadoop fs -chown myuser /apps/hive/warehouse/mydb.db; hadoop fs -chmod 700 /apps/hive/warehouse/mydb.db and now myuser is the only one who can see or do things with that db as hive.warehouse.subdir.inherit.perms=true causes anything created underneath it to inherit the same permissions and ownership as the parent. While this works, Ranger is the way to go though.

Re: hive.warehouse.subdir.inherit.perms=false

balavignesh_nag — Wed, 20 Dec 2017 14:09:30 GMT

Got it ! Thanks @James Dinkel

Re: hive.warehouse.subdir.inherit.perms=false

unblockedmovie — Wed, 26 Sep 2018 00:08:38 GMT

i am interesting too