检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
int, x2 varchar(50) ENCRYPTED WITH (COLUMN_ENCRYPTION_KEY = MyCEK1, ENCRYPTION_TYPE = DETERMINISTIC)); NOTICE: The 'DISTRIBUTE BY' clause is not specified.
Connect to an encrypted database. 1 2 3 4 5 6 -- Use the -C parameter to enable the encrypted database function. gsql -p 57101 postgres -r -C gaussdb=# CREATE CLIENT MASTER KEY MyCMK1 WITH ( KEY_STORE = xxx , KEY_PATH = xxx , ALGORITHM = AES_256_CBC); CREATE CLIENT MASTER KEY gaussdb
If all nodes in a group are faulty after the parameter is configured, you need to remove the group from the parameter list when performing node build operations (node recovery or node replacement without changing the IP address) on a node.
If all nodes in a group are faulty after the parameter is configured, you need to remove the group from the parameter list when performing node build operations (node recovery or node replacement without changing the IP address) on a node.
JSON_MERGE(), JSON_REMOVE(), JSON_REPLACE(), JSON_SET(), JSON_DEPTH(), JSON_LENGTH(), JSON_TYPE(), JSON_VALID(), JSON_ARRAY_APPEND(), benchmark(), FROM_BASE64(), TO_BASE64(), make_set(), mid(), ord(), conv(), crc32(), system_user(), password(), IS_IPV4(), IS_IPV6(), sleep(), bin()
This parameter must be enabled for the multi-tenant database feature (enable_mtd). Fixed cost exists, that is, shared_buffers and metadata (about 200 MB). If max_process_memory minus the fixed cost is less than 2 GB, GaussDB forcibly sets enable_memory_limit to off.
TO { GROUP groupname | NODE ( nodename [, ... ] ) } TO GROUP specifies the node group to which the table to be created belongs. TO NODE is used for internal scale-out tools. INTERNAL DATA data_content INTERNAL DATA data_content is only for internal scale-out.
A node group (user-defined node group) must be specified for a MURMURHASH distributed table, and the node group must be a non-installation node group. Tables cannot be created using CREATE TABLE AS.
be functions or types) LONGTEXT Non-reserved (cannot be functions or types) LOOP Non-reserved LOW_PRIORITY Reserved MASTER Non-reserved MASTER_AUTO_POSITION Non-reserved MASTER_BIND Reserved MASTER_COMPRESSION_ALGORITHMS Non-reserved MASTER_CONNECT_RETRY Non-reserved MASTER_DELAY
be functions or types) LONGTEXT Non-reserved (cannot be functions or types) LOOP Non-reserved LOW_PRIORITY Reserved MASTER Non-reserved MASTER_AUTO_POSITION Non-reserved MASTER_BIND Reserved MASTER_COMPRESSION_ALGORITHMS Non-reserved MASTER_CONNECT_RETRY Non-reserved MASTER_DELAY
If the number of nodes exceeds 7, increase the value of this parameter (for example, to 40). Otherwise, the primary node may remain in the promoting state and the log replication between the primary and standby nodes has no progress. This is a POSTMASTER parameter.
NOCYCLE Reserved N/A N/A NODE Non-reserved N/A N/A NOLOGGING Non-reserved N/A N/A NOMAXVALUE Non-reserved N/A N/A NOMINVALUE Non-reserved N/A N/A NONE Non-reserved (excluding functions and types) Reserved N/A NOT Reserved Reserved Reserved NOTHING Non-reserved N/A N/A NOTIFY Non-reserved
NOCYCLE Reserved N/A N/A NODE Non-reserved N/A N/A NOLOGGING Non-reserved N/A N/A NOMAXVALUE Non-reserved N/A N/A NOMINVALUE Non-reserved N/A N/A NONE Non-reserved (excluding functions and types) Reserved N/A NOT Reserved Reserved Reserved NOTHING Non-reserved N/A N/A NOTIFY Non-reserved
Unit: none Value range: 0 to 262143 Default value: Independent deployment: 1200 (60-core CPU/480 GB memory and 32-core CPU/256 GB memory); 800 (16-core CPU/128 GB memory); 400 (8-core CPU/64 GB memory); 300 (4-core CPU/32 GB memory); 200 (4-core CPU/16 GB memory) Setting method: This
f_int2) ( slice s1 values less than (100, 100) datanode (datanode1,datanode2), slice s2 values less than (200, 200) datanode datanode2, slice s3 values less than (300, 300) datanode datanode2, slice s4 values less than (maxvalue, maxvalue) datanode (datanode1,datanode2
NOCOMPRESS Non-reserved N/A N/A NOCYCLE Reserved N/A N/A NODE Non-reserved N/A N/A NOENTITYESCAPING Non-reserved N/A N/A NOLOGGING Non-reserved N/A N/A NOMAXVALUE Non-reserved N/A N/A NOMINVALUE Non-reserved N/A N/A NONE Non-reserved (cannot be functions or types) Reserved N/A NOT
NOCOMPRESS Non-reserved N/A N/A NOCYCLE Reserved N/A N/A NODE Non-reserved N/A N/A NOENTITYESCAPING Non-reserved N/A N/A NOLOGGING Non-reserved N/A N/A NOMAXVALUE Non-reserved N/A N/A NOMINVALUE Non-reserved N/A N/A NONE Non-reserved (cannot be functions or types) Reserved N/A NOT
This model is only available for instances of V2.0-3.200 or later. This option is only available when Resource Type is set to Elastic Cloud Server (ECS). CAUTION: Single: The availability (or SLA) cannot be guaranteed because the instance is deployed on a single server.
This model is only available for instances of V2.0-3.200 or later. This option is only available when Resource Type is set to Elastic Cloud Server (ECS). CAUTION: Single: The availability (or SLA) cannot be guaranteed because the instance is deployed on a single server.
Grant the retrieve permission of r_reason_sk, r_reason_id, and r_reason_desc columns and the UPDATE permission of the r_reason_desc column in the tpcds.reason table to joe. 1 openGauss=# GRANT select (r_reason_sk,r_reason_id,r_reason_desc),update (r_reason_desc) ON tpcds.reason TO
