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 管理员指南 .............................................

互联网 其它 Teradata Netezza Oracle Greenplum Neoview Vertica Paraccel Aster Data Hadoop Current Database Vendor Landscape Proven Enterprise Grade Capabilities No Enterprise Credibility Aging Proprietary 最先将SQL和Map-Reduce的功能整合到统一的数 据处理框架中 • 可以帮助企业采集所有数据，并在竞争中获得出色 的洞察力 41 Parallel Dataflow Engine • General purpose parallel-dataflow engine natively executes SQL & MapReduce • Optimized for commodity compute, storage FC connected storage Local compute Local storage gNet Interconnect Greenplum Parallel Dataflow Engine gNet Software Interconnect • Supercomputing-based “soft switch” interconnect • Utilizes commodity

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

Documentation 130 Welcome to Tanzu Greenplum 130 Differences Compared to Open Source Greenplum Database 130 Server Documentation 131 Client Documentation 131 Related Documentation 131 Related Products in Greenplum 6 240 Additional Contrib Modules 241 PXF Version 5.8.1 241 Additional Greenplum Database Features 241 VMware Greenplum 6 Documentation VMware, Inc 10 Greenplum 6.0 Beta Features 242 Memory 268 Network 268 Storage 268 Azure Recommendations 269 Master 269 Segments 269 Greenplum Database Concepts 270 About the Greenplum Architecture 270 About the Greenplum Master 272 Master Redundancy

Documentation 136 Welcome to VMware Greenplum 136 Differences Compared to Open Source Greenplum Database 136 Server Documentation 137 Client Documentation 137 Related Documentation 137 VMware Greenplum PXF Version 5.8.1 260 VMware Greenplum 6 Documentation VMware, Inc. 12 Additional Greenplum Database Features 260 Greenplum 6.0 Beta Features 260 Changed Features 261 Removed Features 267 Deprecated Memory 286 Network 286 Storage 286 Azure Recommendations 287 Master 287 Segments 287 Greenplum Database Concepts 288 About the Greenplum Architecture 288 About the Greenplum Master 290 Master Redundancy

Documentation 130 Welcome to Tanzu Greenplum 130 Differences Compared to Open Source Greenplum Database 130 Server Documentation 131 Client Documentation 131 Related Documentation 131 Related Products in Greenplum 6 233 Additional Contrib Modules 233 PXF Version 5.8.1 234 Additional Greenplum Database Features 234 Greenplum 6.0 Beta Features 234 Changed Features 235 Removed Features 241 Deprecated 255 VMware Tanzu Greenplum 6 Documentation VMware, Inc 10 Hadoop Distributions 255 Greenplum Database Cloud Technical Recommendations 255 Operating System 255 Storage 255 Security 256 Amazon Web

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 131 Differences Compared to Open Source Greenplum Database 131 Server Documentation 132 Client Documentation 132 Related Documentation 132 Related Products in Greenplum 6 230 Additional Contrib Modules 230 PXF Version 5.8.1 231 Additional Greenplum Database Features 231 Greenplum 6.0 Beta Features 231 Changed Features 232 Removed Features 238 Deprecated 250 Tanzu Greenplum Text 251 Greenplum Command Center 251 Hadoop Distributions 251 Greenplum Database Cloud Technical Recommendations 251 Operating System 251 Storage 252 Security 252 Amazon Web

Documentation 127 Welcome to Tanzu Greenplum 127 Differences Compared to Open Source Greenplum Database 127 Server Documentation 128 Client Documentation 128 Related Documentation 128 Related Products in Greenplum 6 208 Additional Contrib Modules 209 PXF Version 5.8.1 209 Additional Greenplum Database Features 209 Greenplum 6.0 Beta Features 210 Changed Features 210 Removed Features 216 Deprecated 227 Tanzu Greenplum Text 228 Greenplum Command Center 228 Hadoop Distributions 228 Greenplum Database Cloud Technical Recommendations 228 Operating System 228 Storage 228 Security 229 Amazon Web

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