Tutorial Presto 8.8 Official

In the fast-paced world of big data, query speed and scalability are non-negotiable. Presto (now PrestoDB) has emerged as a leading distributed SQL query engine for running interactive analytics on datasets ranging from gigabytes to petabytes. With the release of Presto 8.8, the open-source community introduced significant enhancements in stability, federation capabilities, and ANSI SQL compliance.

Whether you are a data analyst, a platform engineer, or a curious developer, this tutorial Presto 8.8 will guide you from installation to advanced query execution. By the end of this guide, you will understand how to set up a Presto cluster, configure catalogs for diverse data sources (Hive, MySQL, PostgreSQL), and optimize performance using the latest features of version 8.8.

---

Create etc/config.properties (coordinator + worker on same machine): tutorial presto 8.8

coordinator=true
node-scheduler.include-coordinator=true
http-server.http.port=8080
discovery.uri=http://localhost:8080
query.max-memory=3GB
query.max-memory-per-node=1GB
query.max-total-memory-per-node=2GB

You have now completed a full tutorial Presto 8.8 covering installation, configuration, cross-connector queries, performance tuning, and real-world use cases. Presto 8.8 stands as a robust, high-performance SQL engine that unifies your data silos without moving data.

Next steps:

Happy querying!

---

Further Resources

---

One of the most significant features fully matured in Presto 8.8 is the Cost-Based Optimizer with Hive connector statistics support.

Create etc/jvm.config:

-server
-Xmx4G
-XX:+UseG1GC
-XX:G1HeapRegionSize=32M
-XX:+UseGCOverheadLimit
-XX:+ExplicitGCInvokesConcurrent
-Dlog.levels-file=etc/log.properties