Greenplum Database 5.x Pre-Migration Actions 467 Step 2: Migrating PXF to Greenplum 6.x 468 Migrating gphdfs External Tables to PXF 470 Preparing for the Migration 471 Setting Up PXF 472 Creating a PXF External Options 475 Example gphdfs to pxf External Table Mapping for an HDFS Text File 475 Verifying Access with PXF 476 Removing the gphdfs External Tables 476 Revoking Privileges to the gphdfs Protocol 476 VMware VMware Greenplum 6 Documentation VMware, Inc 248 Pivotal Greenplum Database 6 no longer supports the gphdfs external table protocol to access a Hadoop system. Use the Greenplum Platform Extension Framework

Greenplum Database 5.x Pre-Migration Actions 462 Step 2: Migrating PXF to Greenplum 6.x 462 Migrating gphdfs External Tables to PXF 465 VMware Greenplum 6 Documentation VMware by Broadcom 22 Preparing for Options 469 Example gphdfs to pxf External Table Mapping for an HDFS Text File 470 Verifying Access with PXF 470 Removing the gphdfs External Tables 470 Revoking Privileges to the gphdfs Protocol 470 Upgrading Greenplum 6 Documentation VMware by Broadcom 280 Pivotal Greenplum Database 6 no longer supports the gphdfs external table protocol to access a Hadoop system. Use the Greenplum Platform Extension Framework

Greenplum Database 5.x Pre-Migration Actions 378 Step 2: Migrating PXF to Greenplum 6.x 379 Migrating gphdfs External Tables to PXF 381 Preparing for the Migration 381 Setting Up PXF 382 VMware Tanzu Greenplum Options 385 Example gphdfs to pxf External Table Mapping for an HDFS Text File 385 Verifying Access with PXF 386 Removing the gphdfs External Tables 386 Revoking Privileges to the gphdfs Protocol 386 Upgrading memory within the file system cache for backup. Pivotal Greenplum Database 6 no longer supports the gphdfs external table protocol to access a Hadoop system. Use the Greenplum Platform Extension Framework

Greenplum Database 5.x Pre-Migration Actions 443 Step 2: Migrating PXF to Greenplum 6.x 443 Migrating gphdfs External Tables to PXF 446 Preparing for the Migration 447 Setting Up PXF 447 Creating a PXF External Options 450 Example gphdfs to pxf External Table Mapping for an HDFS Text File 451 Verifying Access with PXF 451 Removing the gphdfs External Tables 451 Revoking Privileges to the gphdfs Protocol 451 Upgrading memory within the file system cache for backup. Pivotal Greenplum Database 6 no longer supports the gphdfs external table protocol to access a Hadoop system. Use the Greenplum Platform Extension Framework

Greenplum Database 5.x Pre-Migration Actions 451 Step 2: Migrating PXF to Greenplum 6.x 452 Migrating gphdfs External Tables to PXF 454 Preparing for the Migration 455 Setting Up PXF 456 Creating a PXF External Options 459 Example gphdfs to pxf External Table Mapping for an HDFS Text File 459 Verifying Access with PXF 460 Removing the gphdfs External Tables 460 Revoking Privileges to the gphdfs Protocol 460 Upgrading memory within the file system cache for backup. Pivotal Greenplum Database 6 no longer supports the gphdfs external table protocol to access a Hadoop system. Use the Greenplum Platform Extension Framework

Greenplum Database 5.x Pre-Migration Actions 449 Step 2: Migrating PXF to Greenplum 6.x 449 Migrating gphdfs External Tables to PXF 451 Preparing for the Migration 452 Setting Up PXF 453 Creating a PXF External Options 456 Example gphdfs to pxf External Table Mapping for an HDFS Text File 456 Verifying Access with PXF 457 Removing the gphdfs External Tables 457 Revoking Privileges to the gphdfs Protocol 457 Upgrading memory within the file system cache for backup. Pivotal Greenplum Database 6 no longer supports the gphdfs external table protocol to access a Hadoop system. Use the Greenplum Platform Extension Framework

memory within the file system cache for backup. Pivotal Greenplum Database 6 no longer supports the gphdfs external table protocol to access a Hadoop system. Use the Greenplum Platform Extension Framework migration: If you are using the gphdfs external table protocol to access data stored in Hadoop in your Greenplum Database 5.x installation, you must first migrate your gphdfs VMware Tanzu Greenplum v6.20 external tables to use PXF instead, since Greenplum Database version 6 removes support for the gphdfs protocol. PXF actions are required if you choose a gpupgrade-based Greenplum Database 5.x to 6

memory within the file system cache for backup. Pivotal Greenplum Database 6 no longer supports the gphdfs external table protocol to access a Hadoop system. Use the Greenplum Platform Extension Framework Greenplum Database 5.x. If you were previously using the gphdfs external table protocol to access data stored in Hadoop, you must migrate your gphdfs external tables to use PXF instead, since Greenplum Database Database version 6 removes support for the gphdfs protocol. 2. Upgrading PXF after upgrading Greenplum Database from a previous 6.x version. Note that different steps are outlined based on your PXF installation

memory within the file system cache for backup. Pivotal Greenplum Database 6 no longer supports the gphdfs external table protocol to access a Hadoop system. Use the Greenplum Platform Extension Framework Greenplum Database 5.x. If you were previously using the gphdfs external table protocol to access data stored in Hadoop, you must also migrate your gphdfs external tables to use PXF instead, since Greenplum Greenplum Database version 6 removes support for the gphdfs protocol. 2. Upgrading PXF after upgrading Greenplum Database from a previous 6.x version. Note that different steps are outlined based on your PXF

Greenplum Database 5.x. If you were previously using the gphdfs external table protocol to access data stored in Hadoop, you must migrate your gphdfs external tables to use PXF instead, since Greenplum Database Database version 6 removes support for the gphdfs protocol. 2. Upgrading PXF after upgrading Greenplum Database from a previous 6.x version. Note that different steps are outlined based on your PXF installation migration. Greenplum Database version 6 removes support for the gphdfs protocol. If you have created external tables that use gphdfs, remove the external table definitions and (optionally) recreate