User xxx does not have privileges for CREATETABLE [How to Solve]

Kerbors authenticated users cannot create external tables on the hive command line

......

> )
> STORED AS PARQUET
> LOCATION '/cdp/hbase/user'
> TBLPROPERTIES('parquet.compression'='SNAPPY');
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:User cdh_admin does not have privileges for CREATETABLE)

Solution:

From: https://community.cloudera.com/t5/Support-Questions/quot-User-does-not-have-privileges-for-CREATETABLE-quot/td-p/21044

 DeenarT

Explorer

Created ‎11-06-2015 08:21 AM

Hi

I had the same problem. I found out that the table creation succeeds if one specifies the fully qualified hdfs location.

create external table test (a string); // works

create external table test_ext (a string) LOCATION ‘/warehouse/projects/mypath/public’; fails

create external table test_ext (a string) LOCATION ‘hdfs://nameservice1/warehouse/projects/mypath/public’; works fine

Hope this works for you too.

Deenar

that is, before the path plus hdfs://nameservice1 prefix

Similar Posts: