# 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:

```python
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>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.ultihash.io/operations/prebuilt-connections/presto.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.