file，gpfdist，PXF，S3等。本节将主要介绍常用的几种，关于其他协议，因为编 者目前无法进行测试，不做介绍，如有需要，可参考官方文档。 file 协议 file协议，通过URI来指向操作系统的文件。URI由主机名、文件所属的路径和 文件名组成，不需要指定端口号，因为访问的是GP各个计算节点的本地文件。文件所 在的位置，必须是初始化GP数据库的用户(按照管理，通常为gpadmin)可以访问的位 database for DETAIL: There isn't a valid primary segment database on host . . . LOCATION子句中可以有多个URI属性，用逗号分隔。例如： CREATE EXTERNAL TABLE test_ext (a int, b int, c text) LOCATION( 'file://mdw/tmp/file1*' 'text' (delimiter E'\x7c'); 在file协议中，URI中可以使用通配符或者C格式的模式匹配，来表示多个文件， 比如上例中，file1*表示所有以file1开头的文件，[2-4,6]表示2、3、4、6。 在LOCATION中指定的URI的数量，是Primary访问文件时的并行数，对于每一个 URI属性，数据库会根据主机名匹配gp_segment_configuration系统表中的

PXF. PXF no longer supports specifying a DELIMITER in the CREATE EXTERNAL TABLE command LOCATION URI. Additional Greenplum Database Features Greenplum Database 6.0 also includes these features and changes As the root user, edit the OpenLDAP configuration file /etc/openldap/ldap.conf: SASL_NOCANON on URI ldaps://ldapA.example.priv ldaps://ldapB.example.priv ldaps://ldapC.example.priv BASE dc=example For certificate validation to succeed, the hostname in the certificate must match a hostname in the URI property. Otherwise, you must also add TLS_REQCERT allow to the file. VMware Greenplum v6.18 Documentation

PXF. PXF no longer supports specifying a DELIMITER in the CREATE EXTERNAL TABLE command LOCATION URI. Additional Greenplum Database Features Greenplum Database 6.0 also includes these features and changes As the root user, edit the OpenLDAP configuration file /etc/openldap/ldap.conf: SASL_NOCANON on URI ldaps://ldapA.example.priv ldaps://ldapB.example.priv ldaps://ldapC.example.priv BASE dc=example,dc=priv For certificate validation to succeed, the hostname in the certificate must match a hostname in the URI property. Otherwise, you must also add TLS_REQCERT allow to the file. VMware Greenplum v6.19 Documentation

As the root user, edit the OpenLDAP configuration file /etc/openldap/ldap.conf: SASL_NOCANON on URI ldaps://ldapA.example.priv ldaps://ldapB.example.priv ldaps://ldapC.example.priv BASE dc=example,dc=priv For certificate validation to succeed, the hostname in the certificate must match a hostname in the URI property. Otherwise, you must also add TLS_REQCERT allow to the file. VMware Greenplum v6.17 Documentation Protocol The file:// protocol is used in a URI that specifies the location of an operating system file. gpfdist:// Protocol The gpfdist:// protocol is used in a URI to reference a running gpfdist instance

PXF. PXF no longer supports specifying a DELIMITER in the CREATE EXTERNAL TABLE command LOCATION URI. Additional Greenplum Database Features Greenplum Database 6.0 also includes these features and changes As the root user, edit the OpenLDAP configuration file /etc/openldap/ldap.conf: SASL_NOCANON on URI ldaps://ldapA.example.priv ldaps://ldapB.example.priv ldaps://ldapC.example.priv BASE dc=example For certificate validation to succeed, the hostname in the certificate must match a hostname in the URI property. Otherwise, you must also add TLS_REQCERT allow to the file. 4. As the gpadmin user, edit

PXF. PXF no longer supports specifying a DELIMITER in the CREATE EXTERNAL TABLE command LOCATION URI. Additional Greenplum Database Features Greenplum Database 6.0 also includes these features and changes Protocol The file:// protocol is used in a URI that specifies the location of an operating system file. gpfdist:// Protocol The gpfdist:// protocol is used in a URI to reference a running gpfdist instance (.bz2), and zstd (.zst) files automatically. You must provide a URI that specifies the location of an operating system file(s). The URI includes the host name, port, and path to the file. Each file must

PXF. PXF no longer supports specifying a DELIMITER in the CREATE EXTERNAL TABLE command LOCATION URI. Additional Greenplum Database Features Greenplum Database 6.0 also includes these features and changes Protocol The file:// protocol is used in a URI that specifies the location of an operating system file. gpfdist:// Protocol The gpfdist:// protocol is used in a URI to reference a running gpfdist instance bz2), and zstd (.zst) files automatically. You must provide a URI that specifies the location of an operating system file(s). The URI includes the host name, port, and path to the file. Each file must

PXF. PXF no longer supports specifying a DELIMITER in the CREATE EXTERNAL TABLE command LOCATION URI. Additional Greenplum Database Features Greenplum Database 6.0 also includes these features and changes Protocol The file:// protocol is used in a URI that specifies the location of an operating system file. gpfdist:// Protocol The gpfdist:// protocol is used in a URI to reference a running gpfdist instance VMware, Inc 502 file:// Protocol The file:// protocol is used in a URI that specifies the location of an operating system file. The URI includes the host name, port, and path to the file. Each file must

PXF. PXF no longer supports specifying a DELIMITER in the CREATE EXTERNAL TABLE command LOCATION URI. Additional Greenplum Database Features Greenplum Database 6.0 also includes these features and changes Protocol The file:// protocol is used in a URI that specifies the location of an operating system file. gpfdist:// Protocol The gpfdist:// protocol is used in a URI to reference a running gpfdist instance bz2), and zstd (.zst) files automatically. You must provide a URI that specifies the location of an operating system file(s). The URI includes the host name, port, and path to the file. Each file must

PXF. PXF no longer supports specifying a DELIMITER in the CREATE EXTERNAL TABLE command LOCATION URI. Additional Greenplum Database Features Greenplum Database 6.0 also includes these features and changes Protocol The file:// protocol is used in a URI that specifies the location of an operating system file. gpfdist:// Protocol The gpfdist:// protocol is used in a URI to reference a running gpfdist instance bz2), and zstd (.zst) files automatically. You must provide a URI that specifies the location of an operating system file(s). The URI includes the host name, port, and path to the file. Each file must