datax,csv,load,copy Ø 数据同步结果确认与显示 • 数据同步方式 Ø gpfdist+外部表 ： UMGW大表 Ø db_sync同步程序 ： 底层库 + 同步逻辑 + Django界面 Ø 临时同步需求： datax , copy 29 Greenplum运维体系 数据库数据传输与同步-db_sync 30 Greenplum运维体系 数据库数据传输与同步-db_sync

存储平台：每台X4500中各48块500GB硬盘，共96 * 500GB – 网络平台：每台X4500和X4200上各有4块千兆网卡 – 软件平台：Solaris 10 ＋ GreenPlum v3.1 Beta – 应用软件：SQL语句 • 数据导入测试 – A - 67858566 rows – B - 80088742 rows – C - 372844366 rows – D - 75042462

​name student_name​,​ c​.​classname FROM students s​,​ classes c WHERE s​.​id​=​c​.​student_id 3.1 查询计划 其对应的查询计划如下所示： test=# explain SELECT s.name student_name, c.classname test-# FROM students

Server Version HBase Server Version 5.15.0, 5.14.0, 5.13.0, 5.12.0, 5.11.1, 5.10.1 2.x, 3.1+ 1.x, 2.x, 3.1+ 1.3.2 5.8.2 2.x 1.x 1.3.2 5.8.1 2.x 1.x 1.3.2 Note: Tanzu Greenplum 6 does not support Hadoop 2.x and 3.1.x and Hive Server 2.x and 3.1, and bundles new and upgraded Hadoop libraries to support these versions. PXF supports Kerberos authentication to Hive Server 2.x and 3.1.x. PXF supports -----------------------------------------------+---------- Neutrinos in the Sun | 3.1 The Sudbury Neutrino Detector | 2.4 A MACHO View of Galactic Dark Matter

Server Version HBase Server Version 6.x, 5.15.x, 5.14.0, 5.13.0, 5.12.0, 5.11.1, 5.10.1 2.x, 3.1+ 1.x, 2.x, 3.1+ 1.3.2 5.8.2 2.x 1.x 1.3.2 5.8.1 2.x 1.x 1.3.2 Note: Tanzu Greenplum 6 does not support Hadoop 2.x and 3.1.x and Hive Server 2.x and 3.1, and bundles new and upgraded Hadoop libraries to support these versions. PXF supports Kerberos authentication to Hive Server 2.x and 3.1.x. PXF supports -----------------------------------------------+---------- Neutrinos in the Sun | 3.1 The Sudbury Neutrino Detector | 2.4 A MACHO View of Galactic Dark Matter

Hadoop 2.x and 3.1.x and Hive Server 2.x and 3.1, and bundles new and upgraded Hadoop libraries to support these versions. PXF supports Kerberos authentication to Hive Server 2.x and 3.1.x. PXF supports Server Version HBase Server Version 6.x, 5.15.x, 5.14.0, 5.13.0, 5.12.0, 5.11.1, 5.10.1 2.x, 3.1+ 1.x, 2.x, 3.1+ 1.3.2 5.8.2 2.x 1.x 1.3.2 5.8.1 2.x 1.x 1.3.2 VMware vSphere Requirements In order to -----------------------------------------------+---------- Neutrinos in the Sun | 3.1 The Sudbury Neutrino Detector | 2.4 A MACHO View of Galactic Dark Matter

Server Version HBase Server Version 6.x, 5.15.x, 5.14.0, 5.13.0, 5.12.0, 5.11.1, 5.10.1 2.x, 3.1+ 1.x, 2.x, 3.1+ 1.3.2 5.8.2 2.x 1.x 1.3.2 5.8.1 2.x 1.x 1.3.2 Note: If you plan to access JSON format data Hadoop 2.x and 3.1.x and Hive Server 2.x and 3.1, and bundles new and upgraded Hadoop libraries to support these versions. PXF supports Kerberos authentication to Hive Server 2.x and 3.1.x. PXF supports -----------------------------------------------+---------- Neutrinos in the Sun | 3.1 The Sudbury Neutrino Detector | 2.4 A MACHO View of Galactic Dark Matter

for more information about this feature. PXF is now certified with Hadoop 2.x and 3.1.x and Hive Server 2.x and 3.1, and bundles new and upgraded Hadoop libraries to support these versions. VMware Tanzu Greenplum 6 Documentation VMware, Inc 197 PXF supports Kerberos authentication to Hive Server 2.x and 3.1.x. PXF supports per-server user impersonation configuration. PXF supports concurrent access to multiple Server Version HBase Server Version 6.x, 5.15.x, 5.14.0, 5.13.0, 5.12.0, 5.11.1, 5.10.1 2.x, 3.1+ 1.x, 2.x, 3.1+ 1.3.2 5.8.2 2.x 1.x 1.3.2 5.8.1 2.x 1.x 1.3.2 Note: If you plan to access JSON format data

Hadoop 2.x and 3.1.x and Hive Server 2.x and 3.1, and bundles new and upgraded Hadoop libraries to support these versions. PXF supports Kerberos authentication to Hive Server 2.x and 3.1.x. PXF supports Server Version HBase Server Version 6.x, 5.15.x, 5.14.0, 5.13.0, 5.12.0, 5.11.1, 5.10.1 2.x, 3.1+ 1.x, 2.x, 3.1+ 1.3.2 5.8.2 2.x 1.x 1.3.2 5.8.1 2.x 1.x 1.3.2 Public Cloud Requirements Operating System -----------------------------------------------+---------- Neutrinos in the Sun | 3.1 The Sudbury Neutrino Detector | 2.4 A MACHO View of Galactic Dark Matter

Hadoop 2.x and 3.1.x and Hive Server 2.x and 3.1, and bundles new and upgraded Hadoop libraries to support these versions. PXF supports Kerberos authentication to Hive Server 2.x and 3.1.x. PXF supports Server Version HBase Server Version 6.x, 5.15.x, 5.14.0, 5.13.0, 5.12.0, 5.11.1, 5.10.1 2.x, 3.1+ 1.x, 2.x, 3.1+ 1.3.2 5.8.2 2.x 1.x 1.3.2 5.8.1 2.x 1.x 1.3.2 Note: If you plan to access JSON format data -----------------------------------------------+---------- Neutrinos in the Sun | 3.1 The Sudbury Neutrino Detector | 2.4 A MACHO View of Galactic Dark Matter