Tables 782 Queries that Contain Subqueries 783 Queries that Contain Common Table Expressions 784 DML Operation Enhancements with GPORCA 785 VMware Greenplum 6 Documentation VMware by Broadcom 37 Changed optimizer_discard_redistribute_hashjoin 1950 optimizer_enable_associativity 1950 optimizer_enable_dml 1951 optimizer_enable_indexonlyscan 1951 optimizer_enable_master_only_queries 1951 optimizer_en time (for example, date and timestamp). 13958 Removed redundant PartitionSelector insertion for DML operations. Data Flow 14759 Resolved an internal error that occurred during an INSERT to an append-only

Tables 774 Queries that Contain Subqueries 775 Queries that Contain Common Table Expressions 776 DML Operation Enhancements with GPORCA 777 Changed Behavior with GPORCA 777 GPORCA Limitations 778 Unsupported optimizer_discard_redistribute_hashjoin 1914 optimizer_enable_associativity 1915 optimizer_enable_dml 1915 optimizer_enable_indexonlyscan 1915 optimizer_enable_master_only_queries 1916 optimizer_en time (for example, date and timestamp). 13958 Removed redundant PartitionSelector insertion for DML operations. Data Flow 14759 Resolved an internal error that occurred during an INSERT to an append-only

Tables 753 Queries that Contain Subqueries 754 Queries that Contain Common Table Expressions 755 DML Operation Enhancements with GPORCA 756 Changed Behavior with GPORCA 757 GPORCA Limitations 758 Unsupported optimizer_discard_redistribute_hashjoin 1909 optimizer_enable_associativity 1909 optimizer_enable_dml 1910 optimizer_enable_indexonlyscan 1910 optimizer_enable_master_only_queries 1910 optimizer_en time (for example, date and timestamp). 13958 Removed redundant PartitionSelector insertion for DML operations. Data Flow 14759 Resolved an internal error that occurred during an INSERT to an append-only

Tables 746 Queries that Contain Subqueries 748 Queries that Contain Common Table Expressions 749 DML Operation Enhancements with GPORCA 749 Changed Behavior with GPORCA 750 GPORCA Limitations 751 Unsupported optimizer_cte_inlining_bound 1851 optimizer_dpe_stats 1851 optimizer_enable_associativity 1851 optimizer_enable_dml 1851 optimizer_enable_indexonlyscan 1852 optimizer_enable_master_only_queries 1852 optimizer_en to produce a plan when the query involved an update on a partitioned table by removing an unused DML column. 32291 Resolves an issue where GPORCA generated a poor plan because it did not identify operation

—— Inforbright – 与MySQL数据库结合，易使用，冷热分离 – 数据库归档，只能load，不支持DML – 对特定OLAP类查询有很好的支持作用 • 通用性数据仓库 —— Greenplum – 独立的数据库仓库解决方案 – 可以很好支持各种方式的数据加载和DML操作 – 具备海量的数据存储和计算性能 9 Greenplum现状说明 三 Greenplum体系架构 二

Tables 746 Queries that Contain Subqueries 747 Queries that Contain Common Table Expressions 748 DML Operation Enhancements with GPORCA 748 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 33 Changed optimizer_cte_inlining_bound 1843 optimizer_dpe_stats 1843 optimizer_enable_associativity 1843 optimizer_enable_dml 1844 optimizer_enable_indexonlyscan 1844 optimizer_enable_master_only_queries 1844 optimizer_en optimizer_enable_replicated_table, that you can use to control GPORCA's behavior when it encounters DML operations on replicated tables. By default, GPORCA attempts to plan and execute operations on replicated

能越好。 单个SQL最少也有数十 秒。 SQL的支持程度 支持完善，几乎所有 PostgreSQL支持的SQL， gp都支持。 支持有限的SQL，查询 支持子查询，但不支持 窗口函数。大部分dml都 不支持，只支持append。 稳定性 有较多的bug。 比较稳定。 Greenplum架构图 Segment Host Segment Host Segment Host 随机分布：数据随机分布在数据库，每次查询都会查询 所有的 segment。 GP的SQL支持程度 基本上绝大多数PostgreSQL支持的SQL，在 greenplum都支持，如常见的建表、建索引的ddl，以及 一般的dml语句。 Greenplum3.X不支持表空间。4.0提供了支持 tablespace功能。 不支持trigger。 建表语句多了distributed by 子名外， 其它的SQL语法 基本上都与PostgreSQL一样：

Tables 644 Queries that Contain Subqueries 645 Queries that Contain Common Table Expressions 646 DML Operation Enhancements with GPORCA 646 Changed Behavior with GPORCA 647 GPORCA Limitations 648 Unsupported optimizer_cte_inlining_bound 1627 optimizer_dpe_stats 1627 optimizer_enable_associativity 1628 optimizer_enable_dml 1628 VMware Tanzu Greenplum 6 Documentation VMware, Inc 105 optimizer_enable_indexonlyscan 1628 failed login attempts are no longer a security risk. 13860 The EPQ routine for AO/AOCS relations and DML node has been disallowed. 13699 Duplicate gp_fastsequence values (ctid) no longer appear in AO tables

Tables 863 Queries that Contain Subqueries 864 Queries that Contain Common Table Expressions 865 DML Operation Enhancements with GPORCA 866 Changed Behavior with the GPORCA 866 Changed Behavior with Greenplum v6.18 Documentation VMware, Inc. 116 optimizer_enable_associativity 1622 optimizer_enable_dml 1622 optimizer_enable_indexonlyscan 1623 optimizer_enable_master_only_queries 1623 optimizer_en been resolved. Server 12197 : Resolves a data corruption issue that could occur with concurrent DML queries on AO/AOCO tables when Greenplum Database was not aware of committed transactions that started

Tables 872 Queries that Contain Subqueries 873 Queries that Contain Common Table Expressions 874 DML Operation Enhancements with GPORCA 875 Changed Behavior with the GPORCA 875 Changed Behavior with optimizer_cte_inlining_bound 1632 optimizer_dpe_stats 1632 optimizer_enable_associativity 1632 optimizer_enable_dml 1633 optimizer_enable_indexonlyscan 1633 optimizer_enable_master_only_queries 1634 optimizer_en been resolved. Server 12197 : Resolves a data corruption issue that could occur with concurrent DML queries on AO/AOCO tables when Greenplum Database was not aware of committed transactions that started