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 数据库 Master 电邮： miaochen@mail.ustc.edu.cn Greenplum Database 管理员指南 V6.2.1 版权所有：Esena(陈淼 +86 18616691889) 编写：陈淼 - 3 - 目录 Greenplum Database 管理员指南 ......................................................

性能优势，我们强烈建议用户将库外的处理逻辑，部署到用 MPP 数 据库的 UDF 这种 In-Database 的方式来处理，你将获得意想不到的性 能和方便性；例如我们在某客户实现的数据转码、数据脱敏等，只需 要简单的改写原有代码后部署到 GP 中，通过并行计算获得数十倍性 能提高。 另外，GPTEXT（lucent 全文检索）、Apache Madlib（开源挖掘算法）、 SAS algorithm、R 都是通过 语句的注意事项： 1) 要注意使用 LeftJoin(Right Join 类似 ) 的场景。避免大表 Hash。 此场景会导致执行计划将右边的大表 Hash 到内存中，有时是性能 拖累。应该将 SQL 改写为如下形式： 原 SQL：selects.*,b.xxx from small s left join big b on s.id=b.id 修改： select s.*,b.xxx from small （Protegrity 执行点）服务器流程。这也意味着 Greenplum 集群内的 所有服务器都应能够到达 Protegrity ESA 服务器，无论其是否联网。 Protegrity 可提供一份安装指南《Protegrity 数据库保护器 - Pivotal Greenplum》。该文件列明了在 Greenplum 主档和节点上安装 PEP 服务器所需执行的步骤，它还包含应该如何导入 Greenplum

44 45 46 47 ⽬录 ⽬录 ⽬录 ⽬录 概览 概览 产品架构 产品架构 云数据仓库产品架构 ⾼可⽤ 快速上⼿ 快速上⼿ ⼀、创建数据仓库 ⼆、连接数据仓库 操作指南 操作指南 关闭数据仓库 启动数据仓库 重启数据仓库 查看数据仓库详情 扩容数据仓库 更改数据仓库密码 续费 删除数据仓库 查看操作⽇志 查看监控 ⽬录 Greenplum数据仓库 UDW 数据导⼊ 数据导⼊ insert加载数据 copy加载数据 外部表并⾏加载数据 从hdfs加载数据 从mysql中导⼊数据 从oracle中导⼊数据 从ufile加载数据 开发指南 开发指南 1、连接数据库 2、数据库管理 3、模式管理 4、表格设计 5、加载数据 6、分区表 7、序列 8、索引 9、 ANALYZE/VACUUM 10、常⽤SQL⼤全 12、常⽤SQL命令 132 132 132 139 139 139 141 142 146 152 152 163 177 177 183 190 190 191 192 udw优化指南 表膨胀 表膨胀 表膨胀的原因 如何避免表膨胀 UDW中 中Json类型 类型 Json相关操作 Json操作举例 Json相关函数 Json创建函数 Json处理函数 接⼊第三⽅

Protocol 0 Configuring the s3 Protocol 792 Using s3 External Tables 793 About the s3 Protocol LOCATION URL 794 About Reading and Writing S3 Data Files 795 s3 Protocol AWS Server-Side Encryption Support 796 External Web Tables 804 Creating and Using External Web Tables 0 Command-based External Web Tables 804 URL-based External Web Tables 805 Examples for Creating External Tables 805 Examples for Creating External can use this option in the CREATE EXTERNAL TABLE LOCATION clause to specify the http/https server URL from which Greenplum Database obtains the s3 protocol configuration file. gpload adds a NEWLINE property

781 Configuring the s3 Protocol 782 Using s3 External Tables 782 About the s3 Protocol LOCATION URL 783 About Reading and Writing S3 Data Files 785 s3 Protocol AWS Server-Side Encryption Support 786 Table Data 792 Creating and Using External Web Tables 793 Command-based External Web Tables 793 URL-based External Web Tables 794 Examples for Creating External Tables 794 Example 1—Single gpfdist can use this option in the CREATE EXTERNAL TABLE LOCATION clause to specify the http/https server URL from which Greenplum Database obtains the s3 protocol configuration file. gpload adds a NEWLINE property

Protocol 783 s3:// Protocol 0 Configuring and Using S3 External Tables 783 About the S3 Protocol URL 785 About S3 Data Files 786 s3 Protocol AWS Server-Side Encryption Support 787 s3 Protocol Proxy External Web Tables 795 Creating and Using External Web Tables 0 Command-based External Web Tables 795 URL-based External Web Tables 796 Examples for Creating External Tables 796 Examples for Creating External Science Library Package. 1. For an R package, identify all dependent R packages and each package web URL. The information can be found by selecting the given package from the following navigation page:

Protocol 715 s3:// Protocol 0 Configuring and Using S3 External Tables 715 About the S3 Protocol URL 717 About S3 Data Files 718 s3 Protocol AWS Server-Side Encryption Support 719 s3 Protocol Proxy External Web Tables 727 Creating and Using External Web Tables 0 Command-based External Web Tables 727 URL-based External Web Tables 728 Examples for Creating External Tables 728 Examples for Creating External Science Library Package. 1. For an R package, identify all dependent R packages and each package web URL. The information can be found by selecting the given package from the following navigation page:

621 Configuring the s3 Protocol 622 Using s3 External Tables 623 About the s3 Protocol LOCATION URL 624 About Reading and Writing S3 Data Files 626 s3 Protocol AWS Server-Side Encryption Support 626 Table Data 634 Creating and Using External Web Tables 634 Command-based External Web Tables 635 URL-based External Web Tables 635 Examples for Creating External Tables 636 Example 1—Single gpfdist can use this option in the CREATE EXTERNAL TABLE LOCATION clause to specify the http/https server URL from which Greenplum Database obtains the s3 protocol configuration file. gpload adds a NEWLINE property

505 Configuring the s3 Protocol 506 Using s3 External Tables 506 About the s3 Protocol LOCATION URL 507 About Reading and Writing S3 Data Files 509 s3 Protocol AWS Server-Side Encryption Support 509 Table Data 516 Creating and Using External Web Tables 516 Command-based External Web Tables 516 URL-based External Web Tables 517 Examples for Creating External Tables 517 Example 1—Single gpfdist can use this option in the CREATE EXTERNAL TABLE LOCATION clause to specify the http/https server URL from which Greenplum Database obtains the s3 protocol configuration file. gpload adds a NEWLINE property

615 Configuring the s3 Protocol 616 Using s3 External Tables 616 About the s3 Protocol LOCATION URL 618 About Reading and Writing S3 Data Files 619 s3 Protocol AWS Server-Side Encryption Support 620 Table Data 628 Creating and Using External Web Tables 628 Command-based External Web Tables 628 URL-based External Web Tables 629 Examples for Creating External Tables 629 Example 1—Single gpfdist can use this option in the CREATE EXTERNAL TABLE LOCATION clause to specify the http/https server URL from which Greenplum Database obtains the s3 protocol configuration file. gpload adds a NEWLINE property