i using sqoop try import sql server table hive. connection string working correctly import failing. below output. getting same error if try import hdfs well. know issue might be?
[cloudera@ushydgnadipalvx sqoop]$ sqoop import --connect "jdbc:sqlserver://[server];username=[username];password=[password];database=[dbname]" --table [tablename] --hive-import warning: /usr/lib/sqoop/../accumulo not exist! accumulo imports fail. please set $accumulo_home root of accumulo installation. 15/07/10 15:31:41 info sqoop.sqoop: running sqoop version: 1.4.3-cdh4.7.0 15/07/10 15:31:41 info tool.basesqooptool: using hive-specific delimiters output. can override 15/07/10 15:31:41 info tool.basesqooptool: delimiters --fields-terminated-by, etc. 15/07/10 15:31:41 info manager.sqlmanager: using default fetchsize of 1000 15/07/10 15:31:41 info tool.codegentool: beginning code generation 15/07/10 15:31:43 info manager.sqlmanager: executing sql statement: select t.* [socialdatas] t 1=0 15/07/10 15:31:45 info orm.compilationmanager: hadoop_mapred_home /usr/lib/hadoop-0.20-mapreduce /tmp/sqoop-cloudera/compile/0159bb09ed314f098b249cb4c7c97130/socialdatas.java:206: cannot find symbol symbol : method readstring(java.io.datainput) location: class java.lang.string this.language = text.readstring(__datain); ^ /tmp/sqoop-cloudera/compile/0159bb09ed314f098b249cb4c7c97130/socialdatas.java:211: cannot find symbol symbol : method readstring(java.io.datainput) location: class java.lang.string this.platform = text.readstring(__datain); ^ /tmp/sqoop-cloudera/compile/0159bb09ed314f098b249cb4c7c97130/socialdatas.java:216: cannot find symbol symbol : method readstring(java.io.datainput) location: class java.lang.string this.text = text.readstring(__datain); ^ /tmp/sqoop-cloudera/compile/0159bb09ed314f098b249cb4c7c97130/socialdatas.java:257: cannot find symbol symbol : method writestring(java.io.dataoutput,java.lang.string) location: class java.lang.string text.writestring(__dataout, language); ^ /tmp/sqoop-cloudera/compile/0159bb09ed314f098b249cb4c7c97130/socialdatas.java:263: cannot find symbol symbol : method writestring(java.io.dataoutput,java.lang.string) location: class java.lang.string text.writestring(__dataout, platform); ^ /tmp/sqoop-cloudera/compile/0159bb09ed314f098b249cb4c7c97130/socialdatas.java:269: cannot find symbol symbol : method writestring(java.io.dataoutput,java.lang.string) location: class java.lang.string text.writestring(__dataout, text); ^ note: /tmp/sqoop-cloudera/compile/0159bb09ed314f098b249cb4c7c97130/socialdatas.java uses or overrides deprecated api. note: recompile -xlint:deprecation details. 6 errors 15/07/10 15:31:47 error tool.importtool: encountered ioexception running import job: java.io.ioexception: error returned javac @ org.apache.sqoop.orm.compilationmanager.compile(compilationmanager.java:217) @ org.apache.sqoop.tool.codegentool.generateorm(codegentool.java:97) @ org.apache.sqoop.tool.importtool.importtable(importtool.java:396) @ org.apache.sqoop.tool.importtool.run(importtool.java:506) @ org.apache.sqoop.sqoop.run(sqoop.java:147) @ org.apache.hadoop.util.toolrunner.run(toolrunner.java:70) @ org.apache.sqoop.sqoop.runsqoop(sqoop.java:183) @ org.apache.sqoop.sqoop.runtool(sqoop.java:222) @ org.apache.sqoop.sqoop.runtool(sqoop.java:231) @ org.apache.sqoop.sqoop.main(sqoop.java:240)
errors in output shown above due hadoop jars not being in classpath. try import after setting proper classpath. below example tcsh shell.
setenv classpath $hadoop_home/lib/*:$classpath 
Comments
Post a Comment