SQL table locations

You need a little information about the location of your SQL tables in CDP. The location depends on the table type that you can determine by running a query.

Hive metastore properties hive.metastore.warehouse.dir and hive.metastore.warehouse.external.dir set the storage locations for Hive and Impala tables. For example:

  • hive.metastore.warehouse.external.dir = s3a://bucketName/warehouse/tablespace/external/hive
  • hive.metastore.warehouse.dir=s3a://bucketName/warehouse/tablespace/managed/hive

Managed tables reside in the managed tablespace, which only Hive can access. By default, external tables reside in the external tablespace.

To determine the managed or external table type, you can run the DESCRIBE EXTENDED table_name command.