March 2021
Intermediate to advanced
265 pages
6h 50m
Chinese
Content preview from Presto实战
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.
连接器
｜
81
Microsoft SQLServer
的连接字符串看起来与
MySQL
类似。但是，
SQL Server
确实有数据
库和
schema
的概念，这个例子只是简单地连接到默认的数据库：
connector.name=sqlserver
connection-url=jdbc:sqlserver://example.net:1433
connection-user=root
connection-password=secret
而使用如
sales
等不同的数据库时，则必须要配置一个属性。
connection-url=jdbc:sqlserver://example.net:1433;databaseName=sales
6.2.4
安全性
目前，
RDBMS
连接器进行认证的唯一方式是在
catalog
配置文件中存储用户名和密码。由
于
Presto
集群中的机器被设计成可信任的系统
，这对于大多数的使用来说应该是足够的。
为了保证
Presto
和所连接的数据源的安全
，对机器和配置文件的安全访问非常重要，应该
像对待私钥一样对待它。所有的
Presto
用户都使用相同的连接访问
RDBMS
。
如果你不想用明文存储密码，有一些方法可以通过
Presto
客户端传递用户名和密码
。第
10
章将进一步讨论。
总而言之，
Presto
与
RDBMS
一起使用是非常容易的
，可以将所有的系统都暴露在一个地
方，并且可以同时查询。仅此就表明使用
Presto
提供了巨大的益处
。当然，用其他连接器
添加更多的数据源之后，事情就会变得更加有趣。所以，让我们继续深入。 ...
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.