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.
连接器
|
93
段），该代码在
Trino SQL
语句中返回表。这允许你访问底层数据源的功能，以便使用遗
留迁移。该功能还可以进一步解锁性能或查询方法，例如支持其他查询语言。
6.3 TPC-H
连接器和
TPC-DS
连接器
第
2
章已经介绍了
TPC-H
连接器的使用方法，下面再来详细学习一下。
TPC-H
和
TPC-DS
连接器内置于
Trino
中，并提供了一系列
schema
以支持
TPC-H
（
TPC
Benchmark H
）和
TPC-DS
（
TPC Benchmark DS
）基准测试。事务处理性能委员会（
http://tpc.
org
）提供的数据库基准测试套件是数据库系统的行业标准，并用于度量高度复杂的决策
支持数据库的性能。
这些连接器可以用于测试
Trino
的能力和查询语法，无须配置外部数据源的访问。当你
查询一个
TPC-H
或
TPC-DS schema
时，连接器使用一个确定性算法实时生成数据。
创建一个
catalog
属性文件（例如
etc/catalog/tpch.properties
），用于配置
TPC-H
连接器：
connector.name=tpch
TPC-DS
连接器的配置是类似的。例如，用
etc/catalog/tpcds.properties
：
connector.name=tpcds
这两个连接器所展示的
schema
在结构上包括相同的数据集：
SHOW SCHEMAS FROM tpch;
Schema
--------------------
information_schema
sf1
sf100
sf1000
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.