You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "amit (JIRA)" <ji...@apache.org> on 2015/05/27 08:13:18 UTC

[jira] [Created] (SQOOP-2373) Error Importing sql sever data from sqoop

amit created SQOOP-2373:
---------------------------

             Summary: Error Importing sql sever data from sqoop
                 Key: SQOOP-2373
                 URL: https://issues.apache.org/jira/browse/SQOOP-2373
             Project: Sqoop
          Issue Type: Bug
         Environment: Windows
            Reporter: amit


Hi 

I am importing data from sql server to hdfs and below is the command

sqoop import –connect “jdbc:sqlserver://Servername:1433;username=hadoop;password=Password;database=MSBI” –table DimDate –target-dir /Hadoop/hdpdatadn/dn/DW/msbi

but I am getting following error:

User: amit.tomar
 Name: DimDate.jar
 Application Type: MAPREDUCE
 Application Tags:
 State: FAILED
 FinalStatus: FAILED
 Started: Wed May 27 12:39:48 +0800 2015
 Elapsed: 23sec
 Tracking URL: History
 Diagnostics: Application application_1432698911303_0005 failed 2 times due to AM Container for appattempt_1432698911303_0005_000002 exited with exitCode: 1
 For more detailed output, check application tracking page:http://apsgsvdevsql01.ap.didata.local:8088/proxy/application_1432698911303_0005/Then, click on links to logs of each attempt.
 Diagnostics: Exception from container-launch.
 Container id: container_1432698911303_0005_02_000001
 Exit code: 1
 Stack trace: ExitCodeException exitCode=1:
 at org.apache.hadoop.util.Shell.runCommand(Shell.java:538)
 at org.apache.hadoop.util.Shell.run(Shell.java:455)
 at org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(Shell.java:715)
 at org.apache.hadoop.yarn.server.nodemanager.DefaultContainerExecutor.launchContainer(DefaultContainerExecutor.java:212)
 at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:302)
 at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:82)
 at java.util.concurrent.FutureTask.run(FutureTask.java:266)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
 at java.lang.Thread.run(Thread.java:745)
 Shell output: 1 file(s) moved.
 Container exited with a non-zero exit code 1
 Failing this attempt. Failing the application. 

>From the log below is the message:

java.lang.Exception: Unknown container. Container either has not started or has already completed or doesn’t belong to this node at all. 

Thanks in advance




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)