Trino

How to connect UltiHash to Trino

In order to grant Trino access to UltiHash, users need to create and configure a catalogue called UltiHash, with the ultihash.properties text file as follows:

connector.name=hive
hive.metastore.uri=thrift://hive-metastore:9083
hive.non-managed-table-writes-enabled=true
hive.s3.path-style-access=true
hive.s3.endpoint=https://ultihash
hive.s3.aws-access-key=mocked
hive.s3.aws-secret-key=mocked

In this file, we setup the Hive connector, which is using S3A connector under the hood. This enables Trino to integrate and communicated with UltiHash.

Each catalogue points at a UltiHash Cluster, and within a catalogue the user can create SQL tables which point at specific buckets in the UltiHash Cluster. Each catalogue can host several SQL tables.

See all information about the integration on GitHub here: https://github.com/UltiHash/scripts/tree/main/trino