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.
高级
SQL
特性
｜
171
•
ST_Contains(Geometry, Geometry) -> boolean
•
ST_Touches(Geometry, Geometry) -> boolean
•
ST_Within(Geometry, Geometry) -> boolean
•
ST_Length(Geometry) -> double
•
ST_Distance(Geometry, Geometry) -> double
•
ST_Area(SphericalGeography) -> double
Presto
文档（参见
1.4.2
节）详细介绍了
Presto
中对地理空间的支持。如果你在使用
Presto
时需要处理地理空间数据，我们强烈建议你看一下该文档。
9.22
Prepared Statement
Prepared Statement
是一种非常有用的方法，它可以使用不同的输入参数值运行相同的
SQL
语句。它允许重复使用
SQL
语句，
这简化了用户反复调用的麻烦，也让代码更干净、更易
于维护。
PreparedStatement
是保存在
Presto
用户会话中的查询。
Prepared Statement
的使用和创建分为两个步骤
。
PREPARE
语句用于创建语句，从而使其在
会话中可重复使用：
PREPARE example
FROM SELECT count(*) FROM hive.ontime.flights_orc;
EXECUTE
命令可用于运行一次或多次查询：
EXECUTE example; ...
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.