Presto 8.8: Instalar

SHOW TABLES; SELECT * FROM nation LIMIT 5; Create /etc/systemd/system/presto.service :

Enable and start:

# Ubuntu/Debian sudo apt update && sudo apt install openjdk-11-jdk sudo yum install java-11-openjdk 2. Download Presto 8.8 # Create installation directory sudo mkdir -p /opt/presto cd /opt/presto Download Presto 8.8 server tarball sudo wget https://repo1.maven.org/maven2/com/facebook/presto/presto-server/0.288/presto-server-0.288.tar.gz Note: Version 8.8 corresponds to release 0.288 in Maven coordinates (Presto versioning changed after 0.288 → 350+). Verify the exact URL from Maven Central . Alternatively, use the official Presto download page: https://prestodb.io/download.html → Select version 0.288 instalar presto 8.8

coordinator=true node-scheduler.include-coordinator=true http-server.http.port=8080 query.max-memory=5GB query.max-memory-per-node=1GB query.max-total-memory-per-node=2GB discovery-server.enabled=true discovery.uri=http://localhost:8080 ( etc/log.properties ) com.facebook.presto=INFO 3.5 Catalog Properties (e.g., TPCH for testing) sudo mkdir etc/catalog Create etc/catalog/tpch.properties :

Date: Current Target Version: Presto 8.8 Environment: Linux (Ubuntu/Debian/CentOS/RHEL) Prerequisites: Java 11 (64-bit), Python 2.7+ (for launcher script) 1. Pre-Installation Checklist | Requirement | Verification Command | |-------------|----------------------| | Java 11 | java -version (must show OpenJDK 11) | | Memory | Free memory for Presto coordinator (minimum 4GB, recommended 8GB+) | | Disk Space | ~500MB for binaries + space for logs/data | | No running Presto | Ensure no existing Presto process conflicts | SHOW TABLES; SELECT * FROM nation LIMIT 5;

connector.name=tpch sudo mkdir -p /var/presto/data sudo mkdir -p /var/log/presto sudo chown -R $(whoami):$(whoami) /var/presto /var/log/presto /opt/presto 5. Start Presto Server cd /opt/presto/current bin/launcher start Check status:

tail -f /var/log/presto/server.log cd /opt/presto sudo wget -O presto-cli.jar https://repo1.maven.org/maven2/com/facebook/presto/presto-cli/0.288/presto-cli-0.288-executable.jar sudo chmod +x presto-cli.jar Run a test query: SELECT * FROM nation LIMIT 5

bin/launcher status View logs: