Presto

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

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

In this file, we setup the Hive connector, which is using S3A driver under the hood. This enables Presto to integrate and communicate 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/presto