July 2023
Intermediate to advanced
278 pages
5h 40m
Chinese
Content preview from Trino 权威指南：原书第2版
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
226
|
第
11
章
停下来想想这件事：在没有任何基础设施需要管理的情况下，你只需要用一个命令行界
面就可以在
S3
中存储的数据文件上运行
SQL
查询。如果没有
Athena
和
Glue
，你必须
部署和管理基础设施和软件来对数据执行
SQL
查询。而如果没有
Trino
，你必须以某种
方式采集并格式化数据，然后写入数据库中，之后才可以进行
SQL
处理。
Athena
和
Glue
的结合是一种令人难以置信的强大工具，而
Trino
使你可以使用标准
SQL
对
S3
上的数据进行操作。
这个简单的介绍并不能使你全面了解
Athena
，但可以让你了解到
Trino
在行业内的应用
情况，以及
Trino
与其他产品的区别。
使用
Athena
可以满足不同的需求，但有一些特定的限制和特性。例如，
Athena
对较大
的、运行时间较长的查询施加了限制。
因为你是为处理后的数据量而不是运行软件的基础设施付费，所以成本计算也有很大不
同。每次运行查询时，你都要为处理的数据付费。根据你的使用模式，这可能更便宜，也
可能更贵。具体来说，为了降低查询成本，你可以在
S3
中预处理数据，从而使用
Parquet
和
ORC
等格式并进行压缩。当然，预处理也是有代价的，因此你必须尝试优化整体成本。
许多其他平台以类似的、隐蔽的方式使用
Trino
，从而为用户和这些平台的提供者提供了
强大的能力。如果你追求管控力和灵活性，运行自己部署的
Trino
仍是一个很棒的选择。
11.5
企业版：
Starburst Enterprise
和
Starburst
Galaxy
Starburst
（
http://starburst.io ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.