Trino: The Definitive Guide

This repository contains helpful resources for the book Trino: The Definitive Guide, formerly Presto: The Definitive Guide, written by Matt Fuller (@mattsfuller), Manfred Moser (@mosabua) and Martin Traverso (@martint) and published by O'Reilly Media.

The following branches are available:

• master branch for the second edition, based on Trino 392
• first-edition-trino branch for the first revision, based on Trino 354
• first-edition-prestosql branch for the first edition, based on PrestoSQL 330

Contents

• cluster-installation: sample config files for coordinator and workers in a cluster
• flight-data-set: DDL, queries and tips for the flights data set
• iris-data-set: DDL, queries and tips for the iris data set
• single-installation: sample config files for single node Presto installation, coordinator and worker as same node
• tpch: queries for the tpch catalog

Resources

Following are a bunch of resources used in the book and as pointers for the readers to further information.

Trino project:

• Trino website at https://trino.io
• Trino documentation at https://trino.io/docs/current/
• Trino blog at https://trino.io/blog/
• Trino Community Broadcast episodes with audio and video at https://trino.io/broadcast/
• GitHub organization with source code https://github.com/trinodb
• Trino community chat https://trino.io/slack.html for sign up to slack at https://trinodb.slack.com
• Trino tag on stackoverflow at https://stackoverflow.com/questions/tagged/trino
• Trino tag on dba stackexchange at https://dba.stackexchange.com/questions/tagged/trino
• Trino Forum at https://www.trinoforum.org/

Links

Blogs and specific blog posts (in no particular order)

• Starburstdata https://blog.starburstdata.com/
• Presto Summit NYC 2019 Recap https://blog.starburstdata.com/technical-blog/nyc-presto-summit-recap
• Pure Storage https://medium.com/@joshua_robinson/presto-powered-s3-data-warehouse-on-kubernetes-aea89d2f40e8
• Lyft https://eng.lyft.com/presto-infrastructure-at-lyft-b10adb9db01
• Pinterest https://medium.com/pinterest-engineering/presto-at-pinterest-a8bda7515e52
• Arm Treasure Data https://www.slideshare.net/taroleo/presto-at-arm-treasure-data-2019-updates
• Wayfair https://www.slideshare.net/kbajda/presto-sql-at-wayfair-meetup-presentation?qid=8c20be5b-ea47-4ef7-a2db-29fe61141180&v=&b=&from_search=2
• WalmartLabs https://medium.com/walmartlabs/presto-on-google-cloud-platform-d3c2187c4880
• WalmartLabs https://medium.com/walmartlabs/exploring-presto-and-zeppelin-for-fast-data-analytics-and-visualization-9cb4dca91c3d
• https://tech.marksblogg.com/50-node-presto-cluster-dataproc.html