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.
高级连接器示例
|
117
flightdate VARCHAR,
flightnum, INTEGER,
origin VARCHAR
dest VARCHAR
)
WITH
index_columns = 'flightdate,origin'
);
在本节中，你学习了键值存储以及在
Trino
中如何使用标准
SQL
来查询它。接下来看另
一个可以从
Trino
中受益的、使用更广泛的系统：
Apache Cassandra
。
7.3 Apache Cassandra
连接器
Apache Cassandra
（
https://cassandra.apache.org
）是一个分布式的、支持海量数据的宽
列存储。
Cassandra
的容错架构和线性扩展性使其得到了广泛的应用。
在
Cassandra
中处理数据的典型方法是使用为
Cassandra
设计的自定义查询语言：
Cassandra
查询语句（
Cassandra Query Language
，
CQL
）。虽然
CQL
从表面上看很像
SQL
，但它实际上缺少
SQL
的许多有用功能，如
Join
。总的来说，它和
SQL
不同，无
法直接使用依赖
SQL
的标准工具。
然而，借助
Cassandra
连接器，你可以对
Cassandra
中的数据进行
SQL
查询。最小配置
就是一个简单的
catalog
文件，比如
etc/catalog/sitedata.properties
。这里的
Cassandra
集
群记录了一个网站上所有的用户交互，例如：
connector.name=cassandra
cassandra.contact-points=sitedata.example.com ...
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.