Geographical Distribution Real-Time Analytics Data Lake Data Warehouse Cloud HVR 连续数据集成技术 Migrations Disaster Recovery 6 扩展性—高性能架构 7 • 创建并装载目标表 • 用于实时复制的初始化 • 也可以单独使用 • 可以被定义为任务，定时调度执行 异构平台环境下初始化同步

Schemas 320 The Default “Public” Schema 321 Creating a Schema 321 Schema Search Paths 321 Setting the Schema Search Path 321 Viewing the Current Schema 322 Dropping a Schema 322 System Schemas 322 About Data with gpfdist and gpload 537 About gpfdist Transformations 538 Determine the Transformation Schema 539 VMware Greenplum 7 Documentation VMware by Broadcom 22 Write a Transformation 540 Write the Initialization 905 Planning Mirror Segments 906 Increasing Segments Per Host 906 About the Expansion Schema 906 Planning Table Redistribution 907 Table Redistribution Method 907 Managing Redistribution

Queue Statement Memory Configuration 335 Resource Queue Spill File Configuration 336 Schema Design 337 Schema Design 0 Data Types 337 Use Types Consistently 337 Choose Data Types that Use the Least Initialization 599 Planning Mirror Segments 600 Increasing Segments Per Host 600 About the Expansion Schema 600 Planning Table Redistribution 601 Managing Redistribution in Large-Scale Greenplum Systems Viewing Table Status 612 Post Expansion Tasks 612 Post Expansion Tasks 0 Removing the Expansion Schema 612 Setting Up PXF on the New Host 613 PXF 5 613 PXF 6 613 Migrating Data with gpcopy 613 Migrating

Queue Statement Memory Configuration 326 Resource Queue Spill File Configuration 327 Schema Design 328 Schema Design 0 Data Types 328 Use Types Consistently 328 Choose Data Types that Use the Least Initialization 590 Planning Mirror Segments 591 Increasing Segments Per Host 591 About the Expansion Schema 591 Planning Table Redistribution 592 Managing Redistribution in Large-Scale Greenplum Systems Viewing Table Status 603 Post Expansion Tasks 603 Post Expansion Tasks 0 Removing the Expansion Schema 603 Setting Up PXF on the New Host 604 PXF 5 604 PXF 6 604 Migrating Data with gpcopy 604 Migrating

Queue Statement Memory Configuration 260 Resource Queue Spill File Configuration 260 Schema Design 261 Schema Design 0 Data Types 261 Use Types Consistently 261 Choose Data Types that Use the Least Initialization 522 Planning Mirror Segments 523 Increasing Segments Per Host 523 About the Expansion Schema 523 Planning Table Redistribution 524 Managing Redistribution in Large-Scale Greenplum Systems Viewing Table Status 535 Post Expansion Tasks 535 Post Expansion Tasks 0 Removing the Expansion Schema 535 Setting Up PXF on the New Host 536 PXF 5 536 PXF 6 536 Migrating Data with gpcopy 536 Migrating

Resource Queue Statement Memory Configuration 330 Resource Queue Spill File Configuration 331 Schema Design 332 Data Types 332 Use Types Consistently 332 Choose Data Types that Use the Least Space Initialization 590 Planning Mirror Segments 591 Increasing Segments Per Host 591 About the Expansion Schema 591 Planning Table Redistribution 592 Managing Redistribution in Large-Scale Greenplum Systems Expansion Status 602 Viewing Table Status 602 Post Expansion Tasks 603 Removing the Expansion Schema 603 Setting Up PXF on the New Host 603 PXF 5 603 PXF 6 603 Migrating Data with gpcopy 604 VMware

Schemas 557 The Default "Public" Schema 557 Creating a Schema 558 Schema Search Paths 558 Setting the Schema Search Path 558 Viewing the Current Schema 559 Dropping a Schema 559 System Schemas 559 Creating Data with gpfdist and gpload 743 About gpfdist Transformations 743 Determine the Transformation Schema 744 Write a Transformation 745 Write the gpfdist Configuration File 746 Transfer the Data 747 Initialization 1126 Planning Mirror Segments 1126 Increasing Segments Per Host 1126 About the Expansion Schema 1127 Planning Table Redistribution 1127 Table Redistribution Method 1127 Managing Redistribution

Default "Public" Schema 528 Creating a Schema 529 VMware Greenplum 6 Documentation VMware, Inc. 24 Schema Search Paths 529 Setting the Schema Search Path 529 Viewing the Current Schema 530 Dropping Dropping a Schema 530 System Schemas 530 Creating and Managing Tables 530 Creating a Table 531 Choosing Column Data Types 531 Setting Table and Column Constraints 531 Check Constraints 532 Not-Null Constraints Data with gpfdist and gpload 713 About gpfdist Transformations 714 Determine the Transformation Schema 715 Write a Transformation 716 Write the gpfdist Configuration File 717 Transfer the Data 718

Schemas 552 The Default “Public” Schema 552 Creating a Schema 552 Schema Search Paths 553 Setting the Schema Search Path 553 Viewing the Current Schema 553 Dropping a Schema 554 System Schemas 554 Creating Data with gpfdist and gpload 734 About gpfdist Transformations 735 Determine the Transformation Schema 736 Write a Transformation 737 Write the gpfdist Configuration File 738 Transfer the Data 739 Initialization 1109 Planning Mirror Segments 1110 Increasing Segments Per Host 1110 About the Expansion Schema 1110 Planning Table Redistribution 1111 Table Redistribution Method 1111 Managing Redistribution

Schemas 450 The Default “Public” Schema 450 Creating a Schema 451 Schema Search Paths 451 Setting the Schema Search Path 451 Viewing the Current Schema 451 Dropping a Schema 452 System Schemas 452 Creating Data with gpfdist and gpload 608 About gpfdist Transformations 609 Determine the Transformation Schema 610 Write a Transformation 611 Write the gpfdist Configuration File 611 Transfer the Data 613 Initialization 938 Planning Mirror Segments 938 Increasing Segments Per Host 939 About the Expansion Schema 939 Planning Table Redistribution 939 Managing Redistribution in Large-Scale Greenplum Systems