Method 344 Altering the Table Storage Model 345 Inheritance Rules for Altering a Partitioned Table’s Storage Model 345 Adding a Compressed Column to Table 345 Inheritance of Compression Settings 345 Best Practices 364 Limitations 365 About Changes to Table Partitioning in Greenplum 7 366 What’s New? 367 VMware Greenplum 7 Documentation VMware by Broadcom 14 What Hasn’t Changed With Classic Mapping 420 Implications 422 Example 422 About Changes to External Tables in Greenplum 7 423 What’s the Same? 423 What Has Changed? 423 VMware Greenplum 7 Documentation VMware by Broadcom 17 Additional

Using the S3 Storage Plugin with gpbackup and gprestore 560 Using the S3 Storage Plugin with gpbackup and gprestore 0 Prerequisites 560 Installing the S3 Storage Plugin 560 Using the S3 Storage Plugin Plugin 560 S3 Storage Plugin Configuration File Format 562 VMware Greenplum v6.18 Documentation VMware, Inc. 30 Using the DD Boost Storage Plugin with gpbackup, gprestore, and gpbackup_manager 564 Viewing Disk Space Usage for Indexes 607 Checking for Data Distribution Skew 607 Viewing a Table's Distribution Key 607 Viewing Data Distribution 608 Checking for Query Processing Skew 608 Avoiding

Using the S3 Storage Plugin with gpbackup and gprestore 569 Using the S3 Storage Plugin with gpbackup and gprestore 0 Prerequisites 569 Installing the S3 Storage Plugin 569 Using the S3 Storage Plugin Plugin 569 S3 Storage Plugin Configuration File Format 571 VMware Greenplum v6.19 Documentation VMware, Inc. 31 Using the DD Boost Storage Plugin with gpbackup, gprestore, and gpbackup_manager 573 Viewing Disk Space Usage for Indexes 616 Checking for Data Distribution Skew 616 Viewing a Table's Distribution Key 616 Viewing Data Distribution 617 Checking for Query Processing Skew 617 Avoiding

Using the S3 Storage Plugin with gpbackup and gprestore 492 Using the S3 Storage Plugin with gpbackup and gprestore 0 Prerequisites 492 Installing the S3 Storage Plugin 492 Using the S3 Storage Plugin Plugin 492 S3 Storage Plugin Configuration File Format 494 Using the DD Boost Storage Plugin with gpbackup, gprestore, and gpbackup_manager 496 VMware Greenplum v6.17 Documentation VMware, Inc. 26 Viewing Disk Space Usage for Indexes 539 Checking for Data Distribution Skew 539 Viewing a Table's Distribution Key 539 Viewing Data Distribution 540 Checking for Query Processing Skew 540 Avoiding

Storage Plugins 561 Using the S3 Storage Plugin with gpbackup and gprestore 561 Prerequisites 561 Installing the S3 Storage Plugin 561 Using the S3 Storage Plugin 562 S3 Storage Plugin Configuration Viewing Disk Space Usage for Indexes 606 Checking for Data Distribution Skew 607 Viewing a Table’s Distribution Key 607 Viewing Data Distribution 607 Checking for Query Processing Skew 608 Avoiding pxf:// Protocol 780 s3:// Protocol 781 Configuring the s3 Protocol 782 Using s3 External Tables 782 About the s3 Protocol LOCATION URL 783 About Reading and Writing S3 Data Files 785 s3 Protocol AWS Server-Side

pxf:// Protocol 621 s3:// Protocol 621 Configuring the s3 Protocol 622 Using s3 External Tables 623 About the s3 Protocol LOCATION URL 624 About Reading and Writing S3 Data Files 626 s3 Protocol AWS Server-Side Server-Side Encryption Support 626 s3 Protocol Proxy Support 627 About Providing the S3 Authentication Credentials 628 About the s3 Protocol Configuration File 628 About Specifying the Configuration Configuration File Location 631 VMware Greenplum 6 Documentation VMware by Broadcom 30 s3 Protocol Limitations 632 Using the gpcheckcloud Utility 632 Using a Custom Protocol 634 Handling Errors in External Table

pxf:// Protocol 592 s3:// Protocol 592 Configuring the s3 Protocol 593 Using s3 External Tables 593 About the s3 Protocol LOCATION URL 595 About Reading and Writing S3 Data Files 596 s3 Protocol AWS Server-Side Support 597 s3 Protocol Proxy Support 598 About Providing the S3 Authentication Credentials 599 About the s3 Protocol Configuration File 599 About Specifying the Configuration File Location 602 s3 Protocol Viewing Disk Space Usage for Indexes 1110 Checking for Data Distribution Skew 1111 Viewing a Table's Distribution Key 1111 Viewing Data Distribution 1111 Checking for Query Processing Skew 1112 Avoiding

pxf:// Protocol 590 s3:// Protocol 590 Configuring the s3 Protocol 591 Using s3 External Tables 591 About the s3 Protocol LOCATION URL 593 About Reading and Writing S3 Data Files 594 s3 Protocol AWS Server-Side Server-Side Encryption Support 595 s3 Protocol Proxy Support 596 About Providing the S3 Authentication Credentials 596 About the s3 Protocol Configuration File 597 About Specifying the Configuration Configuration File Location 599 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 26 s3 Protocol Limitations 600 Using the gpcheckcloud Utility 601 Using a Custom Protocol 602 Handling Errors in External Table

pxf:// Protocol 614 s3:// Protocol 615 Configuring the s3 Protocol 616 Using s3 External Tables 616 About the s3 Protocol LOCATION URL 618 About Reading and Writing S3 Data Files 619 s3 Protocol AWS Server-Side Server-Side Encryption Support 620 s3 Protocol Proxy Support 621 About Providing the S3 Authentication Credentials 621 About the s3 Protocol Configuration File 622 VMware Greenplum 6 Documentation VMware, Inc 26 About Specifying the Configuration File Location 625 s3 Protocol Limitations 625 Using the gpcheckcloud Utility 626 Using a Custom Protocol 628 Handling Errors in External Table Data

pxf:// Protocol 592 s3:// Protocol 593 Configuring the s3 Protocol 594 Using s3 External Tables 594 About the s3 Protocol LOCATION URL 596 About Reading and Writing S3 Data Files 597 s3 Protocol AWS Server-Side Support 598 s3 Protocol Proxy Support 599 About Providing the S3 Authentication Credentials 599 About the s3 Protocol Configuration File 599 About Specifying the Configuration File Location 602 s3 Protocol Viewing Disk Space Usage for Indexes 1092 Checking for Data Distribution Skew 1092 Viewing a Table’s Distribution Key 1093 Viewing Data Distribution 1093 Checking for Query Processing Skew 1093 Avoiding