检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
DDL operations can be performed to add and delete columns only in single-concurrency scenarios. Do not perform other DDL operations on the source database. Otherwise, the job may be abnormal.
To delete a table using DDL, run the drop table test_table_name purge command. Deleting a table in the Oracle database is a high-risk operation by default.
REPLACE: Delete all files with the same custom file name prefix as the file to be written. For example, if the custom file name is abc, all files whose names start with abc will be deleted. APPEND: No processing is performed before the file is written.
The user must have the read, write, and delete permissions on the MySQL database. username Password Password for accessing the MySQL database DB_password DWS database IP address IP address of the DWS database.
To delete multiple tasks at a time, select the tasks and click Delete above the task list. A task in the Scheduling state cannot be deleted. The deletion operation cannot be undone. Exercise caution when performing this operation.
To delete a table using DDL, run the drop table test_table_name purge command. Deleting a table in the Oracle database is a high-risk operation by default.
DELETE_PATH: Delete an OBS path. path Yes String OBS path Table 23 Parameters of the RESTAPI node Parameter Mandatory Type Description url Yes String URL address URL of the cloud service. method Yes String HTTP method GET POST PUT DELETE headers No String HTTP message header in the
Separate multiple ranking parameter descriptions by semicolons (;). 1 request.addQueryStringParam("pre_order_by", "id:ASC;age:ASC;score:DESC"); You can change the value of pre_order_by as follows: Delete an optional ranking parameter.
After a quality job is created, you can edit, delete, run, start scheduling, and stop scheduling it. You cannot start scheduling a one-off quality job.
DELETE_PATH: Delete an OBS path. path Yes String OBS path Table 24 Parameters of the RESTAPI node Parameter Mandatory Type Description url Yes String URL URL of the cloud service. method Yes String HTTP method GET POST PUT DELETE headers No String HTTP message header in the format
Figure 7 Ranking parameters You can change the value of pre_order_by as follows: Delete an optional ranking parameter. The parameter is no longer used for ranking. Change the ranking mode of a ranking parameter whose ranking mode is custom to ascending or descending.
The value can be 1, 2, or 3. 1: new 2: change 3: delete Status code: 400 Table 6 Response body parameters Parameter Type Description error_code String Error code. error_msg String Error description. Example Requests Query the list of packages to be released.
isStopingIncrement String Whether to stop incremental data migration is-execute-auto Boolean Whether to execute the job as scheduled last-update-date Long Time when the job was last updated last-udpate-user String User who last updated the job status isDeleteJob Boolean Whether to delete
isStopingIncrement String Whether to stop incremental data migration is-execute-auto Boolean Whether to execute the job as scheduled last-update-date Long Time when the job was last updated last-udpate-user String User who last updated the job status isDeleteJob Boolean Whether to delete
isStopingIncrement String Whether to stop incremental data migration is-execute-auto Boolean Whether to execute the job as scheduled last-update-date Long Time when the job was last updated last-udpate-user String User who last updated the job status isDeleteJob Boolean Whether to delete
Figure 8 Ranking parameters You can change the value of pre_order_by as follows: Delete an optional ranking parameter. The parameter is no longer used for ranking. Change the ranking mode of a ranking parameter whose ranking mode is custom to ascending or descending.
NOTE: During development and commissioning, developers can directly access data in the production data lake and add, delete, and modify data in tables, posing threats to data security. The data development process cannot be managed.
DELETE_PATH: Delete an OBS path. path Yes String OBS path. Table 24 Parameters of the RestClient node Parameter Mandatory Type Description url Yes String URL address. URL of the cloud service. method Yes String HTTP method.
It does not delete a table. The options are as follows: No: If you select this option, the existing tables will not be updated. Yes: If you select this option, the existing tables will be updated.
If an error is reported during task creation, you need to delete the attribute from the request body. The following figure shows the parameters for creating a main job.