What Should I Do If a Field Is Escaped and Contains a Backslash (\) During the Migration of a DLI Foreign Table (OBS File) to DWS?

Symptom

After the migration of a DLI foreign table to GaussDB(DWS), a field has an extra pair of quotation marks which contain an extra escape character. Other fields are normal.

Source

Fault Analysis

1. As shown in the preceding figure, the sample value at the source contains special characters such as brackets and quotation marks. The JDBC driver escapes the field, and the escape character is displayed at the destination.
2. For DLI foreign table and OBS bucket storage, and file-to-table migration, you can add a quote character (") to the source job configuration.

Solution

In the source job configuration, set Use Quote Char to Yes and use a double quotation mark (").