Re: Multiuser setup on Hive

2012-11-22 Thread Austin Chungath
t;>>> >>>>> ** >>>>> 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 >>>>> permissi

Re: Multiuser setup on Hive

2012-11-22 Thread Dean Wampler
gt; >>>> ** >>>> 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

Re: Multiuser setup on Hive

2012-11-22 Thread Austin Chungath
Typo, I meant "user2 logs into hive and he is able to see and delete database data1" On Thu, Nov 22, 2012 at 12:16 PM, Austin Chungath wrote: > 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 s

Re: Multiuser setup on Hive

2012-11-22 Thread Alexander Alten-Lorenz
That means a separate metastore per User / different port. Please have in mind, anyone should maintain this. On top, the user has to choose the right JDBC connection. I have my doubt on such a installation ;) cheers, Alex On Nov 22, 2012, at 10:48 AM, Austin Chungath wrote: > Thanks Alex, >

Re: Multiuser setup on Hive

2012-11-22 Thread Austin Chungath
Thanks Alex, But unfortunately I don't have kerberos implementation right now to try it out. I was wondering if we can create multiple metastore dbs in mysql and then for each user group make separate hive-site.xml which has the username and jdbc connection details. Do I make any sense? is somethin

Re: Multiuser setup on Hive

2012-11-22 Thread Alexander Alten-Lorenz
You could use SASL / kerberos implementation within HiveServer2. Depends on a kerberosized cluster, too. Hive's metastore server provides the same mechanism, but isn't fully multi connect ready. Here's a link: http://ben-tech.blogspot.de/2012/10/hive-server-2-in-cdh41.html - Alex On Nov 22, 201

Re: Multiuser setup on Hive

2012-11-22 Thread Austin Chungath
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

Re: Multiuser setup on Hive

2012-11-21 Thread Shreepadma Venugopalan
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 >> *Date: *Thu, 22 Nov 201

Re: Multiuser setup on Hive

2012-11-21 Thread Austin Chungath
a information now. > Regards > Bejoy KS > > Sent from handheld, please excuse typos. > -- > *From: * Austin Chungath > *Date: *Thu, 22 Nov 2012 12:16:24 +0530 > *To: *; > *ReplyTo: * user@hive.apache.org > *Subject: *Multiuser setup on

Re: Multiuser setup on Hive

2012-11-21 Thread Bejoy KS
typos. -Original Message- From: Austin Chungath Date: Thu, 22 Nov 2012 12:16:24 To: ; Reply-To: 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 sce

Multiuser setup on Hive

2012-11-21 Thread Austin Chungath
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