检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Flink supports to interpret Canal JSON messages as INSERT, UPDATE, and DELETE messages into the Flink SQL system.
Do not delete the preset system inspection rules of DLI. You are advised not to delete the default rules created by DLI to prevent queue resources from being used up by large SQL jobs.
Example Run the following statement to grant user_name1 the permission to delete the db1 database: 1 GRANT DROP_DATABASE ON databases.db1 TO USER user_name1; Run the following statement to grant user_name1 the SELECT permission of data table tb1 in the db1 database: 1 GRANT SELECT
Ensure that the security group used by the data source allows access from the CIDR block of the DLI queue, and do not delete the VPC peering connection during the datasource connection.
For example, a specific user group is not allowed to delete a cluster. Only basic DLI operations (such as creating and querying jobs) are allowed. For details about DLI permissions, see Permission Management Overview. The following table lists all the system permissions of DLI.
Delete the original datasource connection and create a new one. When you create a connection, ensure that the selected Security Group, VPC, Subnet, and Destination Address are the same as those in RDS. Select a correct Service Type. In this example, select RDS.
Use the UDF created in 6 in the SELECT statement as follows: select TestSumUDF(1,2); Figure 12 Execution result (Optional) Delete the UDF. If the UDF is no longer used, run the following statement to delete it: Drop FUNCTION TestSumUDF; Parent topic: SQL Jobs
On the OBS management console, you can configure lifecycle rules for a bucket to automatically delete objects within it or change object storage classes on a regular basis. For details, see Configuring a Lifecycle Rule.
Currently, upsert, delete, insert, and bulk_insert are supported. upsert: updates and inserts data. delete: deletes data. insert: inserts data. bulk_insert: imports data during initial table creation.
After the multiversion function is enabled, the system automatically backs up table data when you delete or modify the data using insert overwrite or truncate, and retains the data for a certain period. You can quickly restore data within the retention period.
You can configure lifecycle rules to periodically delete objects from buckets or change storage classes of objects. Exercise caution when modifying the job bucket, as it may result in the inability to retrieve historical data.
You can configure lifecycle rules to periodically delete objects from buckets or change storage classes of objects. Exercise caution when modifying the job bucket, as it may result in the inability to retrieve historical data.
DDL: jobs that create, modify, and delete metadata files DCL: jobs that grant and revoke permissions IMPORT: jobs that import external data into the database EXPORT: jobs that export data to an external database QUERY: jobs that run query statements INSERT: jobs that add new data
ALTER TABLE name ADD COLUMN column_name data_type [ COMMENT comment ] [ WITH ( property_name = expression [, ...] ) ] The following statement is used to delete the column_name column from the table.
List<Table> tables = database.listAllTables(); for (Table table : tables) { // Traverse tables and call the deleteTable interface of the Table object to delete tables.
get_package_resource(dli_client, resource_name, group_name): try: pkg_resource = dli_client.get_package_resource(resource_name, group_name) print(pkg_resource) except DliException as e: print(e) return Deleting a Resource Package You can call an API to delete
By granting users the ability to only use DLI resources without allowing them to delete these resources, you can control their access to DLI resources. For newly created users, they must first log in to DLI once to record metadata before being able to use DLI.
On the displayed page, click Delete in the Operation column. In the displayed dialog box, click OK. Parent Topic: Managing Queues
Deny users to create or delete databases, submit jobs (except the default queue), or delete tables. { "Version": "1.1", "Statement": [ { "Effect": "Deny", "Action": [ "dli:database:createDatabase", "dli:database
DDL: jobs that create, modify, and delete metadata files DCL: jobs that grant and revoke permissions When job_type is set to DCL, the operation is synchronous.
