Greenplum Database 7 removes several database features and objects. These changes can potentially affect successfully upgrading from one major version to another. Review this list of removed features and objects before upgrading from Greenplum 6 to Greenplum 7.
The following features have been removed in Greenplum 7:
Support for Quicklz compression. To avoid breaking applications that use Quicklz, set the gp_quicklz_fallback
server configuration parameter to true
.
The --skip_root_stats
option of the analyzedb
utility. analyzedb
populates root statistics required by the optimizer by default.
The Greenplum R Client.
Greenplum MapReduce.
The ARRAY_NAME
variable. It is no longer used by VMware Greenplum.
The PL/Container 3.0 Beta extension. Instead, use the regular PL/Container extension.
The gp_percentil_agg
extension. This is not part of the core Greenplum product.
The createlang
and droplang
utilties. Instead, use CREATE EXTENSION
and DROP EXTENSION
directly.
Support for python2 and the plpythonu
extension.
This section summarizes objects removed in VMware Greenplum 7.
The following list includes the tables and views removed in VMware Greenplum 7.
The following list includes the columns removed in VMware Greenplum 7.
The following list includes the functions removed in VMware Greenplum 7.
The following list includes the types and composite types removed in VMware Greenplum 7.
Types
Composite Types
The following list includes the operators removed in VMware Greenplum 7.
oprname | oprcode | |
---|---|---|
pg_catalog.= | abstimeeq | |
pg_catalog.>= | abstimege | |
pg_catalog.> | abstimegt | |
pg_catalog.<= | abstimele | |
pg_catalog.< | abstimelt | |
pg_catalog.<> | abstimene | |
pg_catalog.= | int2vectoreq | |
pg_catalog.<?> | intinterval | |
pg_catalog.<#> | mktinterval | |
pg_catalog.= | reltimeeq | |
pg_catalog.> | reltimege | |
pg_catalog.> | reltimegt | |
pg_catalog.<= | reltimele | |
pg_catalog.< | reltimelt | |
pg_catalog.<> | reltimene | |
pg_catalog.- | timemi | |
pg_catalog.+ | timepl | |
pg_catalog.<< | tintervalct | |
pg_catalog.= | tintervaleq | |
pg_catalog.>= | tintervalge | |
pg_catalog.> | tintervalgt | |
pg_catalog.<= | tintervalle | |
pg_catalog.#= | tintervalleneq | |
pg_catalog.#>= | tintervallenge | |
pg_catalog.#> | tintervallengt | |
pg_catalog.#<= | tintervallenle | |
pg_catalog.#< | tintervallenlt | |
pg_catalog.#<> | tintervallenne | |
pg_catalog.< | tintervallt | |
pg_catalog.<> | tintervalne | |
pg_catalog.&& | tintervalov | |
pg_catalog.~= | tintervalsame | |
pg_catalog. | tintervalstart |