177 183 190 190 191 192 udw优化指南 表膨胀 表膨胀 表膨胀的原因 如何避免表膨胀 UDW中 中Json类型 类型 Json相关操作 Json操作举例 Json相关函数 Json创建函数 Json处理函数 接⼊第三⽅ 接⼊第三⽅ BI ⼯具 ⼯具 ⼀、 UDW 接⼊ Zeppelin ⼆、 UDW 接⼊ SuperSet UDW 使⽤案例 Copyright © 2012-2021 UCloud 优刻得 5/206 概览 概览 产品架构 快速上⼿ 操作指南 访问UDW数据仓库 数据导⼊ 开发指南 udw优化指南 表膨胀 UDW中Json类型 接⼊第三⽅ BI ⼯具 UDW 使⽤案例 Pxf 扩展功能 迁移数据 使⽤ pg_dump 使⽤ pxf 外部表 FAQs 数据仓库价格 概览 Greenplum数据仓库 UDW 通过 sqoop 把 hdfs 中的数据导⼊到 udw ⽤ mysql2udw 把 mysql 中的数据导⼊到 udw 创建 ufile 的外部表、导⼊导出数据到 ufile 通过外部表导⼊ json 格式的数据 在导⼊⼤量的数据的时候我们建议不要使⽤ insert ⼀条条的导⼊数据、强烈建议使⽤ copy、udwfile 导⼊数据。 5.1 insert加载数据 加载数据 我们可以通过

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 Output Syntax 680 Designing JSON documents Indexes on jsonb Data 685 JSON Functions and Operators 685 JSON Operators 685 JSON Creation Functions 687 JSON Aggregate Functions 689 JSON Processing Functions 689 Table 7. JSON Processing Functions Function Example Result json_array_length(json) jsonb_array_length(jsonb) int Returns the number of elements in the outermost JSON array. json_array_length(‘[1,2,3, {“f1”:1,“f2”:[5,6]},4]’) 5 json_each(json) jsonb_each(jsonb)

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 Output Syntax 787 Designing JSON documents jsonb Data 792 JSON Functions and Operators 793 JSON Operators 793 JSON Creation Functions 795 JSON Aggregate Functions 796 VMware Tanzu Greenplum 6 Documentation VMware, Inc 34 JSON Processing Functions Table 7. JSON Processing Functions Function Return Type Description Example Example Result json_array_length(json) jsonb_array_length(jsonb) int Returns the number of elements in the outermost JSON array

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 Output Syntax Designing JSON documents 905 jsonb Containment and Existence 906 jsonb Indexing 908 GIN Indexes on jsonb Data 908 Btree and Hash Indexes on jsonb Data 910 JSON Functions and Operators 910 JSON Operators Operators 911 JSON Creation Functions 912 JSON Aggregate Functions 913 JSON Processing Functions 914 Working with XML Data 916 Working with XML Data 0 Creating XML Values 917 Encoding Handling 918 Accessing

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 Output Syntax Designing JSON documents 914 jsonb Containment and Existence 915 jsonb Indexing 917 GIN Indexes on jsonb Data 917 Btree and Hash Indexes on jsonb Data 919 JSON Functions and Operators 919 JSON Operators Operators 920 JSON Creation Functions 921 JSON Aggregate Functions 922 JSON Processing Functions 923 Working with XML Data 925 Working with XML Data 0 Creating XML Values 926 Encoding Handling 927 Accessing

Functions 833 Working with JSON Data 834 Working with JSON Data 0 About JSON Data 835 About Unicode Characters in JSON Data 835 Mapping JSON Data Types to Greenplum Data Types 836 JSON Input and Output Syntax Designing JSON documents 837 jsonb Containment and Existence 838 jsonb Indexing 840 GIN Indexes on jsonb Data 840 Btree and Hash Indexes on jsonb Data 842 JSON Functions and Operators 842 JSON Operators Operators 843 JSON Creation Functions 844 JSON Aggregate Functions 845 JSON Processing Functions 846 Working with XML Data 848 Working with XML Data 0 Creating XML Values 849 Encoding Handling 850 Accessing

Working with JSON Data 903 About JSON Data 904 About Unicode Characters in JSON Data 904 Mapping JSON Data Types to Greenplum Data Types 905 JSON Input and Output Syntax 905 Designing JSON documents Btree and Hash Indexes on jsonb Data 910 JSON Functions and Operators 911 JSON Operators 911 JSON Creation Functions 913 JSON Aggregate Functions 914 JSON Processing Functions 914 VMware Tanzu Greenplum Built-in Functions and Operators 1498 JSON Functions and Operators 1502 JSON Operators 1502 JSON Creation Functions 1504 JSON Aggregate Functions 1505 JSON Processing Functions 1505 Window Functions

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 Output Syntax 622 Designing JSON documents and Operators 1579 JSON Functions and Operators 1584 Processing and Creating JSON Data 1584 JSON Operators 1584 JSON Creation Functions 1586 JSON Aggregate Functions 1588 JSON Processing Functions Table 8. JSON Processing Functions Function Return Type Description Example Example Result json_array_length(json) jsonb_array_length(jsonb) int Returns the number of elements in the outermost JSON array

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 Output Syntax 816 Designing JSON documents Btree and Hash Indexes on jsonb Data 821 JSON Functions and Operators 821 JSON Operators 822 JSON Creation Functions 823 JSON Aggregate Functions 824 JSON Processing Functions 825 Working with XML Built-in Functions and Operators 1743 JSON Functions and Operators 1747 JSON Operators 1748 JSON Creation Functions 1749 JSON Aggregate Functions 1751 JSON Processing Functions 1751 Window Functions

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 Output Syntax 825 Designing JSON documents Btree and Hash Indexes on jsonb Data 830 JSON Functions and Operators 830 JSON Operators 831 JSON Creation Functions 832 JSON Aggregate Functions 833 JSON Processing Functions 834 Working with XML Built-in Functions and Operators 1769 JSON Functions and Operators 1774 JSON Operators 1774 JSON Creation Functions 1775 JSON Aggregate Functions 1777 JSON Processing Functions 1777 Window Functions