检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 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.
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.
Added the function and description of the OBS tablespace to "CREATE TABLESPACE".
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
An Error Message Is Displayed When a Common User Executes the Statement for Creating or Deleting a GDS or OBS Foreign Table, Indicating that the User Does Not Have the Permission or the Permission Is Insufficient Parent Topic: DDL Syntax
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
Schema Is Granted to a User, the User Still Cannot Query the Tables How Do I Revoke the Permission of a User If grant select on table t1 to public Has Been Executed on a Table An Error Message Is Displayed When a Common User Executes the Statement for Creating or Deleting a GDS or OBS
"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 6 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. To mount the SFS shared path, enter its IP address.
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
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.
V3 table A V3 table refers to a table whose colversion defined in the CREATE TABLE syntax is 3.0 during table creation, indicating that each column of the column-store table is stored in a file named C1_field.0, and data is stored in the OBS file system.
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
