Shulou(Shulou.com)06/03 Report--

The following is about how to solve the error of importing data into mysql using sqoop. The secret of the text lies in being close to the topic. So, no gossip, let's go straight to the following, I believe you will benefit from reading this article on how to solve errors in importing data into mysql using sqoop.

Sqoop export- connect jdbc:mysql://localhost:3306/xiandian-username root-password 000000-export-dir / 1daoyun/data/hive/phy_course_xd.txt-table xd_phy_course

The first time I used the above command to import, I failed to import the data because there was no format of the text data. Then using another method to command import is also a failure.

Sqoop export-connect jdbc:mysql://localhost:3306/xiandian-username root-password 000000-table xd_phy_course-hcatalog-database default-hcatalog-table xd_phy_course

Check the command several times. The second command has no problem. Finally, after restarting mariadb, you can use the second command successfully.

Reason analysis: using the first command to import the format two of the data without input text leads to an error in the database table, and then importing it by other methods will also fail.

The solution is to delete the table to be imported, or restart the database directly

For the above use of sqoop to import data into mysql error how to solve the relevant content, is there anything we do not understand? Or if you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.