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,
