PRODUCT DOCUMENTATION Pivotal™ Greenplum Database® Version 5.17.0 Pivotal Greenplum Database Documentation Rev: A01 © 2019 Pivotal Software, Inc. Copyright OpenTopic Notice Copyright Privacy Policy | Terms of Use Copyright © 2019 Pivotal Software, Inc. All rights reserved. Pivotal Software, Inc. believes the information in this publication is accurate as of its publication date. The information is subject to change without notice. THE INFORMATION IN THIS PUBLICATION IS PROVIDED "AS IS." PIVOTAL SOFTWARE, INC. ("Pivotal") MAKES NO REPRESENTATIONS OR WARRANTIES OF ANY KIND WITH RESPECT TO THE INFORMATION IN THIS PUBLICATION, AND SPECIFICALLY DISCLAIMS IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Use, copying, and distribution of any Pivotal software described in this publication requires an applicable software license. All trademarks used herein are the property of Pivotal or their respective owners. Revised February 2019 (5.17.0) 2 Contents OpenTopic Contents Chapter 1: Pivotal Greenplum 5.17.0 Release Notes............................. 14 Welcome to Pivotal Greenplum 5.17.0............................................................................................. 15 Changed Feature...............................................................................................................................16 Experimental Features...................................................................................................................... 17 Deprecated Features......................................................................................................................... 18 Resolved Issues................................................................................................................................ 19 Known Issues and Limitations.......................................................................................................... 20 Differences Compared to Open Source Greenplum Database.........................................................29 Supported Platforms.......................................................................................................................... 30 Veritas NetBackup.................................................................................................................. 32 Supported Platform Notes...................................................................................................... 32 Pivotal Greenplum Tools and Extensions Compatibility................................................................... 34 Client Tools.............................................................................................................................34 Extensions...............................................................................................................................35 Pivotal Greenplum Data Connectors......................................................................................36 Pivotal GPText Compatibility.................................................................................................. 36 Pivotal Greenplum Command Center.................................................................................... 36 Hadoop Distribution Compatibility..................................................................................................... 37 Upgrading to Greenplum Database 5.17.0....................................................................................... 38 Upgrading from 5.x to 5.17.0................................................................................................. 39 Troubleshooting a Failed Upgrade......................................................................................... 41 Migrating Data to Pivotal Greenplum 5.x..........................................................................................42 Pivotal Greenplum on DCA Systems................................................................................................44 Installing the Pivotal Greenplum 5.17.0 Software Binaries on DCA Systems........................ 44 Upgrading from 5.x to 5.17.0 on DCA Systems.....................................................................44 Update for gp_toolkit.gp_bloat_expected_pages Issue.................................................................... 47 Update for gp_toolkit.gp_bloat_diag Issue........................................................................................49 Chapter 2: Greenplum Database Installation Guide...............................51 Introduction to Greenplum.................................................................................................................52 The Greenplum Master.........................................................