Not much of a post here, just recording a good way to automatically run queries in the presto cli.
./presto-cli-350-executable.jar \ --server https://your.cluster.dns:443 \ --catalog hive \ --schema default \ --client-request-timeout "10s" \ --user "john.humphreys" \ --password \ --execute "select * from some_db.some_table limit 10"
If you need the password as well, you can pipe it into the command with the yes
command in Linux. I also suspect there is an environment variable you can pre-set for that, but I didn’t dig in to double check.