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 <ankitjainc...@gmail.com> wrote:
> Hi all,
>
> I have created database test_db and grant all permission to user 'apache'
> on 'test_db'
> hive>create database test_db
> hive>grant all on database test_db to user apache.
>
> hive>show grant user apache on database test_db;
> OK
> database test
> principalName *apache*
> principalType USER
> privilege All
> grantTime 1319111980
> grantor *abc*
> *
> My current user is 'abc'*
>
> I can't able to create table inside test_db.
>
> I got the following error.
> Authorization failed:No privilege 'Create' found for outputs {
> database:test_db}. Use show grant to get more details.
>
> I have to switch user from 'abc' to 'apache'. Is it possible in hive?
>
> Thanks,
> Ankit
>
>
>
