https://community.cloudera.com/t5/Support-Questions/sqoop-ERROR-tool-ImportTool-Import-failed-org-apache-hadoop/m-p/236990#M198803 <P>Trying to import data from oracle DB and getting error</P><PRE>.... 19/07/31 13:07:10 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-myuser/compile/375d3de163797c05cd7b480fddcfe58c/QueryResult.jar 19/07/31 13:07:10 ERROR tool.ImportTool: Import failed: org.apache.hadoop.fs.UnsupportedFileSystemException: No FileSystem for scheme "null" &nbsp; &nbsp; at org.apache.hadoop.fs.FileSystem.getFileSystemClass(FileSystem.java:3281) &nbsp; &nbsp; at org.apache.hadoop.fs.FileSystem.createFileSystem(FileSystem.java:3301) ....</PRE><P><BR />My sqoop command looks like...</P><PRE>sqoop import \ &nbsp; &nbsp; -Dmapreduce.map.memory.mb=3144 -Dmapreduce.map.java.opts=-Xmx1048m \ &nbsp; &nbsp; -Dyarn.app.mapreduce.am.log.level=DEBUG \ &nbsp; &nbsp; -Dmapreduce.map.log.level=DEBUG \ &nbsp; &nbsp; -Dmapreduce.reduce.log.level=DEBUG \ &nbsp; &nbsp; -Dmapred.job.name="Ora import table $tablename" \ &nbsp; &nbsp; -Djava.security.egd=file:///dev/urandom \ &nbsp; &nbsp; -Djava.security.egd=file:///dev/urandom \ &nbsp; &nbsp; -Doraoop.timestamp.string=false \ &nbsp; &nbsp; -Dmapreduce.map.max.attempts=10 \ &nbsp; &nbsp; $oracle_cnxn_str \ &nbsp; &nbsp; --as-parquetfile \ &nbsp; &nbsp; --target-dir /some/hdfs/path \ &nbsp; &nbsp; -query "$sqoop_query" \ &nbsp; &nbsp; --split-by $splitby \ &nbsp; &nbsp; --where "1=1" \ &nbsp; &nbsp; --num-mappers 12 \ &nbsp; &nbsp; --delete-target-dir</PRE><P>Not sure what to make of this error message. Any debugging suggestions or fixes?</P> Thu, 01 Aug 2019 06:12:17 GMT rvillanueva 2019-08-01T06:12:17Z https://community.cloudera.com/t5/Support-Questions/sqoop-ERROR-tool-ImportTool-Import-failed-org-apache-hadoop/m-p/236990#M198803 <P>Trying to import data from oracle DB and getting error</P><PRE>.... 19/07/31 13:07:10 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-myuser/compile/375d3de163797c05cd7b480fddcfe58c/QueryResult.jar 19/07/31 13:07:10 ERROR tool.ImportTool: Import failed: org.apache.hadoop.fs.UnsupportedFileSystemException: No FileSystem for scheme "null" &nbsp; &nbsp; at org.apache.hadoop.fs.FileSystem.getFileSystemClass(FileSystem.java:3281) &nbsp; &nbsp; at org.apache.hadoop.fs.FileSystem.createFileSystem(FileSystem.java:3301) ....</PRE><P><BR />My sqoop command looks like...</P><PRE>sqoop import \ &nbsp; &nbsp; -Dmapreduce.map.memory.mb=3144 -Dmapreduce.map.java.opts=-Xmx1048m \ &nbsp; &nbsp; -Dyarn.app.mapreduce.am.log.level=DEBUG \ &nbsp; &nbsp; -Dmapreduce.map.log.level=DEBUG \ &nbsp; &nbsp; -Dmapreduce.reduce.log.level=DEBUG \ &nbsp; &nbsp; -Dmapred.job.name="Ora import table $tablename" \ &nbsp; &nbsp; -Djava.security.egd=file:///dev/urandom \ &nbsp; &nbsp; -Djava.security.egd=file:///dev/urandom \ &nbsp; &nbsp; -Doraoop.timestamp.string=false \ &nbsp; &nbsp; -Dmapreduce.map.max.attempts=10 \ &nbsp; &nbsp; $oracle_cnxn_str \ &nbsp; &nbsp; --as-parquetfile \ &nbsp; &nbsp; --target-dir /some/hdfs/path \ &nbsp; &nbsp; -query "$sqoop_query" \ &nbsp; &nbsp; --split-by $splitby \ &nbsp; &nbsp; --where "1=1" \ &nbsp; &nbsp; --num-mappers 12 \ &nbsp; &nbsp; --delete-target-dir</PRE><P>Not sure what to make of this error message. Any debugging suggestions or fixes?</P> Thu, 01 Aug 2019 06:12:17 GMT https://community.cloudera.com/t5/Support-Questions/sqoop-ERROR-tool-ImportTool-Import-failed-org-apache-hadoop/m-p/236990#M198803 rvillanueva 2019-08-01T06:12:17Z https://community.cloudera.com/t5/Support-Questions/sqoop-ERROR-tool-ImportTool-Import-failed-org-apache-hadoop/m-p/236991#M198804 <P>Issue was that the --target-dir path included some variables in the start of the path and ended up with the path looking like</P><P>//some/hdfs/path</P><P>and the "empty" // was confusing sqoop.</P> Thu, 01 Aug 2019 06:28:30 GMT https://community.cloudera.com/t5/Support-Questions/sqoop-ERROR-tool-ImportTool-Import-failed-org-apache-hadoop/m-p/236991#M198804 rvillanueva 2019-08-01T06:28:30Z