MPP 架构，适⽤于海量数据的存储和计算。UDW 的架构如上图所⽰，主要有 Client、Master Node 和 Compute Node 组成。基本组成部分的功能如下： 产品架构 Greenplum数据仓库 UDW Copyright © 2012-2021 UCloud 优刻得 7/206 1. Client：访问 UDW 的客⼾端 ⽀持通过 JDBC、ODBC、PHP、Python、命令⾏ com/greenplum-client.tar tar -zxvf greenplum-client.tar.gz 2）配置udw客⼾端 进⼊ greenplum-client 安装⽬录，编辑 greenplum_client_path.sh 修改UDW_HOME(export UDW_HOME= client安装⽬录)（如/root/greenplum-client） 3） 使配置⽣效 在~/ 在~/.bashrc中添加如下配置 source /data/greenplum-client/greenplum\_client\_path.sh 执⾏ source ~/.bashrc 备注：/data/greenplum-client是greenplum-client的安装路径 4） 连接数据库 psql -h hostIP（或域名） –U username -d database

Greenplum 130 Differences Compared to Open Source Greenplum Database 130 Server Documentation 131 Client Documentation 131 Related Documentation 131 Related Products 131 VMware Tanzu Greenplum 6.x Release Data Domain Boost (VMware Greenplum) 260 VMware Greenplum Tools and Extensions Compatibility 260 Client Tools 260 Extensions 261 Data Connectors 261 VMware Greenplum Text 262 Greenplum Command Center Variables 437 To set up the gpadmin environment for Greenplum Database 438 Next Steps 438 Allowing Client Connections 439 Creating Databases and Loading Data 439 Installing Optional Extensions (VMware

Greenplum 140 Differences Compared to Open Source Greenplum Database 140 Server Documentation 141 Client Documentation 141 Related Documentation 142 VMware Greenplum 6.x Release Notes 143 Upgrading Greenplum 286 Software Dependencies 287 Java 290 VMware Greenplum Tools and Extensions Compatibility 290 Client Tools 290 Extensions 290 Data Connectors 291 VMware Greenplum Text 292 Greenplum Command Center Variables 431 To set up the gpadmin environment for Greenplum Database 431 Next Steps 432 Allowing Client Connections 432 Creating Databases and Loading Data 432 Installing Optional Extensions (VMware

Greenplum 130 Differences Compared to Open Source Greenplum Database 130 Server Documentation 131 Client Documentation 131 Related Documentation 131 Related Products 131 VMware Tanzu Greenplum 6.x Release Data Domain Boost (Tanzu Greenplum) 252 Tanzu Greenplum Tools and Extensions Compatibility 252 Client Tools 252 Extensions 253 Data Connectors 253 Tanzu Greenplum Text 254 Greenplum Command Center VMware, Inc 17 To set up the gpadmin environment for Greenplum Database 423 Next Steps 423 Allowing Client Connections 424 Creating Databases and Loading Data 424 Installing Optional Extensions (Tanzu Greenplum)

Greenplum 136 Differences Compared to Open Source Greenplum Database 136 Server Documentation 137 Client Documentation 137 Related Documentation 137 VMware Greenplum 6.x Release Notes 139 Upgrading Greenplum Greenplum on DCA Systems 277 Storage 278 VMware Greenplum Tools and Extensions Compatibility 278 Client Tools 278 Extensions 279 Data Connectors 279 VMware Greenplum Text 281 Greenplum Command Center Variables 412 To set up the gpadmin environment for Greenplum Database 413 Next Steps 413 Allowing Client Connections 413 Creating Databases and Loading Data 414 Installing Optional Extensions (VMware

Greenplum 131 Differences Compared to Open Source Greenplum Database 131 Server Documentation 132 Client Documentation 132 Related Documentation 132 Related Products 132 VMware Tanzu Greenplum 6.x Release Data Domain Boost (Tanzu Greenplum) 248 Tanzu Greenplum Tools and Extensions Compatibility 248 Client Tools 248 Extensions 249 Data Connectors 250 Tanzu Greenplum Text 251 Greenplum Command Center Variables 420 To set up the gpadmin environment for Greenplum Database 420 Next Steps 421 Allowing Client Connections 421 Creating Databases and Loading Data 421 Installing Optional Extensions (Tanzu Greenplum)

Greenplum 127 Differences Compared to Open Source Greenplum Database 127 Server Documentation 128 Client Documentation 128 Related Documentation 128 Related Products 128 VMware Tanzu Greenplum 6.x Release Data Domain Boost (Tanzu Greenplum) 225 Tanzu Greenplum Tools and Extensions Compatibility 225 Client Tools 226 Extensions 226 Data Connectors 227 Tanzu Greenplum Text 228 Greenplum Command Center Variables 357 To set up the gpadmin environment for Greenplum Database 357 Next Steps 358 Allowing Client Connections 358 Creating Databases and Loading Data 358 Installing Optional Extensions (Tanzu Greenplum)

Greenplum 6 140 Differences Compared to Open Source Greenplum Database 140 Server Documentation 141 Client Documentation 141 Related Documentation 141 Related Products 141 Platform Requirements 142 Platform 146 Data Domain Boost (Tanzu Greenplum) 146 Tanzu Greenplum Tools and Extensions Compatibility 0 Client Tools 147 Extensions 147 Data Connectors 148 Tanzu Greenplum Text 149 Greenplum Command Center Variables 275 To set up the gpadmin environment for Greenplum Database 276 Next Steps 276 Allowing Client Connections 277 Creating Databases and Loading Data 277 Installing Optional Extensions (Tanzu Greenplum)

Greenplum 6 139 Differences Compared to Open Source Greenplum Database 139 Server Documentation 140 Client Documentation 140 Related Documentation 140 Related Products 140 Platform Requirements 141 Platform 145 Data Domain Boost (Tanzu Greenplum) 145 Tanzu Greenplum Tools and Extensions Compatibility 0 Client Tools 146 Extensions 146 Data Connectors 147 Tanzu Greenplum Text 148 Greenplum Command Center Variables 267 To set up the gpadmin environment for Greenplum Database 267 Next Steps 268 Allowing Client Connections 268 Creating Databases and Loading Data 268 VMware Greenplum v6.18 Documentation VMware

Tanzu™ Greenplum® 6.17 Documentation 134 Welcome to Tanzu Greenplum 6 134 Server Documentation 134 Client Documentation 134 Related Documentation 135 Related Products 135 Platform Requirements 136 Platform Greenplum on DCA Systems 139 Storage 140 Data Domain Boost 140 Tools and Extensions Compatibility 140 Client Tools 141 Extensions 141 Data Connectors 142 Tanzu Greenplum Text 143 Greenplum Command Center Variables 200 To set up the gpadmin environment for Greenplum Database 201 Next Steps 202 Allowing Client Connections 202 Creating Databases and Loading Data 202 Installing Optional Extensions 202 Installing