I am doing a PoC with MinIO, Hive Metastore, and Trino on Docker compose using latest versions of all official images. I can share my /opt/hive/metastore-site.xml and /etc/trino/catalog/hive.properties if needed.

I have set the MinIO bucket accesss to public read/write and I have set the admin tokens of MinIO in both of HMS and Trino.

I am stuck for a week now on this error and I have tried many possibilities, but nothing works.

In /opt/hive/metastore-site.xml

<property>
    <name>hive.security.metastore.authorization.manager</name>
    <value>org.apache.hadoop.hive.ql.security.authorization.StorageBasedAuthorizationProvider</value>
</property>

Logs:

2024-04-27 01:20:50 2024-04-26T23:20:50.760Z    INFO    dispatcher-query-5      io.trino.event.QueryMonitor     TIMELINE: Query 20240426_232050_00000_hjrys :: FAILED (HIVE_METASTORE_ERROR) :: elapsed 294ms :: planning 0ms :: waiting 1ms :: scheduling 294ms :: running 0ms :: finishing 294ms :: begin 2024-04-26T23:20:50.463Z :: end 2024-04-26T23:20:50.757Z

CLI

[trino@da599e9df13c /]$ trino --catalog hive
trino> create schema utm;
Query 20240426_232050_00000_hjrys failed: Failed to create external path s3a://utm/utm.db for database utm. This may result in access not being allowed if the StorageBasedAuthorizationProvider is enabled: null