E-MapReduce:Use the CLI to submit a Presto job

Prerequisites

Before you begin, ensure that you have:

• A Presto cluster created on the EMR on ACK page of the EMR console. See Getting Started.

• The AliyunOSSFullAccess and AliyunDLFFullAccess policies attached to your account. See Grant permissions to a role.

• The administrator password configured for your Presto cluster. See Configure the administrator password of a Presto cluster.

Set up the Trino CLI

1. Download trino to a directory on your on-premises machine.

2. Make the binary executable:

   sudo chmod +x trino

Connect to your Presto cluster

1. Log on to the EMR console. In the left-side navigation pane, click EMR on ACK.

2. On the EMR on ACK page, click the name of your cluster.

3. Click the Access Links and Ports tab, then locate the URL for Trino.

4. Replace trino in the URL with trino-cli. For example, if the URL shown is:

   https://trino.c-b95f82c36ee646c5.c1e36180fdf3745c9b7bbc8d3e682****.cn-hangzhou.alicontainer.com

   Use the following as your server URL:

   https://trino-cli.c-b95f82c36ee646c5.c1e36180fdf3745c9b7bbc8d3e682****.cn-hangzhou.alicontainer.com

5. Start the CLI with the modified URL:

   ./trino --server https://trino-cli.c-b95f82c36ee646c5.c1e36180fdf3745c9b7bbc8d3e682****.cn-hangzhou.alicontainer.com --user admin --password --insecure

   Enter the admin user password when prompted.

6. After logging on, run the following command to list available catalogs:

   show catalogs;

   For supported SQL statements, see SQL statement syntax.

   

View Presto job details

1. On the Access Links and Ports tab, click the Trino URL in the Access URL column to open the Trino web UI.

2. Enter the admin user credentials and click Log In. After you log on to Trino, you can view the details of a Presto job.