1、一种是会报空指针错误如图:
出现这种情况有两种可能,第一种是缺少依赖包:
cp /opt/software/mysql-connector-java-5.1.31.jar /opt/install/sqoop/lib/
cp /opt/software/commons-lang-2.6.jar /opt/install/sqoop/lib/
cp /opt/software/java-json.jar /opt/install/sqoop/lib/
第二种是/sqoop/lib/下面多了hive-exec-3.1.2.jar,如图:
sqoop的lib文件夹下,把蓝色方框里面的包删除,或者移到别的地方,再创建job可以成功了
2、解决上面问题,可能还会报错
把/hive/conf/hive-site.xml拷贝放到/sqoop/conf文件下
3、Sqoop报错:
ERROR Could not register mbeans java.security.
AccessControlException:access denied(“javax.management.MBeanTrustPermission”“register”)
解决办法:
修改Jdk的文件jdk1.8.0_11/jre/lib/security/java.policy
具体配置如下:
grant{
permission javax.management.MBenTrustPermission"register";
};