× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Lwaugh reported 2018-03-27T00:01:09Z  · tomconrad last modified 2018-09-12T14:10:08Z

Support of Pivotal Greenplum Version 5.0.0


customer request
Priority Major
Complexity Unknown
Component DB - Greenplum
Version 19.5

Release notes:

https://gpdb.docs.pivotal.io/560/relnotes/GPDB_561_README.html#topic_irl_p5n_scb

 

Note:  We will not support the experimental features offered in this version.

 

Query Optimization Enhancements

Greenplum Database 5.6.1 includes these GPORCA enhancements:
  • To improve GPORCA query optimization performance, resource usage information is retrieved only when required when generating optimization statistics. In previous releases, the information was being retrieved whenever the GPORCA timer was reset.
  • When optimizing queries against partitioned tables, GPORCA calculates predicate conditions that are partitioning conditions. To improve optimization performance, these partitioning conditions are cached and reused during query optimization. In previous releases, the partitioning conditions were calculated multiple times during query optimization.
  • To improve query optimization, GPORCA exhaustive join order generation maintains a top-n list of order alternatives making the join order processing pick the join order with the lowest cost estimated cost. In previous releases, the ordering of the join alternative did not guarantee the lowest cost join ordering.

PL/Container Enhancements

PL/Container has been updated to version 1.1. Greenplum Database 5.6.1 supports PL/Container 1.1. PL/Container 1.1 includes these enhancements:
  • PL/Container is installed as a Greenplum Database extension. PL/Container 1.1 is installed by gppkg as a Greenplum Database extension, while PL/Container 1.0 extension is installed as a Greenplum Database language. Upgrading to PL/Container 1.1 from 1.0 requires uninstalling PL/Container 1.0.

  • PL/Container configuration supports adjusting the CPU usage for Docker containers that are controlled by PL/Container.

    In the PL/Container configuration file, the cpu_share attribute of a settings attribute is a relative weighting of CPU usage compared to other containers. For example, a container with a cpu_share of 2048 is allocated double the CPU slice time compared with container with the default value of 1024.

For information about the PL/Container extension in Greenplum Database including upgrading to PL/Container 1.1, see PL/Container Language Extension.

gpbackup and gprestore Enhancements

Greenplum Database 5.6.1 includes these gpbackup and gprestore enhancements.
  • The gpbackup and gprestore utilities are included in the Greenplum Databse SuSE distribution.
  • The utilities support Data Domain DD Boost File System Plug-In (BoostFS). For information about using BoostFS, see Using gpbackup and gprestore with BoostFS.

Parameter to Ignore 4.3.x INTO ERROR TABLE Clause

The Greenplum Database server configuration parameter gp_ignore_error_table controls Greenplum Database behavior when the INTO ERROR TABLE clause is specified in a CREATE EXTERNAL TABLE or COPY command. The INTO ERROR TABLE clause was removed in Greenplum Database 5.

The default value is false, Greenplum Database returns an error if the INTO ERROR TABLEclause is specified in a command.

If the value is true, Greenplum Database ignores the clause, issues a warning, and executes the command and logs information about data rows with formatting errors. In Greenplum Database 5.x, you access the error log information with built-in SQL functions. See the CREATE EXTERNAL TABLE or COPY command.

You can set this value to true to avoid the Greenplum Database 5 error when you run applications that execute CREATE EXTERNAL TABLE or COPY commands that include the Greenplum Database 4.3.x INTO ERROR TABLE clause.

Value Range Default Set Classifications
Boolean false master

system

reload

For information about Greenplum Database server configuration parameters, see Server Configuration Parameters.

Experimental Pivotal Greenplum-Informatica Connector

Greenplum Database 5.6 provides integration with the new Pivotal Greenplum-Informatica Connector (experimental). The Pivotal Greenplum-Informatica Connector supports high speed data transfer from an Informatica PowerCenter cluster to a Pivotal Greenplum Database cluster for batch and streaming ETL operations.

Greenplum Database 5.6 introduces the Greenplum Streaming Server (GPSS) component, which manages all communication between the Informatica PowerCenter node and the Pivotal Greenplum Database cluster. See the Pivotal Greenplum-Informatica Connector (Experimental) Documentation.

Greenplum Metrics Collection Extension

The Greenplum Metrics Collection Extension has been added to this release. This extension is a prerequisite for an upcoming Pivotal Greenplum Command Center release on Red Hat and CentOS platforms, and is not yet enabled.

The extension is installed in the$GPHOME/share/postgresql/extension/metrics_collection directory, and its library files are installed in the $GPHOME/lib/postgresql directory.

The server configuration parameter shared_preload_libraries in the master and segment postgresql.conf files is updated to include the name of the extension's shared library, metrics_collection.so.

Changed Features

Greenplum Database 5.6.1 includes these changed features.
  • For PL/Container 1.1, the configuration attribute use_container_network is not supported. PL/Container 1.1 determines the appropriate network protocol. When upgrading to PL/Container 1.1 the attribute must be removed from the configuration file. For information about PL/Container 1.1, see New Features.
  • For the Python installed with Greenplum Database, the Python paramiko library has been updated to version 1.18.1. The update helps resolve issues with cryptography libraries used on RHEL 7.4 systems with FIPS enabled. See resolved issue 29089.
  • Resource group cgroup configuration has changed. The gpdb.conf cgroup configuration file must now include a memory control group. The memory control group is a placeholder for future support of cgroup-based memory management for Greenplum Database external components. If you have enabled resource group-based resource management in your current Greenplum Database installation, you must re-configure cgroups. Refer to Upgrading to Greenplum Database 5.6.1 for resource group cgroup upgrade instructions. See Using Resource Groups in the Greenplum Database Administrator Guide for general resource group configuration and usage information.

 

Issue #15539

Verified
Fixed
Resolved 2018-09-12T14:09:33Z
 
 
Completion
Due Mar 30, 2018
Fixed Build ADS19.5.0-dev-11
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017