Specifying Table Distribution Columns 218 VMware Greenplum v6.19 Documentation VMware, Inc. 8 Resource Groups Features 219 PL/pgSQL Procedural Language Enhancements 219 Replicated Table Data 220 Concurrency Parameters 464 Example: Using the Data Type of a Table Column 464 VMware Greenplum v6.19 Documentation VMware, Inc. 23 Example: Composite Type Based on a Table Row 465 Example: Using a Variable Number of for failed segments using gpstate 532 Check for failed segments using the gp_segment_configuration table 533 Check for failed segments by examining log files 533 To check the log files 533 Understanding

Algorithm 210 Relaxed Rules for Specifying Table Distribution Columns 210 Resource Groups Features 211 PL/pgSQL Procedural Language Enhancements 211 Replicated Table Data 212 Concurrency Improvements in Aliases for Function Parameters 455 Example: Using the Data Type of a Table Column 455 Example: Composite Type Based on a Table Row 456 Example: Using a Variable Number of Arguments 457 Example: Using for failed segments using gpstate 523 Check for failed segments using the gp_segment_configuration table 524 Check for failed segments by examining log files 524 To check the log files 524 Understanding

About Database Statistics in Greenplum Database 180 System Statistics 181 Table Size 181 The pg_statistic System Table and pg_stats View 181 Sampling 185 Updating Statistics 185 Analyzing Partitioned 322 About Table Definition Basics 323 Default Column Values 324 Generated Columns 325 Creating and Managing Tables 326 Creating a Table 326 Choosing Column Data Types 326 Setting Table and Column 329 Choosing the Table Distribution Policy 329 Declaring Distribution Keys 330 Custom Distribution Key Hash Functions 331 Example Custom Hash Operator Class 331 Choosing the Table Storage Model 333

Aliases for Function Parameters 390 Example: Using the Data Type of a Table Column 390 Example: Composite Type Based on a Table Row 391 Example: Using a Variable Number of Arguments 392 Example: Using Per Host 523 About the Expansion Schema 523 Planning Table Redistribution 524 Managing Redistribution in Large-Scale Greenplum Systems 524 Table Redistribution Methods 524 Systems with Abundant Free gpexpand 534 To redistribute tables with gpexpand 534 Monitoring Table Redistribution 534 Viewing Expansion Status 534 Viewing Table Status 535 Post Expansion Tasks 535 Post Expansion Tasks 0 Removing

Algorithm 215 Relaxed Rules for Specifying Table Distribution Columns 215 Resource Groups Features 216 PL/pgSQL Procedural Language Enhancements 216 Replicated Table Data 217 Concurrency Improvements in Aliases for Function Parameters 458 Example: Using the Data Type of a Table Column 459 Example: Composite Type Based on a Table Row 459 Example: Using a Variable Number of Arguments 460 Example: Using for failed segments using gpstate 525 Check for failed segments using the gp_segment_configuration table 526 Check for failed segments by examining log files 526 To check the log files 526 Understanding

Algorithm 271 Relaxed Rules for Specifying Table Distribution Columns 271 Resource Groups Features 271 PL/pgSQL Procedural Language Enhancements 272 Replicated Table Data 272 VMware Greenplum 6 Documentation About Database Statistics in Greenplum Database 329 System Statistics 330 Table Size 330 The pg_statistic System Table and pg_stats View 330 Sampling 334 Updating Statistics 334 Analyzing Partitioned 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

Algorithm 238 Relaxed Rules for Specifying Table Distribution Columns 239 Resource Groups Features 239 PL/pgSQL Procedural Language Enhancements 239 Replicated Table Data 240 Concurrency Improvements in About Database Statistics in Greenplum Database 297 System Statistics 298 Table Size 298 The pg_statistic System Table and pg_stats View 298 Sampling 302 Updating Statistics 302 Analyzing Partitioned 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

Algorithm 257 Relaxed Rules for Specifying Table Distribution Columns 257 Resource Groups Features 258 PL/pgSQL Procedural Language Enhancements 258 Replicated Table Data 258 Concurrency Improvements in About Database Statistics in Greenplum Database 315 System Statistics 316 Table Size 316 The pg_statistic System Table and pg_stats View 316 Sampling 320 Updating Statistics 320 Analyzing Partitioned 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

Algorithm 231 Relaxed Rules for Specifying Table Distribution Columns 231 Resource Groups Features 232 PL/pgSQL Procedural Language Enhancements 232 Replicated Table Data 232 Concurrency Improvements in About Database Statistics in Greenplum Database 286 System Statistics 287 Table Size 287 The pg_statistic System Table and pg_stats View 287 Sampling 291 Updating Statistics 291 Analyzing Partitioned 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

Algorithm 207 Relaxed Rules for Specifying Table Distribution Columns 207 Resource Groups Features 207 PL/pgSQL Procedural Language Enhancements 208 Replicated Table Data 208 Concurrency Improvements in About Database Statistics in Greenplum Database 256 System Statistics 257 Table Size 257 The pg_statistic System Table and pg_stats View 257 Sampling 260 Updating Statistics 260 Analyzing Partitioned Documentation 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