Tutorial Presto 8.8 May 2026

wget https://repo1.maven.org/maven2/io/prestosql/presto-cli/8.8/presto-cli-8.8-executable.jar
mv presto-cli-8.8-executable.jar presto
chmod +x presto
./presto --server localhost:8080

You should see the Presto shell: presto>

To get the most out of this tutorial, apply these tuning suggestions.

Presto 0.208 Tutorial

Table of Contents

Create postgresql.properties:

connector.name=postgresql
connection-url=jdbc:postgresql://localhost:5432/tpch_db
connection-user=presto_user
connection-password=secure_password

query.spill-enabled=true
query.spill-to-disk=true
spill.max-used-space-threshold=0.9
  • Set Timer: Turn the dial past 20 minutes, then turn it back to the recommended time (usually 12–18 minutes).
  • Finish: When the timer rings, the heat shuts off. Use oven mitts to remove the pan or slide the pizza onto a cutting board.

    • Before Presto can use CBO, statistics must exist. In Hive CLI:

    -- Compute basic stats for a table
ANALYZE TABLE sales COMPUTE STATISTICS;

    -- Compute column-level stats (for join optimization)
ANALYZE TABLE sales COMPUTE STATISTICS FOR COLUMNS order_date, customer_id, amount;
 tutorial presto 8.8