Trying to run Sqoop on command line to import the tables. But getting the container issue. AM Container for appattempt_1461334413304_0001_000002
exited with exitCode: 1 sqoop-1.4.6.2.4.0.0-169
C:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169>SQOOP
import --connect jdbc:oracle:thin:@nile:1527:huiprd --username hud_reader
--password hud_reader_n1le --table PWRLINE_COPY.DATAAGGRUN --m 1 --target-dir
/sqoopout
Warning: HBASE_HOME and HBASE_VERSION
not set.
Warning: HCATALOG_HOME does not exist
HCatalog imports will fail.
Please set HCATALOG_HOME to the root
of your HCatalog installation.
Warning: ACCUMULO_HOME not set.
Warning: HBASE_HOME does not exist HBase
imports will fail.
Please set HBASE_HOME to the root of
your HBase installation.
Warning: ACCUMULO_HOME does not exist
Accumulo imports will fail.
Please set ACCUMULO_HOME to the root
of your Accumulo installation.
16/04/22 10:16:34 INFO sqoop.Sqoop:
Running Sqoop version: 1.4.6.2.4.0.0-169
16/04/22 10:16:34 WARN tool.BaseSqoopTool:
Setting your password on the command-line is insecure. Consider using -P
instead.
16/04/22 10:16:35 INFO oracle.OraOopManagerFactory:
Data Connector for Oracle and Hadoop is disabled.
16/04/22 10:16:35 INFO manager.SqlManager:
Using default fetchSize of 1000
16/04/22 10:16:35 INFO tool.CodeGenTool:
Beginning code generation
16/04/22 10:16:35 INFO manager.OracleManager:
Time zone has been set to GMT
16/04/22 10:16:36 INFO manager.SqlManager:
Executing SQL statement: SELECT t.* FROM PWRLINE_COPY.DATAAGGRUN t WHERE
1=0
16/04/22 10:16:36 INFO orm.CompilationManager:
HADOOP_MAPRED_HOME is c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169
Note: \tmp\sqoop-sahus\compile\a489aa4feab0423cc7d532172cfdc763\PWRLINE_COPY_DATAAGGRUN.java
uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation
for details.
16/04/22 10:16:39 INFO orm.CompilationManager:
Writing jar file: \tmp\sqoop-sahus\compile\a489aa4feab0423cc7d532172cfdc763\PWRLINE_COPY.DATAAGGRUN.jar
16/04/22 10:16:39 INFO manager.OracleManager:
Time zone has been set to GMT
16/04/22 10:16:39 INFO manager.OracleManager:
Time zone has been set to GMT
16/04/22 10:16:39 INFO mapreduce.ImportJobBase:
Beginning import of PWRLINE_COPY.DATAAGGRUN
16/04/22 10:16:40 INFO Configuration.deprecation:
mapred.jar is deprecated. Instead, use mapreduce.job.jar
16/04/22 10:16:40 INFO manager.OracleManager:
Time zone has been set to GMT
16/04/22 10:16:41 INFO Configuration.deprecation:
mapred.map.tasks is deprecated. Instead, use mapreduce.job.maps
16/04/22 10:16:42 INFO impl.TimelineClientImpl:
Timeline service address: http://cc-wvd-ap161.pepcoholdings.biz:8188/ws/v1/timeline/
16/04/22 10:16:43 INFO client.RMProxy:
Connecting to ResourceManager at cc-wvd-ap161.pepcoholdings.biz/161.186.159.156:8032
16/04/22 10:16:47 INFO db.DBInputFormat:
Using read commited transaction isolation
16/04/22 10:16:47 INFO mapreduce.JobSubmitter:
number of splits:1
16/04/22 10:16:48 INFO mapreduce.JobSubmitter:
Submitting tokens for job: job_1461334413304_0001
16/04/22 10:16:50 INFO impl.YarnClientImpl:
Submitted application application_1461334413304_0001
16/04/22 10:16:50 INFO mapreduce.Job:
The url to track the job: http://cc-wvd-ap161.pepcoholdings.biz:8088/proxy/application_1461334413304_0001/
16/04/22 10:16:50 INFO mapreduce.Job:
Running job: job_1461334413304_0001
16/04/22 10:17:30 INFO mapreduce.Job:
Job job_1461334413304_0001 running in uber mode : false
16/04/22 10:17:30 INFO mapreduce.Job:
map 0% reduce 0%
16/04/22 10:17:30 INFO mapreduce.Job:
Job job_1461334413304_0001 failed with state FAILED due to: Application
application_1461334413304_0001 failed 2 times due to AM Container for appattempt_1461334413304_0001_000002
exited with exitCode: 1
For more detailed output, check application
tracking page:http://cc-wvd-ap161.pepcoholdings.biz:8088/cluster/app/application_1461334413304_0001Then,
click on links to logs of each attempt.
Diagnostics: Exception from container-launch.
Container id: container_e13_1461334413304_0001_02_000001
Exit code: 1
Stack trace: ExitCodeException exitCode=1:
at org.apache.hadoop.util.Shell.runCommand(Shell.java:576)
at org.apache.hadoop.util.Shell.run(Shell.java:487)
at org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(Shell.java:753)
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:303)
at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:82)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Shell output:
1 file(s) moved.
c:\hadoop\hdpdata\hadoop\local\usercache\sahus\appcache\application_1461334413304_0001\container_e13_1461334413304_0001_02_000001>rem
Creating copy of launch script
c:\hadoop\hdpdata\hadoop\local\usercache\sahus\appcache\application_1461334413304_0001\container_e13_1461334413304_0001_02_000001>copy
"launch_container.cmd" "c:/hadoop/hdpdata/hadoop/logs/application_1461334413304_0001/container_e13_1461334413304_0001_02_000001/launch_container.cmd"
1 file(s)
copied.
c:\hadoop\hdpdata\hadoop\local\usercache\sahus\appcache\application_1461334413304_0001\container_e13_1461334413304_0001_02_000001>rem
Determining directory contents
c:\hadoop\hdpdata\hadoop\local\usercache\sahus\appcache\application_1461334413304_0001\container_e13_1461334413304_0001_02_000001>dir
1>>"c:/hadoop/hdpdata/hadoop/logs/application_1461334413304_0001/container_e13_1461334413304_0001_02_000001/directory.info"
Container exited with a non-zero exit
code 1
Failing this attempt. Failing the application.
16/04/22 10:17:30 INFO mapreduce.Job:
Counters: 0
16/04/22 10:17:30 WARN mapreduce.Counters:
Group FileSystemCounters is deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter
instead
16/04/22 10:17:30 INFO mapreduce.ImportJobBase:
Transferred 0 bytes in 49.3867 seconds (0 bytes/sec)
16/04/22 10:17:30 WARN mapreduce.Counters:
Group org.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce.TaskCounter
instead
16/04/22 10:17:30 INFO mapreduce.ImportJobBase:
Retrieved 0 records.
16/04/22 10:17:30 ERROR tool.ImportTool:
Error during import: Import job failed!
... View more
