Segment Disk Layout 276 About the Greenplum Interconnect 277 Interconnect Redundancy 277 Network Interface Configuration 277 Switch Configuration 278 About ETL Hosts for Data Loading 279 About VMware 555 Check Constraints 556 Not-Null Constraints 556 Unique Constraints 556 Primary Keys 556 Foreign Keys 557 Choosing the Table Distribution Policy 557 Declaring Distribution Keys 558 Custom Distribution with Foreign Tables 633 Using Foreign-Data Wrappers with Greenplum Database 634 Writing a Foreign Data Wrapper 634 Requirements 635 Known Issues and Limitations 635 Header Files 636 Foreign Data

239 Example Segment Disk Layout 239 The Interconnect 240 Interconnect Redundancy 240 Network Interface Configuration 240 Switch Configuration 241 ETL Hosts for Data Loading 242 Tanzu Greenplum Performance type> 448 Returning a SETOF 448 Using the ResultSetProvider Interface 449 Using the ResultSetHandle Interface 450 Using JDBC 451 Exception Handling 451 Savepoints 452 VMware Greenplum Running SQL Commands 463 PL/pgSQL Plan Caching 463 PL/pgSQL Examples 464 Example: Aliases for Function Parameters 464 Example: Using the Data Type of a Table Column 464 VMware Greenplum v6.19 Documentation

Segment Disk Layout 264 About the Greenplum Interconnect 265 Interconnect Redundancy 265 Network Interface Configuration 265 Switch Configuration 266 About ETL Hosts for Data Loading 267 About Tanzu Greenplum 532 Check Constraints 532 Not-Null Constraints 533 Unique Constraints 533 Primary Keys 533 Foreign Keys 533 Choosing the Table Distribution Policy 534 Declaring Distribution Keys 535 Custom Distribution with Foreign Tables 608 Using Foreign-Data Wrappers with Greenplum Database 608 Writing a Foreign Data Wrapper 609 Requirements 610 Known Issues and Limitations 610 Header Files 610 Foreign Data

Segment Disk Layout 268 About the Greenplum Interconnect 269 Interconnect Redundancy 269 Network Interface Configuration 269 Switch Configuration 270 About ETL Hosts for Data Loading 271 About Tanzu Greenplum 535 Check Constraints 535 Not-Null Constraints 536 Unique Constraints 536 Primary Keys 536 Foreign Keys 536 VMware Tanzu Greenplum 6 Documentation VMware, Inc 22 Choosing the Table Distribution with Foreign Tables 611 Using Foreign-Data Wrappers with Greenplum Database 611 Writing a Foreign Data Wrapper 612 Requirements 612 Known Issues and Limitations 613 Header Files 613 Foreign Data

232 VMware Greenplum v6.18 Documentation VMware, Inc. 8 Interconnect Redundancy 233 Network Interface Configuration 233 Switch Configuration 234 ETL Hosts for Data Loading 235 Tanzu Greenplum Performance type> 439 Returning a SETOF 439 Using the ResultSetProvider Interface 439 Using the ResultSetHandle Interface 440 VMware Greenplum v6.18 Documentation VMware, Inc. 21 Using JDBC 441 VMware Greenplum v6.18 Documentation VMware, Inc. 22 PL/pgSQL Examples 455 Example: Aliases for Function Parameters 455 Example: Using the Data Type of a Table Column 455 Example: Composite Type Based

Segment Disk Layout 308 About the Greenplum Interconnect 309 Interconnect Redundancy 309 Network Interface Configuration 309 Switch Configuration 310 About ETL Hosts for Data Loading 311 About VMware 560 Check Constraints 561 Not-Null Constraints 561 Unique Constraints 561 Primary Keys 562 Foreign Keys 562 Choosing the Table Distribution Policy 562 Declaring Distribution Keys 563 Custom Distribution with Foreign Tables 639 Using Foreign-Data Wrappers with Greenplum Database 640 Writing a Foreign Data Wrapper 641 Requirements 642 Known Issues and Limitations 642 Header Files 642 Foreign Data

Segment Disk Layout 294 About the Greenplum Interconnect 295 Interconnect Redundancy 295 Network Interface Configuration 295 Switch Configuration 296 About ETL Hosts for Data Loading 297 About VMware 531 Check Constraints 532 Not-Null Constraints 532 Unique Constraints 532 Primary Keys 533 Foreign Keys 533 Choosing the Table Distribution Policy 533 Declaring Distribution Keys 534 Custom Distribution with Foreign Tables 610 Using Foreign-Data Wrappers with Greenplum Database 611 Writing a Foreign Data Wrapper 612 Requirements 612 Known Issues and Limitations 613 Header Files 613 Foreign Data

165 Example Segment Disk Layout 166 The Interconnect 166 Interconnect Redundancy 167 Network Interface Configuration 167 Switch Configuration 168 ETL Hosts for Data Loading 169 Greenplum Performance type> 374 Returning a SETOF 374 Using the ResultSetProvider Interface 374 Using the ResultSetHandle Interface 375 Using JDBC 376 Exception Handling 377 Savepoints 377 Logging 377 Security Running SQL Commands 389 PL/pgSQL Plan Caching 389 PL/pgSQL Examples 390 Example: Aliases for Function Parameters 390 Example: Using the Data Type of a Table Column 390 Example: Composite Type Based

236 Example Segment Disk Layout 237 The Interconnect 238 Interconnect Redundancy 238 Network Interface Configuration 238 Switch Configuration 239 ETL Hosts for Data Loading 240 Tanzu Greenplum Performance Returning a SETOF 443 Returning a SETOF 443 Using the ResultSetProvider Interface 443 Using the ResultSetHandle Interface 444 Using JDBC 445 Exception Handling 446 Savepoints 446 Logging 446 Security Running SQL Commands 457 PL/pgSQL Plan Caching 458 PL/pgSQL Examples 458 Example: Aliases for Function Parameters 458 Example: Using the Data Type of a Table Column 459 Example: Composite Type Based

Segment Disk Layout 239 About the Greenplum Interconnect 240 Interconnect Redundancy 240 Network Interface Configuration 240 Switch Configuration 241 About ETL Hosts for Data Loading 242 About Tanzu Greenplum 453 Check Constraints 453 Not-Null Constraints 454 Unique Constraints 454 Primary Keys 454 Foreign Keys 454 Choosing the Table Distribution Policy 454 Declaring Distribution Keys 455 Custom Distribution XML Transformations 521 Accessing External Data with Foreign Tables 521 Using Foreign-Data Wrappers with Greenplum Database 521 Writing a Foreign Data Wrapper 522 Requirements 522 Known Issues and