Should I setup a single global Hive metastore or multiple ones (one for Hive, one for Iceberg, etc.)?

Trino
1

What is usually done?

2

Typically using only one is sufficient. Just make sure it is performant. It needs a good network connection to Trino, solid overall performance, and good backend database performance.