depends on your configuration (metastore). if the user abc exist as a linux
user:
sudo -u apache hive
should work.
- Alex
On Thu, Oct 20, 2011 at 4:21 PM, Ankit Jain wrote:
>
> Thanks for reply,
>
> my problem is still not solve.
>
> u have any idea about, how we can switch user in hive.
>
>
Thanks for reply,
my problem is still not solve.
u have any idea about, how we can switch user in hive.
Thanks,
Ankit
On Thu, Oct 20, 2011 at 7:29 PM, Alexander C.H. Lorenz <
wget.n...@googlemail.com> wrote:
> try to run as user abc:
>
> REVOKE ALL PRIVILEGES, GRANT OPTION
> FROM user [, us
try to run as user abc:
REVOKE ALL PRIVILEGES, GRANT OPTION
FROM user [, user] ...
https://cwiki.apache.org/confluence/display/Hive/AuthDev#AuthDev-4.3grant%2Frevokestatement
- Alex
On Thu, Oct 20, 2011 at 3:45 PM, Ankit Jain wrote:
> Hi Alexander,
>
> Thanks for reply..
>
> I have used
Hi Alexander,
Thanks for reply..
I have used the use test_dn and then run the command create table test (one
string);.
Actual problem is that .. my current user is 'abc' and 'abc' doesn't have
permission over test_db database. I have granted all permission to user
apache.
So, i want to switch
Hi,
did you use the database:
hive> use test_db;
hive> create table test (one string);
OK
Time taken: 0.303 seconds
works for me.
regards,
Alex
On Thu, Oct 20, 2011 at 2:50 PM, Ankit Jain wrote:
> Hi all,
>
> I have created database test_db and grant all permission to user 'apache'
> on 'tes