External table access

As administrator, you must set up 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.