我输入的命令是

sqoop create-hive-table --connect jdbc:mysql://127.0.0.1:3306/mydemo --table userinfos --username root --password ok --hive-database myexp

首先报错

22/11/24 10:57:04 INFO hive.HiveImport: Loading uploaded data into Hive
22/11/24 10:57:04 ERROR hive.HiveConfig: Could not load org.apache.hadoop.hive.conf.HiveConf. Make sure HIVE_CONF_DIR is set correctly.
22/11/24 10:57:04 ERROR tool.CreateHiveTableTool: Encountered IOException running create table job: java.io.IOException: java.lang.ClassNotFoundException: org.apache.hadoop.hive.conf.HiveConf
 

解决 该这个文件家人们

多加一句这个.就是你的hive conf

 

 然后完事重新运行命令他又报错了

先报这个

22/11/24 10:57:04 ERROR tool.CreateHiveTableTool: Encountered IOException running create table job: java.io.IOException: java.lang.ClassNotFoundException: org.apache.hadoop.hive.conf.HiveConf

然后这个

22/11/24 10:59:11 INFO hive.HiveImport: Loading uploaded data into Hive
Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/hadoop/hive/shims/ShimLoader
 

解决==>
===>将这五个hive lib下的jar直接ctrl c  ctrl v 到sqoop的lib下

 

 完事解决