Re: Creating temp tables in select statements

Thanks everyone for the reply. We are using 2.3.2 :( but good to see this implemented in Hive. It is such a common use case. Edward, will you be having the UDTF source anywhere. On a related note, do we have any Hive UDF library ala Hivemall but for ge

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

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 Sent: Friday, March 29, 2019 9:11 AM To: user@hive.apache.org Subject: External table data and Ranger Security (doAs

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 the