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)
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