Re: disable internal tables

2014-01-31 Thread Alex Nastetsky
I figured out a workaround. Instead of making /apps/hive/warehouse permissions 000, make it 222 (only "write" permissions). This satisfies Hive's requirement to be able to write something to that directory when it's creating external tables. (It actually never writes anything there during this proc

Re: disable internal tables

2014-01-30 Thread Alex Nastetsky
Thanks. But if I assign a group of the users to /apps/hive/warehouse then they can still create internal tables, which is what I am trying to prevent. I am on version 0.12.0.2.0.6.0. On Thu, Jan 30, 2014 at 11:55 AM, Peyman Mohajerian wrote: > This is a known issue, it still will write somethin

Re: disable internal tables

2014-01-30 Thread Peyman Mohajerian
This is a known issue, it still will write something at '/apps/hive/warehouse', it's best to assign a common group to your hive and hdfs users and assign that group to both of these directories. I heard this issue is fixed in .12 or .13, others can confirm. On Thu, Jan 30, 2014 at 8:27 AM, Alex N

disable internal tables

2014-01-30 Thread Alex Nastetsky
Hi, I am trying to enforce all Hive tables to be created with EXTERNAL. The way I am doing this is by making the location of the warehouse (/apps/hive/warehouse in my case) to have permissions 000 (completely inaccessible). But then when I try to create an external table, I see that it still trie