Help Center/ MapReduce Service/ User Guide (Kuala Lumpur Region)/ MRS Cluster Component Operation Gudie/ Using Sqoop/ Common Issues About Sqoop/ What Should I Do If the Data Type of Fields timestamp and data Is Incorrect During Data Synchronization Between Hive and MySQL?
Updated on 2022-12-14 GMT+08:00

What Should I Do If the Data Type of Fields timestamp and data Is Incorrect During Data Synchronization Between Hive and MySQL?

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.