cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

4 REPLIES 4

weldermartins
Honored Contributor

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

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

Vidula
Honored Contributor

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!

JunlinZeng
New Contributor II

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

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group