for PostgreSQL - 打造更简单易用的Cloud SQL Data Warehouse 个人介绍 缪长风 ⚫ 2010年初加入支付宝，负责Oracle RAC和Greenplum数据仓库 ⚫ 有幸参与了Oracle RAC到 Greenplum再到Hadoop以及最终到 ODPS的架构演进工作。 ⚫ 2012年起，转至阿里巴巴大数据团队，负责Hbase/OTS业务支 撑，期 PostgreSQL 未来演进 AnalyticDB for PostgreSQL 在线MPP数据仓库服务 简单易用、海量扩展、兼容部分Oracle 语法生态、既支持在线交互分析，也支持离线数据处理。 AnalyticDB for PostgreSQL （云Greenplum）低成本，快速 构筑在线企业数据仓库。 • 应用易开发、适配 支持SQL 2003，部分兼容Oracle语法， 支持PL/SQL （INSERT/UPDATE/DELETE） • 行存储及多种索引（Btree, Bitmap 等），点查询毫秒级返回 • 支持分布式事务，标准数据库隔离级别 基于AnalyticDB for PostgreSQL 构筑云上数据仓库 1：实时数仓场景 通过 DTS/Kettle/rds_dbsync 实时同步交易库数据到 ADBPG MySQL/PG->DTS->ADBPG 2：离线数仓场景 数据集成按天/小时 批量同步交易库数据ADBPG

................................................................................. 1072 37.2.2. Container Types ............................................................................. 1072 37.2.3 structures. 37.2. The PostgreSQL Type System PostgreSQL data types can be divided into base types, container types, domains, and pseudo-types. 37.2.1. Base Types Base types are those, like integer, that low-level programming. Refer to Section 8.7 for more information. 37.2.2. Container Types PostgreSQL has three kinds of “container” types, which are types that contain multiple values of other types. These

................................................................................. 1132 37.2.2. Container Types .................................................................................. 1132 37 structures. 37.2. The PostgreSQL Type System PostgreSQL data types can be divided into base types, container types, domains, and pseudo-types. 37.2.1. Base Types Base types are those, like integer, that low-level programming. Refer to Section 8.7 for more information. 37.2.2. Container Types PostgreSQL has three kinds of “container” types, which are types that contain multiple values of other types. These

Functions and Operators Operator Right Operand Type Description Example Throws an error if top level container is not an array. #- text[] Delete the field or ele- ment with specified path (for JSON arrays, ................................................................................. 1041 38.2.2. Container Types ............................................................................. 1041 38.2.3 structures. 38.2. The PostgreSQL Type System PostgreSQL data types can be divided into base types, container types, domains, and pseudo-types. 38.2.1. Base Types Base types are those, like integer, that

................................................................................. 1170 38.2.2. Container Types .................................................................................. 1170 38 structures. 38.2. The PostgreSQL Type System PostgreSQL data types can be divided into base types, container types, domains, and pseudo-types. 38.2.1. Base Types Base types are those, like integer, that low-level programming. Refer to Section 8.7 for more information. 38.2.2. Container Types PostgreSQL has three kinds of “container” types, which are types that contain multiple values of other types. These

................................................................................. 1111 38.2.2. Container Types ............................................................................. 1111 38.2.3 structures. 38.2. The PostgreSQL Type System PostgreSQL data types can be divided into base types, container types, domains, and pseudo-types. 38.2.1. Base Types Base types are those, like integer, that low-level programming. Refer to Section 8.7 for more information. 38.2.2. Container Types PostgreSQL has three kinds of “container” types, which are types that contain multiple values of other types. These

ment with specified in- dex (Negative integers count from the end). Throws an error if top level container is not an array. '["a", "b"]'::j- sonb - 1 #- text[] Delete the field or ele- ment with specified ................................................................................. 1074 37.2.2. Container Types ............................................................................. 1074 37.2.3 structures. 37.2. The PostgreSQL Type System PostgreSQL data types can be divided into base types, container types, domains, and pseudo-types. 37.2.1. Base Types Base types are those, like integer, that

ment with specified in- dex (Negative integers count from the end). Throws an error if top level container is not an array. '["a", "b"]'::j- sonb - 1 #- text[] Delete the field or ele- ment with specified ................................................................................. 1097 38.2.2. Container Types .................................................................................. 1097 38 structures. 38.2. The PostgreSQL Type System PostgreSQL data types can be divided into base types, container types, domains, and pseudo-types. 38.2.1. Base Types Base types are those, like integer, that

Type Description Example dex (Negative integers count from the end). Throws an error if top level container is not an array. #- text[] Delete the field or ele- ment with specified path (for JSON arrays, ................................................................................. 1132 37.2.2. Container Types .................................................................................. 1132 37 structures. 37.2. The PostgreSQL Type System PostgreSQL data types can be divided into base types, container types, domains, and pseudo-types. 37.2.1. Base Types Base types are those, like integer, that

................................................................................. 1234 38.2.2. Container Types .................................................................................. 1234 38 structures. 38.2. The PostgreSQL Type System PostgreSQL data types can be divided into base types, container types, domains, and pseudo-types. 38.2.1. Base Types Base types are those, like integer, that low-level programming. Refer to Section 8.7 for more information. 38.2.2. Container Types PostgreSQL has three kinds of “container” types, which are types that contain multiple values of other types. These