阿里云 AnalyticDB for PostgreSQL - 打造更简单易用的Cloud SQL Data Warehouse 个人介绍 缪长风 ⚫ 2010年初加入支付宝，负责Oracle RAC和Greenplum数据仓库 ⚫ 有幸参与了Oracle RAC到 Greenplum再到Hadoop以及最终到 ODPS的架构演进工作。 ⚫ 2012年起，转至阿里巴巴大数据团队，负责Hbase/OTS业务支 构筑在线企业数据仓库。 • 应用易开发、适配 支持SQL 2003，部分兼容Oracle语法， 支持PL/SQL 存储过程，OLAP窗口函数，事务及数据库标准隔离级别 完备功能和生态，实现应用快速迁移或适配 • PB级数据秒级响应 MPP水平扩展架构，PB级数据查询秒级响应；向量化计算，及列存储智能索引，领先传统数据库引擎性能 3x； 新一代SQL优化器，实现复杂分析语句免调优 • 支持多模分析 库内置100+ 机器学习算法库，实现数据智能探索；高性 能向量检索算法，支持视频/图像检索 以图搜图 AnalyticDB for PostgreSQL 产品架构 协调节点 OSS 分布式云存储服务 SQL Client/BI Tools 协调节点（Master Node） • 接收请求，制定分布式执行计划 计算组（Compute Groups） • 全并行分析计算 • 数据双副本存储 • 定期自动备份

........................................................................................3 2. The SQL Language ......................................................................................... ..............21 II. The SQL Language.............................................................................................................................22 4. SQL Syntax.................... .......................................................................................321 22.1. SQL Dump..............................................................................................

........................................................................................3 2. The SQL Language ......................................................................................... ..................19 II. The SQL Language......................................................................................................................21 4. SQL Syntax....................... .......................................................................................303 22.1. SQL Dump..............................................................................................

........................................................................................3 2. The SQL Language ......................................................................................... ..............21 II. The SQL Language.............................................................................................................................22 4. SQL Syntax.................... .......................................................................................355 23.1. SQL Dump..............................................................................................

........................................................................................3 2. The SQL Language ......................................................................................... ..............21 II. The SQL Language.............................................................................................................................22 4. SQL Syntax.................... .......................................................................................353 23.1. SQL Dump..............................................................................................

........................................................................................3 2. The SQL Language ......................................................................................... ..............21 II. The SQL Language.............................................................................................................................22 4. SQL Syntax.................... .......................................................................................373 23.1. SQL Dump..............................................................................................

........................................................................................3 2. The SQL Language ......................................................................................... ..............21 II. The SQL Language.............................................................................................................................22 4. SQL Syntax.................... .......................................................................................373 23.1. SQL Dump..............................................................................................

........................................................................................3 2. The SQL Language ......................................................................................... ..............24 II. The SQL Language.............................................................................................................................25 4. SQL Syntax.................... Configuration File............................................520 18.1.3. Parameter Interaction via SQL........................................................................521 18.1.4. Parameter Interaction

........................................................................................3 2. The SQL Language ......................................................................................... ..................21 II. The SQL Language......................................................................................................................22 4. SQL Syntax....................... via the Configuration File.....................................492 18.1.3. Parameter Interaction via SQL.................................................................493 18.1.4. Parameter Interaction via

........................................................................................3 2. The SQL Language ......................................................................................... ..............24 II. The SQL Language.............................................................................................................................25 4. SQL Syntax.................... Configuration File............................................497 xii 18.1.3. Parameter Interaction via SQL........................................................................498 18.1.4. Parameter Interaction