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.

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:

• https://trino.io
• https://trino.io/docs/current/
• https://trino.io/blog/
• https://github.com/trinodb
• https://trinodb.slack.com
• https://stackoverflow.com/questions/tagged/trino

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