Question
What should I do if the data type of fields timestamp and data is incorrect during data synchronization between Hive and MySQL?
Answer
- Forcibly convert the data type of the timestamp field in the Sqoop source package to be the same as that in Hive.
- Change the data type of the timestamp field in Hive to String.