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.
使用
Trino
|
39
3.5 Trino Web UI
Trino
服务端提供了一个
Web
界面，通常叫作
Trino Web UI
。如图
3-3
所示，
Trino Web UI
提供了
Trino
服务端及其查询处理的详细信息。
Trino Web UI
可以借助与
Trino
服务端相同的
HTTP
端口号，使用相同的地址访问。默
认端口是
8080
，例如
http://trino.example.com:8080
。因此，在本地的安装环境下，可以
在
http://localhost:8080
处访问
Web UI
。
你需要提供用户名并登录。默认情况下，没有开启身份验证功能，所以你可以使用一个
随机的用户名。
主仪表盘显示了
Trino
利用率的细节和查询列表。你还可以通过
UI
获得更进一步的信
息。这些信息对操作
Trino
和管理运行中的查询具有极大的价值。
使用
Web UI
有助于监控
Trino
和性能调优，
12.1
节有详细介绍。新手主要可以用它来确
认服务端是否正常启动和运行，以及是否正在处理你的查询。
图 3-3：显示有关集群高级信息的 Trino Web UI
3.6
使用
Trino
执行
SQL
Trino
是一个兼容
ANSI SQL
的查询引擎，可以让你使用相同的
SQL
语句、函数和运算
符来查询和操作所有可以连接到的数据源中的数据。
Trino
致力于成为一个与现有
SQL
标准兼容的系统。其主要设计原则之一是既不发明一
Trino权威指南 1-6.indd 39Trino权威指南 1-6.indd 39 2023-8-4 13:58:172023-8-4 ...
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.