You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Kristopher Kane <kk...@gmail.com> on 2019/03/29 14:11:22 UTC

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

RE: External table data and Ranger Security (doAs=false)

Posted by Shawn Weeks <sw...@weeksconsulting.us>.

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 <kk...@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