--connect jdbc:oracle:thin: sqoop import --connect jdbc:oracle:thin:@//161.186.157.143:1527/huiprd --username hud_reader --password hud_reader_n1le --table PWRLINE_COPY.DATAAGGRUN -m 1 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 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/26 12:10:58 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.4.0.0-169 16/04/26 12:10:59 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 16/04/26 12:10:59 INFO oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop is disabled. 16/04/26 12:10:59 INFO manager.SqlManager: Using default fetchSize of 1000 16/04/26 12:10:59 INFO tool.CodeGenTool: Beginning code generation 16/04/26 12:11:00 INFO manager.OracleManager: Time zone has been set to GMT 16/04/26 12:11:00 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM PWRLINE_COPY.DATAAGGRUN t WHERE 1=0 16/04/26 12:11:00 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is c:\hadoop\hdp\hadoop- 2.7.1.2.4.0.0-169 Note: \tmp\sqoop-sahus\compile\935c87fa3f1478df4ec155a440e9e6b1\PWRLINE_COPY_DATAAGGRUN.java uses or overrides a deprecated API. Note: Recompile with -Xlint:deprecation for details. 16/04/26 12:11:03 INFO orm.CompilationManager: Writing jar file: \tmp\sqoop-sahus\compile \935c87fa3f1478df4ec155a440e9e6b1\PWRLINE_COPY.DATAAGGRUN.jar 16/04/26 12:11:03 INFO manager.OracleManager: Time zone has been set to GMT 16/04/26 12:11:03 INFO manager.OracleManager: Time zone has been set to GMT 16/04/26 12:11:03 INFO mapreduce.ImportJobBase: Beginning import of PWRLINE_COPY.DATAAGGRUN 16/04/26 12:11:04 INFO Configuration.deprecation: mapred.jar is deprecated. Instead, use mapreduce.job.jar 16/04/26 12:11:04 INFO manager.OracleManager: Time zone has been set to GMT 16/04/26 12:11:05 INFO Configuration.deprecation: mapred.map.tasks is deprecated. Instead, use mapreduce.job.maps 16/04/26 12:11:06 INFO impl.TimelineClientImpl: Timeline service address: http://cc-wvd- ap161.pepcoholdings.biz:8188/ws/v1/timeline/ 16/04/26 12:11:06 INFO client.RMProxy: Connecting to ResourceManager at cc-wvd- ap161.pepcoholdings.biz/161.186.159.156:8032 16/04/26 12:11:13 INFO db.DBInputFormat: Using read commited transaction isolation 16/04/26 12:11:13 INFO db.DataDrivenDBInputFormat: BoundingValsQuery: SELECT MIN(DATAAGGRUNID), MAX(DATAAGGRUNID) FROM PWRLINE_COPY.DATAAGGRUN 16/04/26 12:11:13 INFO mapreduce.JobSubmitter: number of splits:4 16/04/26 12:11:14 INFO mapreduce.JobSubmitter: Submitting tokens for job: job_1461613343454_0003 16/04/26 12:11:15 INFO impl.YarnClientImpl: Submitted application application_1461613343454_0003 16/04/26 12:11:15 INFO mapreduce.Job: The url to track the job: http://cc-wvd- ap161.pepcoholdings.biz:8088/proxy/application_1461613343454_0003/ 16/04/26 12:11:15 INFO mapreduce.Job: Running job: job_1461613343454_0003 16/04/26 12:12:08 INFO mapreduce.Job: Job job_1461613343454_0003 running in uber mode : false 16/04/26 12:12:08 INFO mapreduce.Job: map 0% reduce 0% 16/04/26 12:12:08 INFO mapreduce.Job: Job job_1461613343454_0003 failed with state FAILED due to: Application application_1461613343454_0003 failed 2 times due to AM Container for appattempt_1461613343454_0003_000002 exited with exitCode: 1 For more detailed output, check application tracking page:http://cc-wvd- ap161.pepcoholdings.biz:8088/cluster/app/application_1461613343454_0003Then, click on links to logs of each attempt. Diagnostics: Exception from container-launch. Container id: container_e19_1461613343454_0003_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_1461613343454_0003\container_e19_1461613343454_0003_02_000001>rem Creating copy of launch script c:\hadoop\hdpdata\hadoop\local\usercache\sahus\appcache \application_1461613343454_0003\container_e19_1461613343454_0003_02_000001>copy "launch_container.cmd" "c:/hadoop/hdpdata/hadoop/logs/application_1461613343454_0003/container_e19_1461613343454_0003_ 02_000001/launch_container.cmd" 1 file(s) copied. c:\hadoop\hdpdata\hadoop\local\usercache\sahus\appcache \application_1461613343454_0003\container_e19_1461613343454_0003_02_000001>rem Determining directory contents c:\hadoop\hdpdata\hadoop\local\usercache\sahus\appcache \application_1461613343454_0003\container_e19_1461613343454_0003_02_000001>dir 1>>"c:/hadoop/hdpdata/hadoop/logs/application_1461613343454_0003/container_e19_1461613343454_00 03_02_000001/directory.info" Container exited with a non-zero exit code 1 Failing this attempt. Failing the application. 16/04/26 12:12:08 INFO mapreduce.Job: Counters: 0 16/04/26 12:12:08 WARN mapreduce.Counters: Group FileSystemCounters is deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead 16/04/26 12:12:08 INFO mapreduce.ImportJobBase: Transferred 0 bytes in 62.8048 seconds (0 bytes/sec) 16/04/26 12:12:08 WARN mapreduce.Counters: Group org.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce.TaskCounter instead 16/04/26 12:12:08 INFO mapreduce.ImportJobBase: Retrieved 0 records. 16/04/26 12:12:08 ERROR tool.ImportTool: Error during import: Import job failed!