Support Questions

Find answers, ask questions, and share your expertise

hive.warehouse.subdir.inherit.perms=false

avatar

Could someone explain about this parameter?

1 ACCEPTED SOLUTION

avatar
Rising Star

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.


View solution in original post

5 REPLIES 5

avatar
Super Collaborator

avatar

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

avatar
Rising Star

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.


avatar

Got it ! Thanks @James Dinkel

avatar
New Contributor

i am interesting too