vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/dev/dws_04_3333.html
Lu, Huayi e6fa411af0 DWS DEV 830.201 version 
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2024-05-16 07:24:04 +00:00

9.9 KiB
Raw Permalink Blame History

Change History

Released On

Description

2024-04-03

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.
    1. READ ONLY HDFS foreign tables in JSON format are supported.
    2. READ ONLY OBS foreign tables in JSON file format are supported.
  • Column-store VACUUM
    1. Added the GUC parameter colvacuum_threshold_scale_factor to control the minimum ratio of dead tuples in a rewritten file of column-store tables.
    2. 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.