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.
109
第 7 章
高级连接器示例
从第
6
章中，你已经学习了
Trino
提供的一些连接器以及如何配置它们，本章会把这些
知识扩展到一些比较复杂的使用场景和连接器。这些连接器通常需要翻译来自底层数据
源的存储模式和思想，而这些数据源并不容易映射到
SQL
和
Trino
的面向表的模型上。
如果你打算通过
Trino
连接并用
SQL
查询特定的系统，可以直接阅读相关小节。
•7.1
节，用
Phoenix
连接
HBase
。
•7.2
节，键值存储连接器示例：
Accumulo
。
•7.3
节，
Apache Cassandra
连接器。
•7.4
节，流系统连接器示例：
Kafka
。
•7.5
节，文档存储连接器示例：
Elasticsearch
。
了解这些连接器之后，你可以通过学习
7.6
节中的联邦查询和相关的
ETL
用法来进一步
完善你的理解。
7.1
用
Phoenix
连接
HBase
分布式、可扩展的大数据存储
Apache HBase
（
https://hbase.apache.org
）构建在
HDFS
之上，但用户并不一定通过
Hive
连接器访问底层的
HDFS
。
Apache Phoenix
项目
（
https://phoenix.apache.org
）提供了一个
SQL
层来访问
HBase
，得益于
Trino Phoenix
连
接器，用户可以像其他数据源一样通过
Trino
访问
HBase
数据库。
与之前一样，你只需要一个
catalog
文件，例如
etc/catalog/bigtables.properties
：
connector.name=phoenix5
phoenix.connection-url=jdbc:phoenix:zookeeper1,zookeeper2:2181:/hbase ...
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.