Greenplum数据仓库UDW - UCloud中立云计算服务商
实际可⽤总容量略⼩于节点个数*节点磁盘⼤⼩/2,请根据实际数据⼤⼩选择合适的节点。 3.设置数据仓库信息 必选项有数据仓库名称、DB管理员⽤⼾名、管理员密码。可选项有默认DB,默认DB的名称为dev,你可以选择除了“test”、“postgres”、“template”、“template0”、“template1” 、 “default”之外的其他名称。 DB管理员⽤⼾名不能为“postgres”。端⼝固定为 5432,暂不提供修改。 我们可以⽤copy快速加载⽂件数据到udw。具体语法如下: 数据导⼊ Greenplum数据仓库 UDW Copyright © 2012-2021 UCloud 优刻得 73/206 cat /data/test.dat | psql -h hostIP -U UserName -d DB -c "COPY employee from STDIN with CSV DELIMITER '|';" hostIP:udw访问id DISTRIBUTED RANDOMLY; 修改分布策略: 1)分区策略修改为随机分布: alter table test set with (reorganize=true) distributed randomly; 2)分区策略修改为按照id的hash分布: alter table test set with (reorganize=true) distributed by (id); 开发指南0 码力 | 206 页 | 5.35 MB | 1 年前3VMware Greenplum 6 Documentation
Prerequisites 942 Install Docker 943 Install PL/Container 944 Install PL/Container Docker Images 945 Test the PL/Container Installation 947 Upgrade PL/Container 948 VMware Greenplum 6 Documentation VMware Greenplum Database has been updated to version 1.21.0. The gpcheckcat utility now includes a new test -- mix_distribution_policy -- which checks for tables created with legacy and non-legacy hash operations staging table name when the name was enclosed in double quotes. 13399 : Adds SSL connection regression test cases. Release 6.20.1 Release Date: 2022-03-25 VMware Greenplum 6.20.1 is a maintenance release0 码力 | 2445 页 | 18.05 MB | 1 年前3VMware Tanzu Greenplum v6.21 Documentation
Creating the Greenplum Template 313 Validating the Template 313 Creating a Test Virtual Machine 313 Verifying the Test Virtual Machine Settings 314 Allocating the Virtual Machines with Terraform 317 Prerequisites 787 Install Docker 787 Install PL/Container 788 Install PL/Container Docker Images 789 Test the PL/Container Installation 791 Upgrade PL/Container 792 Uninstall PL/Container 793 Uninstall staging table name when the name was enclosed in double quotes. 13399 Adds SSL connection regression test cases. Release 6.20.1 Release Date: 2022-03-25 VMware Tanzu Greenplum 6.20.1 is a maintenance release0 码力 | 2025 页 | 33.54 MB | 1 年前3VMware Greenplum 6 Documentation
Prerequisites 932 Install Docker 932 Install PL/Container 933 Install PL/Container Docker Images 935 Test the PL/Container Installation 937 Upgrade PL/Container 938 Uninstall PL/Container 939 Uninstall staging table name when the name was enclosed in double quotes. 13399 Adds SSL connection regression test cases. Release 6.20.1 Release Date: 2022-03-25 VMware Tanzu Greenplum 6.20.1 is a maintenance release where gpcheckcat returned the error invalid input syntax for integer during the orphaned_toast_tables test because the command did not correctly handle a temporary toast table. 12957 Resolves an issue where0 码力 | 2374 页 | 44.90 MB | 1 年前3VMware Tanzu Greenplum v6.23 Documentation
904 Install PL/Container Docker Images 905 VMware Tanzu Greenplum 6 Documentation VMware, Inc 39 Test the PL/Container Installation 907 Upgrade PL/Container 908 Uninstall PL/Container 909 Uninstall staging table name when the name was enclosed in double quotes. 13399 Adds SSL connection regression test cases. Release 6.20.1 Release Date: 2022-03-25 VMware Tanzu Greenplum 6.20.1 is a maintenance release where gpcheckcat returned the error invalid input syntax for integer during the orphaned_toast_tables test because the command did not correctly handle a temporary toast table. 12957 Resolves an issue where0 码力 | 2298 页 | 40.94 MB | 1 年前3VMware Greenplum v6.25 Documentation
Prerequisites 913 Install Docker 914 Install PL/Container 915 Install PL/Container Docker Images 916 Test the PL/Container Installation 918 Upgrade PL/Container 919 Uninstall PL/Container 920 Uninstall staging table name when the name was enclosed in double quotes. 13399 : Adds SSL connection regression test cases. Release 6.20.1 Release Date: 2022-03-25 VMware Greenplum 6.20.1 is a maintenance release where gpcheckcat returned the error invalid input syntax for integer during the orphaned_toast_tables test because the command did not correctly handle a temporary toast table. 12957 Resolves an issue where0 码力 | 2400 页 | 18.02 MB | 1 年前3VMware Greenplum v6.19 Documentation
429 Install PL/Container Docker Images 430 VMware Greenplum v6.19 Documentation VMware, Inc. 21 Test the PL/Container Installation 432 Upgrade PL/Container 434 Uninstall PL/Container 435 Uninstall must configure SELinux contexts, policies, and domains based on your security requirements, and test your configuration to ensure there is no functionality or performance impact to Greenplum Database where gpcheckcat returned the error invalid input syntax for integer during the orphaned_toast_tables test because the command did not correctly handle a VMware Greenplum v6.19 Documentation VMware, Inc0 码力 | 1972 页 | 20.05 MB | 1 年前3VMware Tanzu Greenplum 6 Documentation
Prerequisites 901 Install Docker 901 Install PL/Container 902 Install PL/Container Docker Images 903 Test the PL/Container Installation 905 Upgrade PL/Container 907 Uninstall PL/Container 908 Uninstall staging table name when the name was enclosed in double quotes. 13399 : Adds SSL connection regression test cases. VMware Tanzu Greenplum 6 Documentation VMware, Inc. 150 Release 6.20.1 Release Date: 2022-03-25 where gpcheckcat returned the error invalid input syntax for integer during the orphaned_toast_tables test because the command did not correctly handle a temporary toast table. 12957 Resolves an issue where0 码力 | 2311 页 | 17.58 MB | 1 年前3VMware Greenplum v6.18 Documentation
VMware, Inc. 20 Install Docker 419 Install PL/Container 420 Install PL/Container Docker Images 421 Test the PL/Container Installation 423 Upgrade PL/Container 424 Uninstall PL/Container 425 Uninstall must configure SELinux contexts, policies, and domains based on your security requirements, and test your configuration to ensure there is no functionality or performance impact to Greenplum Database the use of pkill -f in gpcheckperf. 178761563 : Removes unrelated output message regarding netperf test, that was shown when running gpcheckperf -r N. 178637128 : Fixes the issue of the missing --help0 码力 | 1959 页 | 19.73 MB | 1 年前3VMware Greenplum v6.17 Documentation
Prerequisites 354 Install Docker 354 Install PL/Container 355 Install PL/Container Docker Images 356 Test the PL/Container Installation 358 Upgrade PL/Container 359 Uninstall PL/Container 360 Uninstall must configure SELinux contexts, policies, and domains based on your security requirements, and test your configuration to ensure there is no functionality or performance impact to Greenplum Database context. If you require increased SELinux confinement for Greenplum processes and users, you must test your configuration to ensure that there are no functionality or performance impacts to Greenplum0 码力 | 1893 页 | 17.62 MB | 1 年前3
共 19 条
- 1
- 2