Functions 478 Backing Up and Restoring a Database 479 Completing the Migration 480 Working With Hash Operator Classes in Greenplum 6 480 Migrating from Open Source Greenplum Database to VMware Greenplum 482 Declaring Distribution Keys 563 Custom Distribution Key Hash Functions 564 Example Custom Hash Operator Class 564 Choosing the Table Storage Model 566 Heap Storage 566 Append-Optimized Storage 567 Expressions 793 Column References 794 Positional Parameters 794 Subscripts 794 Field Selection 795 Operator Invocations 795 Function Calls 796 Aggregate Expressions 796 Limitations of Aggregate Expressions

Reviewing the Results 342 Next Steps 342 Creating the Jumpbox Virtual Machine 342 Uploading the ISO Image to vCenter 342 Deploying the Jumpbox Virtual Machine 343 Initializing the Jumpbox Virtual Machine Functions 484 Backing Up and Restoring a Database 485 Completing the Migration 485 Working With Hash Operator Classes in Greenplum 6 486 Migrating from Open Source Greenplum Database to VMware Greenplum 487 Declaring Distribution Keys 558 Custom Distribution Key Hash Functions 558 Example Custom Hash Operator Class 559 Choosing the Table Storage Model 561 Heap Storage 561 Append-Optimized Storage 561

Reviewing the Results 332 Next Steps 332 Creating the Jumpbox Virtual Machine 332 Uploading the ISO Image to vCenter 332 Deploying the Jumpbox Virtual Machine 333 Initializing the Jumpbox Virtual Machine Functions 467 Backing Up and Restoring a Database 468 Completing the Migration 468 Working With Hash Operator Classes in Greenplum 6 469 Enabling iptables (Optional) 470 How to Enable iptables 471 Example Declaring Distribution Keys 537 Custom Distribution Key Hash Functions 538 Example Custom Hash Operator Class 538 Choosing the Table Storage Model 540 Heap Storage 541 Append-Optimized Storage 541

Functions 459 Backing Up and Restoring a Database 460 Completing the Migration 461 Working With Hash Operator Classes in Greenplum 6 461 Migrating from Open Source Greenplum Database to VMware Greenplum 463 Declaring Distribution Keys 534 Custom Distribution Key Hash Functions 535 Example Custom Hash Operator Class 535 Choosing the Table Storage Model 537 Heap Storage 537 Append-Optimized Storage 538 Expressions 764 Column References 765 Positional Parameters 765 Subscripts 765 Field Selection 766 Operator Invocations 766 Function Calls 767 Aggregate Expressions 767 Limitations of Aggregate Expressions

Reviewing the Results 328 Next Steps 328 Creating the Jumpbox Virtual Machine 328 Uploading the ISO Image to vCenter 328 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 14 Deploying the Jumpbox Virtual Functions 464 Backing Up and Restoring a Database 465 Completing the Migration 466 Working With Hash Operator Classes in Greenplum 6 466 Enabling iptables (Optional) 468 How to Enable iptables 468 Example Declaring Distribution Keys 535 Custom Distribution Key Hash Functions 535 Example Custom Hash Operator Class 535 Choosing the Table Storage Model 537 Heap Storage 538 Append-Optimized Storage 538

Declaring Distribution Keys 330 Custom Distribution Key Hash Functions 331 Example Custom Hash Operator Class 331 Choosing the Table Storage Model 333 Heap Storage 333 Append-Optimized Storage 334 Understanding Index-Only Scans and Covering Indexes 391 BRIN Indexes 394 Index Maintenance 395 Built-in Operator Classes 396 Creating and Managing Views 397 Creating Views 397 Dropping Views 397 Best Practices Expressions 586 Column References 587 Positional Parameters 587 Subscripts 587 Field Selection 588 Operator Invocations 588 Function Calls 589 Aggregate Expressions 589 Limitations of Aggregate Expressions

Reviewing the Results 297 Next Steps 297 Creating the Jumpbox Virtual Machine 297 Uploading the ISO Image to vCenter 297 Deploying the Jumpbox Virtual Machine 297 Initializing the Jumpbox Virtual Machine Functions 392 Backing Up and Restoring a Database 393 Completing the Migration 394 Working With Hash Operator Classes in Greenplum 6 394 Enabling iptables (Optional) 396 How to Enable iptables 396 Example Declaring Distribution Keys 455 Custom Distribution Key Hash Functions 456 Example Custom Hash Operator Class 456 Choosing the Table Storage Model 458 Heap Storage 458 Append-Optimized Storage 458

Backup 297 Backing Up and Restoring a Database 300 Completing the Migration 301 Working With Hash Operator Classes in Greenplum 6 301 Enabling iptables (Optional) 303 How to Enable iptables 303 Example Declaring Distribution Keys 724 Custom Distribution Key Hash Functions 725 Example Custom Hash Operator Class 725 Choosing the Table Storage Model 727 Heap Storage 727 Append-Optimized Storage 727 Expressions 874 Column References 875 Positional Parameters 875 Subscripts 876 Field Selection 876 Operator Invocations 877 Function Calls 877 Aggregate Expressions 877 Limitations of Aggregate Expressions

Upgrade 301 Backing Up and Restoring a Database 305 Completing the Migration 306 Working With Hash Operator Classes in Greenplum 6 307 Enabling iptables (Optional) 308 Enabling iptables (Optional) 0 How Declaring Distribution Keys 735 Custom Distribution Key Hash Functions 736 Example Custom Hash Operator Class 736 Choosing the Table Storage Model 738 VMware Greenplum v6.19 Documentation VMware, Inc Expressions 882 Column References 883 Positional Parameters 883 Subscripts 884 Field Selection 884 Operator Invocations 885 Function Calls 885 Aggregate Expressions 885 Limitations of Aggregate Expressions

Upgrade 292 Backing Up and Restoring a Database 296 Completing the Migration 297 Working With Hash Operator Classes in Greenplum 6 297 Enabling iptables (Optional) 299 Enabling iptables (Optional) 0 How Declaring Distribution Keys 726 Custom Distribution Key Hash Functions 727 Example Custom Hash Operator Class 727 Choosing the Table Storage Model 729 VMware Greenplum v6.18 Documentation VMware, Inc Expressions 873 Column References 874 Positional Parameters 874 Subscripts 875 Field Selection 875 Operator Invocations 876 Function Calls 876 Aggregate Expressions 876 Limitations of Aggregate Expressions