hive.warehouse.subdir.inherit.perms=false

[#1]

Could someone explain about this parameter?

[#2]

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

[#3]

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

[#4 · Accepted solution]

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.

[#5]

Got it ! Thanks @James Dinkel

[#6]

i am interesting too