sqoop import --hive-import --
      
        connect jdbc:oracle:thin:@
        
          
            192.168.29.16:1521/testdb --username NAME --
            
              passord PASS --verbose -m 1 --table T_USERINFO
            
          
        
      
    

      FileNotFoundException: File does not exist: hdfs:
      
        //
      
      
        opt/sqoop-1.4.4/lib/commons-io-1.4.jar
        

      
            at org.apache 
      
        ... ...
        

              at org.apache ... ...
      
    

      It is common 
      
        for
      
       Hadoop services to look 
      
        for
      
       jars 
      
        in
      
       HDFS because all nodes 
      
        in
      
       the cluster can access files 
      
        in
      
       HDFS. This is important 
      
        if
      
       the MapReduce job being kicked off by the Hadoop service, 
      
        in
      
       this 
      
        case
      
      
         Sqoop, has a dependence on those jars. Remember, the Mappers are running on a DataNode, not the NameNode even though you are (probably) running the Sqoop command from the NameNode. Putting the jars on HDFS is not the only possible solution to this problem, but it is a sensible one.



Now we can deal with the actual error. At least one, but probably all, of your Mappers are unable to 
      
      
        find
      
       a jar they need. That means that either the jar does not exist or the user trying to access them does not have the required permissions. First check 
      
        if
      
       the 
      
        file
      
       exists by running hadoop fs -
      
        ls
      
       home/SqoopUser/sqoop-
      
        1.4
      
      .
      
        3
      
      -cdh4.
      
        4.0
      
      /sqoop-
      
        1.4
      
      .
      
        3
      
      -cdh4.
      
        4.0
      
      .jar by a user with superuser privileges on the cluster. If it does not exist, put it there with hadoop fs -put {jarLocationOn/NameNode/fileSystem/sqoop-
      
        1.4
      
      .
      
        3
      
      -cdh4.
      
        4.0
      
      .jar} /home/SqoopUser/sqoop-
      
        1.4
      
      .
      
        3
      
      -cdh4.
      
        4.0
      
      /sqoop-
      
        1.4
      
      .
      
        3
      
      -cdh4.
      
        4.0
      
      .jar. 
    

      <!--查看以下文件系統(tǒng)中的文件目錄，這是遞歸查詢，如果文件很多 建議不要家-R參數(shù)，而是逐層查看-->
      
        

hadoop fs 
      
      -
      
        ls
      
       -R /

<!--建立相同的目錄結(jié)構(gòu)-->
      
        

hadoop fs 
      
      -
      
        mkdir
      
       /
      
        opt

hadoop fs 
      
      -
      
        mkdir
      
       /opt/sqoop-
      
        1.4
      
      .
      
        4
      
      

<!--將本地的/opt/sqoop-
      
        1.4
      
      .
      
        4
      
      /lib 拷貝到hdfs中的/opt/sqoop-
      
        1.4
      
      .4目錄中-->
      
        

hadoop fs 
      
      -put /opt/sqoop-
      
        1.4
      
      .
      
        4
      
      /lib /opt/sqoop-
      
        1.4
      
      .
      
        4
      
      /

<!--查看一下結(jié)果,確認(rèn)拷貝成功-->
      
        

hadoop fs 
      
      -
      
        ls
      
       -R /opt/sqoop-
      
        1.4
      
      .
      
        4
      
    

      
        java.lang.Exception: java.lang.RuntimeException: java.lang.ClassNotFoundException: Class U_BASICINFO not found

    at org.apache.hadoop.mapred.LocalJobRunner$Job.runTasks(LocalJobRunner.java:
      
      
        462
      
      
        )

    at org.apache.hadoop.mapred.LocalJobRunner$Job.run(LocalJobRunner.java:
      
      
        522
      
      
        )

Caused by: java.lang.RuntimeException: java.lang.ClassNotFoundException: Class U_BASICINFO not found

    at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:
      
      
        1895
      
      
        )

    at org.apache.sqoop.mapreduce.db.DBConfiguration.getInputClass(DBConfiguration.java:
      
      
        394
      
      
        )

    at .....
      
    

      <!--拷貝到sqoop/bin目錄下-->


      
        cp
      
       /tmp/sqoop-root/compile/某個(gè)臨時(shí)文件夾包含需要的class和jar文件
      
        /*
      
      
          /opt/sqoop-1.4.4/bin/



<!--put到hdfs中的/user/USERNAME/文件夾下-->

hadoop fs -put /tmp/sqoop-root/compile/某個(gè)臨時(shí)文件夾包含需要的class和jar文件/* /user/root/
      
    

      hadoop fs -
      
        rm
      
       /user/USERNAME
      
        /*