Tutorial — Presto 8.8

Since Presto 8.8 is a historical release (from the 8.x line before the transition to Presto 8.x/Trino split), this guide focuses on key features available in Presto 8.8 and how to use them.

1. Install Presto: Download the Presto 8.8 binary from the official website and extract it to a directory on your machine.
2. Configure the Cluster: Create a configuration file (config.properties) that specifies the cluster name, node name, and other settings.
3. Start the Cluster: Start the Presto cluster using the presto command.

• SELECT: Retrieves data from one or more tables.
• FROM: Specifies the table(s) to query.
• WHERE: Filters data based on conditions.
• GROUP BY: Groups data by one or more columns.

8.2 Enabling Dynamic Filtering (On by default in 8.8)

Dynamic filtering speeds up fact-dimension joins. Verify it's active: tutorial presto 8.8

• Explore the Delta Lake connector for ACID transactions.
• Try Presto on Kubernetes using the official Helm chart.
• Join the Presto Community Slack for advanced troubleshooting.