Presto Cheat Sheet
This code example demonstrates Bash programming techniques and best practices.
git clone https://github.com/prestodb/f8-2019-demo
cd f8-2019-demo
docker-compose up
open localhost:8888
Language: Bash
Original Source: BlogEngine.NET Migration
Code Lines: 9
Presto : https://prestodb.io/overview.html
Quick "Presto" docker setup from FB 2019 Demo:
https://github.com/prestodb/f8-2019-demo
installing presto :
https://prestodb.io/docs/current/installation/deployment.html
installing the client (cli):
https://prestodb.io/docs/current/installation/cli.html
High level commands for the server:
When connecting to a JDBC SQL Server Database.
Your connection URL should contain the database name you'd like to connect to.
Presto schemas do not include sql databases only sql owners/schemas.
Launching the presto client:
https://prestodb.io/docs/current/installation/cli.html
Obtain a damn good starter "etc" directory from sundog because presto doesn't come with one but it's needed:
prerequisites:
good SQL Server reference for Presto: https://docs.starburstdata.com/latest/connector/sqlserver.html
Web Interface info:
https://prestodb.io/docs/current/admin/web-interface.html
Presto Configs from Sundog Media:
http://media.sundog-soft.com/hadoop/presto-hdp-config.tgz
presto-hdp-config (1).tgz (734.00 bytes)
#rename the presto jar and make it executable.
don@Edge:~$ mv presto-cli-0.237.1-executable.jar presto_cli
don@Edge:~$ chmod +x presto_cli
deploy : https://prestodb.io/docs/current/installation/deployment.html
cli: https://prestodb.io/docs/current/installation/cli.html
add source: https://prestodb.io/presto-admin/docs/current/installation/presto-catalog-installation.html
tools: https://prestodb.io/download.html
driver:
- https://prestodb.io/docs/current/installation/jdbc.html
- https://docs.snowflake.com/en/user-guide/jdbc.html
great alternatives:
Presto Cheat Sheet
High level commands for the server: bin