从Sqoop1.4.7导入到hdfs中的hadoop表很好导入到hive 3.1.1时

knpiaxh1  于 2021-05-29  发布在  Hadoop
关注(0)|答案(0)|浏览(339)
sqoop import --connect jdbc:mysql://localhost:3306/sqoopdb --username dsa -P 
             --split-by id --columns id,name --table employee --target-dir /test1 
             --fields-terminated-by "," --hive-import --create-hive-table 
             --hive-table employee_sqoop

将sqoop1.4.7中的表导入hdfs就可以了。导入到hive 3.1.1时
错误[main]tool.importtool:导入失败:java.io.ioexception:配置单元clidriver退出,状态为1
这是带有hbase、sqoop和hive的最新版本的伪hadoop3.1.1集群。。。。
我将libthrift*.jar文件从hive/lib复制到sqoop/lib目录中
我还将hbase\u home设置为一个不存在的路径
将jackson-annotations-2.9.5.jar、jackson-core-2.9.5.jar、jackson-databind-2.9.5.jar文件复制到sqoop/lib文件夹中*

ERROR [main] tool.ImportTool: Import failed: java.io.IOException: Hive CliDriver exited with status=1   at
 org.apache.sqoop.hive.HiveImport.executeScript(HiveImport.java:355)
    at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:241)
    at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:537)
    at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:628)    at
 org.apache.sqoop.Sqoop.run(Sqoop.java:147)     at
 org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)  at
 org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)    at
 org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)     at
 org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)     at
 org.apache.sqoop.Sqoop.main(Sqoop.java:252)

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题