Hive table locations
You need a little information about the location of your Hive tables in CDP Public Cloud, which you can control. The location depends on the table type that you can determine by running a Hive query.
hive.metastore.warehouse.external.dir set the storage locations for Hive
tables. For example:
hive.metastore.warehouse.external.dir = s3a://bucketName/warehouse/tablespace/external/hive
hive.metastore.warehouse.external.dir that determine storage locations for Hive
tables. Managed tables reside in the managed tablespace, which only Hive can access. By default,
Hive assumes external tables reside in the external tablespace.
To determine the managed or external table type, you can run the DESCRIBE EXTENDED table_name command.