Setting Up PXF 466 Creating a PXF External Table 468 Mapping the LOCATION Clause 468 Mapping the FORMAT Options 469 Example gphdfs to pxf External Table Mapping for an HDFS Text File 470 Verifying Access 4—Single gpfdist instance with error logging 637 Example 5—TEXT Format on a Hadoop Distributed File Server 638 Example 6—Multiple files in CSV format with header rows 638 Example 7—Readable External Web Table gpload 678 Synopsis 678 Requirements 678 Description 678 Options 679 Control File Format 680 Log File Format 689 Notes 689 Examples 690 See Also 691 pg_dump 691 Synopsis 691 Description 691

Setting Up PXF 447 Creating a PXF External Table 449 Mapping the LOCATION Clause 449 Mapping the FORMAT Options 450 Example gphdfs to pxf External Table Mapping for an HDFS Text File 451 Verifying Access 4—Single gpfdist instance with error logging 608 Example 5—TEXT Format on a Hadoop Distributed File Server 609 Example 6—Multiple files in CSV format with header rows 609 Example 7—Readable External Web Table gpload 648 Synopsis 649 Requirements 649 Description 649 Options 650 Control File Format 651 Log File Format 660 VMware Greenplum 6 Documentation VMware, Inc. 31 Notes 660 Examples 660 See Also

Setting Up PXF 472 Creating a PXF External Table 473 Mapping the LOCATION Clause 474 Mapping the FORMAT Options 475 Example gphdfs to pxf External Table Mapping for an HDFS Text File 475 Verifying Access 4—Single gpfdist instance with error logging 631 Example 5—TEXT Format on a Hadoop Distributed File Server 632 Example 6—Multiple files in CSV format with header rows 632 Example 7—Readable External Web Table Documentation VMware, Inc 29 Requirements 670 Description 670 Options 671 Control File Format 672 Log File Format 681 Notes 681 Examples 682 See Also 682 pg_dump 683 Synopsis 683 Description 683

Setting Up PXF 456 Creating a PXF External Table 457 Mapping the LOCATION Clause 457 Mapping the FORMAT Options 459 Example gphdfs to pxf External Table Mapping for an HDFS Text File 459 Verifying Access 4—Single gpfdist instance with error logging 608 Example 5—TEXT Format on a Hadoop Distributed File Server 609 Example 6—Multiple files in CSV format with header rows 609 Example 7—Readable External Web Table gpload 646 Synopsis 646 Requirements 646 Description 646 Options 647 Control File Format 648 Log File Format 656 Notes 657 Examples 657 See Also 658 pg_dump 658 Synopsis 658 Description 658

Setting Up PXF 453 Creating a PXF External Table 455 Mapping the LOCATION Clause 455 Mapping the FORMAT Options 456 Example gphdfs to pxf External Table Mapping for an HDFS Text File 456 Verifying Access 4—Single gpfdist instance with error logging 606 Example 5—TEXT Format on a Hadoop Distributed File Server 606 Example 6—Multiple files in CSV format with header rows 607 Example 7—Readable External Web Table gpload 644 Synopsis 644 Requirements 644 Description 644 Options 645 Control File Format 646 Log File Format 654 Notes 655 Examples 655 See Also 656 pg_dump 656 Synopsis 656 Description 656

VMware, Inc 17 Creating a PXF External Table 383 Mapping the LOCATION Clause 384 Mapping the FORMAT Options 385 Example gphdfs to pxf External Table Mapping for an HDFS Text File 385 Verifying Access 4—Single gpfdist instance with error logging 519 Example 5—TEXT Format on a Hadoop Distributed File Server 519 Example 6—Multiple files in CSV format with header rows 520 Example 7—Readable External Web Table gpload 552 Synopsis 552 Requirements 552 Description 552 Options 553 Control File Format 554 Log File Format 562 Notes 562 Examples 562 See Also 563 pg_dump 563 Synopsis 563 Description 563

Greenplum 7 Documentation VMware by Broadcom 18 Example 5—TEXT Format on a Hadoop Distributed File Server 445 Example 6—Multiple files in CSV format with header rows 445 Example 7—Readable External Web Table gpload 473 Synopsis 473 Requirements 473 Description 474 Options 474 Control File Format 475 Log File Format 484 Notes 485 Examples 485 See Also 486 pg_dump 486 Synopsis 486 Description 486 Loading Data Using an External Table 529 Loading and Writing Non-HDFS Custom Data 529 Using a Custom Format 530 Importing and Exporting Fixed Width Data 530 Examples of Reading Fixed-Width Data 531 Example

Overview 506 Migrating PgBouncer 507 Configuring PgBouncer 507 PgBouncer Authentication File Format 508 Configuring HBA-based Authentication for PgBouncer 509 Starting PgBouncer 510 Managing PgBouncer Filtering with gprestore 555 Configuring Email Notifications 555 gpbackup and gprestore Email File Format 556 Email YAML File Sections 556 Examples 557 Understanding Backup Files 558 Segment Data Files the S3 Storage Plugin 569 Using the S3 Storage Plugin 569 S3 Storage Plugin Configuration File Format 571 VMware Greenplum v6.19 Documentation VMware, Inc. 31 Using the DD Boost Storage Plugin with

Overview 497 Migrating PgBouncer 498 Configuring PgBouncer 498 PgBouncer Authentication File Format 499 Configuring HBA-based Authentication for PgBouncer 500 Starting PgBouncer 501 VMware Greenplum Filtering with gprestore 546 Configuring Email Notifications 546 gpbackup and gprestore Email File Format 547 Email YAML File Sections 547 Examples 548 Understanding Backup Files 549 Segment Data Files the S3 Storage Plugin 560 Using the S3 Storage Plugin 560 S3 Storage Plugin Configuration File Format 562 VMware Greenplum v6.18 Documentation VMware, Inc. 30 Using the DD Boost Storage Plugin with

Overview 432 Migrating PgBouncer 433 Configuring PgBouncer 433 PgBouncer Authentication File Format 434 Configuring HBA-based Authentication for PgBouncer 435 Starting PgBouncer 436 Managing PgBouncer Filtering with gprestore 477 Configuring Email Notifications 478 gpbackup and gprestore Email File Format 479 Email YAML File Sections 479 Examples 480 Understanding Backup Files 480 Segment Data Files the S3 Storage Plugin 492 Using the S3 Storage Plugin 492 S3 Storage Plugin Configuration File Format 494 Using the DD Boost Storage Plugin with gpbackup, gprestore, and gpbackup_manager 496 VMware