Recommended Hive metastore pattern for Trino integration

irispan
New Contributor II

‎08-22-2022 08:14 AM

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

Labels:
Preview file
120 KB
0 Kudos

weldermartins
Honored Contributor

‎08-22-2022 01:49 PM

To insert table you have to create a Dataframe and Schema.

0 Kudos

irispan
New Contributor II
In response to weldermartins

‎08-23-2022 05:56 AM

would you mind showing me how to make the code works?

0 Kudos

Vidula
Databricks Partner

‎09-12-2022 12:12 AM

Hi @iris pan​ 

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. 

We'd love to hear from you.

Thanks!

0 Kudos

JunlinZeng
Databricks Employee
Databricks Employee

‎08-25-2023 01:19 AM

> 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?

Databricks maintained hive metastore is not suggested to be used externally. So I would suggest to use external hive metastore.