Recommended Hive metastore pattern for Trino integration

irispan
New Contributor II

Hi, i have several questions regarding Trino integration:

  1. Is it recommended to use an external Hive metastore or leverage on the databricks-maintained Hive metastore when it comes to enabling external query engines such as Trino?
  2. When I tried to use external hive metastore, I have completed the steps here: https://docs.databricks.com/data/metastores/external-hive-metastore.html. However, when I tried to create a delta table, I see the following error (file:/user/hive/warehouse/myTable is not a directory or unable to create one). I would like to understand how to solve the issue.

test - Databricks