This issue is the third official release, adapts to DWS 8.1.3.325.
2023-04-28
This issue is the second official release, adapts to DWS 8.1.3.200.
Partition addition and partition table management are supported.PERIOD (interval type) and TTL (interval type) are now available in partition management.
JSON foreign tables are supported.
READ ONLY HDFS foreign tables in JSON format are supported.
READ ONLY OBS foreign tables in JSON file format are supported.
Column-store VACUUM
Added the GUC parameter colvacuum_threshold_scale_factor to control the minimum ratio of dead tuples in a rewritten file of column-store tables.
The VACUUM operation on the primary table is disabled by default. You need to set the colvacuum_threshold_scale_factor parameter to enable this function.
The row-store ring buffer is controlled by a switch.
The ring buffer is controlled by a switch and its threshold is adjustable. Batch update of large tables no longer uses the ring buffer.
Default storage mode of a table.It is controlled by the parameter default_orientation. If the storage mode is not specified during table creation, this parameter specifies the default storage mode.
The GBK character set supports the euro sign.
OBS foreign tables are adapted to XSKY and the parameter eol is added.
SQL supports Roaring Bitmaps.
Case-insensitive is supported to improve Teradata compatibility.
List partitioned tables are supported.
Enhanced MySQL compatibility
ALTER TABLE can modify multiple columns at a time.
ALTER TABLE supports COMMENT.
ALTER TABLE supports CHANGE, DROP KEY, DROP PARTITION, and FIRST/AFTER.
DWS customers have a large number of MERGE INTO operations on replication tables. Like row-store replication tables, column-store replication tables now support UPDATE, DELETE, and MERGE INTO operations.
Fine-grained permission management
Added the ALTER, DROP and VACUUM permissions at table level.
Added the ALTER and DROP permissions at schema level.
Add the preset roles role_signal_backend and role_read_all_stats.
Added the distributed view pg_session_wlmstat.
Added the GUC parameter log_clean_strategy for CM cluster log compression and clearance.
Modified partition table features
Changed the limit on the number of boundary values: The number of partitions in a partition table cannot exceed 32767, and the number of boundary values of all partitions cannot exceed 32767.
The default partition creation policy is modified. When a partition table is created, two default partitions are created. The partition time range of the two default partitions is PERIOD.
Added the function of returning NULL when the divisor is 0.
Specifies whether to report an error when the divisor is 0 in MySQL compatibility mode. The compatibility configuration item enable_division_by_zero_mysql is added to the behavior_compat_options parameter.
Added the GUC parameter ddl_lock_timeout, which specifies the DDL lock timeout interval.
Enhanced the view PG_LOCKS.
Added the views PGXC_WAIT_DETAIL and PGXC_LOCKWAIT_DETAIL.
Add columns such as wait_on_pid and query_id.
2022-11-17
This issue is the first official release, adapts to DWS 8.1.1.202.