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.
34
|
第
3
章
选项有
ALIGNED
、
VERTICAL
、
TSV
、
TSV_HEADER
、
CSV
、
CSV_HEADER
、
CSV_UNQUOTED
、
CSV_
HEADER_UNQUOTED
、
JSON
和
NULL
，默认值是
CSV
。
3.1.7
忽略错误
Trino CLI
提供了
--ignore-error
选项来忽略执行文件中的查询时遇到的任何错误。默
认行为是在遇到第一个错误时终止执行脚本。
3.2 Trino JDBC
驱动
任何
Java
应用程序都可以通过
Java
数据库连接（
JDBC
）驱动连接到
Trino
。
JDBC
是一
套标准的数据库访问
API
，它提供了在关系型数据库中查询、插入、删除和更新数据等
的必要方法。许多运行在
JVM
上的客户端应用程序或服务端应用程序使用
JDBC
来访
问底层的数据库，以实现数据库管理、报表和其他一些特性。通过
JDBC
驱动，所有这
些应用程序都可以使用
Trino
。
Trino
的
JDBC
驱动允许你连接到
Trino
并使用
SQL
语句与
Trino
交互。
如果你熟悉
JDBC
驱动的不同实现，就知道
Trino
的
JDBC
驱动是
Type 4
驱
动，这仅仅意味着它直接与
Trino
原生协议通信。
JDBC
驱动可以让你使用许多强大的
SQL
客户端和数据库管理工具，比如开源工具
DBeaver
或
SQuirreL SQL
客户端等。基于
JDBC
的报告生成、仪表盘和分析工具也可以
与
Trino
一起使用。
用这些工具连接
Trino
的步骤都很相似：
1.
下载
JDBC
驱动。
2.
将
JDBC
驱动放置在应用程序的
classpath
（类路径）的覆盖范围之内。 ...
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.