Trino Managed CNode Applications

Prev Next

Configuration Settings for Trino Apps

The configuration.yaml file for Trino should include this section with details for connecting to a VAST Database:

  vast: 'connector.name: vast
    endpoint: ENDPOINT
    access_key_id: VAST_ACCESS_KEY
    secret_access_key: VAST_SECRET_KEY
    data_endpoints: DATA_ENDPOINTS
    vast.http-client.request-timeout: 100h
    vast.http-client.idle-timeout: 290s
    num_of_splits: 512
    num_of_subsplits: 4
    '

where VAST_ACCESS_KEY and VAST_SECRET_KEY are the access and secret keys for a VMS  user with permissions to create and access VAST Databases (see Pre-requisites), and ENDPOINT and DATA_ENDPOINTS are the Coordinator VIP.

Downloading and Configuring the Trino Client

  • Run this command to download the Trino client jar

    wget https://repo1.maven.org/maven2/io/trino/trino-cli/<version>/trino-cli-<version>-executable.jar -O trino chmod +x trino

    where <version> is the Trino version of the client (for example, 429).

Using the Trino Client to Connect to the Trino Managed App

Run this command on the client to connect to the Trino app:

./trino --server <VIP>:8080 --catalog vast --schema <schema> --user <username> 

where VIP is the Coordinator VIP, schema is your schema in the VAST database, and username is the VMS user created for Trino.