Instalar Presto 8.8 — Como
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:
bin/launcher status View logs:
com.facebook.presto=INFO Presto needs a catalog to query data. Create a catalog for MySQL: como instalar presto 8.8
sudo nano /etc/presto/config.properties Add: coordinator=true node-scheduler
connector.name=mysql connection-url=jdbc:mysql://localhost:3306 connection-user=root connection-password=your_password You can replace mysql with tpch for testing (no extra setup): como instalar presto 8.8
sudo mkdir /etc/presto/catalog sudo nano /etc/presto/catalog/mysql.properties Add:
presto --server localhost:8080 --catalog tpch --schema sf1 Execute: