Help Center/ Data Lake Insight/ FAQs/ Datasource Connections/ Datasource Connection O&M/ An Insert Operation Failed After the Schema of the GaussDB(DWS) Source Table Is Updated

An Insert Operation Failed After the Schema of the GaussDB(DWS) Source Table Is Updated

Updated on 2023-05-19 GMT+08:00

Symptom

A datasource GaussDB(DWS) table and the datasource connection were created in DLI, and the schema of the source table in GaussDB(DWS) were updated. During the job execution, the schema of the source table failed to be updated, and the job failed.

Cause Analysis

When the insert operation is executed on the DLI datasource table, the GaussDB(DWS) source table is deleted and recreated. If the statement for creating the datasource table is not updated on DLI, the GaussDB(DWS) source table will fail to be updated.

Procedure

Create a datasource table on DLI and add table creation configuration truncate = true to clear table data but not delete the table.

Summary and Suggestions

After the source table is updated, the corresponding datasource table must be updated too on DLI.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback