VMware by Broadcom 11 Defining Database Objects 314 Creating and Managing Databases 315 About Template and Default Databases 315 Creating a Database 316 Cloning a Database 316 Creating a Database Partition Scanning 357 About Viewing Your Partition Design 357 Viewing a Classic Syntax Sub-Partition Template 358 Constructing a pg_partitions-Equivalent Query 358 About Partition Pruning 358 Partition Maintenance Partition 376 Exchanging a Partition 376 Splitting a Partition 376 Modifying a Sub-Partition Template 377 Exchanging a Leaf Partition with an External Table 377 Example Exchanging a Partition with

Database Objects 0 Creating and Managing Databases 715 Creating and Managing Databases 0 About Template and Default Databases 715 Creating a Database 716 Cloning a Database 716 Creating a Database a Partition 753 Exchanging a Partition 754 Splitting a Partition 754 Modifying a Subpartition Template 755 Exchanging a Leaf Child Partition with an External Table 756 Example Exchanging a Partition CONFIGURATION 1061 ALTER TEXT SEARCH DICTIONARY 1061 ALTER TEXT SEARCH PARSER 1062 ALTER TEXT SEARCH TEMPLATE 1062 ALTER TYPE 1062 ALTER USER 1062 ALTER USER MAPPING 1063 ALTER VIEW 1063 ANALYZE 1063

Database Objects 0 Creating and Managing Databases 724 Creating and Managing Databases 0 About Template and Default Databases 724 Creating a Database 725 Cloning a Database 725 Creating a Database a Partition 762 Exchanging a Partition 763 Splitting a Partition 763 Modifying a Subpartition Template 764 Exchanging a Leaf Child Partition with an External Table 765 Example Exchanging a Partition CONFIGURATION 1070 ALTER TEXT SEARCH DICTIONARY 1070 ALTER TEXT SEARCH PARSER 1071 ALTER TEXT SEARCH TEMPLATE 1071 ALTER TYPE 1071 ALTER USER 1071 ALTER USER MAPPING 1072 ALTER VIEW 1072 ANALYZE 1072

Database Objects 0 Creating and Managing Databases 647 Creating and Managing Databases 0 About Template and Default Databases 647 Creating a Database 648 Cloning a Database 648 Creating a Database a Partition 685 Exchanging a Partition 686 Splitting a Partition 686 Modifying a Subpartition Template 687 Exchanging a Leaf Child Partition with an External Table 688 Example Exchanging a Partition CONFIGURATION 997 ALTER TEXT SEARCH DICTIONARY 997 ALTER TEXT SEARCH PARSER 998 ALTER TEXT SEARCH TEMPLATE 998 ALTER TYPE 998 ALTER USER 998 ALTER USER MAPPING 999 ALTER VIEW 999 ANALYZE 999 BEGIN

Users and File System 709 Defining Database Objects 713 Creating and Managing Databases 713 About Template and Default Databases 713 Creating a Database 714 Cloning a Database 714 Creating a Database a Partition 752 Exchanging a Partition 752 Splitting a Partition 753 Modifying a Subpartition Template 753 Exchanging a Leaf Child Partition with an External Table 754 Example Exchanging a Partition CONFIGURATION 1060 ALTER TEXT SEARCH DICTIONARY 1060 ALTER TEXT SEARCH PARSER 1061 ALTER TEXT SEARCH TEMPLATE 1061 ALTER TYPE 1061 ALTER USER 1061 ALTER USER MAPPING 1062 ALTER VIEW 1062 ANALYZE 1062

Database to a local machine 300 Deploying the Greenplum Database Template OVA 301 Modifying Resources 301 Validating the Virtual Machine Template 302 Provisioning the Virtual Machines 302 Monitoring the Login User 304 Next Steps 304 Option 2: Deploying Greenplum Using Your Own Template 304 Creating the Virtual Machine Template 305 Preparing the Virtual Machine 305 Performing System Configuration 306 306 Installing the Greenplum Database Software 312 Creating the Greenplum Template 313 Validating the Template 313 Creating a Test Virtual Machine 313 Verifying the Test Virtual Machine Settings 314

Preparing Greenplum Virtual Machine Base Template 363 Adding Deployment Configurations to the Virtual Machine Base Template 364 Importing the Base Template as a Virtual Machine 364 Configuring Base 518 Managing Data 522 Defining Database Objects 522 Creating and Managing Databases 523 About Template and Default Databases 523 Creating a Database 523 Cloning a Database 524 Creating a Database a Partition 562 Exchanging a Partition 563 Splitting a Partition 564 Modifying a Subpartition Template 564 Exchanging a Leaf Child Partition with an External Table 565 VMware Greenplum 6 Documentation

VMware by Broadcom 18 Prerequisites 380 Preparing Greenplum Virtual Machine Base Template 380 Configuring the Base Template Virtual Hardware 380 Configuring Greenplum Deployment 382 Deploying the Greenplum 547 Managing Data 551 Defining Database Objects 551 Creating and Managing Databases 552 About Template and Default Databases 552 Creating a Database 552 Cloning a Database 553 Creating a Database a Partition 592 Exchanging a Partition 592 Splitting a Partition 593 Modifying a Subpartition Template 593 Exchanging a Leaf Child Partition with an External Table 594 Example Exchanging a Partition

Database to a local machine 346 Deploying the Greenplum Database Template OVA 346 Modifying Resources 347 Validating the Virtual Machine Template 348 Provisioning the Virtual Machines 348 Monitoring the 542 Managing Data 546 Defining Database Objects 546 Creating and Managing Databases 547 About Template and Default Databases 547 Creating a Database 547 Cloning a Database 548 Creating a Database a Partition 586 Exchanging a Partition 586 Splitting a Partition 587 Modifying a Subpartition Template 587 Exchanging a Leaf Child Partition with an External Table 588 Example Exchanging a Partition

Deploying the Greenplum Database Template OVA 336 Modifying Resources 337 VMware Tanzu Greenplum 6 Documentation VMware, Inc 14 Validating the Virtual Machine Template 338 Provisioning the Virtual Machines 522 Managing Data 526 Defining Database Objects 526 Creating and Managing Databases 527 About Template and Default Databases 527 Creating a Database 527 Cloning a Database 528 Creating a Database a Partition 564 Exchanging a Partition 564 Splitting a Partition 565 Modifying a Subpartition Template 566 Exchanging a Leaf Child Partition with an External Table 567 Example Exchanging a Partition