Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive create table

Hive create table

New Contributor

I am trying to create an external table hive , i get below error.I have defined the policy in ranger. Hive policy i have given all permissions to the user for the database(all tables & all columns).

I am conecting to hive using beeline

Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [hdp_ingest] does not have [ALL] privilege on [hdfs://hdpmaster1.m.com:8020/datalake/first/landing/tbltest] (state=42000,code=40000)

4 REPLIES 4

Re: Hive create table

Re: Hive create table

New Contributor

I have already given all persmission in Ranger

Highlighted

Re: Hive create table

New Contributor

This is resolved. Because hive is not configured with impersonation, table creation uses hive user to create tables and landing directories in HDFS. added hive in Ranger policy

Re: Hive create table

@vishal dutt

Glad your problem is fixed