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 HDFS in CDP Private Cloud Base). 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 in CDP Private Cloud Base must be
secured using Ranger.