组成。基本组成部分的功能如下： 产品架构 Greenplum数据仓库 UDW Copyright © 2012-2021 UCloud 优刻得 7/206 1. Client：访问 UDW 的客⼾端 ⽀持通过 JDBC、ODBC、PHP、Python、命令⾏ Sql 等⽅式访问 UDW 2. Master Node：访问 UDW 数据仓库的⼊⼝ 接收客⼾端的连接请求 负责权限认证 处理 SQL 命令 调度分发执⾏计划 如上图所⽰客⼾端访问管理，提供了客⼾端下载和数据加载⼯具和⽂档的下载。 JDBC连接 连接 Linux操作系统 快速上⼿ Greenplum数据仓库 UDW Copyright © 2012-2021 UCloud 优刻得 17/206 yum install postgresql-jdbc.noarch –y Windows 环境下 JDBC 驱动，将 jar 添加到⼯程的 BUILD PATH。 Statement stmt = null; try { Class.forName("org.postgresql.Driver"); c = DriverManager.getConnection("jdbc:postgresql://hostIP:port/dbname",”UserName”,”Password”); stmt = c.createStatement(); String sql

type> 448 Using the ResultSetProvider Interface 449 Using the ResultSetHandle Interface 450 Using JDBC 451 Exception Handling 451 Savepoints 452 VMware Greenplum v6.19 Documentation VMware, Inc. 22 Kerberos Authentication 0 Mapping Kerberos Principals to Greenplum Database Roles 656 Configuring JDBC Kerberos Authentication for Greenplum Database 0 Installing and Configuring a Kerberos KDC Server DataDirect Driver Documentation 1969 DataDirect JDBC Driver for VMware Tanzu Greenplum 1970 VMware Greenplum v6.19 Documentation VMware, Inc. 137 DataDirect JDBC Driver for VMware Tanzu Greenplum 0 Prerequisites

Using the ResultSetHandle Interface 440 VMware Greenplum v6.18 Documentation VMware, Inc. 21 Using JDBC 441 Exception Handling 442 Savepoints 442 Logging 442 Security 0 Installation 443 Trusted Language Kerberos Authentication 0 Mapping Kerberos Principals to Greenplum Database Roles 647 Configuring JDBC Kerberos Authentication for Greenplum Database 0 Installing and Configuring a Kerberos KDC Server Documentation 1956 DataDirect JDBC Driver for VMware Tanzu Greenplum 1957 DataDirect JDBC Driver for VMware Tanzu Greenplum 0 Prerequisites 1957 Downloading the DataDirect JDBC Driver 1957 Obtaining Version

SETOF 443 Using the ResultSetProvider Interface 443 Using the ResultSetHandle Interface 444 Using JDBC 445 Exception Handling 446 Savepoints 446 Logging 446 Security 447 Installation 447 Trusted Kerberos Authentication 644 Mapping Kerberos Principals to Greenplum Database Roles 646 Configuring JDBC Kerberos Authentication for Greenplum Database 647 Installing and Configuring a Kerberos KDC Server 1984 DataDirect Driver Documentation 1986 DataDirect JDBC Driver for VMware Tanzu Greenplum 1986 Prerequisites 1986 Downloading the DataDirect JDBC Driver 1987 Obtaining Version Details for the Driver

type> 977 Using the ResultSetProvider Interface 978 Using the ResultSetHandle Interface 979 Using JDBC 980 Exception Handling 980 Savepoints 981 Logging 981 Security 981 Installation 982 Trusted Kerberos Authentication 1054 Mapping Kerberos Principals to Greenplum Database Roles 1055 Configuring JDBC Kerberos Authentication for Greenplum Database 1056 Installing and Configuring a Kerberos KDC Server 2416 DataDirect Driver Documentation 2417 DataDirect JDBC Driver for VMware Tanzu Greenplum 2418 Prerequisites 2418 Downloading the DataDirect JDBC Driver 2418 Obtaining Version Details for the Driver

VMware Greenplum 6 Documentation VMware, Inc. 42 Using the ResultSetHandle Interface 947 Using JDBC 948 Exception Handling 949 Savepoints 949 Logging 950 Security 950 Installation 950 Trusted Kerberos Authentication 1023 Mapping Kerberos Principals to Greenplum Database Roles 1024 Configuring JDBC Kerberos Authentication for Greenplum Database 1025 Installing and Configuring a Kerberos KDC Server 2371 DataDirect Driver Documentation 2372 DataDirect JDBC Driver for VMware Tanzu Greenplum 2373 Prerequisites 2373 Downloading the DataDirect JDBC Driver 2373 VMware Greenplum 6 Documentation VMware

SETOF 813 Using the ResultSetProvider Interface 813 Using the ResultSetHandle Interface 814 Using JDBC 815 Exception Handling 815 Savepoints 815 Logging 815 Security 816 Installation 816 VMware Tanzu Kerberos Authentication 878 Mapping Kerberos Principals to Greenplum Database Roles 880 Configuring JDBC Kerberos Authentication for Greenplum Database 881 Installing and Configuring a Kerberos KDC Server 1999 DataDirect Driver Documentation 2000 DataDirect JDBC Driver for VMware Tanzu Greenplum 2001 Prerequisites 2001 Downloading the DataDirect JDBC Driver 2001 Obtaining Version Details for the Driver

SETOF 965 Using the ResultSetProvider Interface 965 Using the ResultSetHandle Interface 966 Using JDBC 967 Exception Handling 967 Savepoints 968 Logging 968 Security 969 Installation 969 Trusted Kerberos Authentication 1040 Mapping Kerberos Principals to Greenplum Database Roles 1042 Configuring JDBC Kerberos Authentication for Greenplum Database 1043 Installing and Configuring a Kerberos KDC Server 2345 DataDirect Driver Documentation 2346 DataDirect JDBC Driver for VMware Tanzu Greenplum 2346 Prerequisites 2346 Downloading the DataDirect JDBC Driver 2347 Obtaining Version Details for the Driver

SETOF 935 Using the ResultSetProvider Interface 935 Using the ResultSetHandle Interface 936 Using JDBC 937 Exception Handling 937 Savepoints 938 Logging 938 Security 938 Installation 938 Trusted Kerberos Authentication 1009 Mapping Kerberos Principals to Greenplum Database Roles 1011 Configuring JDBC Kerberos Authentication for Greenplum Database 1012 Installing and Configuring a Kerberos KDC Server 2269 DataDirect Driver Documentation 2270 DataDirect JDBC Driver for VMware Tanzu Greenplum 2271 Prerequisites 2271 Downloading the DataDirect JDBC Driver 2271 Obtaining Version Details for the Driver

type> 930 Using the ResultSetProvider Interface 930 Using the ResultSetHandle Interface 931 Using JDBC 932 Exception Handling 932 Savepoints 933 Logging 933 Security 934 Installation 934 Trusted Kerberos Authentication 1004 Mapping Kerberos Principals to Greenplum Database Roles 1006 Configuring JDBC Kerberos Authentication for Greenplum Database 1007 Installing and Configuring a Kerberos KDC Server 2281 DataDirect Driver Documentation 2282 DataDirect JDBC Driver for VMware Tanzu Greenplum 2283 Prerequisites 2283 Downloading the DataDirect JDBC Driver 2283 Obtaining Version Details for the Driver