Presto (now officially known as Trino , though the original PrestoSQL 8.8 is a specific legacy release) is a high-performance, distributed SQL query engine designed for querying large datasets across multiple data sources.
sudo mkdir -p /etc/presto sudo mkdir -p /var/lib/presto/data sudo mkdir -p /var/log/presto sudo chown -R $USER:$USER /etc/presto /var/lib/presto /var/log/presto Navigate to /etc/presto and create the following configuration files: 4.1 node.properties sudo nano /etc/presto/node.properties Add:
tail -f /var/log/presto/server.log Wait for the message: ======== SERVER STARTED ======== Download the Presto CLI client: como instalar presto 8.8
sudo mkdir -p /opt/presto cd /opt/presto sudo wget https://repo1.maven.org/maven2/com/facebook/presto/presto-server/8.8/presto-server-8.8.tar.gz sudo tar -xzf presto-server-8.8.tar.gz sudo mv presto-server-8.8/* . sudo rm -rf presto-server-8.8 presto-server-8.8.tar.gz Presto 8.8 is an older release. If the Maven URL is deprecated, check the PrestoDB archives or use Trino (the modern fork). For historical/educational purposes, this is the canonical path. 🗂️ Passo 3: Criar a Estrutura de Diretórios Presto needs separate directories for configuration, data, and logs:
sudo mkdir /etc/presto/catalog sudo nano /etc/presto/catalog/mysql.properties Add: Presto (now officially known as Trino , though
sudo nano /etc/presto/catalog/tpch.properties Content:
java -version # Output should show version 11.x Create a dedicated directory and download the tarball: If the Maven URL is deprecated, check the
com.facebook.presto=INFO Presto needs a catalog to query data. Create a catalog for MySQL: