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.
129
第 8 章
在 Trino 中使用 SQL
在安装和运行
Trino
之后，
3.6
节讲解了
Trino
中一流的
SQL
支持的核心特性。如有必
要，可以回顾一下这部分内容。
在第
6
章中你知道了可以在
Trino
中用
SQL
查询很多数据源。
在本章中，你将深入了解
Trino
所支持
SQL
的细节，包括一组数据定义语言（
Data
Definition Language
，
DDL
）语句，它们用于创建和操作数据库对象，如
schema
、表、
列和视图。你还将学习更多的数据类型和
SQL
语句。在第
9
章中，你将学习更多运算符
和函数的高级用法。
本章的目的是展示
Trino
中
SQL
的能力。关于
Trino
中
SQL
的最新和最完整的信息，可
以参考
Trino
官方文档，参见
1.4.2
节。
要在
Trino
中使用
SQL
，可以使用
Trino CLI
、任何使用
JDBC
驱动程序的
应用程序、
Python
客户端库、
ODBC
驱动或其他客户端应用程序，详见第
3
章。
连接器带来的影响
在 Trino 中执行的所有操作都依赖数据源的连接器及其对特定命令的支持。举个例子：
如果连接数据源的连接器不支持
DELETE
语句，则执行
DELETE
就会失败。你可以访问
Trino 官方文档，查看 SQL 支持这一节，得到关于特定连接器的相关细节说明。
此外，创建的连接通常使用特定的用户或某种授权机制，即存在特定的限制。如果
用户没有除读取数据以外的权限，或者甚至只能从特定的 schema 中读取数据，那么
其他操作（如删除数据或写入新数据）就会执行失败。
Trino权威指南 正文7z-最后.indd ...
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.