Converting Unsupported Data Types
Scenario
When field mapping is configured on CDM, a message is displayed indicating that the data type of the field is not supported and the field needs to be deleted. If you need to use this field, you can use SQL statements to convert the field type in the source job configuration to the type supported by CDM for data migration.
Procedure
- Modify the CDM migration job and enable Use SQL Statement.
The SQL statement format is as follows: select id,cast(Original field name as INT) as New field name, which can be the same as the original field name from schemaName.tableName;
Example: select `id`, `name`, cast(`gender` AS char(255) ) AS `gender` from `test_1117869`.`test_no_support_type`;
- Wait for the fields to be converted to the data types supported by CDM.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot