7 Documentation VMware by Broadcom 9 Required Environment Variables 264 GPHOME 265 PATH 265 LD_LIBRARY_PATH 265 COORDINATOR_DATA_DIRECTORY 265 Optional Environment Variables 265 PGAPPNAME 265 Default “Public” Schema 321 Creating a Schema 321 Schema Search Paths 321 Setting the Schema Search Path 321 Viewing the Current Schema 322 Dropping a Schema 322 System Schemas 322 About Table Definition Graph? 720 Graph Analytics on Greenplum 721 Using Graph 721 Graph Modules 723 All Pairs Shortest Path (APSP) 723 Breadth-First Search 723 Hyperlink-Induced Topic Search (HITS) 724 VMware Greenplum

493 Greenplum Environment Variables 493 Required Environment Variables 493 GPHOME 493 PATH 494 LD_LIBRARY_PATH 494 MASTER_DATA_DIRECTORY 494 Optional Environment Variables 494 PGAPPNAME 494 PGDATABASE Default “Public” Schema 552 Creating a Schema 552 Schema Search Paths 553 Setting the Schema Search Path 553 Viewing the Current Schema 553 Dropping a Schema 554 System Schemas 554 Creating and Managing 913 All Pairs Shortest Path (APSP) 913 Breadth-First Search 913 Hyperlink-Induced Topic Search (HITS) 913 PageRank and Personalized PageRank 914 Single Source Shortest Path (SSSP) 914 Weakly Connected

468 Greenplum Environment Variables 468 Required Environment Variables 469 GPHOME 469 PATH 469 LD_LIBRARY_PATH 469 MASTER_DATA_DIRECTORY 469 Optional Environment Variables 470 PGAPPNAME 470 PGDATABASE VMware Greenplum 6 Documentation VMware, Inc. 24 Schema Search Paths 529 Setting the Schema Search Path 529 Viewing the Current Schema 530 Dropping a Schema 530 System Schemas 530 Creating and Managing 894 All Pairs Shortest Path (APSP) 894 Breadth-First Search 895 Hyperlink-Induced Topic Search (HITS) 895 PageRank and Personalized PageRank 895 Single Source Shortest Path (SSSP) 896 Weakly Connected

497 Greenplum Environment Variables 497 Required Environment Variables 497 GPHOME 498 PATH 498 LD_LIBRARY_PATH 498 MASTER_DATA_DIRECTORY 498 Optional Environment Variables 498 PGAPPNAME 498 PGDATABASE Default "Public" Schema 557 Creating a Schema 558 Schema Search Paths 558 Setting the Schema Search Path 558 Viewing the Current Schema 559 Dropping a Schema 559 System Schemas 559 Creating and Managing 923 All Pairs Shortest Path (APSP) 923 Breadth-First Search 924 Hyperlink-Induced Topic Search (HITS) 924 PageRank and Personalized PageRank 924 Single Source Shortest Path (SSSP) 925 Weakly Connected

302 Greenplum Environment Variables 0 Required Environment Variables 302 GPHOME 303 PATH 303 LD_LIBRARY_PATH 303 MASTER_DATA_DIRECTORY 303 Optional Environment Variables 303 VMware Greenplum v6 400 All Pairs Shortest Path (APSP) 400 Breadth-First Search 400 Hyperlink-Induced Topic Search (HITS) 401 PageRank and Personalized PageRank 401 Single Source Shortest Path (SSSP) 401 Weakly Connected 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 About PostGIS

312 Greenplum Environment Variables 0 Required Environment Variables 312 GPHOME 312 PATH 312 LD_LIBRARY_PATH 312 MASTER_DATA_DIRECTORY 313 Optional Environment Variables 313 PGAPPNAME 313 PGDATABASE 409 All Pairs Shortest Path (APSP) 409 Breadth-First Search 409 Hyperlink-Induced Topic Search (HITS) 410 PageRank and Personalized PageRank 410 Single Source Shortest Path (SSSP) 410 Weakly Connected 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 About PostGIS

236 Greenplum Environment Variables 0 Required Environment Variables 236 GPHOME 236 PATH 236 LD_LIBRARY_PATH 236 MASTER_DATA_DIRECTORY 237 Optional Environment Variables 237 PGAPPNAME 237 PGDATABASE 335 All Pairs Shortest Path (APSP) 335 Breadth-First Search 335 Hyperlink-Induced Topic Search (HITS) 336 PageRank and Personalized PageRank 336 Single Source Shortest Path (SSSP) 336 Weakly Connected 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 338 Geospatial

306 Greenplum Environment Variables 306 Required Environment Variables 306 GPHOME 307 PATH 307 LD_LIBRARY_PATH 307 MASTER_DATA_DIRECTORY 307 Optional Environment Variables 307 PGAPPNAME 307 PGDATABASE 404 All Pairs Shortest Path (APSP) 404 Breadth-First Search 404 Hyperlink-Induced Topic Search (HITS) 405 PageRank and Personalized PageRank 405 Single Source Shortest Path (SSSP) 406 Weakly Connected 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 PostGIS

Variables 474 Required Environment Variables 474 GPHOME 474 PATH 474 VMware Tanzu Greenplum 6 Documentation VMware, Inc 19 LD_LIBRARY_PATH 474 MASTER_DATA_DIRECTORY 475 Optional Environment Variables Default “Public” Schema 532 Creating a Schema 532 Schema Search Paths 533 Setting the Schema Search Path 533 Viewing the Current Schema 533 Dropping a Schema 533 System Schemas 534 Creating and Managing bar json_extract_path(from_json json, VARIADIC path_elems text[]) jsonb_extract_path(from_json jsonb, VARIADIC path_elems text[]) json jsonb Returns the JSON value pointed to by path_elems (equivalent

398 Greenplum Environment Variables 399 Required Environment Variables 399 GPHOME 399 PATH 399 LD_LIBRARY_PATH 399 MASTER_DATA_DIRECTORY 399 Optional Environment Variables 400 PGAPPNAME 400 PGDATABASE Default “Public” Schema 450 Creating a Schema 451 Schema Search Paths 451 Setting the Schema Search Path 451 Viewing the Current Schema 451 Dropping a Schema 452 System Schemas 452 Creating and Managing bar json_extract_path(from_json json, VARIADIC path_elems text[]) jsonb_extract_path(from_json jsonb, VARIADIC path_elems text[]) json jsonb Returns the JSON value pointed to by path_elems (equivalent