370 Encrypting Data in Tables using PGP 372 Encrypting gpfdist Connections 375 Tuning SQL Queries 377 Tuning SQL Queries 0 How to Generate Explain Plans 377 How to Read Explain Plans 378 Optimizing Database 444 Uninstall the Java JAR files and Software Package 444 Writing PL/Java functions 445 SQL Declaration 445 Type Mapping 445 NULL Handling 446 Complex Types 447 Returning Complex Types 447 Language 0 About Greenplum Database PL/pgSQL 461 Greenplum Database SQL Limitations 462 The PL/pgSQL Language 462 Running SQL Commands 463 PL/pgSQL Plan Caching 463 PL/pgSQL Examples 464 Example:

361 Encrypting Data in Tables using PGP 363 Encrypting gpfdist Connections 366 Tuning SQL Queries 368 Tuning SQL Queries 0 How to Generate Explain Plans 368 How to Read Explain Plans 369 Optimizing Database 434 Uninstall the Java JAR files and Software Package 435 Writing PL/Java functions 435 SQL Declaration 436 Type Mapping 436 NULL Handling 437 Complex Types 437 Returning Complex Types 438 Language 0 About Greenplum Database PL/pgSQL 452 Greenplum Database SQL Limitations 452 The PL/pgSQL Language 452 Running SQL Commands 454 PL/pgSQL Plan Caching 454 VMware Greenplum v6.18 Documentation

Up VMware vSphere Network 351 Verifying the Distributed Virtual Switch Settings 351 Creating the Distributed Port Groups 352 Configuring the Distributed Port Groups 352 VMware Greenplum 6 Documentation by Broadcom 17 Principles of VMware vSphere Distributed Switch to Uplink Assignment 352 Using Four 100GbE Links 353 Enabling VMware vSphere Distributed Switch (vDS) Health Check 354 Next Steps 355 637 Example 4—Single gpfdist instance with error logging 637 Example 5—TEXT Format on a Hadoop Distributed File Server 638 Example 6—Multiple files in CSV format with header rows 638 Example 7—Readable

334 Verifying the Distributed Virtual Switch Settings 334 Creating the Distributed Port Groups 335 Configuring the Distributed Port Groups 336 Principles of VMware vSphere Distributed Switch to Uplink Uplink Assignment 336 Using Four 100GbE Links 336 Enabling VMware vSphere Distributed Switch (vDS) Health Check 337 Next Steps 338 Setting Up VMware vSphere DRS and HA 338 Enabling DRS 338 Enabling HA 608 Example 4—Single gpfdist instance with error logging 608 Example 5—TEXT Format on a Hadoop Distributed File Server 609 Example 6—Multiple files in CSV format with header rows 609 Example 7—Readable

315 Verifying the Distributed Virtual Switch Settings 315 Creating the Distributed Port Groups 316 Configuring the Distributed Port Groups 317 Principles of VMware vSphere Distributed Switch to Uplink Uplink Assignment 317 Using Four 100GbE Links 317 Enabling VMware vSphere Distributed Switch (vDS) Health Check 318 Next Steps 319 Setting Up VMware vSphere DRS and HA 319 Enabling DRS 319 Enabling HA 631 Example 4—Single gpfdist instance with error logging 631 Example 5—TEXT Format on a Hadoop Distributed File Server 632 Example 6—Multiple files in CSV format with header rows 632 Example 7—Readable

304 Verifying the Distributed Virtual Switch Settings 305 Creating the Distributed Port Groups 305 Configuring the Distributed Port Groups 306 Principles of VMware vSphere Distributed Switch to Uplink Uplink Assignment 306 Using Four 100GbE Links 307 Enabling VMware vSphere Distributed Switch (vDS) Health Check 308 Next Steps 308 VMware Tanzu Greenplum 6 Documentation VMware, Inc 13 Setting Up VMware 608 Example 4—Single gpfdist instance with error logging 608 Example 5—TEXT Format on a Hadoop Distributed File Server 609 Example 6—Multiple files in CSV format with header rows 609 Example 7—Readable

272 Verifying the Distributed Virtual Switch Settings 273 Creating the Distributed Port Groups 273 Configuring the Distributed Port Groups 274 Principles of VMware Vsphere Distributed Switch to Uplink Uplink Assignment 274 Using Four 100GbE Links 275 Enabling VMware Vsphere Distributed Switch (vDS) Health Check 275 Next Steps 276 Setting Up VMware vSphere DRS and HA 276 Enabling DRS 276 Enabling HA 518 Example 4—Single gpfdist instance with error logging 519 Example 5—TEXT Format on a Hadoop Distributed File Server 519 Example 6—Multiple files in CSV format with header rows 520 Example 7—Readable

Tables using PGP 298 Encrypting gpfdist Connections 301 Tuning SQL Queries 303 VMware Greenplum v6.17 Documentation VMware, Inc. 13 Tuning SQL Queries 0 How to Generate Explain Plans 303 How to Read Explain Database 369 Uninstall the Java JAR files and Software Package 370 Writing PL/Java functions 370 SQL Declaration 371 Type Mapping 371 NULL Handling 372 Complex Types 372 Returning Complex Types 373 Language 0 About Greenplum Database PL/pgSQL 387 Greenplum Database SQL Limitations 387 The PL/pgSQL Language 387 Running SQL Commands 389 PL/pgSQL Plan Caching 389 PL/pgSQL Examples 390 Example:

PGP Keys 365 Encrypting Data in Tables using PGP 367 Encrypting gpfdist Connections 370 Tuning SQL Queries 372 How to Generate Explain Plans 372 How to Read Explain Plans 373 Optimizing Greenplum Database 439 Uninstall the Java JAR files and Software Package 439 Writing PL/Java functions 439 SQL Declaration 440 Type Mapping 440 NULL Handling 441 Complex Types 441 Returning Complex Types 442 Language 455 About Greenplum Database PL/pgSQL 456 Greenplum Database SQL Limitations 456 The PL/pgSQL Language 456 Running SQL Commands 457 PL/pgSQL Plan Caching 458 PL/pgSQL Examples 458 Example:

300 Verifying the Distributed Virtual Switch Settings 301 Creating the Distributed Port Groups 301 Configuring the Distributed Port Groups 302 Principles of VMware vSphere Distributed Switch to Uplink Uplink Assignment 302 Using Four 100GbE Links 302 Enabling VMware vSphere Distributed Switch (vDS) Health Check 303 Next Steps 304 Setting Up VMware vSphere DRS and HA 304 Enabling DRS 304 Enabling HA 605 Example 4—Single gpfdist instance with error logging 606 Example 5—TEXT Format on a Hadoop Distributed File Server 606 Example 6—Multiple files in CSV format with header rows 607 Example 7—Readable