检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
If the UPDATE GLOBAL INDEX clause is not used when you delete, split, clear, or exchange partitions, concurrent DML services may report errors due to invalidated indexes.
[Rule] Once a distribution key is inserted, it cannot be updated unless you delete the key and insert it again. Selecting a Partitioning Mode Table 3 Table partitioning modes and scenarios Partitioning Mode Description Range Table data is partitioned by range.
date_lt_timestamp date_lt_timestamptz date_mi date_mi_interval date_mii date_ne date_ne_timestamp date_ne_timestamptz date_out date_pl_interval date_pli date_recv date_send date_smaller date_sortsupport daterange_canonical daterange_subdiff datetime_pl datetimetz_pl dcbrt decode defined degrees delete
Only simple DELETE statements are supported. For example: DELETE FROM t1 WHERE c1 = ? and c2 = 10; Columns c1 and c2 are index columns, which can be followed by constants or parameters. Only simple UPDATE statements are supported. For example: UPDATE t1 SET c3 = c3+?
To repair the file, you need to delete the file whose size is 0 and then repair it. You can delete a file only after the file descriptor is automatically closed. You can manually restart the process or perform a primary/standby switchover.
The DML statements include the UPDATE, INSERT, DELETE, MERGE, PREPARE, EXPLAIN, SHOW, LOCK, COPY, CLUSTER, ANONYMOUS, DELTA, EXECUTE, MOVE, FETCH, CLOSE, DEALLOCATE, DECLARE, and LOAD statements.
The following \set meta-command of gsql can be used to specify a variable: \set varname value To delete a variable specified by the \set command, run the following command: \unset varname NOTE: A variable is a simple name-value pair, where the value can be any characters in any length
The following \set meta-command of gsql can be used to set a variable: \set varname value To delete the variables set by the \set command, run the following command: \unset varname NOTE: A variable is a simple name-value pair. The value can be any characters in any length.
The following \set meta-command of gsql can be used to set a variable: \set varname value To delete the variables set by the \set command, run the following command: \unset varname NOTE: A variable is a simple name-value pair. The value can be any characters in any length.
The following \set meta-command of gsql can be used to set a variable: \set varname value To delete the variables set by the \set command, run the following command: \unset varname NOTE: A variable is a simple name-value pair. The value can be any characters in any length.
The following \set meta-command of gsql can be used to set a variable: \set varname value To delete the variables set by the \set command, run the following command: \unset varname NOTE: A variable is a simple name-value pair. The value can be any characters in any length.
The multinode hint can be added after the select, insert, update, delete, and merge keywords. gtm_host2 Parameter description: Specifies the host name or IP address of the standby GTM 2 if the standby GTM 2 is deployed. This parameter is visible only to the sysadmin user.
The following \set meta-command of gsql can be used to set a variable: \set varname value To delete the variables set by the \set command, run the following command: \unset varname NOTE: A variable is a simple name-value pair. The value can be any characters in any length.
The multinode hint can be added after the select, insert, update, delete, and merge keywords. gtm_host2 Parameter description: Specifies the host name or IP address of the standby GTM 2 if the standby GTM 2 is deployed. This parameter is visible only to the sysadmin user.
Description Plan hints are specified in the following format after keywords such as SELECT, INSERT, UPDATE, DELETE, and MERGE: 1 /*+ <plan hint>*/ You can specify multiple hints for a query plan and separate them with spaces.
Description Plan hints are specified in the following format after keywords such as SELECT, INSERT, UPDATE, DELETE, and MERGE: 1 /*+ <plan hint>*/ You can specify multiple hints for a query plan and separate them with spaces.
date_lt_timestamp date_lt_timestamptz date_mi date_mi_interval date_mii date_ne date_ne_timestamp date_ne_timestamptz date_out date_pl_interval date_pli date_recv date_send date_smaller date_sortsupport daterange_canonical daterange_subdiff datetime_pl datetimetz_pl dcbrt decode defined degrees delete
Description Plan hints are specified in the following format after keywords such as SELECT, INSERT, UPDATE, DELETE, and MERGE: 1 /*+ <plan hint>*/ You can specify multiple hints for a query plan and separate them with spaces.
You can create a CEK, change the client master key specified by a CEK, and delete a CEK. Table 4 lists the involved SQL statements.
You can create a CEK, change the client master key specified by a CEK, and delete a CEK. For details about related SQL statements, see Table 4.
