Julien Have you checked the Ranger Audit logs to see whether the block came from Ranger?
Also, are you using Ranger on both HDFS and Hive side? Thanks Bosco From: Julien Carme <[email protected]> Reply-To: <[email protected]> Date: Friday, January 8, 2016 at 10:20 AM To: <[email protected]> Subject: Cannot create Hive external table Hello, I have just updated HDP from 2.2 to 2.3, so I am now using Ranger 0.5.0 and Hive 1.2.1 I try to create an external table using insert overwrite directory '/tmp/test' select * from my_table; Previously it was working fine. But now I always get: Error occurred executing hive query: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [my_login] does not have [WRITE] privilege on [/tmp/test] I tried not creating /tmp/test, I tried creating /tmp/test with 777 mod, I tried giving any permission I can with Ranger HDFS and Hive right managers, I tried doAs=T and doAs=F, whatever I do I always get this error message. There is just now no way for me to create external tables. Any help would be greatly appreciated. Best Regards,
