322 Dropping a Schema 322 System Schemas 322 About Table Definition Basics 323 Default Column Values 324 Generated Columns 325 Creating and Managing Tables 326 Creating a Table 326 Choosing Column 337 Support for Run-length Encoding 338 Adding Column-level Compression 338 Default Compression Values 340 Precedence of Compression Settings 340 Optimal Location for Column Compression Settings 341 Indexes 388 Example: Setting up a Partial Index to Exclude Common Values 388 Example: Setting up a Partial Index to Exclude Uninteresting Values 389 Example: Setting up a Partial Unique Index 390 Example:

VMware Greenplum v6.18 Documentation VMware, Inc. 16 Loading Data 0 INSERT Statement with Column Values 352 COPY Statement 352 External Tables 352 External Tables with Gpfdist 353 Gpload 354 Best PL/Perl Support 448 Developing Functions with PL/Perl 449 Built-in PL/Perl Functions 450 Global Values in PL/Perl 451 Notes 451 PL/pgSQL Language 452 PL/pgSQL Language 0 About Greenplum Database PL/pgSQL Table Row 456 Example: Using a Variable Number of Arguments 457 Example: Using Default Argument Values 457 Example: Using Polymorphic Data Types 458 Example: Anonymous Block 459 References 459 PL/Python

Monitoring Greenplum Database Log Files 0 Loading Data 360 Loading Data 0 INSERT Statement with Column Values 361 COPY Statement 361 VMware Greenplum v6.19 Documentation VMware, Inc. 17 External Tables 361 PL/Perl Support 457 Developing Functions with PL/Perl 458 Built-in PL/Perl Functions 459 Global Values in PL/Perl 460 Notes 461 PL/pgSQL Language 461 PL/pgSQL Language 0 About Greenplum Database PL/pgSQL Table Row 465 Example: Using a Variable Number of Arguments 466 Example: Using Default Argument Values 467 Example: Using Polymorphic Data Types 467 Example: Anonymous Block 468 References 469 PL/Python

544 Support for Run-length Encoding 545 Adding Column-level Compression 545 Default Compression Values 547 Precedence of Compression Settings 547 Optimal Location for Column Compression Settings 547 VMware Tanzu Greenplum 6 Documentation VMware, Inc 31 Formatting Columns 725 Representing NULL Values 725 Escaping 726 Escaping in Text Formatted Files 726 Escaping in CSV Formatted Files 727 Character 4]]) Example: CREATE TABLE mymatrix (myvalue int[]); INSERT INTO mymatrix VALUES (array[[1,2],[3,4]]); INSERT INTO mymatrix VALUES (array[[0,1],[1,0]]); SELECT sum(myvalue) FROM mymatrix; sum {{1,3}, {4

461 Support for Run-length Encoding 462 Adding Column-level Compression 462 Default Compression Values 464 Precedence of Compression Settings 464 Optimal Location for Column Compression Settings 464 COPY 623 Formatting Data Files 624 Formatting Rows 624 Formatting Columns 624 Representing NULL Values 625 Escaping 625 Escaping in Text Formatted Files 625 Escaping in CSV Formatted Files 626 Character 4]]) Example: CREATE TABLE mymatrix (myvalue int[]); INSERT INTO mymatrix VALUES (array[[1,2],[3,4]]); INSERT INTO mymatrix VALUES (array[[0,1],[1,0]]); SELECT sum(myvalue) FROM mymatrix; sum {{1,3}, {4

6 Documentation VMware by Broadcom 27 Adding Column-level Compression 572 Default Compression Values 573 Precedence of Compression Settings 573 Optimal Location for Column Compression Settings 574 COPY 759 Formatting Data Files 760 Formatting Rows 760 Formatting Columns 760 Representing NULL Values 761 Escaping 761 VMware Greenplum 6 Documentation VMware by Broadcom 36 Escaping in Text Formatted JSON Processing Functions 834 Working with XML Data 836 Creating XML Values 837 Encoding Handling 838 Accessing XML Values 838 Processing XML 839 Mapping Tables to XML 840 XML Function Reference

565 Support for Run-length Encoding 566 Adding Column-level Compression 566 Default Compression Values 568 Precedence of Compression Settings 568 Optimal Location for Column Compression Settings 568 COPY 751 Formatting Data Files 751 Formatting Rows 751 Formatting Columns 752 Representing NULL Values 752 Escaping 752 Escaping in Text Formatted Files 753 Escaping in CSV Formatted Files 753 Character JSON Processing Functions 825 Working with XML Data 828 Creating XML Values 828 Encoding Handling 829 Accessing XML Values 830 Processing XML 830 Mapping Tables to XML 831 XML Function Reference

Column-level Compression 542 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 23 Default Compression Values 544 Precedence of Compression Settings 544 Optimal Location for Column Compression Settings 544 COPY 723 Formatting Data Files 723 Formatting Rows 723 Formatting Columns 724 Representing NULL Values 724 Escaping 724 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 32 Escaping in Text Formatted JSON Processing Functions 795 Working with XML Data 797 Creating XML Values 798 Encoding Handling 799 Accessing XML Values 799 Processing XML 800 Mapping Tables to XML 801 XML Function Reference

541 Support for Run-length Encoding 542 Adding Column-level Compression 543 Default Compression Values 544 Precedence of Compression Settings 544 Optimal Location for Column Compression Settings 545 COPY 730 Formatting Data Files 730 Formatting Rows 731 Formatting Columns 731 Representing NULL Values 731 Escaping 731 Escaping in Text Formatted Files 732 Escaping in CSV Formatted Files 732 Character JSON Processing Functions 805 Working with XML Data 807 Creating XML Values 808 Encoding Handling 809 Accessing XML Values 809 Processing XML 810 Mapping Tables to XML 811 XML Function Reference

Monitoring Greenplum Database Log Files 0 Loading Data 286 Loading Data 0 INSERT Statement with Column Values 287 COPY Statement 287 External Tables 287 External Tables with Gpfdist 288 Gpload 289 Best PL/Perl Support 383 Developing Functions with PL/Perl 384 Built-in PL/Perl Functions 385 Global Values in PL/Perl 386 Notes 386 PL/pgSQL Language 387 PL/pgSQL Language 0 About Greenplum Database PL/pgSQL Table Row 391 Example: Using a Variable Number of Arguments 392 Example: Using Default Argument Values 392 Example: Using Polymorphic Data Types 393 Example: Anonymous Block 394 References 394 PL/Python