Hive create table

[#1]

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)

[#2]

@vishal dutt

Please refer to this link which will give all the information.

https://cwiki.apache.org/confluence/display/RANGER/Hive+Commands+to+Ranger+Permission+Mapping

[#3]

I have already given all persmission in Ranger

[#4]

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

[#5]

@vishal dutt

Glad your problem is fixed