Presto CLI script example

presto-cli-sample.sh

export PRESTO_PASSWORD=*****

./presto194 \
  --server https://presto.server:31443 \
  --catalog <mycatalog> \
  --keystore-password password \
  --keystore-path /mnt/c/private/presto-client.jks \
  --schema <myschema> \
  --output-format TSV \
  --user <username> \
  --password \
  -f testquery.sql

To run the script and capture the output to an environment variable, use this:

OUTPUT="$(./testquery.sh)"
echo $OUTPUT | awk '{print $1}'
echo $OUTPUT | awk '{print $2}'