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.
94
|
第
6
章
如第
8
章和第
9
章所述，你可以使用这些数据集来学习
Trino
支持的更多
SQL
，而无须
连接另一个数据库（如例子所示，也可以使用
Docker
容器）。
这些连接器的另一个重要使用场景是获得简单可用的数据。可以将这些连接器用于开发
和测试，甚至在
Trino
部署的生产环境中使用。由于易于获得大量数据，因此你可以构
建在
Trino
集群上施加很大负载的查询。
如果想要使用
TPC
数据集测试对象存储或
RDBMS
的性能，可以运行
CREATE
TABLE AS
SELECT
查询，这条语句会将数据从连接器复制到另一个
catalog
中。之后，就可以使用
相同的
TPC
查询测试特定软件中的数据。
这可以使你更好地了解集群性能，对其进行调整和优化，并确保即使发生了跨版本更新
或其他变更，集群也可以正常工作。
6.4
用于分布式存储数据源的
Hive
连接器
如
1.5
节所述，
Trino
是为了在
Facebook
这样的体量上运行快速查询而设计的。鉴于
Facebook
在其
Hive
数据仓库中拥有海量的存储，
Hive
连接器自然成为
Trino
开发的首
批连接器之一。
6.4.1 Apache Hadoop
和
Apache Hive
在了解
Hive
连接器以及它对众多对象存储格式的适用性之前，需要先梳理一下
Apache
Hadoop
（
https://hadoop.apache.org/
）和
Apache Hive
（
https://hive.apache.org/
）的相关
知识。
如果你对
Hadoop
和
Hive
不熟悉且想了解更多，推荐浏览项目的官方网站 ...
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.