An error occurred when exporting and importing data from hive warehouse into MySQL database with sqoop tool in Ubuntu pseudo distributed HDFS.
Give it a try
In the folder generated in ~/TMP/sqoop Chen/compile/jar. java. Copy the calss file to the/usr/local/sqoop/lib/folder, and then run the export and Import command again
The above sqoop-chen directory is sqoop user name
Export-Import command:
The above solution:
After running again, the following figure shows that the export and import succeeded:
View MySQL:
Read More:
- Mysql + Mybatis Batch Update Datas Error: BadSqlGrammarException
- [Solved] MySQL Startup Error: Job for mysqld.service failed because the control process exited with error code
- MYSQL 5.7 Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it..
- Zabbix import MySQL database error ERROR 1046 (3D000) at line 1: No database selected
- How to Solve MYSQL Error: Failed to start MySQL 8.0 database server
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
- How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- [Solved] Job for mysqld.service failed because the control process exited with error code
- Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
- MySql Install Error: Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
- Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution
- host ‘‘ is not allowed to connect to this mysql server Connect MYSQL Error
- MySQL Install Error: MySQL error 1042: Unable to connect to any of the specified MySQL hosts
- [Solved] Django configures MySQL Error: NameError: name ”_MySQL ‘is not defined
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
- [Solved] mariadb Startup Error: Job for mariadb.service failed because the control process exited with error code.