1906 gp_dynamic_partition_pruning 1906 gp_eager_two_phase_agg 1906 gp_enable_agg_distinct 1906 gp_enable_agg_distinct_pruning 1907 gp_enable_direct_dispatch 1907 gp_enable_exchange_default_partition gp_enable_global_deadlock_detector 1908 gp_enable_gpperfmon 1908 gp_enable_groupext_distinct_gather 1908 gp_enable_groupext_distinct_pruning 1908 gp_enable_multiphase_agg 1908 gp_enable_predicate_propagation s 1909 gp_enable_relsize_collection 1910 gp_enable_segment_copy_checking 1910 gp_enable_sort_distinct 1910 gp_enable_sort_limit 1910 gp_external_enable_exec 1910 gp_external_max_segs 1911 VMware

gp_dispatch_keepalives_interval 1586 gp_dynamic_partition_pruning 1586 gp_enable_agg_distinct 1586 gp_enable_agg_distinct_pruning 1587 gp_enable_direct_dispatch 1587 gp_enable_exchange_default_partition gp_enable_global_deadlock_detector 1588 gp_enable_gpperfmon 1588 gp_enable_groupext_distinct_gather 1589 gp_enable_groupext_distinct_pruning 1589 gp_enable_multiphase_agg 1589 gp_enable_predicate_propagation s 1590 gp_enable_relsize_collection 1590 gp_enable_segment_copy_checking 1591 gp_enable_sort_distinct 1591 gp_enable_sort_limit 1591 gp_external_enable_exec 1592 gp_external_max_segs 1592 gp_ex

gp_default_storage_options 1574 gp_dynamic_partition_pruning 1576 gp_enable_agg_distinct 1576 gp_enable_agg_distinct_pruning 1576 gp_enable_direct_dispatch 1577 gp_enable_exchange_default_partition gp_enable_global_deadlock_detector 1578 gp_enable_gpperfmon 1578 gp_enable_groupext_distinct_gather 1578 gp_enable_groupext_distinct_pruning 1579 gp_enable_multiphase_agg 1579 gp_enable_predicate_propagation s 1580 gp_enable_relsize_collection 1580 gp_enable_segment_copy_checking 1580 gp_enable_sort_distinct 1581 gp_enable_sort_limit 1581 gp_external_enable_exec 1581 gp_external_max_segs 1582 gp_ex

(label[], label, expr) int[], bigint[], float[] pivot_sum( array[‘A1’,‘A2’], attr, value) A pivot aggregation using sum to resolve duplicate entries. unnest (array[]) set of anyelement unnest( array[‘one’ (label[], label, expr) int[], bigint[], float[] pivot_sum( array[‘A1’,‘A2’], attr, value) A pivot aggregation using sum to resolve duplicate entries. unnest (array[]) set of anyelement unnest( array[‘one’ 1811 gp_dynamic_partition_pruning 1811 gp_eager_two_phase_agg 1811 gp_enable_agg_distinct 1811 gp_enable_agg_distinct_pruning 1812 gp_enable_direct_dispatch 1812 gp_enable_exchange_default_partition

ning 1510 VMware Greenplum v6.17 Documentation VMware, Inc. 108 gp_enable_agg_distinct 1510 gp_enable_agg_distinct_pruning 1511 gp_enable_direct_dispatch 1511 gp_enable_exchange_default_partition gp_enable_global_deadlock_detector 1512 gp_enable_gpperfmon 1512 gp_enable_groupext_distinct_gather 1513 gp_enable_groupext_distinct_pruning 1513 gp_enable_multiphase_agg 1513 gp_enable_predicate_propagation s 1514 gp_enable_relsize_collection 1514 gp_enable_segment_copy_checking 1515 gp_enable_sort_distinct 1515 gp_enable_sort_limit 1515 gp_external_enable_exec 1516 gp_external_max_segs 1516 gp_ex

GROUP BY Clause 1508 The HAVING Clause 1510 The WINDOW Clause 1510 The SELECT List 1514 The DISTINCT Clause 1515 The UNION Clause 1515 The INTERSECT Clause 1516 The EXCEPT Clause 1516 The ORDER ng 1728 gp_eager_two_phase_agg 1728 gp_enable_agg_distinct 1728 VMware Greenplum 7 Documentation VMware by Broadcom 102 gp_enable_agg_distinct_pruning 1729 gp_enable_direct_dispatch 1729 gp_enable_fast_sri gp_enable_fast_sri 1729 gp_enable_global_deadlock_detector 1729 gp_enable_groupext_distinct_gather 1730 gp_enable_groupext_distinct_pruning 1730 gp_enable_multiphase_agg 1730 gp_enable_predicate_propagation

(label[], label, expr) int[], bigint[], float[] pivot_sum( array[‘A1’,‘A2’], attr, value) A pivot aggregation using sum to resolve duplicate entries. unnest (array[]) set of anyelement unnest( array[‘one’ (label[], label, expr) int[], bigint[], float[] pivot_sum( array[‘A1’,‘A2’], attr, value) A pivot aggregation using sum to resolve duplicate entries. unnest (array[]) set of anyelement unnest( array[‘one’ gp_dispatch_keepalives_interval 1592 gp_dynamic_partition_pruning 1593 gp_enable_agg_distinct 1593 gp_enable_agg_distinct_pruning 1593 gp_enable_direct_dispatch 1593 gp_enable_exchange_default_partition

gp_dispatch_keepalives_interval 1598 gp_dynamic_partition_pruning 1598 gp_enable_agg_distinct 1599 gp_enable_agg_distinct_pruning 1599 gp_enable_direct_dispatch 1599 gp_enable_exchange_default_partition gp_enable_global_deadlock_detector 1600 gp_enable_gpperfmon 1601 gp_enable_groupext_distinct_gather 1601 gp_enable_groupext_distinct_pruning 1601 gp_enable_multiphase_agg 1601 gp_enable_predicate_propagation s 1602 gp_enable_relsize_collection 1603 gp_enable_segment_copy_checking 1603 gp_enable_sort_distinct 1603 gp_enable_sort_limit 1604 gp_external_enable_exec 1604 gp_external_max_segs 1604 gp_ex

108 gp_dynamic_partition_pruning 1865 gp_eager_two_phase_agg 1866 gp_enable_agg_distinct 1866 gp_enable_agg_distinct_pruning 1866 gp_enable_direct_dispatch 1866 gp_enable_exchange_default_partition gp_enable_global_deadlock_detector 1867 gp_enable_gpperfmon 1867 gp_enable_groupext_distinct_gather 1868 gp_enable_groupext_distinct_pruning 1868 gp_enable_multiphase_agg 1868 gp_enable_predicate_propagation s 1869 gp_enable_relsize_collection 1869 gp_enable_segment_copy_checking 1869 gp_enable_sort_distinct 1870 gp_enable_sort_limit 1870 gp_external_enable_exec 1870 gp_external_max_segs 1870 gp_ex

1871 gp_dynamic_partition_pruning 1872 gp_eager_two_phase_agg 1872 gp_enable_agg_distinct 1872 gp_enable_agg_distinct_pruning 1872 gp_enable_direct_dispatch 1872 gp_enable_exchange_default_partition gp_enable_global_deadlock_detector 1873 gp_enable_gpperfmon 1873 gp_enable_groupext_distinct_gather 1874 gp_enable_groupext_distinct_pruning 1874 gp_enable_multiphase_agg 1874 gp_enable_predicate_propagation s 1875 gp_enable_relsize_collection 1875 gp_enable_segment_copy_checking 1875 gp_enable_sort_distinct 1876 gp_enable_sort_limit 1876 gp_external_enable_exec 1876 gp_external_max_segs 1876 gp_ex