Re: Is there a reason for the Hive remote metastore to execute commands as different users?

ander C.H. Lorenz wrote: > Derby depends on a local filestore, for more flexibility and security I > suggest mysql as a metastore. > - Alex > > On Tue, Nov 29, 2011 at 3:06 AM, Alex Holmes wrote: >> >> Hi, >> >> I'm running Hive 0.7.1 with a remote met

Is there a reason for the Hive remote metastore to execute commands as different users?

Hi, I'm running Hive 0.7.1 with a remote metastore (Derby) on Hadoop 0.20.2. Is there a reason that CREATE and DROP commands when translated into HDFS operations are run as the remote Hive metastore user, but a LOAD is translated into HDFS operations that are executed as the Hive client user? If

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

Re: Hive 0.7.1 authorization woes

how grant? > > (But with remote metastore, i think hive should not return empty list > instead of null for list_privileges etc.) > > > > On Wed, Aug 24, 2011 at 2:34 PM, Alex Holmes wrote: >> Authorization works for me with the local metastore.  The remote >> metastor

Re: Hive 0.7.1 authorization woes

show grant? > > (But with remote metastore, i think hive should not return empty list > instead of null for list_privileges etc.) > > > > On Wed, Aug 24, 2011 at 2:34 PM, Alex Holmes wrote: >> Authorization works for me with the local metastore.  The remote >> met

Re: Hive 0.7.1 authorization woes

does not work with it at all. Thanks, Alex On Wed, Aug 24, 2011 at 5:20 PM, yongqiang he wrote: > 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: >

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 datab

Re: Hive 0.7.1 authorization woes

Tue, Aug 23, 2011 at 1:27 PM, yongqiang he wrote: > 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 wi

Local and remote metastores

Hi everyone, Does anyone know the differences between local and remove Hive metastores? Are there features that are only provided by the remote datastore (like authorization)? Is the use of a local metastore recommended in production? Many thanks, Alex

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