Re: Hive 0.7.1 authorization woes

HDFS, the Hive metastore and the hive client are all running as "hduser". On Thu, Aug 25, 2011 at 8:22 PM, yongqiang he wrote: > what is your unix name on that machine? can u do a whoami? > > On Thu, Aug 25, 2011 at 5:15 PM, Alex Holmes wrote: >> Here's the hive-site.xml file (I use the same fil

Re: Hive 0.7.1 authorization woes

what is your unix name on that machine? can u do a whoami? On Thu, Aug 25, 2011 at 5:15 PM, Alex Holmes wrote: > Here's the hive-site.xml file (I use the same file for both the client > and remote metastore).  We're using mysql as the metastore DB. > > > > > > >  hive.security.authorization.e

Re: Hive 0.7.1 authorization woes

Here's the hive-site.xml file (I use the same file for both the client and remote metastore). We're using mysql as the metastore DB. hive.security.authorization.enabled true hive.metastore.local false hive.metastore.uris thrift://localhost:9083 javax.jdo.option.Connection

Re: Hive 0.7.1 authorization woes

Hi, hive> CREATE TABLE pokes2 (foo INT, bar STRING); OK hive> LOAD DATA LOCAL INPATH '/app/hadoop/hive1.in' OVERWRITE INTO TABLE pokes2; OK hive> grant select on table pokes2 to user hduser; OK hive> set hive.security.authorization.enabled=true; hive> show grant user hduser on table pokes2; OK da

Re: Hive 0.7.1 authorization woes

this is what i have tried with a remote metastore: > set hive.security.authorization.enabled=false; hive> > > > drop table src2; OK Time taken: 1.002 seconds hive> create table src2 (key int, value string); OK Time taken: 0.03 seconds hive> > > > set hive.security.autho

Re: Hive 0.7.1 authorization woes

Authorization works for me with the local metastore. The remote metastore works with authorization turned off, but as soon as I turn it on and issue any commands I get these exceptions on the hive client. Could you also try the remote metastore please? I'm pretty sure that authorization does not

Re: Hive 0.7.1 authorization woes

I am using local metastore, and can not reproduce the problem. what message did you get when running local metastore? On Wed, Aug 24, 2011 at 1:58 PM, Alex Holmes wrote: > Thanks for opening a ticket. > > Table-level grants aren't working for me either (HIVE-2405 suggests > that the bug is only

Re: Hive 0.7.1 authorization woes

Thanks for opening a ticket. Table-level grants aren't working for me either (HIVE-2405 suggests that the bug is only related to global grants). hive> set hive.security.authorization.enabled=false; hive> CREATE TABLE pokes (foo INT, bar STRING); OK Time taken: 1.245 seconds hive> LOAD DATA LOCAL

Re: Hive 0.7.1 authorization woes

This is a bug. Will open a jira to fix this. and will backport it to 0.7.1. https://issues.apache.org/jira/browse/HIVE-2405 thanks for reporting this one! On Wed, Aug 24, 2011 at 6:25 AM, Alex Holmes wrote: > I created the mysql database (with the simple create database command) > and the remote

Re: Hive 0.7.1 authorization woes

I created the mysql database (with the simple create database command) and the remote metastore seemed to creat the mysql tables. Here's some grant information and what I see in the database: [hduser@aholmes-desktop conf]$ hive hive> grant all to user hduser; OK Time taken: 0.334 seconds hive> sh

Re: Hive 0.7.1 authorization woes

Have you created the metastore mysql tables for authorization? Can u do a show grant? thanks yongqiang On Tue, Aug 16, 2011 at 2:55 PM, Alex Holmes wrote: > Hi all, > > I've been struggling with getting Hive authorization to work for a few > hours, and I really hope someone can help me.  I instal

Hive 0.7.1 authorization woes

Hi all, I've been struggling with getting Hive authorization to work for a few hours, and I really hope someone can help me. I installed Hive 0.7.1 on top of Hadoop 0.20.203. I'm using mysql for the metastore, and configured Hive to enable authorization: hive.security.authorization.enabled