ERROR tool.ImportTool: Import failed: java.io.IOException: java.lang.ClassNotFoundException: org.apa

 

原因：缺少hive jar包

解决办法：将hive/lib 包下的hive-common-1.2.2.jar和 hive-exec-1.2.2.jar 拷贝到sqoop/lib包下

[root@CentOS7 sqoop-1.4.7]# cp /usr/apache-hive-1.2.2-bin/lib/hive-common-1.2.2.jar /usr/sqoop-1.4.7/lib/
[root@CentOS7 sqoop-1.4.7]# cp /usr/apache-hive-1.2.2-bin/lib/hive-exec-1.2.2.jar /usr/sqoop-1.4.7/lib/ 

添加之后会出现： ERROR tool.ImportTool: Import failed: org.apache.hadoop.mapred.FileAlreadyExistsException: Output directory hdfs://CentOS:9000/user/root/student already exists

 原因：刚才环节已经在hdfs中创建了文件夹

解决办法：删除即可

hdfs dfs -rm -f -r hdfs://CentOS:9000/user/root/student

成功！！！