198 198 198 200 201 201 202 202 202 203 203 203 203 203 204 205 206 访问 Hive 访问 HBase 使⽤ 使⽤ pg_dump 迁移数据 迁移数据 安装 greenplum-db-clients 使⽤ pg_dump 导出数据 使⽤ psql 重建数据 利⽤ 利⽤ hdfs 外部表迁移数据 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） 使配置⽣效 在~/

来的迁移代价，而开发、运维人员无需要学 习新的数据库处理技术，人力成本也能够大大降低。 ● 处理和分析各种数据源的数据的平台：支持各种数据源，包括 Kafka、Hadoop、HIVE、 HBase、S3、Gemfire、各种数据库和文件等，不需要移动数据，避免了数据加载的复杂 性，和其带来的数据不一致的问题。 ● 支持各种数据格式的平台：不管是结构化、半结构化（XML、JSON、KV）还是非结构化，

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

Greenplum 6 131 Differences Compared to Open Source Greenplum Database 131 Server Documentation 132 Client Documentation 132 Related Documentation 132 Related Products 132 Platform Requirements 134 Operating Data Domain Boost (Tanzu Greenplum) 138 Tanzu Greenplum Tools and Extensions Compatibility 138 Client Tools 138 Extensions 139 Data Connectors 140 Tanzu Greenplum Text 141 Greenplum Command Center Variables 272 To set up the gpadmin environment for Greenplum Database 272 Next Steps 273 Allowing Client Connections 273 Creating Databases and Loading Data 273 Installing Optional Extensions (Tanzu Greenplum)

再进一步看，Master-Slave 架构在业界的大数据分布式计算和云计 算体系中被广泛应用，大家可以看到，现在主流分布式系统都是采 用 Master-Slave 架 构， 包 括：Hadoop FS、Hbase、MapReduce、 Storm、Mesos...... 无一例外都是 Master-Slave 架构。相反，采用 MultipleActive Master 的软件系统，需要消耗更多资源和机制来保证

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)