Greenplum Database 管理员指南 V6.2.1 版权所有：Esena(陈淼 +86 18616691889) 编写：陈淼 - 1 - Greenplum Database 管理员指南 版本 V6.2.1 2020 年 09 月 27 日 欢迎关注 Greenplum 官方微信公众号和加入官方社区技术讨论群： 从闭源到开源的成长历程，一路给 Greenplum 做各种补丁 脚本，也看到了 Greenplum 的大幅进步，甚至我们以前的小技巧也不再需要，持续的 进步，带来的是生态的蓬勃发展。 Greenplum Database 管理员指南 V6.2.1 版权所有：Esena(陈淼 +86 18616691889) 编写：陈淼 - 2 - 序言 术语约定 GP ： Greenplum 数据库 编写： 陈淼 电邮： miaochen@mail.ustc.edu.cn Greenplum Database 管理员指南 V6.2.1 版权所有：Esena(陈淼 +86 18616691889) 编写：陈淼 - 3 - 目录 Greenplum Database 管理员指南 .............................................

Queries Slow Queries Easy Querying Difficult Querying Current approaches Streamed data lake Relational data lake Storage data lake Strengths • Good latency (a few Seconds) • SQL queries are easy (slides after that...) • Good “dove-tailing” with subsequent “sematic” ETL steps Ingestion into relational data lake semantic layer (cubes, marts etc..) ODS, e.g. redshift, greenplum or RDS ETL users RDS Kafka or Kinesis streamed analytics users HVR Simultaneous ingestion into streaming, relational and storage ETL users streamed analytics EMR ODS Kafka S3 users users HVR Strengths

globally – Customer count and revenue growing – Pivotal engineering investment growing – 9 Greenplum Database releases in 2016 – Open source code contribution growing – 1417 commits to the github repo of Greenplum 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 Greenplum Database Overview • Massively Parallel Processing (MPP) database system – Scales out to hundreds(*) of nodes • Shared nothing architecture distribution – Random distribution 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 Greenplum Database Architecture Client Interconnect MPP Segment Host MPP Master Host ? Synch Process Standby

meet their DMSA requirements, and Pivotal Greenplum’s strong capabilities here as an MPP relational database are well-showcased 12 Pivotal Confidential–Internal Use Only 卓越的OLAP特性 列式存储 分区、压缩 高级特性

Documentation 140 Welcome to Tanzu Greenplum 6 140 Differences Compared to Open Source Greenplum Database 140 Server Documentation 141 Client Documentation 141 Related Documentation 141 Related Products in Greenplum 6 220 Additional Contrib Modules 221 PXF Version 5.8.1 221 Additional Greenplum Database Features 221 Greenplum 6.0 Beta Features 222 Changed Features 222 Removed Features 228 Deprecated 260 Installing the Greenplum Database Software 260 Installing the Greenplum Database Software 261 Installing Greenplum Database 261 Downloading the Greenplum Database Server Software (VMware Tanzu

Documentation 139 Welcome to Tanzu Greenplum 6 139 Differences Compared to Open Source Greenplum Database 139 Server Documentation 140 Client Documentation 140 Related Documentation 140 Related Products in Greenplum 6 212 Additional Contrib Modules 213 PXF Version 5.8.1 213 Additional Greenplum Database Features 213 Greenplum 6.0 Beta Features 214 Changed Features 214 Removed Features 220 Deprecated User 252 Next Steps 253 Installing the Greenplum Database Software 253 Installing the Greenplum Database Software 0 Installing Greenplum Database 254 (Optional) Installing to a Non-Default Directory

Greenplum 6 154 Known Issues and Limitations 154 Differences Compared to Open Source Greenplum Database 160 Installing and Upgrading Greenplum 161 VMware Greenplum v6.17 Documentation VMware, Inc. User 185 Next Steps 187 Installing the Greenplum Database Software 187 Installing the Greenplum Database Software 0 Installing Greenplum Database 187 (Optional) Installing to a Non-Default Directory Directory 189 Enabling Passwordless SSH 190 Confirming Your Installation 191 About Your Greenplum Database Installation 191 Next Steps 192 Creating the Data Storage Areas 192 Creating the Data Storage

Documentation 129 Welcome to VMware Greenplum 7 129 Differences Compared to Open Source Greenplum Database 129 Server Documentation 130 Client Documentation 130 Related Documentation 131 VMware Greenplum Features 132 Changed Features 134 External Tables 134 Database Utilities 134 Additional Supplied Modules and Extensions 134 SQL Commands 135 Database Maintenance 136 System Functions, Catalog Tables and 152 Network 152 Storage 153 Azure Recommendations 153 Coordinator 153 Segments 153 Greenplum Database Concepts 154 VMware Greenplum 7 Documentation VMware by Broadcom 4 About the Greenplum Architecture

Documentation 131 Welcome to Tanzu Greenplum 6 131 Differences Compared to Open Source Greenplum Database 131 Server Documentation 132 Client Documentation 132 Related Documentation 132 Related Products in Greenplum 6 217 Additional Contrib Modules 218 PXF Version 5.8.1 218 Additional Greenplum Database Features 218 Greenplum 6.0 Beta Features 219 Changed Features 219 Removed Features 225 Deprecated the Greenplum Database Software 258 Installing Greenplum Database 258 Downloading the Greenplum Database Server Software (VMware Tanzu Greenplum) 259 Verifying the Greenplum Database Software (VMware

Documentation 140 Welcome to VMware Greenplum 140 Differences Compared to Open Source Greenplum Database 140 Server Documentation 141 Client Documentation 141 Related Documentation 142 VMware Greenplum Processing 144 Release 6.27.0 144 Features 144 Resolved Issues 145 Server 145 Query Processing 146 Database Utilities 146 Cluster Management 146 Additional Supplied Modules and Extensions 146 Release 6 in Greenplum 6 272 Additional Contrib Modules 273 PXF Version 5.8.1 273 Additional Greenplum Database Features 273 Greenplum 6.0 Beta Features 274 Changed Features 274 Removed Features 280 Deprecated