2025-11-19 10:24:44.080 INFO : Compiling command(queryId=hive_20251119102417_5d5c931e-0c6d-41f5-a123-783d84502632)
2025-11-19 10:24:54.598 INFO : No Stats for ads_sx_ioc@ads_hr_sxrz_employee_attendance, Columns: workshop_name, data_batch, data_type, hrefficiecvy_divide, dept_name, attnd_cnt
2025-11-19 10:24:54.598 INFO : No Stats for ads_sx_ioc@ads_hr_sxrz_employee_attendance, Columns: bu_name
2025-11-19 10:24:54.598 INFO : No Stats for ads_sx_ioc@ads_hr_sxrz_employee_attendance, Columns: level6_depart_name
2025-11-19 10:24:54.598 INFO : No Stats for ads_sx_ioc@ads_hr_sxrz_employee_attendance, Columns: bu_name, workshop_name, data_batch, data_type, hrefficiecvy_divide, attnd_cnt, level6_depart_name
2025-11-19 10:24:54.598 INFO : No Stats for ads_sx_ioc@ads_hr_sxrz_in_loss_staff, Columns: workshop_name, index_value, data_batch, hrefficiecvy_divide, dept_name, index_name
2025-11-19 10:24:54.598 INFO : No Stats for ads_sx_ioc@ads_hr_sxrz_in_loss_staff, Columns: bu_name, workshop_name, index_value, data_batch, hrefficiecvy_divide, index_name
2025-11-19 10:24:54.598 INFO : No Stats for ads_sx_ioc@ads_hr_sxrz_in_loss_staff, Columns: bu_name, level6_depart_name
2025-11-19 10:24:54.598 INFO : No Stats for ads_sx_ioc@ads_hr_sxrz_in_loss_staff, Columns: bu_name, index_value, data_batch, hrefficiecvy_divide, level5_depart_name, index_name, level6_depart_name
2025-11-19 10:24:54.598 INFO : No Stats for ads_sx_ioc@ads_mfg_sxlj_cry_crystal_pdt, Columns: workshop_name, round_ingot_w_val, date_value
2025-11-19 10:24:54.598 INFO : No Stats for ads_sx_ioc@ads_mfg_sxlj_output_collect, Columns: workshop_name, prod_w_val, stat_date, index_name
2025-11-19 10:24:54.598 INFO : No Stats for sxcdm_dwd@dwd_sxzj_new_yield_details, Columns: sto_pow, factory, inspection_date, inspection_result, barcode, currentfactory
2025-11-19 10:24:54.598 INFO : No Stats for cdm_dim@dim_sxzj_mfgline, Columns: area_name, factory_code, factory_name
2025-11-19 10:24:54.598 INFO : No Stats for sxcdm_dwd@dwd_sxzj1_new_yield_details, Columns: sto_pow, factory, inspection_date, inspection_result, barcode, currentfactory
2025-11-19 10:24:54.598 INFO : No Stats for cdm_dim@dim_sxzj1_mfgline, Columns: area_name, factory_code, factory_name
2025-11-19 10:24:54.598 INFO : No Stats for ads_sx_ioc@ads_mfg_sxqp_yield_dtl, Columns: workshop_name, prod_w_val, area_code, stat_date
2025-11-19 10:24:54.598 INFO : No Stats for ads_sx_ioc@ads_mfg_sxdc_prod_index, Columns: area_name, workshop_name, date_value, jkcspec, output_w_val
2025-11-19 10:24:54.598 INFO : No Stats for cdm_dim@dim_pub_date, Columns: week_start_date_wed, week_end_date_wed, date_id, week_of_year_wed
2025-11-19 10:24:54.598 INFO : No Stats for cdm_dim@dim_pub_date, Columns: yearmonthstr, month_timespan
2025-11-19 10:24:54.598 INFO : Warning: Shuffle Join MERGEJOIN[926][tables = [$hdt$_1]] in Stage 'Reducer 54' is a cross product
2025-11-19 10:24:54.598 INFO : Warning: Shuffle Join MERGEJOIN[936][tables = [$hdt$_2]] in Stage 'Reducer 59' is a cross product
2025-11-19 10:24:54.598 INFO : Semantic Analysis Completed (retrial = false)
2025-11-19 10:24:54.598 INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:_col0, type:string, comment:null), FieldSchema(name:_col1, type:string, comment:null), FieldSchema(name:_col2, type:string, comment:null), FieldSchema(name:_col3, type:string, comment:null), FieldSchema(name:_col4, type:string, comment:null), FieldSchema(name:_col5, type:string, comment:null), FieldSchema(name:_col6, type:string, comment:null), FieldSchema(name:_col7, type:timestamp, comment:null)], properties:null)
2025-11-19 10:24:54.598 INFO : Completed compiling command(queryId=hive_20251119102417_5d5c931e-0c6d-41f5-a123-783d84502632); Time taken: 24.631 seconds
2025-11-19 10:24:54.598 INFO : Executing command(queryId=hive_20251119102417_5d5c931e-0c6d-41f5-a123-783d84502632)switch applicationId of planId-1983017638615019081 from null to application_1744630663935_9685292
2025-11-19 10:25:08.615 INFO : Query ID = hive_20251119102417_5d5c931e-0c6d-41f5-a123-783d84502632
2025-11-19 10:25:08.615 INFO : Total jobs = 1
2025-11-19 10:25:08.615 INFO : Launching Job 1 out of 1
2025-11-19 10:25:08.615 INFO : Starting task [Stage-1:MAPRED] in serial mode
2025-11-19 10:25:08.615 INFO : Subscribed to counters: [] for queryId: hive_20251119102417_5d5c931e-0c6d-41f5-a123-783d84502632
2025-11-19 10:25:08.615 INFO : Tez session hasn't been created yet. Opening session
2025-11-19 10:25:08.615 INFO : Dag name: with zj_zgrs as (select dat...data_all_month (Stage-1)
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Setting tez.task.scale.memory.reserve-fraction to 0.30000001192092896
2025-11-19 10:25:08.615 INFO : Status: Running (Executing on YARN cluster with App id application_1744630663935_9685292)
2025-11-19 10:38:32.016 INFO : Completed executing command(queryId=hive_20251119102417_5d5c931e-0c6d-41f5-a123-783d84502632); Time taken: 829.345 seconds
==================================sql detailed error track info======================================
Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Application application_1744630663935_9685292 failed 2 times due to AM Container for appattempt_1744630663935_9685292_000002 exited with exitCode: 255
Failing this attempt.Diagnostics: [2025-11-19 10:37:41.735]Exception from container-launch.
Container id: container_e37_1744630663935_9685292_02_000001
Exit code: 255
Exception message: Launch container failed
Shell error output: Nonzero exit code=255, error message='Unknown error code'
Shell output: main : command provided 1
main : run as user is simba
main : requested yarn user is simba
Getting exit code file...
Creating script paths...
Writing pid file...
Writing to tmp file /opt2/hadoop/yarn/local/nmPrivate/application_1744630663935_9685292/container_e37_1744630663935_9685292_02_000001/container_e37_1744630663935_9685292_02_000001.pid.tmp
Writing to cgroup task files...
Creating local dirs...
Launching container...
[2025-11-19 10:37:41.736]Container exited with a non-zero exit code 255. Error file: prelaunch.err.
Last 4096 bytes of prelaunch.err :
Last 4096 bytes of stderr :
Halting due to Out Of Memory Error...
Halting due to Out Of Memory Error...
Halting due to Out Of Memory Error...
Halting due to Out Of Memory Error...
Halting due to Out Of Memory Error...
[2025-11-19 10:37:41.736]Container exited with a non-zero exit code 255. Error file: prelaunch.err.
Last 4096 bytes of prelaunch.err :
Last 4096 bytes of stderr :
Halting due to Out Of Memory Error...
Halting due to Out Of Memory Error...
Halting due to Out Of Memory Error...
Halting due to Out Of Memory Error...
Halting due to Out Of Memory Error...
For more detailed output, check the application tracking page: http://dmp-datakun-master01:8188/applicationhistory/app/application_1744630663935_9685292 Then click on links to logs of each attempt.
. Failing the application.