6.6. Querying Presto

The Presto Coordinator pod is reachable via the Kubernetes Service. By default, the service is only available within the Kubernetes Cluster at http://presto-coordinator-service-CLUSTER_NAME_UUID.NAMESPACE.svc.cluster.local:8080, where NAMESPACE is the Kubernetes namespace where the given Presto cluster is deployed and CLUSTER_NAME_UUID is the unique service name.

You can adjust the endpoint name using service.name parameter. Please refer to Service properties for more information.

CLI

1. Launch Presto CLI pod in interactive mode

In your console, type the following command to launch Presto CLI pod. Your cursor will skip to the next line, prefixed with a Presto prompt: presto >.

kubectl run presto-cli --rm -i --tty --image IMAGE_REPOSITORY/starburstdata/presto -- presto-cli \
 --server http://presto-coordinator-service-CLUSTER_NAME_UUID.NAMESPACE.svc.cluster.local:8080

where IMAGE_REPOSITORY is your Docker registry address (if present).

2. Show Catalogs and Schemas

View your catalogs and schemas by running the following commands. Note: replace tpch with your desired catalog.

show catalogs;
show schemas in tpch;
3. Write a Query

Type your SQL query into the Presto CLI. For reference, view the SQL SELECT statement below.

select * from tpch.sf1.nation;
4. Run Query

Press <Enter> to execute your query. Query progress is displayed live in the Presto CLI console.

5. View Query Results

When Presto finishes processing the query, you will be presented with the results of your query within the Presto CLI console.

ODBC & JDBC Drivers

The open source Presto JDBC driver can be used with Presto on AWS. It can be downloaded from Starburst’s download page. Additionally, Starburst provides Enterprise ODBC and JDBC drivers, available for Windows, Mac, and Linux platforms for its Enterprise customers. Please refer to the following link for both.