You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Ronak Bhatt <ro...@gmail.com> on 2012/02/03 07:08:06 UTC

Can you help with this error ...No privilege 'Create' found for outputs {.....

hive> create table t1(t1 string);

Authorization failed:No privilege 'Create' found for outputs {
database:test1}. Use show grant to get more details.

hive>



*
*

Re: Can you help with this error ...No privilege 'Create' found for outputs {.....

Posted by Able C <ca...@gmail.com>.

hi
do you enable authorization ?
hive> set hive.security.authorization.enabled;   -- is this " true"?

you can
hive> set  hive.security.authorization.enabled = false;

or
hive> grant create to your_username on table t1;


2012/2/3 Ronak Bhatt <ro...@gmail.com>

> hive> create table t1(t1 string);
>
> Authorization failed:No privilege 'Create' found for outputs {
> database:test1}. Use show grant to get more details.
>
> hive>
>
>
>
> *
> *
>
>


-- 
Best wishs！
曹 坤

Re: Can you help with this error ...No privilege 'Create' found for outputs {.....

Posted by Ankit Jain <an...@gmail.com>.

Hi,

set hive.security.authorization.enabled property false in hive-default.xml

Thanks,
Ankit

On Fri, Feb 3, 2012 at 11:38 AM, Ronak Bhatt <ro...@gmail.com> wrote:

> hive> create table t1(t1 string);
>
> Authorization failed:No privilege 'Create' found for outputs {
> database:test1}. Use show grant to get more details.
>
> hive>
>
>
>
> *
> *
>
>