topic Re: Recommended Hive metastore pattern for Trino integration in Data Engineering

Recommended Hive metastore pattern for Trino integration

irispan — Mon, 22 Aug 2022 15:14:27 GMT

Hi, i have several questions regarding Trino integration:

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

Re: Recommended Hive metastore pattern for Trino integration

weldermartins — Mon, 22 Aug 2022 20:49:04 GMT

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

Re: Recommended Hive metastore pattern for Trino integration

irispan — Tue, 23 Aug 2022 12:56:36 GMT

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

Re: Recommended Hive metastore pattern for Trino integration

Vidula — Mon, 12 Sep 2022 07:12:34 GMT

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!

Re: Recommended Hive metastore pattern for Trino integration

JunlinZeng — Fri, 25 Aug 2023 08:19:30 GMT

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