You'll need to create Ranger HDFS Policies to allow the specific user access to the external table directory.
Thanks Shawn Weeks -----Original Message----- From: Kristopher Kane <kkane.l...@gmail.com> Sent: Friday, March 29, 2019 9:11 AM To: user@hive.apache.org Subject: External table data and Ranger Security (doAs=false) If using a default external table location, in a cluster with Ranger Authorization, the table location and data are owned by the `hive` user. Since the table is external, there doesn't seem to be a way to delete this data other than impersonating or becoming the `hive` or `hdfs` principal. Is there another way? Kris
