There is an implicit check done by HiveServer2 to make sure the user has access to the external files. You are correct, at the HDFS level, each file permission is individually checked.
What sort of error are you getting in hive log file? And is there any error on the HDFS side? Thanks Bosco From: Margus Roo <mar...@roo.ee> Reply-To: <user@ranger.incubator.apache.org> Date: Monday, May 16, 2016 at 7:36 AM To: <user@ranger.incubator.apache.org> Subject: Can not create hive2 external table Hi In case I try to create external table and I have in example 100 000 files in locations I point in hive DDL and Ranger authorization is enabled then I will get different errors in hive log. Mainly they are GC timeouts. In hdfs namenode log I can see loads of authorization rows. I think ranger is doing check for every single file ?! In case I disable ranger authorization for hive then it creates external table. So - am I doing something wrong? -- Margus (margusja) Roo http://margus.roo.ee skype: margusja +372 51 48 780