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.
连接器
|
87
•
适用于使用
HDFS
和类似的对象存储系统的查询系统的
Hive
连接器，参见
6.4
节。
•
用于现代对象存储系统和数据湖仓的表格式的连接器，参见
6.5
节。
•
与非关系型数据源的众多连接器，参见
6.6
节。
•
用于
TPC
基准数据的
tpch
和
tpcds
连接器，参见
6.3
节。
•
用于
Java
管理扩展（
JMX
）的连接器，参见
6.7
节。
本章将介绍更多关于
Trino
项目自带的部分连接器的信息。目前
Trino
中已经推出
20
多
个连接器，而且
Trino
团队和用户社区还在创造更多的连接器。商业连接器和专有连接
器也可以用于扩展
Trino
性能的边界。最后，如果有一个自定义的数据源，或者一个没
有适配连接器的数据源，你可以通过实现必要的
SPI
调用来实现这个连接器，然后将它
放到
Trino
的
plugin
目录里即可。
catalog
和连接器使用有一个重要方面：它们可同时用于
Trino
中的
SQL
语句和查询。这
意味着
Trino
可以创建跨数据源的查询。例如，
Trino
可以将来自关系型数据库的数据与
存储在对象存储后台文件中的数据结合起来。这种联邦查询将在
7.6
节中详细讨论。
6.1
配置
如
2.3
节所述，你想访问的每个数据源都需要创建一个
catalog
属性文件来配置
catalog
。
在编写查询时，这个文件的名称决定了写查询时
catalog
的名称。
必填属性
connector.name
表示
catalog
中使用的是哪个连接器。同一个连接器可以在
不同的
catalog
中多次使用。例如，使用相同连接器技术（如
PostgreSQL ...
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.