我输入的命令是
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下
完事解决