Bayes Classification 393 References 397 Graph Analytics 397 Graph Analytics 0 What is a Graph? 397 Graph Analytics on Greenplum 398 Using Graph 398 Graph Modules 400 All Pairs Shortest Path (APSP) Weakly Connected Components 402 Measures 402 Average Path Length 402 Closeness Centrality 403 Graph Diameter 403 In-Out Degree 403 References 403 Geospatial Analytics 404 Geospatial Analytics 0 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

Bayes Classification 402 References 406 Graph Analytics 406 Graph Analytics 0 What is a Graph? 406 Graph Analytics on Greenplum 407 Using Graph 407 Graph Modules 409 All Pairs Shortest Path (APSP) Weakly Connected Components 411 Measures 411 Average Path Length 411 Closeness Centrality 412 Graph Diameter 412 In-Out Degree 412 References 412 Geospatial Analytics 413 Geospatial Analytics 0 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

Bayes Classification 328 References 332 Graph Analytics 332 Graph Analytics 0 What is a Graph? 332 Graph Analytics on Greenplum 333 Using Graph 333 Graph Modules 335 All Pairs Shortest Path (APSP) Weakly Connected Components 337 Measures 337 Average Path Length 337 Closeness Centrality 338 Graph Diameter 338 VMware Greenplum v6.17 Documentation VMware, Inc. 15 In-Out Degree 338 References 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

Tanzu Greenplum v6.20 Documentation VMware, Inc. 18 Graph Analytics 401 What is a Graph? 401 Graph Analytics on Greenplum 402 Using Graph 403 Graph Modules 404 All Pairs Shortest Path (APSP) 404 Breadth-First Weakly Connected Components 406 Measures 406 Average Path Length 406 Closeness Centrality 407 Graph Diameter 407 In-Out Degree 407 References 408 Geospatial Analytics 408 About PostGIS 408 Greenplum 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

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

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 714 Naive Bayes Classification 715 References 719 Graph Analytics 719 What is a Graph? 720 Graph Analytics on Greenplum 721 Using Graph 721 Graph Modules 723 All Pairs Shortest Path (APSP) 723 Breadth-First Weakly Connected Components 725 Measures 725 Average Path Length 725 Closeness Centrality 725 Graph Diameter 726 In-Out Degree 726 References 726 Geospatial Analytics 726 Greenplum PostGIS Extension

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 Classification 905 References 909 Graph Analytics 909 VMware Greenplum 6 Documentation VMware, Inc 37 What is a Graph? 910 Graph Analytics on Greenplum 910 Using Graph 911 Graph Modules 913 All Pairs Shortest

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 914 Naive Bayes Classification 916 References 920 Graph Analytics 920 What is a Graph? 920 Graph Analytics on Greenplum 921 Using Graph 922 Graph Modules 923 All Pairs Shortest Path (APSP) 923 Breadth-First

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 Output Syntax 786 Designing JSON documents Btree and Hash Indexes on jsonb Data 791 JSON Functions and Operators 792 JSON Operators 792 JSON Creation Functions 794 JSON Aggregate Functions 795 JSON Processing Functions 795 Working with XML 873 Naive Bayes Classification 875 References 879 Graph Analytics 879 What is a Graph? 880 Graph Analytics on Greenplum 880 Using Graph 881 Graph Modules 882 All Pairs Shortest Path (APSP) 882 Breadth-First