Hello All,
I am new to hadoop, i need help with one issue which i am facing. There was one requirement to add new columns in table after the changes when i am trying to test the changes. The M/R job trying 2-3 times and it is getting failed, so SQOOP export is also getting failed. When i see logs i didn't have any specific exception. I am sharing the log details, if any have idea please do let me know and thanks in adv
19/07/30 04:06:18 INFO tool.CodeGenTool: Beginning code generation
19/07/30 04:06:18 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM [staging].[SR] AS t WHERE 1=0
19/07/30 04:06:19 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /opt/mapr/hadoop/hadoop-2.7.0
Note: /tmp/sqoop-/SR.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
19/07/30 04:06:23 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-/SR.jar
19/07/30 04:06:28 INFO mapreduce.ExportJobBase: Beginning export of SR
19/07/30 04:06:28 INFO Configuration.deprecation: mapred.jar is deprecated. Instead, use mapreduce.job.jar
19/07/30 04:06:28 INFO mapreduce.JobBase: Setting default value for hadoop.job.history.user.location=none
19/07/30 04:06:29 INFO Configuration.deprecation: mapred.reduce.tasks.speculative.execution is deprecated. Instead, use mapreduce.reduce.speculative
19/07/30 04:06:29 INFO Configuration.deprecation: mapred.map.tasks.speculative.execution is deprecated. Instead, use mapreduce.map.speculative
19/07/30 04:06:29 INFO Configuration.deprecation: mapred.map.tasks is deprecated. Instead, use mapreduce.job.maps
19/07/30 04:06:29 INFO client.MapRZKBasedRMFailoverProxyProvider: Updated RM address to
19/07/30 04:06:31 INFO input.FileInputFormat: Total input paths to process : 1
19/07/30 04:06:31 INFO input.FileInputFormat: Total input paths to process : 1
19/07/30 04:06:31 INFO mapreduce.JobSubmitter: number of splits:1
19/07/30 04:06:31 INFO Configuration.deprecation: mapred.map.tasks.speculative.execution is deprecated. Instead, use mapreduce.map.speculative
19/07/30 04:06:31 INFO Configuration.deprecation: mapred.reduce.tasks.speculative.execution is deprecated. Instead, use mapreduce.reduce.speculative
19/07/30 04:06:31 INFO Configuration.deprecation: mapred.map.tasks is deprecated. Instead, use mapreduce.job.maps
19/07/30 04:06:31 INFO mapreduce.JobSubmitter: Submitting tokens for job: job_1563651888010_477141
19/07/30 04:06:32 INFO security.ExternalTokenManagerFactory: Initialized external token manager class - com.mapr.hadoop.yarn.security.MapRTicketManager
19/07/30 04:06:32 INFO impl.YarnClientImpl: Submitted application application_1563651888010_477141
19/07/30 04:06:32 INFO mapreduce.Job: The url to track the job: https://proxy/application_1563651888010_477141/
19/07/30 04:06:32 INFO mapreduce.Job: Running job: job_1563651888010_477141
19/07/30 04:06:49 INFO mapreduce.Job: Job job_1563651888010_477141 running in uber mode : false
19/07/30 04:06:49 INFO mapreduce.Job: map 0% reduce 0%
19/07/30 04:07:08 INFO mapreduce.Job: map 6% reduce 0%
19/07/30 04:17:18 INFO mapreduce.Job: Task Id : attempt_1563651888010_477141_m_000000_0, Status : FAILED
AttemptID:attempt_1563651888010_477141_m_000000_0 Timed out after 600 secs
19/07/30 04:17:19 INFO mapreduce.Job: map 0% reduce 0%
19/07/30 04:17:37 INFO mapreduce.Job: map 6% reduce 0%
19/07/30 04:27:48 INFO mapreduce.Job: Task Id : attempt_1563651888010_477141_m_000000_1, Status : FAILED
AttemptID:attempt_1563651888010_477141_m_000000_1 Timed out after 600 secs
19/07/30 04:27:49 INFO mapreduce.Job: map 0% reduce 0%
19/07/30 04:28:06 INFO mapreduce.Job: map 6% reduce 0%
19/07/30 04:38:18 INFO mapreduce.Job: Task Id : attempt_1563651888010_477141_m_000000_2, Status : FAILED
AttemptID:attempt_1563651888010_477141_m_000000_2 Timed out after 600 secs
Container killed by the ApplicationMaster.
Container killed on request. Exit code is 143
Container exited with a non-zero exit code 143
19/07/30 04:38:19 INFO mapreduce.Job: map 0% reduce 0%
19/07/30 04:38:44 INFO mapreduce.Job: map 6% reduce 0%
19/07/30 04:48:48 INFO mapreduce.Job: map 100% reduce 0%
19/07/30 04:48:48 INFO mapreduce.Job: Job job_1563651888010_477141 failed with state FAILED due to: Task failed task_1563651888010_477141_m_000000
Job failed as tasks failed. failedMaps:1 failedReduces:0
19/07/30 04:48:48 INFO mapreduce.Job: Counters: 10
Job Counters
Failed map tasks=4
Launched map tasks=4
Other local map tasks=3
Rack-local map tasks=1
Total time spent by all maps in occupied slots (ms)=2513029
Total time spent by all reduces in occupied slots (ms)=0
Total time spent by all map tasks (ms)=2513029
Total vcore-seconds taken by all map tasks=2513029
Total megabyte-seconds taken by all map tasks=2573341696
DISK_MILLIS_MAPS=1256515
19/07/30 04:48:48 WARN mapreduce.Counters: Group FileSystemCounters is deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead
19/07/30 04:48:48 INFO mapreduce.ExportJobBase: Transferred 0 bytes in 2,539.3569 seconds (0 bytes/sec)
19/07/30 04:48:48 WARN mapreduce.Counters: Group org.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce.TaskCounter instead
19/07/30 04:48:48 INFO mapreduce.ExportJobBase: Exported 0 records.
19/07/30 04:48:48 ERROR tool.ExportTool: Error during export: Export job failed!