You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Jack Yang <ji...@uow.edu.au> on 2015/07/07 07:50:35 UTC

multiple users for hive access

Hi all,

I would like to have multiple users to access hive.
Does anyone try that before?
Is there any tutorial or link I can study from?

Best regards,
Jack


Re: multiple users for hive access

Posted by Jeff Zhang <zj...@gmail.com>.
Have you tried to start hive cli using these 2 users ? What issue did you
see ?

On Wed, Jul 8, 2015 at 11:50 AM, Jack Yang <ji...@uow.edu.au> wrote:

> Thanks, mate. I have mysql run as my metadata store.
>
>
>
> What is the next step?  when I start hive (0.13 version), I just type in
> hive in my command line.
>
>
>
> Now, that is say I have two users: A and B. I would like A and B access
> hive tables using hive-cli.
>
>
>
> How can I do that?
>
>
>
>
>
> *From:* Jeff Zhang [mailto:zjffdu@gmail.com]
> *Sent:* Tuesday, 7 July 2015 4:22 PM
> *To:* user@hive.apache.org
> *Subject:* Re: multiple users for hive access
>
>
>
> Hive support multiple user scenario as long as the metadata store support
> multiple user access. By default hive use derby embedded mode which don't
> support multiple user access. You can configure it to server mode or use
> other metadata store like mysql etc.  Here's the tutorial for how to
> configure derby server mode
>
>
>
> https://cwiki.apache.org/confluence/display/Hive/HiveDerbyServerMode
>
>
>
>
>
>
>
> On Tue, Jul 7, 2015 at 1:50 PM, Jack Yang <ji...@uow.edu.au> wrote:
>
> Hi all,
>
>
>
> I would like to have multiple users to access hive.
>
> Does anyone try that before?
>
> Is there any tutorial or link I can study from?
>
>
>
> Best regards,
>
> Jack
>
>
>
>
>
>
>
> --
>
> Best Regards
>
> Jeff Zhang
>



-- 
Best Regards

Jeff Zhang

RE: multiple users for hive access

Posted by Jack Yang <ji...@uow.edu.au>.
Thanks, mate. I have mysql run as my metadata store.

What is the next step?  when I start hive (0.13 version), I just type in hive in my command line.

Now, that is say I have two users: A and B. I would like A and B access hive tables using hive-cli.

How can I do that?


From: Jeff Zhang [mailto:zjffdu@gmail.com]
Sent: Tuesday, 7 July 2015 4:22 PM
To: user@hive.apache.org
Subject: Re: multiple users for hive access

Hive support multiple user scenario as long as the metadata store support multiple user access. By default hive use derby embedded mode which don't support multiple user access. You can configure it to server mode or use other metadata store like mysql etc.  Here's the tutorial for how to configure derby server mode

https://cwiki.apache.org/confluence/display/Hive/HiveDerbyServerMode



On Tue, Jul 7, 2015 at 1:50 PM, Jack Yang <ji...@uow.edu.au>> wrote:
Hi all,

I would like to have multiple users to access hive.
Does anyone try that before?
Is there any tutorial or link I can study from?

Best regards,
Jack




--
Best Regards

Jeff Zhang

Re: multiple users for hive access

Posted by Jeff Zhang <zj...@gmail.com>.
Hive support multiple user scenario as long as the metadata store support
multiple user access. By default hive use derby embedded mode which don't
support multiple user access. You can configure it to server mode or use
other metadata store like mysql etc.  Here's the tutorial for how to
configure derby server mode

https://cwiki.apache.org/confluence/display/Hive/HiveDerbyServerMode



On Tue, Jul 7, 2015 at 1:50 PM, Jack Yang <ji...@uow.edu.au> wrote:

> Hi all,
>
>
>
> I would like to have multiple users to access hive.
>
> Does anyone try that before?
>
> Is there any tutorial or link I can study from?
>
>
>
> Best regards,
>
> Jack
>
>
>



-- 
Best Regards

Jeff Zhang