Oracle Cloud Infrastructure Documentation

Accessing Trino from CLI

You can access Trino from the CLI for both HA and non-HA clusters.

Big Data Service 3.0.23 and later:

Use the following command to access Trino from CLI in a HA cluster:

/usr/lib/trino/bin/trino-cli --server https://<host>:7778 --krb5-principal <trino-keytab-principal> --krb5-keytab-path <trino-keytab-path> --krb5-remote-service-name trino --truststore-path=/etc/security/serverKeys/truststore.jks

Before Big Data Service 3.0.23:

Use the following command to access Trino from CLI in a HA cluster:

/usr/lib/trino/bin/trino-cli --server https://<host>:7778 --krb5-principal <trino-keytab-principal> --krb5-keytab-path <trino-keytab-path> --krb5-remote-service-name trino --user <trino-keytab-principal> --truststore-path=/etc/security/serverKeys/truststore.jks
where:
  • host is the FQDN of the master node where Trino coordinator is running,
  • --krb5-principal is the principal to use when authenticating to the coordinator, and
  • --krb5-keytab-path is the location of the keytab that can be used to authenticate the principal specified by --krb5-principal.

Use the following command to access Trino from CLI in a non-HA cluster:

/usr/lib/trino/bin/trino-cli --server http://<host>:8285

where host is the FQDN of the master node where Trino coordinator is running.