Help Center/ MapReduce Service/ Component Operation Guide (Normal)/ Using Sqoop/ Common Issues About Sqoop/ What Should I Do If the Data Type of Fields timestamp and date Is Incorrect During Data Synchronization Using HCatalog Between Hive and MySQL?
Updated on 2026-06-27 GMT+08:00

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

Question

What should I do if the data type of fields timestamp and date is incorrect during data synchronization using HCatalog 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.