Learning and Operating Presto: Fast, Reliable SQL for Data Analytics and Lakehouses

The Presto community has mushroomed since its origins at Facebook in 2012. But ramping up this open source distributed SQL query engine can be challenging even for the most experienced engineers. With this practical book, data engineers and architects, platform engineers, cloud engineers, and software engineers will learn how to use Presto operations at your organization to derive insights on datasets wherever they reside.

Authors Angelica Lo Duca, Tim Meehan, Vivek Bharathan, and Ying Su explain what Presto is, where it came from, and how it differs from other data warehousing solutions. You'll discover why Facebook, Uber, Alibaba Cloud, Hewlett Packard Enterprise, IBM, Intel, and many more use Presto and how you can quickly deploy Presto in production.

With this book, you will:

• Learn how to install and configure Presto
• Use Presto with business intelligence tools
• Understand how to connect Presto to a variety of data sources
• Extend Presto for real-time business insight
• Learn how to apply best practices and tuning
• Get troubleshooting tips for logs, error messages, and more
• Explore Presto's architectural concepts and usage patterns
• Understand Presto security and administration

Presto社群自2012年在Facebook誕生以來已經蓬勃發展。但即使對於最有經驗的工程師來說，擴展這個開源分散式SQL查詢引擎也可能具有挑戰性。這本實用書籍將教導數據工程師、架構師、平台工程師、雲端工程師和軟體工程師如何在組織中使用Presto操作，以從數據集中獲取洞察力，無論數據集位於何處。

作者Angelica Lo Duca、Tim Meehan、Vivek Bharathan和Ying Su解釋了Presto是什麼，它的起源以及它與其他數據倉儲解決方案的區別。您將了解為什麼Facebook、Uber、阿里巴巴雲、惠普企業、IBM、英特爾等眾多公司使用Presto，以及如何快速將Presto部署到生產環境中。

通過這本書，您將能夠：
- 學習如何安裝和配置Presto
- 使用商業智能工具與Presto一起使用
- 了解如何將Presto連接到各種數據源
- 擴展Presto以獲取實時業務洞察力
- 學習如何應用最佳實踐和調優
- 獲得日誌、錯誤消息等故障排除提示
- 探索Presto的架構概念和使用模式
- 了解Presto的安全性和管理