Get the App
SLTechnology News&Howtos  ›  Internet Technology  › 

How to solve the error of importing data into mysql with sqoop

Shulou Source: shulou.com Published: 2022-06-03 07:19:01 11月23日 Update

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.

Tags: Data command method database text format input success following text content reason cause analysis place mystery text more plate first time article Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Redmi MariaDB MySQL NVidia Docker