阿里云 AnalyticDB for PostgreSQL - 打造更简单易用的Cloud SQL Data Warehouse 个人介绍 缪长风 ⚫ 2010年初加入支付宝，负责Oracle RAC和Greenplum数据仓库 ⚫ 有幸参与了Oracle RAC到 Greenplum再到Hadoop以及最终到 ODPS的架构演进工作。 ⚫ 2012年起，转至阿里巴巴大数据团队，负责Hbase/OTS业务支 RDS 关系型数据 库D ECS自建 自建大数据计算平台 Hadoop Spark EMR Dataphi n OSS海量云存储 Data Lake Store DTS 实时同步 Dump Data Dump Data 数据集成 按需回流 数据仓库应用 在线数据仓库 数据 查询 数据集成 批量同步 1 3 4 2 云化在线数仓 ： 简化、敏捷、一栈式构筑数据仓库

Notation.........................................................................................52 5. Data Definition....................................................................................... Value...................................................................66 5.5.6. Changing a Column’s Data Type ........................................................................67 5.5.7. Renaming a ................................................................................84 5.10. Foreign Data .................................................................................................

Mixed Notation..................................................................................47 5. Data Definition....................................................................................... Default Value............................................................61 5.5.6. Changing a Column’s Data Type .................................................................61 5.5.7. Renaming a Column ................................................................................77 5.10. Foreign Data .................................................................................................

Evaluation Rules ............................................................................39 5. Data Definition....................................................................................... Value...................................................................52 5.5.6. Changing a Column’s Data Type ........................................................................53 5.5.7. Renaming a .............68 6. Data Manipulation........................................................................................................................70 6.1. Inserting Data ...................

Notation.........................................................................................51 5. Data Definition....................................................................................... Value...................................................................66 5.5.6. Changing a Column’s Data Type ........................................................................67 5.5.7. Renaming a ................................................................................83 5.10. Foreign Data .................................................................................................

Mixed Notation..................................................................................47 5. Data Definition....................................................................................... Default Value............................................................60 5.5.6. Changing a Column’s Data Type .................................................................61 5.5.7. Renaming a Column ................................................................................76 5.10. Foreign Data .................................................................................................

Functions ........................................................................................ 59 5. Data Definition ...................................................................................... ................................................................................ 97 5.12. Foreign Data ........................................................................................... 111 5 ....................... 112 6. Data Manipulation ............................................................................................... 114 6.1. Inserting Data ...............................

notation..........................................................................................50 5. Data Definition....................................................................................... Value...................................................................65 5.5.6. Changing a Column’s Data Type ........................................................................66 5.5.7. Renaming a .............83 6. Data Manipulation........................................................................................................................85 6.1. Inserting Data ...................

notation...................................................................................46 5. Data Definition....................................................................................... Default Value............................................................60 5.5.6. Changing a Column’s Data Type .................................................................61 5.5.7. Renaming a Column ................77 6. Data Manipulation.................................................................................................................79 6.1. Inserting Data .......................

Functions .................................................................................. 55 5. Data Definition ...................................................................................... ................................................................................ 91 5.12. Foreign Data ..................................................................................... 105 5.13. Other .......................... 105 6. Data Manipulation .......................................................................................... 108 6.1. Inserting Data .................................