Name 可以 使用逗号(,)分割。或者使用@符号跟随文件名的方式指定，该文件包含需 要匹配的 DB Name。 role 匹配哪个 ROLE。all 可以匹配全部的 ROLE。如果想把一个 GROUP 的所 有成员匹配上，可以在 ROLE Name 前使用加号(+)表示。多个 ROLE Name 可以使用逗号(,)分割。或者使用@符号跟随文件名的方式指定，该文件包 含需要匹配的 ROLE 文件中的记录是顺序匹配的，当某个登录被前面的记录匹配了， 将不会继续匹配后面的记录。所以，一定要避免记录之间有互相包含的关系出现，否则 不容易发现登录失败的原因。编辑这个文件时一定要注意保证输入的正确性，避免 Windows 隐藏符号等特殊不可见字符的出现，也不能随意修改初始化时自动生成的记 录，错误的修改可能会导致数据库无法访问，甚至出现无法执行 gpstop 等尴尬情况， 那时只能使用 pg_ctl 或者 kill -9 才能停止数据库，这是不应该发生的。 编写：陈淼 - 200 - 关于PostgreSQL中SQL规则和概念的完整解释，参考相关PostgreSQL的相关文 档。 SQL 值表达式 SQL值表达式，由数值、符号、运算符、SQL函数和数据组成。使用表达式来做数 据的比较，或执行运算。运算包括逻辑运算、算术运算和集合运算等。 以下这些都是值表达式(这一块编者也不能逐个确定示例，姑且先这样)： 

Functions 617 Advanced Aggregate Functions 619 Working with JSON Data 620 About JSON Data 620 About Unicode Characters in JSON Data 621 Mapping JSON Data Types to Greenplum Data Types 621 JSON Input and description. gp_read_error_log() is enhanced to detect division by zero, JSON mapping, and unsupported unicode errors encountered during foreign scans of external tables. This feature is not supported for a /data/coordinator COORDINATOR_PORT=5432 TRUSTED SHELL=ssh CHECK_POINT_SEGMENTS=8 ENCODING=UNICODE 3. (Optional) If you want to deploy mirror segments, uncomment and set the mirroring parameters

Functions 810 Advanced Aggregate Functions 812 Working with JSON Data 813 About JSON Data 814 About Unicode Characters in JSON Data 814 Mapping JSON Data Types to Greenplum Data Types 815 JSON Input and /gpinitsystem_config ARRAY_NAME="Greenplum Data Platform" TRUSTED_SHELL=ssh CHECK_POINT_SEGMENTS=8 ENCODING=UNICODE SEG_PREFIX=gpseg HEAP_CHECKSUM=on HBA_HOSTNAMES=0 QD_PRIMARY_ARRAY=mdw~mdw~5432~/gpdata/master/gpseg-1~0~-1 /gpinitsystem_config ARRAY_NAME="Greenplum Data Platform" TRUSTED_SHELL=ssh CHECK_POINT_SEGMENTS=8 ENCODING=UNICODE SEG_PREFIX=gpseg HEAP_CHECKSUM=on HBA_HOSTNAMES=0 QD_PRIMARY_ARRAY=mdw~mdw~5432~/gpdata/master/gpseg-1~0~-1

polymorphic pseudo-type in PostgreSQL. 785 Working with JSON Data 785 About JSON Data 786 About Unicode Characters in JSON Data 786 Mapping JSON Data Types to Greenplum Data Types 787 JSON Input and /gpinitsystem_config ARRAY_NAME="Greenplum Data Platform" TRUSTED_SHELL=ssh CHECK_POINT_SEGMENTS=8 ENCODING=UNICODE SEG_PREFIX=gpseg HEAP_CHECKSUM=on HBA_HOSTNAMES=0 QD_PRIMARY_ARRAY=mdw~mdw~5432~/gpdata/master/gpseg-1~0~-1 /gpinitsystem_config ARRAY_NAME="Greenplum Data Platform" TRUSTED_SHELL=ssh CHECK_POINT_SEGMENTS=8 ENCODING=UNICODE SEG_PREFIX=gpseg HEAP_CHECKSUM=on HBA_HOSTNAMES=0 QD_PRIMARY_ARRAY=mdw~mdw~5432~/gpdata/master/gpseg-1~0~-1

Functions 782 Advanced Aggregate Functions 783 Working with JSON Data 784 About JSON Data 785 About Unicode Characters in JSON Data 785 Mapping JSON Data Types to Greenplum Data Types 786 JSON Input and /gpinitsystem_config ARRAY_NAME="Greenplum Data Platform" TRUSTED_SHELL=ssh CHECK_POINT_SEGMENTS=8 ENCODING=UNICODE SEG_PREFIX=gpseg HEAP_CHECKSUM=on HBA_HOSTNAMES=0 QD_PRIMARY_ARRAY=mdw~mdw~5432~/gpdata/master/gpseg-1~0~-1 /gpinitsystem_config ARRAY_NAME="Greenplum Data Platform" TRUSTED_SHELL=ssh CHECK_POINT_SEGMENTS=8 ENCODING=UNICODE SEG_PREFIX=gpseg HEAP_CHECKSUM=on HBA_HOSTNAMES=0 QD_PRIMARY_ARRAY=mdw~mdw~5432~/gpdata/master/gpseg-1~0~-1

polymorphic pseudo-type in PostgreSQL. 678 Working with JSON Data 678 About JSON Data 679 About Unicode Characters in JSON Data 679 Mapping JSON Data Types to Greenplum Data Types 679 JSON Input and /gpinitsystem_config ARRAY_NAME="Greenplum Data Platform" TRUSTED_SHELL=ssh CHECK_POINT_SEGMENTS=8 ENCODING=UNICODE SEG_PREFIX=gpseg HEAP_CHECKSUM=on HBA_HOSTNAMES=0 QD_PRIMARY_ARRAY=mdw~mdw~5432~/gpdata/master/gpseg-1~1~-1 MASTER_DIRECTORY=/data/master MASTER_PORT=5432 TRUSTED SHELL=ssh CHECK_POINT_SEGMENTS=8 ENCODING=UNICODE 3. (Optional) If you want to deploy mirror segments, uncomment and set the mirroring parameters

Functions 820 Advanced Aggregate Functions 821 Working with JSON Data 822 About JSON Data 823 About Unicode Characters in JSON Data 823 Mapping JSON Data Types to Greenplum Data Types 824 JSON Input and MASTER_DIRECTORY=/data/master MASTER_PORT=5432 TRUSTED SHELL=ssh CHECK_POINT_SEGMENTS=8 ENCODING=UNICODE 3. (Optional) If you want to deploy mirror segments, uncomment and set the mirroring parameters unspecified2 any No 1 UHC Unified Hangul Code Korean No 1-2 WIN949, Windows949 UTF8 Unicode, 8-bit all Yes 1-4 Unicode VMware Greenplum 6 Documentation VMware by Broadcom 452 Name Description Language

Functions 791 Advanced Aggregate Functions 792 Working with JSON Data 793 About JSON Data 794 About Unicode Characters in JSON Data 794 Mapping JSON Data Types to Greenplum Data Types 795 JSON Input and Documentation VMware, Inc. 409 MASTER_PORT=5432 TRUSTED SHELL=ssh CHECK_POINT_SEGMENTS=8 ENCODING=UNICODE 3. (Optional) If you want to deploy mirror segments, uncomment and set the mirroring parameters Documentation VMware, Inc. 433 Name Description Language Server? Bytes/Char Aliases UTF8 Unicode, 8-bit all Yes 1-4 Unicode WIN866 Windows CP866 Cyrillic Yes 1 ALT WIN874 Windows CP874 Thai Yes 1 WIN1250

Functions 901 Working with JSON Data 902 Working with JSON Data 0 About JSON Data 903 About Unicode Characters in JSON Data 903 Mapping JSON Data Types to Greenplum Data Types 904 JSON Input and MASTER_DIRECTORY=/data/master MASTER_PORT=5432 TRUSTED SHELL=ssh CHECK_POINT_SEGMENTS=8 ENCODING=UNICODE 3. (Optional) If you want to deploy mirror segments, uncomment and set the mirroring parameters unspecified2 any No 1 UHC Unified Hangul Code Korean No 1-2 WIN949, Windows949 UTF8 Unicode, 8-bit all Yes 1-4 Unicode WIN866 Windows CP866 Cyrillic Yes 1 ALT WIN874 Windows CP874 Thai Yes 1 WIN1250

Functions 910 Working with JSON Data 911 Working with JSON Data 0 About JSON Data 912 About Unicode Characters in JSON Data 912 Mapping JSON Data Types to Greenplum Data Types 913 JSON Input and MASTER_DIRECTORY=/data/master MASTER_PORT=5432 TRUSTED SHELL=ssh CHECK_POINT_SEGMENTS=8 ENCODING=UNICODE 3. (Optional) If you want to deploy mirror segments, uncomment and set the mirroring parameters unspecified2 any No 1 UHC Unified Hangul Code Korean No 1-2 WIN949, Windows949 UTF8 Unicode, 8-bit all Yes 1-4 Unicode WIN866 Windows CP866 Cyrillic Yes 1 ALT WIN874 Windows CP874 Thai Yes 1 WIN1250