External table access
As administrator, you must set up Apache Ranger to allow users to access external tables.
External tables reside by default in /warehouse/tablespace/external on your object store. To specify some other location of the external table, you need to include the specification in the table creation statement as shown in the following example:
CREATE EXTERNAL TABLE my_external_table (a string, b string) LOCATION '/users/andrena';
Hive assigns a default permission of 777 to the
hive user, sets a umask to
restrict subdirectories, and provides a default ACL to give Hive read and write access to all
subdirectories. External tables must be secured using Ranger.