for Python 443 R Data Science Library Package 443 R Data Science Libraries 444 Installing the R Data Science Library Package 446 Uninstalling the R Data Science Library Package 447 Greenplum Platform Preparing Greenplum 4.3 and 5 Databases for Backup 475 About Migrating Views Created with lag()/lead() Functions 478 Backing Up and Restoring a Database 479 Completing the Migration 480 Working With Hash Operator Greenplum Environment Variables 497 Required Environment Variables 497 GPHOME 498 PATH 498 LD_LIBRARY_PATH 498 MASTER_DATA_DIRECTORY 498 Optional Environment Variables 498 PGAPPNAME 498 PGDATABASE

Data Science Library Package 282 R Data Science Library Package 0 R Data Science Libraries 283 Installing the R Data Science Library Package 285 Uninstalling the R Data Science Library Package 286 Greenplum Environment Variables 0 Required Environment Variables 312 GPHOME 312 PATH 312 LD_LIBRARY_PATH 312 MASTER_DATA_DIRECTORY 313 Optional Environment Variables 313 PGAPPNAME 313 PGDATABASE Explain Plans 378 Optimizing Greenplum Queries 380 Greenplum Grouping Extensions 381 Window Functions 381 High Availability 382 High Availability 0 Disk Storage 382 Best Practices 383 Master Mirroring

for Python 424 R Data Science Library Package 425 R Data Science Libraries 425 Installing the R Data Science Library Package 427 Uninstalling the R Data Science Library Package 428 Greenplum Platform Preparing Greenplum 4.3 and 5 Databases for Backup 456 About Migrating Views Created with lag()/lead() Functions 459 Backing Up and Restoring a Database 460 Completing the Migration 461 Working With Hash Operator Greenplum Environment Variables 468 Required Environment Variables 469 GPHOME 469 PATH 469 LD_LIBRARY_PATH 469 MASTER_DATA_DIRECTORY 469 Optional Environment Variables 470 PGAPPNAME 470 PGDATABASE

Data Science Library Package 274 R Data Science Library Package 0 R Data Science Libraries 274 Installing the R Data Science Library Package 276 Uninstalling the R Data Science Library Package 276 Greenplum Environment Variables 0 Required Environment Variables 302 GPHOME 303 PATH 303 LD_LIBRARY_PATH 303 MASTER_DATA_DIRECTORY 303 Optional Environment Variables 303 VMware Greenplum v6.18 Documentation Explain Plans 369 Optimizing Greenplum Queries 371 Greenplum Grouping Extensions 372 Window Functions 373 High Availability 373 High Availability 0 Disk Storage 373 Best Practices 374 Master Mirroring

for Python 434 R Data Science Library Package 435 R Data Science Libraries 435 Installing the R Data Science Library Package 436 Uninstalling the R Data Science Library Package 437 Greenplum Platform Preparing Greenplum 4.3 and 5 Databases for Backup 464 About Migrating Views Created with lag()/lead() Functions 467 Backing Up and Restoring a Database 468 Completing the Migration 468 Working With Hash Operator Variables 474 GPHOME 474 PATH 474 VMware Tanzu Greenplum 6 Documentation VMware, Inc 19 LD_LIBRARY_PATH 474 MASTER_DATA_DIRECTORY 475 Optional Environment Variables 475 PGAPPNAME 475 PGDATABASE

Science Library Package 450 R Data Science Libraries 450 VMware Greenplum 6 Documentation VMware, Inc 18 Installing the R Data Science Library Package 451 Uninstalling the R Data Science Library Package Preparing Greenplum 4.3 and 5 Databases for Backup 480 About Migrating Views Created with lag()/lead() Functions 484 Backing Up and Restoring a Database 485 Completing the Migration 485 Working With Hash Operator Greenplum Environment Variables 493 Required Environment Variables 493 GPHOME 493 PATH 494 LD_LIBRARY_PATH 494 MASTER_DATA_DIRECTORY 494 Optional Environment Variables 494 PGAPPNAME 494 PGDATABASE

Data Science Library Package 207 R Data Science Library Package 0 R Data Science Libraries 208 Installing the R Data Science Library Package 210 Uninstalling the R Data Science Library Package 210 Greenplum Environment Variables 0 Required Environment Variables 236 GPHOME 236 PATH 236 LD_LIBRARY_PATH 236 MASTER_DATA_DIRECTORY 237 Optional Environment Variables 237 PGAPPNAME 237 PGDATABASE Explain Plans 304 Optimizing Greenplum Queries 306 Greenplum Grouping Extensions 307 Window Functions 308 High Availability 308 High Availability 0 Disk Storage 308 Best Practices 309 Master Mirroring

for Python 432 R Data Science Library Package 432 R Data Science Libraries 432 Installing the R Data Science Library Package 434 Uninstalling the R Data Science Library Package 434 Greenplum Platform Preparing Greenplum 4.3 and 5 Databases for Backup 461 About Migrating Views Created with lag()/lead() Functions 464 Backing Up and Restoring a Database 465 Completing the Migration 466 Working With Hash Operator Greenplum Environment Variables 471 Required Environment Variables 471 GPHOME 471 PATH 472 LD_LIBRARY_PATH 472 MASTER_DATA_DIRECTORY 472 Optional Environment Variables 472 PGAPPNAME 472 PGDATABASE

Module Package 278 R Data Science Library Package 279 R Data Science Libraries 279 Installing the R Data Science Library Package 281 Uninstalling the R Data Science Library Package 281 Greenplum Platform Greenplum Environment Variables 306 Required Environment Variables 306 GPHOME 307 PATH 307 LD_LIBRARY_PATH 307 MASTER_DATA_DIRECTORY 307 Optional Environment Variables 307 PGAPPNAME 307 PGDATABASE Explain Plans 373 Optimizing Greenplum Queries 375 Greenplum Grouping Extensions 376 Window Functions 376 High Availability 377 Disk Storage 377 Best Practices 377 Master Mirroring 378 Best Practices

Additional Supplied Modules and Extensions 134 SQL Commands 135 Database Maintenance 136 System Functions, Catalog Tables and Views 137 Greenplum Query Optimizer (GPORCA) 138 Append-Optimized Tables 138 for Python 232 R Data Science Library Package 232 R Data Science Libraries 232 Installing the R Data Science Library Package 234 Uninstalling the R Data Science Library Package 234 Greenplum Platform Documentation VMware by Broadcom 9 Required Environment Variables 264 GPHOME 265 PATH 265 LD_LIBRARY_PATH 265 COORDINATOR_DATA_DIRECTORY 265 Optional Environment Variables 265 PGAPPNAME 265 PGDATABASE