采取列存储和压缩的追加表，分布键为id,根据time分区,时间间隔为1天。完整的建表语句如下所⽰： create table t_unetanalysis_data ( id serial,uuid varchar(64) DEFAULT NULL, item_id int DEFAULT NULL, time int DEFAULT NULL, data varchar(4000) DEFAULT range(time) ( START (1469980800) END (1488297600) EVERY (86400) ); 其中，id 为记录序号，通过 serial（序列）实现⾃增；uuid 存储⽤⼾组织 ID 或者⽤⼾的 IP；item_id 为代表某种分析项的 id（分析项如IP流量、TCP包量、TCP重传率等）；time为时间戳； data为数据。 样本数据如下图所⽰： UDW 2012-2021 UCloud 优刻得 184/206 根据查询需要创建索引如下： create index t_unetanalysis_data_uuid_itemid_time on t_unetanalysis_data(uuid, item_id, time); 数据导⼊ 数据导⼊ 为了加快数据插⼊UDW的速度，强烈建议⽤copy的⽅式将数据导⼊。⽰例代码如下图所⽰： UDW

Dispatcher • GPORCA is Default Optimizer • JSON Type & Functions • Improved XML Type/Functions • UUID Type • Anonymous Code Blocks (Do statement) • UDF default and Variadic parameters • DBLink

2 to PG 8.3 (2017 time frame) – JSON/JSONB – Full Text Search – Improved XML Type/Functions – UUID Type – Raster PostGIS – Anonymous Code Blocks – PostgreSQL based Analyze (faster) – Extension

Pivotal Greenplum 5 支持多种新的内置数据类型，并针对现有数据类型进行了改进。新增的类型包括符合 RFC 4122 和 ISO/IEC 9834-8:2005 标准的通用惟一标识符 (UUID)。JSON 类型可用于存储和处理不限长度的可变 JSON 数据，新 增了用于查询和解析 JSON 记录的内置函数。与 JSON 类似，HSTORE 可用于在数据库中存储和查询半结构化数据。 Greenplum

TIMESTAMP9_LTZ 1684 TIMESTAMP9_NTZ Examples 1684 Valid input for TIMESTAMP9_NTZ 1684 Limitations 1685 uuid-ossp 1685 Installing and Registering the Module 1685 VMware Greenplum 7 Documentation VMware by pageinspect pg_trgm pgcrypto pgvector postgres_fdw postgresql-hll sslinfo tablefunc timestamp9 uuid-ossp For additional information about the modules supplied with Greenplum Database, refer to Additional time_minmax_ops time without time zone < <= = >= > timetz_minmax_ops time with time zone < <= = >= > uuid_minmax_ops uuid < <= = >= > Creating and Managing Views Views enable you to save frequently used or complex

TIMESTAMP9_LTZ 1865 TIMESTAMP9_NTZ Examples 1865 Valid input for TIMESTAMP9_NTZ 1865 Limitations 1866 uuid-ossp 1866 Installing and Registering the Module 1866 Module Documentation 1866 Character Set Support by Broadcom 173 timestamp9, which provides an efficient nanosecond-precision timestamp data type. uuid-ossp, which provides functions to generate universally unique identifiers (UUIDs). Version 6.23 only) pageinspect pg_trgm pgcrypto postgres_fdw postgresql-hll sslinfo tablefunc timestamp9 uuid-ossp For additional information about the modules supplied with Greenplum Database, refer to Additional

TIMESTAMP9_LTZ 1831 TIMESTAMP9_NTZ Examples 1831 Valid input for TIMESTAMP9_NTZ 1831 Limitations 1832 uuid-ossp 1832 VMware Greenplum 6 Documentation VMware, Inc 100 Installing and Registering the Module tree-like structure. timestamp9, which provides an efficient nanosecond-precision timestamp data type. uuid-ossp, which provides functions to generate universally unique identifiers (UUIDs). Version 6.23 only) pageinspect pg_trgm pgcrypto postgres_fdw postgresql-hll sslinfo tablefunc timestamp9 uuid-ossp For additional information about the modules supplied with Greenplum Database, refer to Additional

Registering the Module 1772 Module Documentation 1772 Additional Documentation 1772 Limitations 1773 uuid-ossp 1773 Installing and Registering the Module 1773 Module Documentation 1773 Character Set Support tree-like structure. timestamp9, which provides an efficient nanosecond-precision timestamp data type. uuid-ossp, which provides functions to generate universally unique identifiers (UUIDs). Version 6.23 Greenplum only) pageinspect pg_trgm pgcrypto postgres_fdw postgresql-hll sslinfo timestamp9 uuid-ossp For additional information about the modules supplied with Greenplum Database, refer to Additional

TIMESTAMP9_LTZ 1824 TIMESTAMP9_NTZ Examples 1825 Valid input for TIMESTAMP9_NTZ 1825 Limitations 1825 uuid-ossp 1825 Installing and Registering the Module 1825 Module Documentation 1826 Character Set Support tree-like structure. timestamp9, which provides an efficient nanosecond-precision timestamp data type. uuid-ossp, which provides functions to generate universally unique identifiers (UUIDs). Version 6.23 only) pageinspect pg_trgm pgcrypto postgres_fdw postgresql-hll sslinfo tablefunc timestamp9 uuid-ossp For additional information about the modules supplied with Greenplum Database, refer to Additional

(p) ] with time zone timestamptz 8 bytes 4713 BC - 294,277 AD both date and time, with time zone uuid 16 bytes Universally Unique Identifiers according to RFC 4122, ISO/IEC 9834-8:2005 xml1 1