presto --server localhost:8080 --catalog tpch --schema sf1 Execute:
sudo mkdir /etc/presto/catalog sudo nano /etc/presto/catalog/mysql.properties Add:
sudo nano /etc/presto/catalog/tpch.properties Content:
com.facebook.presto=INFO Presto needs a catalog to query data. Create a catalog for MySQL:
coordinator=true node-scheduler.include-coordinator=true http-server.http.port=8080 query.max-memory=3GB query.max-memory-per-node=1GB discovery-server.enabled=true discovery.uri=http://localhost:8080 sudo nano /etc/presto/log.properties Set logging levels:
# Ubuntu/Debian sudo apt update sudo apt install openjdk-11-jdk -y sudo yum install java-11-openjdk -y