检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Multi-temperature tables support only partitioned column-store tables and depend on available OBS tablespaces. Multi-temperature tables support only the default tablespace default_obs_tbs. If you need to add an OBS tablespace, contact technical support.
Added the function and description of the OBS tablespace to "CREATE TABLESPACE".
For OBS hot and cold tables: They do not support specifying the partition table's tablespace as the OBS tablespace for MOVE, EXCHANGE, MERGE, and SPLIT operations.
The default distribution mode is not specified for the OBS dfs server write-only foreign tables. 8.1.3.310 and earlier versions Parent topic: Version 8.1.3
206400, "status": "COMPLETED", "updated": "2022-11-01T02:15:26", "type":"AUTO", "backup_key": "20221101_021217", "prior_backup_key": "FULL", "base_backup_key": "20221101_021217", "backup_device": "OBS
Currently, you can use ANALYZE to collect statistics from row-store tables, column-store tables, HDFS tables, ORC- and CARBONDATA-formatted OBS foreign tables, and foreign tables for collaborative analysis.
OVERWRITE allows you to insert data into an OBS foreign table in overwrite mode, where the data in the original directory will be overwritten. The foreign table supports OVERWRITE single-partition and multi-level Value partitioning.
table that contains the I/O information of the current DN WorkloadCGroupHashLock Used to prevent concurrent access to or concurrent modification on a hash table that contains Cgroup information OBSGetPathLock Used to prevent concurrent read/write or concurrent write/write on an OBS
"Functions and Operators" > "Hudi System Functions" in SQL Syntax Reference "DDL Syntax" > "CREATE FOREIGN TABLE (SQL on OBS or Hadoop)" in SQL Syntax Reference Lock Distributed deadlock detection Added the GUC parameters enable_global_deadlock_detector and global_deadlock_detector_period
table that contains the I/O information of the current DN WorkloadCGroupHashLock Used to prevent concurrent access to or concurrent modification on a hash table that contains Cgroup information OBSGetPathLock Used to prevent concurrent read/write or concurrent write/write on an OBS
Default value: off acceleration_with_compute_pool Parameter description: Specifies whether to use the computing resource pool for acceleration when OBS is queried.
"DDL Syntax > CREATE FOREIGN TABLE (OBS Import and Export)" in SQL Syntax Reference Improved autovacuum usability. The GUC parameter enable_pg_stat_object is added to control whether the autovacuum updates the system catalogs.
Table 4 Automated snapshot parameters Parameter Description Backup Device Select OBS or NFS from the drop-down list. NFS backup file system address (NFS parameter) NFS shared IP address. Enter the IP address of the SFS shared path.
The unit is KB. 102,400–1,073,741,823 cstore_buffers Size of the shared buffer used by column-store tables and column-store tables (ORC, Parquet, and CarbonData) of OBS and HDFS foreign tables.
list" Supported: Projects Enterprise projects Disabling a cluster alarm "dws:dmsClusterAlarm:disable" "dws:dmsQuery:list" Supported: Projects Enterprise projects Managing gRPC external service "dws:dmsGrpcOuter:operation" "dws:dmsQuery:list", "dws:cluster:setSecuritySettings", "obs
The OBS foreign table is read-only by default. Precautions The foreign table is owned by the user who runs the command. The distribution mode of a GDS foreign table does not need to be explicitly specified. The default is ROUNDROBIN.
Type: USERSET Value range: an integer ranging from 0 to 2147483647 Default value: 10min enable_insert_foreign_table_dop Parameter description: Specifies whether to enable DOP acceleration when data is written into an OBS foreign table.
The OBS foreign table is read-only by default. Precautions The foreign table is owned by the user who runs the command. The distribution mode of a GDS foreign table does not need to be explicitly specified. The default is ROUNDROBIN.
Managing Jobs After creating a cluster instance, you can customize a job, enable a job, and migrate data. You can create jobs to migrate data or automatically create tables. Data migration: Data is migrated from Kafka to GaussDB(DWS). Automatic table creation: Tables and fields in
Binding Different Resource Pools to Two Types of Jobs to Balance Load for GaussDB(DWS) This practice demonstrates how to use GaussDB(DWS) for resource management, helping enterprises eliminate bottlenecks in concurrent query performance. SQL jobs can run smoothly without affecting
