hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dean Wampler <dean.wamp...@thinkbiganalytics.com>
Subject Re: Multiuser setup on Hive
Date Thu, 22 Nov 2012 14:14:20 GMT
If you go the route of locking down permissions at the HDFS level, then it
will help if everyone works in his or her own database, since all the
tables will be rooted at a directory for each db.

dean

On Thu, Nov 22, 2012 at 2:26 AM, Austin Chungath <austincv@gmail.com> wrote:

> Shreepadam,
> So what do you recommend for this? What are the current best practices for
> deploying hive in a multi-user environment?
>
> Thanks,
> Austin
>
> On Thu, Nov 22, 2012 at 1:10 PM, Shreepadma Venugopalan <
> shreepadma@cloudera.com> wrote:
>
>> Hi Austin,
>>
>> Hive authorization in its current form has a number of bugs and it is not
>> recommended that you use it. We are planning to work on supporting
>> authorization in a subsequent version of Hive.
>>
>> Thanks.
>> Shreepadma
>>
>>
>> On Wed, Nov 21, 2012 at 11:12 PM, Austin Chungath <austincv@gmail.com>wrote:
>>
>>> Hi Bejoy,
>>>
>>> Thanks for the quick reply.
>>> I had been reading through hive authorization
>>> https://cwiki.apache.org/Hive/languagemanual-auth.html
>>>
>>> Is it any good. Can anyone explain what happens if I enable this?
>>> Will I be able to prevent users from deleting other user's tables?
>>>
>>>
>>> Regards,
>>> Austin
>>>
>>>
>>>
>>> On Thu, Nov 22, 2012 at 12:20 PM, Bejoy KS <bejoy_ks@yahoo.com> wrote:
>>>
>>>> **
>>>> Hi Austin
>>>>
>>>> In hive currently you can have permissions only on the hdfs layer not
>>>> on the metastore. The current hive metastore don't have multiuser
>>>> permission support. Any user will be able to drop the metadata information
>>>> now.
>>>> Regards
>>>> Bejoy KS
>>>>
>>>> Sent from handheld, please excuse typos.
>>>> ------------------------------
>>>> *From: * Austin Chungath <austincv@gmail.com>
>>>> *Date: *Thu, 22 Nov 2012 12:16:24 +0530
>>>> *To: *<user@hive.apache.org>; <user@hadoop.apache.org>
>>>> *ReplyTo: * user@hive.apache.org
>>>> *Subject: *Multiuser setup on Hive
>>>>
>>>> Hi,
>>>>
>>>> I had been trying to set up a multi user environment for hive.
>>>> I have set up the hive metastore db in MySQL and hive works.
>>>>
>>>> Consider this scenario:
>>>>
>>>> user1 has created a database data1
>>>> user2 has created a database data2
>>>>
>>>> Now user2 logs into hive and he is able to see and delete database data2
>>>>
>>>> How do I prevent this?
>>>>
>>>> Regards,
>>>> Austin
>>>>
>>>>
>>>>
>>>
>>>
>>
>


-- 
*Dean Wampler, Ph.D.*
thinkbiganalytics.com
+1-312-339-1330

Mime
View raw message