search

trinodb / trino

Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
https://trino.io
Apache License 2.0
10.49k stars 3.02k forks source link

How to use trino connect a prestodb? #10407

Open heroygt opened 2 years ago

heroygt commented 2 years ago

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 commented 2 years ago

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 commented 2 years ago

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

heroygt commented 2 years ago

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 commented 2 years ago

@heroygt https://github.com/trinodb/trino/pull/3105#issuecomment-763214441