1. 错误: Sqoop:Import failed: java.lang.ClassNotFoundException: org.apache.hadoop.hive.conf.HiveConf
解决方法 1:
将 MySQL 中的数据导入到 hive 中报错:
ERROR tool.ImportTool:Import failed: java.io.IOException: java.lang.ClassNotFoundException: org.apache.hadoop.hive.conf.HiveConf
这是因为 sqoop 需要一个 hive 的包, 将 hive/lib 中的 hive-common-2.3.3.jar 拷贝到 sqoop 的 lib 目录中, 重新执行试试.
解决方法 2:
在 / etc/profile 中添加下面一行
export HADOOP_CLASSPATH=$HADOOP_CLASSPATH:$HIVE_HOME/lib/*
2. 错误: main ERROR Could not register mbeans java.security.AccessControlException: access denied ("javax.management.MBeanTrustPermission" "register")
解决方法:
- Just add the following lines to your java.policy file unter <JRE_HOME>/lib/security.
- grant {
- permission javax.management.MBeanTrustPermission "register";
- };
3. 错误: ERROR exec.DDLTask: java.lang.NoSuchMethodError: com.fasterxml.jackson.databind.ObjectMapper.readerFor(Ljava/lang/Class;)Lcom/fasterxml/jackson/databind/ObjectReader;
解决犯法: jackson jar 包版本冲突, 将 sqoop/lib 下的 jackson*.jar 备份, 将 hive/lib 包下的 jackson*.jar 包拷贝过来
4. 错误: Required table missing : "DBS" in Catalog ""Schema"". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.schema.autoCreateTables"
解决方法:
到 hive-site.xml 中找到 datanucleus.schema.autoCreateAll 把 value 改成 true
参考: http://blog.itpub.NET/31506529/viewspace-2213877/
来源: http://www.bubuko.com/infodetail-2778090.html