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

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 Replicate an Existing Backup 501 Backup/Restore Storage Plugin API 501 Backup/Restore Storage Plugin API 0 Plugin Configuration File 501 Plugin API 502 Plugin Commands 503 Implementing a Backup/Restore Storage delete_backup 0 Synopsis 510 Description 510 Arguments 510 Exit Code 510 Example 510 plugin_api_version 511 plugin_api_version 0 Synopsis 511 Description 511 Return Value 511 restore_data 511 restore_data

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

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

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