VMware Greenplum 7 Documentation VMware Greenplum 7 You can find the most up-to-date technical documentation on the VMware by Broadcom website at: https://docs.vmware.com/ VMware by Broadcom 3401 Hillview trademark information. VMware Greenplum 7 Documentation VMware by Broadcom 2 Contents VMware Greenplum® 7 Documentation 129 Welcome to VMware Greenplum 7 129 Differences Compared to Open Source Greenplum 129 Server Documentation 130 Client Documentation 130 Related Documentation 131 VMware Greenplum 7.x Release Notes 132 Release 7.0 132 Key New Features 132 Changed Features 134 External Tables 134

Confidential │ ©2021 VMware, Inc. 3 Confidential │ ©2021 VMware, Inc. Brin Index 在Greenplum 7中的 理论与实践 陈金豹，VMWare内核工程师 Confidential │ ©2021 VMware, Inc. 目录 Brin Index On Heap AppendOnly Table │ ©2021 VMware, Inc. Block Range Index 存储数据块中元组字段的最 大最小值，用于过滤不符合条 件的数据块 1 3 2 5 7 8 8 10 9 11 11 12 [1, 5] [7, 10] [9, 12] Brin Heap Confidential │ ©2021 VMware, Inc. Brin的优势和劣势 优势： 占用空间小 Brin tuple: 20bytes Block Range: 8K * 20 = 160K Brin比Heap小8000倍 1 TB的Heap表只需要125M的Brin [1, 5] [7, 10] [9, 12] Brin Block Rang Confidential │ ©2021 VMware, Inc. Brin的选择率 BlockNum: B = 1000

Processing 190 Cluster Management 190 Data Flow 190 VMware Greenplum 6 Documentation VMware by Broadcom 7 Extensions 191 Release 6.20 191 Release 6.20.5 191 Resolved Issues 191 Query Optimizer 191 Server VMware Greenplum 482 Prerequisites 482 Procedure 482 Migrating VMware Greenplum from Enterprise Linux 7 to 8 or 9 484 Important Upgrade Considerations 484 Upgrade Methods 487 Greenplum Copy Utility 487 PGCLIENTENCODING 499 Example Ansible Playbook 500 Ansible Playbook - Greenplum Database Installation for CentOS 7 501 Greenplum Database Security Configuration Guide 503 VMware Greenplum 6 Documentation VMware by

185 Changed Features 185 Resolved Issues 185 VMware Tanzu Greenplum 6 Documentation VMware, Inc 7 Release 6.14.0 186 Features 186 Resolved Issues 186 Release 6.13 188 Release 6.13.0 188 Features PGCLIENTENCODING 476 Example Ansible Playbook 476 Ansible Playbook - Greenplum Database Installation for CentOS 7 477 Greenplum Database Security Configuration Guide 479 Securing the Database 480 Accessing a Kerberized Hadoop Distributed File Server 609 Example 6—Multiple files in CSV format with header rows 609 Example 7—Readable External Web Table with Script 610 Example 8—Writable External Table with gpfdist 610 Example

Cluster Management 185 Postgres Query Planner 186 VMware Greenplum 6 Documentation VMware, Inc 7 Release 6.16 186 Release 6.16.3 186 Resolved Issues 186 Server 186 Analyze 187 Release 6.16.2 PGCLIENTENCODING 495 Example Ansible Playbook 495 Ansible Playbook - Greenplum Database Installation for CentOS 7 496 Greenplum Database Security Configuration Guide 498 Securing the Database 499 Accessing a Kerberized Hadoop Distributed File Server 632 Example 6—Multiple files in CSV format with header rows 632 Example 7—Readable External Web Table with Script 632 Example 8—Writable External Table with gpfdist 632 Example

Features 180 Resolved Issues 180 Release 6.14 181 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 7 Release 6.14.1 181 Changed Features 181 Resolved Issues 182 Release 6.14.0 182 Features 182 Resolved PGCLIENTENCODING 473 Example Ansible Playbook 473 Ansible Playbook - Greenplum Database Installation for CentOS 7 474 Greenplum Database Security Configuration Guide 477 VMware Tanzu Greenplum 6 Documentation VMware Hadoop Distributed File Server 606 Example 6—Multiple files in CSV format with header rows 607 Example 7—Readable External Web Table with Script 607 Example 8—Writable External Table with gpfdist 607 Example

Features 177 Resolved Issues 178 Release 6.9 179 VMware Tanzu Greenplum 6 Documentation VMware, Inc 7 Release 6.9.1 180 Resolved Issues 180 Release 6.9.0 180 Features 180 Resolved Issues 180 Release PGCLIENTENCODING 401 Example Ansible Playbook 401 Ansible Playbook - Greenplum Database Installation for CentOS 7 402 Greenplum Database Security Configuration Guide 404 Securing the Database 404 Accessing a Kerberized Hadoop Distributed File Server 519 Example 6—Multiple files in CSV format with header rows 520 Example 7—Readable External Web Table with Script 520 Example 8—Writable External Table with gpfdist 520 Example

PostGIS 186 Release 6.19.2 186 Changed Features 186 VMware Greenplum 6 Documentation VMware, Inc. 7 Resolved Issues 186 Server 186 Query Optimizer 187 Cluster Management 187 Data Flow 187 Release PGCLIENTENCODING 471 Example Ansible Playbook 471 Ansible Playbook - Greenplum Database Installation for CentOS 7 472 Greenplum Database Security Configuration Guide 474 Securing the Database 475 Accessing a Kerberized Hadoop Distributed File Server 609 Example 6—Multiple files in CSV format with header rows 609 Example 7—Readable External Web Table with Script 609 Example 8—Writable External Table with gpfdist 610 Example

Features 196 Resolved Issues 196 Release 6.6 197 VMware Greenplum v6.19 Documentation VMware, Inc. 7 Release 6.6.0 197 Features 197 Resolved Issues 198 Release 6.5 198 Release 6.5.0 198 Features Playbook 314 Example Ansible Playbook 0 Ansible Playbook - Greenplum Database Installation for CentOS 7 315 Greenplum Database Cloud Technical Recommendations 317 Operating System 317 Storage 317 Security 808 Example 6—Multiple files in CSV format with header rows 0 Example 7—Readable External Web Table with Script 808 Example 7—Readable External Web Table with Script 0 Example 8—Writable External Table

Release 6.1.0 203 Features 203 Resolved Issues 205 VMware Greenplum v6.18 Documentation VMware, Inc. 7 Release 6.0 207 Release 6.0.1 207 Changed Features 207 Resolved Issues 207 Release 6.0.0 209 New Playbook 304 Example Ansible Playbook 0 Ansible Playbook - Greenplum Database Installation for CentOS 7 305 Greenplum Database Cloud Technical Recommendations 308 Operating System 308 Storage 308 Security 798 Example 6—Multiple files in CSV format with header rows 0 Example 7—Readable External Web Table with Script 799 Example 7—Readable External Web Table with Script 0 Example 8—Writable External Table