Querying Trino Through Trino Gateway

#!/usr/bin/env bash

ORIG="$PATH"

export PATH="/opt/jdk-23/bin:$PATH"

# This assumes that trino-cli has been downloaded into this directory

# and been renamed "trino". 

chmod +x ./trino

if [ "$1" = "gateway" ]; then

        ./trino \

                --server 'https://<TRINO_GATEWAY_HOST>:9104' \

                --krb5-remote-service-name "HTTP" \

                --krb5-principal "your_principal" \

                --krb5-config-path /etc/krb5.conf \

                --krb5-keytab-path /your/keytab/goes/here.keytab \

                --krb5-service-principal-pattern '${SERVICE}@<COORDINATOR_HOST>' \

                --catalog <catalog_name> \

                --schema <schema_name>

else

        ./trino \

                --server 'https://<TRINO_COORDINATOR_HOST>:9098' \

                --krb5-remote-service-name "HTTP" \

                --krb5-principal "your_principal" \

                --krb5-config-path /etc/krb5.conf \

                --krb5-keytab-path /your/keytab/goes/here.keytab \

                --catalog <catalog_name> \

                --schema <schema_name>

fi

export PATH="$ORIG"

--krb5-service-principal-pattern '${SERVICE}@<COORDINATOR_HOST>'

${SERVICE}@${HOST}