How to use trino connect a prestodb?

[heroygt]

Hi there,

Because I need to join several tables among multiple datasources, I setup a trino server to connect them. Since one of the datasources is hive which is behind of a presto server, I try to configure a connector for that presto server, but I cannot find the right connector type. Please help~

[martint]

You should’ve able to connect Trino directly to the Hive data source instead of going through a separate prestodb cluster. Would that be an option?

[heroygt]

Presto is a published datesource. As a downstream user, I'm not able to connect hive directly without authorization.

[heroygt]

You should’ve able to connect Trino directly to the Hive data source instead of going through a separate prestodb cluster. Would that be an option?

Also, I don't have resources to run a new cluster as powerful as existed presto cluster

[tooptoop4]

@heroygt #3105 (comment)