realfirst/installing-presto-cli.md

Forked from simonw/installing-presto-cli.md

Created August 1, 2018 01:27

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/realfirst/e4603df962ec72d9e0cc9b1f17cabfba.js"></script>
Save realfirst/e4603df962ec72d9e0cc9b1f17cabfba to your computer and use it in GitHub Desktop.

Download ZIP

Installing the Presto command-line tool

Raw

installing-presto-cli.md

Installing the Presto command-line tool

I had to install Java to get presto working

brew cask install java

From https://prestodb.io/docs/current/installation/cli.html I did:

wget https://repo1.maven.org/maven2/com/facebook/presto/presto-cli/0.202/presto-cli-0.202-executable.jar
mv presto-cli-0.202-executable.jar presto
chmod +x presto

and then...

./presto --server myserver:8080 --catalog hive \
    --execute "SELECT ..." \
    --output-format CSV_HEADER > data.csv

I did this for progress:

watch 'wc -l data.csv && ls -lah data.csv && tail -n 10 data.csv'