How Do I Handle Source tinyint(1) Fields During Real-Time Data Synchronization from MySQL to Doris?
Symptom
In a real-time job for migrating data from MySQL to Doris, source tinyint(1) fields are automatically converted to boolean fields during automatic table creation. When a value other than 0 or 1 is inserted into such fields, an error will occur.
Possible Causes
Source tinyint(1) fields are converted to fields of an inappropriate type during automatic table creation.
Solution
Add attribute tinyInt1isBit to the MySQL data connection and set its value to false. In this way, source tinyint(1) fields can be converted to fields of a type that fits the destination.
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
