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.

Removed Features

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.

Removed Objects

This section summarizes objects removed in VMware Greenplum 7.

Removed Tables and Views

The following list includes the tables and views removed in VMware Greenplum 7.

  • gp_toolkit.gp_size_of_partition_and_indexes_disk
  • gp_toolkit.__gp_user_data_tables
  • pg_catalog.pg_partition
  • pg_catalog.pg_partition_columns
  • pg_catalog.pg_partition_encoding
  • pg_catalog.pg_partition_rule
  • pg_catalog.pg_partitions
  • pg_catalog.pg_partition_templates
  • pg_catalog.pg_stat_partition_operations

Removed Columns

The following list includes the columns removed in VMware Greenplum 7.

  • gp_toolkit.gp_locks_on_resqueue.lorwaiting
  • gp_toolkit.gp_resgroup_config.cpu_rate_limit
  • gp_toolkit.gp_resgroup_config.memory_auditor
  • gp_toolkit.gp_resgroup_config.memory_shared_quota
  • gp_toolkit.gp_resgroup_config.memory_spill_ratio
  • gp_toolkit.gp_resgroup_status.cpu_usage
  • gp_toolkit.gp_resgroup_status.memory_usage
  • gp_toolkit.gp_resgroup_status_per_host.cpu
  • gp_toolkit.gp_resgroup_status_per_host.memory_available
  • gp_toolkit.gp_resgroup_status_per_host.memory_quota_available
  • gp_toolkit.gp_resgroup_status_per_host.memory_quota_used
  • gp_toolkit.gp_resgroup_status_per_host.memory_shared_available
  • gp_toolkit.gp_resgroup_status_per_host.memory_shared_used
  • gp_toolkit.gp_resgroup_status_per_host.memory_used
  • gp_toolkit.gp_resgroup_status_per_host.rsgname
  • gp_toolkit.gp_resgroup_status_per_segment.cpu
  • gp_toolkit.gp_resgroup_status_per_segment.hostname
  • gp_toolkit.gp_resgroup_status_per_segment.memory_available
  • gp_toolkit.gp_resgroup_status_per_segment.memory_quota_available
  • gp_toolkit.gp_resgroup_status_per_segment.memory_quota_used
  • gp_toolkit.gp_resgroup_status_per_segment.memory_shared_available
  • gp_toolkit.gp_resgroup_status_per_segment.memory_shared_used
  • gp_toolkit.gp_resgroup_status_per_segment.memory_used
  • gp_toolkit.gp_resgroup_status_per_segment.rsgname
  • gp_toolkit.gp_resgroup_status.rsgname
  • gp_toolkit.__gp_user_tables.autrelstorage
  • information_schema.routines.result_cast_character_set_name
  • information_schema.routines.sql_data_access
  • pg_catalog.gp_configuration_history.desc
  • pg_catalog.gp_distributed_log.distributed_id
  • pg_catalog.gp_distributed_xacts.distributed_id
  • pg_catalog.gp_stat_replication.flush_location
  • pg_catalog.gp_stat_replication.replay_location
  • pg_catalog.gp_stat_replication.sent_location
  • pg_catalog.gp_stat_replication.write_location
  • pg_catalog.pg_proc.protransform
  • pg_catalog.pg_proc.proisagg
  • pg_catalog.pg_proc.proiswindow
  • pg_catalog.pg_am.ambeginscan
  • pg_catalog.pg_am.ambuild
  • pg_catalog.pg_am.ambuildempty
  • pg_catalog.pg_am.ambulkdelete
  • pg_catalog.pg_am.amcanbackward
  • pg_catalog.pg_am.amcanmulticol
  • pg_catalog.pg_am.amcanorder
  • pg_catalog.pg_am.amcanorderbyop
  • pg_catalog.pg_am.amcanreturn
  • pg_catalog.pg_am.amcanunique
  • pg_catalog.pg_am.amclusterable
  • pg_catalog.pg_am.amcostestimate
  • pg_catalog.pg_am.amendscan
  • pg_catalog.pg_am.amgetbitmap
  • pg_catalog.pg_am.amgettuple
  • pg_catalog.pg_am.aminsert
  • pg_catalog.pg_am.amkeytype
  • pg_catalog.pg_am.ammarkpos
  • pg_catalog.pg_am.amoptionalkey
  • pg_catalog.pg_am.amoptions
  • pg_catalog.pg_am.ampredlocks
  • pg_catalog.pg_am.amrescan
  • pg_catalog.pg_am.amrestrpos
  • pg_catalog.pg_am.amsearcharray
  • pg_catalog.pg_am.amsearchnulls
  • pg_catalog.pg_am.amstorage
  • pg_catalog.pg_am.amstrategies
  • pg_catalog.pg_am.amsupport
  • pg_catalog.pg_am.amvacuumcleanup
  • pg_catalog.pg_appendonly.blkdiridxid
  • pg_catalog.pg_appendonly.blocksize
  • pg_catalog.pg_appendonly.checksum
  • pg_catalog.pg_appendonly.columnstore
  • pg_catalog.pg_appendonly.compresslevel
  • pg_catalog.pg_appendonly.compresstype
  • pg_catalog.pg_appendonly.safefswritesize
  • pg_catalog.pg_appendonly.visimapidxid
  • pg_catalog.pg_attrdef.adsrc
  • pg_catalog.pg_authid.rolcatupdate
  • pg_catalog.pg_class.relhasoids
  • pg_catalog.pg_class.relhaspkey
  • pg_catalog.pg_class.relstorage
  • pg_catalog.pg_constraint.consrc

Removed Functions

The following list includes the functions removed in VMware Greenplum 7.

  • pg_catalog.abstime
  • pg_catalog.abstimeeq
  • pg_catalog.abstimege
  • pg_catalog.abstimegt
  • pg_catalog.abstimein
  • pg_catalog.abstimele
  • pg_catalog.abstimelt
  • pg_catalog.abstimene
  • pg_catalog.abstimeout
  • pg_catalog.abstimerecv
  • pg_catalog.abstimesend
  • pg_catalog.bmbeginscan
  • pg_catalog.bmbuild
  • pg_catalog.bmbuildempty
  • pg_catalog.bmbulkdelete
  • pg_catalog.bmcostestimate
  • pg_catalog.bmendscan
  • pg_catalog.bmgetbitmap
  • pg_catalog.bmgettuple
  • pg_catalog.bminsert
  • pg_catalog.bmmarkpos
  • pg_catalog.bmoptions
  • pg_catalog.bmrescan
  • pg_catalog.bmrestrpos
  • pg_catalog.bmvacuumcleanup
  • pg_catalog.btabstimecmp
  • pg_catalog.btbeginscan
  • pg_catalog.btbuild
  • pg_catalog.btbuildempty
  • pg_catalog.btbulkdelete
  • pg_catalog.btcanreturn
  • pg_catalog.btcostestimate
  • pg_catalog.btendscan
  • pg_catalog.btgetbitmap
  • pg_catalog.btgettuple
  • pg_catalog.btinsert
  • pg_catalog.btmarkpos
  • pg_catalog.btoptions
  • pg_catalog.btreltimecmp
  • pg_catalog.btrescan
  • pg_catalog.btrestrpos
  • pg_catalog.bttintervalcmp
  • pg_catalog.btvacuumcleanup
  • pg_catalog.cdblegacyhash_abstime
  • pg_catalog.cdblegacyhash_reltime
  • pg_catalog.cdblegacyhash_tinterval
  • pg_catalog.ginbeginscan
  • pg_catalog.ginbuild
  • pg_catalog.ginbuildempty
  • pg_catalog.ginbulkdelete
  • pg_catalog.gincostestimate
  • pg_catalog.ginendscan
  • pg_catalog.gingetbitmap
  • pg_catalog.gininsert
  • pg_catalog.ginmarkpos
  • pg_catalog.ginoptions
  • pg_catalog.ginrescan
  • pg_catalog.ginrestrpos
  • pg_catalog.ginvacuumcleanup
  • pg_catalog.gistbeginscan
  • pg_catalog.gist_box_compress
  • pg_catalog.gist_box_decompress
  • pg_catalog.gistbuild
  • pg_catalog.gistbuildempty
  • pg_catalog.gistbulkdelete
  • pg_catalog.gistcostestimate
  • pg_catalog.gistendscan
  • pg_catalog.gistgetbitmap
  • pg_catalog.gistgettuple
  • pg_catalog.gistinsert
  • pg_catalog.gistmarkpos
  • pg_catalog.gistoptions
  • pg_catalog.gistrescan
  • pg_catalog.gistrestrpos
  • pg_catalog.gistvacuumcleanup
  • pg_catalog.gp_elog
  • pg_catalog.gp_fault_inject
  • pg_catalog.gp_quicklz_compress
  • pg_catalog.gp_quicklz_constructor
  • pg_catalog.gp_quicklz_decompress
  • pg_catalog.gp_quicklz_destructor
  • pg_catalog.gp_quicklz_validator
  • pg_catalog.gp_update_ao_master_stats
  • pg_catalog.gtsquery_decompress
  • pg_catalog.hashbeginscan
  • pg_catalog.hashbuild
  • pg_catalog.hashbuildempty
  • pg_catalog.hashbulkdelete
  • pg_catalog.hashcostestimate
  • pg_catalog.hashendscan
  • pg_catalog.hashgetbitmap
  • pg_catalog.hashgettuple
  • pg_catalog.hashinsert
  • pg_catalog.hashint2vector
  • pg_catalog.hashmarkpos
  • pg_catalog.hashoptions
  • pg_catalog.hashrescan
  • pg_catalog.hashrestrpos
  • pg_catalog.hashvacuumcleanup
  • pg_catalog.inet_gist_decompress
  • pg_catalog.int2vectoreq
  • pg_catalog.interval
  • pg_catalog.interval_transform
  • pg_catalog.mktinterval
  • pg_catalog.numeric2point
  • pg_catalog.numeric_transform
  • pg_catalog.pg_current_xlog_insert_location
  • pg_catalog.pg_current_xlog_location
  • pg_catalog.pg_get_partition_def
  • pg_catalog.pg_get_partition_rule_def
  • pg_catalog.pg_get_partition_template_def
  • pg_catalog.pg_is_xlog_replay_paused
  • pg_catalog.pg_last_xlog_receive_location
  • pg_catalog.pg_last_xlog_replay_location
  • pg_catalog.pg_stat_get_backend_waiting
  • pg_catalog.pg_stat_get_backend_waiting_reason
  • pg_catalog.pg_switch_xlog
  • pg_catalog.pg_xlogfile_name
  • pg_catalog.pg_xlogfile_name_offset
  • pg_catalog.pg_xlog_location_diff
  • pg_catalog.pg_xlog_replay_pause
  • pg_catalog.pg_xlog_replay_resume
  • pg_catalog.range_gist_compress
  • pg_catalog.range_gist_decompress
  • pg_catalog.reltime
  • pg_catalog.reltimeeq
  • pg_catalog.reltimege
  • pg_catalog.reltimegt
  • pg_catalog.reltimein
  • pg_catalog.reltimele
  • pg_catalog.reltimelt
  • pg_catalog.reltimene
  • pg_catalog.reltimeout
  • pg_catalog.reltimerecv
  • pg_catalog.reltimesend
  • pg_catalog.smgreq
  • pg_catalog.smgrin
  • pg_catalog.smgrne
  • pg_catalog.smgrout
  • pg_catalog.spgbeginscan
  • pg_catalog.spgbuild
  • pg_catalog.spgbuildempty
  • pg_catalog.spgbulkdelete
  • pg_catalog.spgcanreturn
  • pg_catalog.spgcostestimate
  • pg_catalog.spgendscan
  • pg_catalog.spggetbitmap
  • pg_catalog.spggettuple
  • pg_catalog.spginsert
  • pg_catalog.spgmarkpos
  • pg_catalog.spgoptions
  • pg_catalog.spgrescan
  • pg_catalog.spgrestrpos
  • pg_catalog.spgvacuumcleanup
  • pg_catalog.timemi
  • pg_catalog.timenow
  • pg_catalog.timepl
  • pg_catalog.timestamp_transform
  • pg_catalog.time_transform
  • pg_catalog.tinterval
  • pg_catalog.tintervalct
  • pg_catalog.tintervalend
  • pg_catalog.tintervaleq
  • pg_catalog.tintervalge
  • pg_catalog.tintervalgt
  • pg_catalog.tintervalin
  • 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.tintervalout
  • pg_catalog.tintervalov
  • pg_catalog.tintervalrecv
  • pg_catalog.tintervalrel
  • pg_catalog.tintervalsame
  • pg_catalog.tintervalsend
  • pg_catalog.tintervalstart
  • pg_catalog.varbit_transform
  • pg_catalog.varchar_transform

Removed Types and Composite Types

The following list includes the types and composite types removed in VMware Greenplum 7.

Types

  • pg_catalog._reltime
  • pg_catalog.reltime
  • pg_catalog.smgr
  • pg_catalog._tinterval
  • pg_catalog.tinterval
  • pg_catalog._abstime
  • pg_catalog.abstim

Composite Types

  • gp_toolkit.gp_size_of_partition_and_indexes_disk
  • gp_toolkit.__gp_user_data_tables
  • pg_catalog.pg_partition
  • pg_catalog.pg_partition_columns
  • pg_catalog.pg_partition_encoding
  • pg_catalog.pg_partition_rule
  • pg_catalog.pg_partitions
  • pg_catalog.pg_partition_templates
  • pg_catalog.pg_stat_partition_operations

Removed Operators

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
check-circle-line exclamation-circle-line close-line
Scroll to top icon