Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

hive.warehouse.subdir.inherit.perms=false

Solved Go to solution
Highlighted

hive.warehouse.subdir.inherit.perms=false

Could someone explain about this parameter?

1 ACCEPTED SOLUTION

Accepted Solutions

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

New Contributor

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.


6 REPLIES 6

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

Expert Contributor

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

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

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

New Contributor

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

Got it ! Thanks @James Dinkel

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

New Contributor

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).

run 3, five nights at freddy's

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

New Contributor

i am interesting too