also delivers meta-data as hive external tables definitions Ingestion into data lake storage compaction storage, e.g. CSV or Avro files on S3 semantic layer (cubes, marts etc..) ETL ODS, e.g. Added value from HVR • Easy to setup • Performant Ingestion into data lake using streaming compaction semantic layer (cubes, marts etc..) ETL ODS, e.g. redshift, greenplum or RDS Kafka or Kinesis ODS Kafka S3 users users HVR Strengths • All advantages of previous approaches • No extra compaction • Another group of stakeholders is satisfied, without compromising latency or quality for others

s_table_setting 1568 gp_adjust_selectivity_for_outerjoins 1569 gp_appendonly_compaction 1569 gp_appendonly_compaction_threshold 1569 gp_autostats_allow_nonowner 1570 gp_autostats_mode 1570 gp_au gp_locks_on_relation 1748 gp_locks_on_resqueue 1749 Checking Append-Optimized Tables 1749 __gp_aovisimap_compaction_info(oid) 1749 __gp_aoseg(regclass) 1750 __gp_aoseg_history(regclass) 1751 __gp_aocsseg(regclass) performed if the percentage of expired rows in the table exceeds the value of the gp_appendonly_compaction_threshold configuration parameter, which is 10 (10%) by default. The threshold is checked on each

s_table_setting 1578 gp_adjust_selectivity_for_outerjoins 1579 gp_appendonly_compaction 1579 gp_appendonly_compaction_threshold 1579 gp_autostats_allow_nonowner 1579 gp_autostats_mode 1580 gp_au gp_locks_on_relation 1760 gp_locks_on_resqueue 1761 Checking Append-Optimized Tables 1761 __gp_aovisimap_compaction_info(oid) 1762 VMware Greenplum v6.19 Documentation VMware, Inc. 129 __gp_aoseg(regclass) 1762 performed if the percentage of expired rows in the table exceeds the value of the gp_appendonly_compaction_threshold configuration parameter, which is 10 (10%) by default. The threshold is checked on each

s_table_setting 1503 gp_adjust_selectivity_for_outerjoins 1504 gp_appendonly_compaction 1504 gp_appendonly_compaction_threshold 1504 gp_autostats_mode 1505 gp_autostats_mode_in_functions 1505 gp gp_locks_on_relation 1682 gp_locks_on_resqueue 1683 Checking Append-Optimized Tables 1683 __gp_aovisimap_compaction_info(oid) 1683 __gp_aoseg(regclass) 1684 __gp_aoseg_history(regclass) 1685 __gp_aocsseg(regclass) performed if the percentage of expired rows in the table exceeds the value of the gp_appendonly_compaction_threshold configuration parameter, which is 10 (10%) by default. The threshold is checked on each

s_table_setting 1590 gp_adjust_selectivity_for_outerjoins 1591 gp_appendonly_compaction 1591 gp_appendonly_compaction_threshold 1591 gp_autostats_allow_nonowner 1592 gp_autostats_mode 1592 gp_au gp_locks_on_relation 1776 gp_locks_on_resqueue 1777 Checking Append-Optimized Tables 1777 __gp_aovisimap_compaction_info(oid) 1778 __gp_aoseg(regclass) 1778 __gp_aoseg_history(regclass) 1779 __gp_aocsseg(regclass) performed if the percentage of expired rows in the table exceeds the value of the gp_appendonly_compaction_threshold configuration parameter, which is 10 (10%) by default. The threshold is checked on each

s_table_setting 1898 gp_adjust_selectivity_for_outerjoins 1899 gp_appendonly_compaction 1899 gp_appendonly_compaction_threshold 1899 VMware Greenplum 6 Documentation VMware by Broadcom 111 gp_au gp_locks_on_relation 2296 gp_locks_on_resqueue 2297 Checking Append-Optimized Tables 2297 __gp_aovisimap_compaction_info(oid) 2298 __gp_aoseg(regclass) 2298 __gp_aoseg_history(regclass) 2299 __gp_aocsseg(regclass) value can be configured with the gp_appendonly_compaction_threshold server configuration parameter. VACUUM FULL ignores the value of gp_appendonly_compaction_threshold and rewrites the segment file regardless

s_table_setting 1586 gp_adjust_selectivity_for_outerjoins 1587 gp_appendonly_compaction 1587 gp_appendonly_compaction_threshold 1587 gp_autostats_allow_nonowner 1587 gp_autostats_mode 1588 gp_au gp_locks_on_relation 1916 gp_locks_on_resqueue 1917 Checking Append-Optimized Tables 1917 __gp_aovisimap_compaction_info(oid) 1918 __gp_aoseg(regclass) 1918 __gp_aoseg_history(regclass) 1918 __gp_aocsseg(regclass) value can be configured with the gp_appendonly_compaction_threshold server configuration parameter. VACUUM FULL ignores the value of gp_appendonly_compaction_threshold and rewrites the segment file regardless

s_table_setting 1864 gp_adjust_selectivity_for_outerjoins 1864 gp_appendonly_compaction 1865 gp_appendonly_compaction_threshold 1865 gp_autostats_allow_nonowner 1865 gp_autostats_mode 1865 VMware gp_locks_on_relation 2248 gp_locks_on_resqueue 2249 Checking Append-Optimized Tables 2249 __gp_aovisimap_compaction_info(oid) 2250 __gp_aoseg(regclass) 2250 __gp_aoseg_history(regclass) 2251 __gp_aocsseg(regclass) value can be configured with the gp_appendonly_compaction_threshold server configuration parameter. VACUUM FULL ignores the value of gp_appendonly_compaction_threshold and rewrites the segment file regardless

s_table_setting 1804 gp_adjust_selectivity_for_outerjoins 1805 gp_appendonly_compaction 1805 gp_appendonly_compaction_threshold 1805 gp_autostats_allow_nonowner 1805 gp_autostats_mode 1806 gp_au gp_locks_on_relation 2176 gp_locks_on_resqueue 2176 Checking Append-Optimized Tables 2177 __gp_aovisimap_compaction_info(oid) 2177 __gp_aoseg(regclass) 2178 __gp_aoseg_history(regclass) 2178 __gp_aocsseg(regclass) value can be configured with the gp_appendonly_compaction_threshold server configuration parameter. VACUUM FULL ignores the value of gp_appendonly_compaction_threshold and rewrites the segment file regardless

s_table_setting 1796 gp_adjust_selectivity_for_outerjoins 1797 gp_appendonly_compaction 1797 gp_appendonly_compaction_threshold 1797 gp_autostats_allow_nonowner 1797 gp_autostats_mode 1798 gp_au gp_locks_on_relation 2167 gp_locks_on_resqueue 2167 Checking Append-Optimized Tables 2168 __gp_aovisimap_compaction_info(oid) 2168 __gp_aoseg(regclass) 2169 __gp_aoseg_history(regclass) 2169 __gp_aocsseg(regclass) value can be configured with the gp_appendonly_compaction_threshold server configuration parameter. VACUUM FULL ignores the value of gp_appendonly_compaction_threshold and rewrites the segment file regardless