Explain Plans 378 Optimizing Greenplum Queries 380 Greenplum Grouping Extensions 381 Window Functions 381 High Availability 382 High Availability 0 Disk Storage 382 Best Practices 383 Master Mirroring Greenplum Database MADlib Package 397 Adding MADlib Functions to a Database 397 Upgrading MADlib 397 Upgrading a MADlib Package 398 Upgrading MADlib Functions 398 Uninstalling MADlib 398 Remove MADlib objects PL/Java Language 437 PL/Java Language 0 About PL/Java 438 About Greenplum Database PL/Java 439 Functions 439 Server Configuration Parameters 439 Installing Java 440 Installing PL/Java 441 Installing

Explain Plans 369 Optimizing Greenplum Queries 371 Greenplum Grouping Extensions 372 Window Functions 373 High Availability 373 High Availability 0 Disk Storage 373 Best Practices 374 Master Mirroring Greenplum Database MADlib Package 388 Adding MADlib Functions to a Database 388 Upgrading MADlib 388 Upgrading a MADlib Package 389 Upgrading MADlib Functions 389 Uninstalling MADlib 389 VMware Greenplum PL/Java Language 428 PL/Java Language 0 About PL/Java 429 About Greenplum Database PL/Java 430 Functions 430 Server Configuration Parameters 430 Installing Java 431 Installing PL/Java 432 Installing

Explain Plans 304 Optimizing Greenplum Queries 306 Greenplum Grouping Extensions 307 Window Functions 308 High Availability 308 High Availability 0 Disk Storage 308 Best Practices 309 Master Mirroring Greenplum Database MADlib Package 323 Adding MADlib Functions to a Database 323 Upgrading MADlib 323 Upgrading a MADlib Package 324 Upgrading MADlib Functions 324 Uninstalling MADlib 324 Remove MADlib objects PL/Java Language 363 PL/Java Language 0 About PL/Java 364 About Greenplum Database PL/Java 365 Functions 365 Server Configuration Parameters 365 Installing Java 366 Installing PL/Java 367 Installing

Preparing Greenplum 4.3 and 5 Databases for Backup 475 About Migrating Views Created with lag()/lead() Functions 478 Backing Up and Restoring a Database 479 Completing the Migration 480 Working With Hash Operator the Table Distribution Policy 562 Declaring Distribution Keys 563 Custom Distribution Key Hash Functions 564 Example Custom Hash Operator Class 564 Choosing the Table Storage Model 566 Heap Storage 642 Foreign Data Wrapper Functions 642 Foreign Data Wrapper Callback Functions 643 VMware Greenplum 6 Documentation VMware by Broadcom 31 Foreign Data Wrapper Helper Functions 647 Greenplum Database

Preparing Greenplum 4.3 and 5 Databases for Backup 464 About Migrating Views Created with lag()/lead() Functions 467 Backing Up and Restoring a Database 468 Completing the Migration 468 Working With Hash Operator the Table Distribution Policy 536 Declaring Distribution Keys 537 Custom Distribution Key Hash Functions 538 Example Custom Hash Operator Class 538 Choosing the Table Storage Model 540 Heap Storage Limitations 613 Header Files 613 Foreign Data Wrapper Functions 613 Foreign Data Wrapper Callback Functions 614 Foreign Data Wrapper Helper Functions 617 Greenplum Database Considerations 618 Building

Preparing Greenplum 4.3 and 5 Databases for Backup 480 About Migrating Views Created with lag()/lead() Functions 484 Backing Up and Restoring a Database 485 Completing the Migration 485 Working With Hash Operator the Table Distribution Policy 557 Declaring Distribution Keys 558 Custom Distribution Key Hash Functions 558 Example Custom Hash Operator Class 559 Choosing the Table Storage Model 561 Heap Storage 636 Foreign Data Wrapper Functions 636 Foreign Data Wrapper Callback Functions 637 VMware Greenplum 6 Documentation VMware, Inc 27 Foreign Data Wrapper Helper Functions 640 Greenplum Database Considerations

Additional Supplied Modules and Extensions 134 SQL Commands 135 Database Maintenance 136 System Functions, Catalog Tables and Views 137 Greenplum Query Optimizer (GPORCA) 138 Append-Optimized Tables 138 the Table Distribution Policy 329 Declaring Distribution Keys 330 Custom Distribution Key Hash Functions 331 Example Custom Hash Operator Class 331 Choosing the Table Storage Model 333 Heap Storage Limitations 410 Header Files 410 Foreign Data Wrapper Functions 410 Foreign Data Wrapper Callback Functions 411 Foreign Data Wrapper Helper Functions 414 Greenplum Database Considerations 415 Building

Preparing Greenplum 4.3 and 5 Databases for Backup 456 About Migrating Views Created with lag()/lead() Functions 459 Backing Up and Restoring a Database 460 Completing the Migration 461 Working With Hash Operator the Table Distribution Policy 533 Declaring Distribution Keys 534 Custom Distribution Key Hash Functions 535 Example Custom Hash Operator Class 535 Choosing the Table Storage Model 537 Heap Storage Limitations 613 Header Files 613 Foreign Data Wrapper Functions 613 Foreign Data Wrapper Callback Functions 614 Foreign Data Wrapper Helper Functions 618 Greenplum Database Considerations 619 Building

Explain Plans 373 Optimizing Greenplum Queries 375 Greenplum Grouping Extensions 376 Window Functions 376 High Availability 377 Disk Storage 377 Best Practices 377 Master Mirroring 378 Best Practices Greenplum Database MADlib Package 391 Adding MADlib Functions to a Database 392 Upgrading MADlib 392 Upgrading a MADlib Package 392 Upgrading MADlib Functions 393 Uninstalling MADlib 393 Remove MADlib objects References 432 PL/Java Language 432 About PL/Java 433 About Greenplum Database PL/Java 434 Functions 434 Server Configuration Parameters 434 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc

Preparing Greenplum 4.3 and 5 Databases for Backup 461 About Migrating Views Created with lag()/lead() Functions 464 Backing Up and Restoring a Database 465 Completing the Migration 466 Working With Hash Operator the Table Distribution Policy 534 Declaring Distribution Keys 535 Custom Distribution Key Hash Functions 535 Example Custom Hash Operator Class 535 Choosing the Table Storage Model 537 Heap Storage 610 Foreign Data Wrapper Functions 610 Foreign Data Wrapper Callback Functions 611 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 27 Foreign Data Wrapper Helper Functions 615 Greenplum Database