{"STAGE DEPENDENCIES":{"Stage-3":{"DEPENDENT STAGES":"Stage-4"},"Stage-4":{"DEPENDENT STAGES":"Stage-2, Stage-0"},"Stage-1":{"ROOT STAGE":"TRUE"},"Stage-2":{"DEPENDENT STAGES":"Stage-1"},"Stage-0":{"DEPENDENT STAGES":"Stage-1"}},"STAGE PLANS":{"Stage-3":{"Stats-Aggr Operator":{}},"Stage-4":{"Create Table Operator:":{"Create Table":{"serde name:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","name:":"dmlr_scm_l3.l3_stock_rebal_insufficiency_temp1","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat","columns:":["location_code string","parts_number string","segment_sql string","recall string","branch_name string","branch_region string","genuine string","genuine_type string","outbound_sq_12_month double","orderlines_12_month bigint","inventory_qty double","inventory_unit_cost double","safety_stock_quantity double","avg_daily_demand double","excess_stock_quantity double","days_to_exhaust double","days_to_stock_out double","insufficient_stock_quantity double","insufficient_stock_value double","current_inventory double","max_inventory_target_quantity double","backorder_quantity decimal(20,0)","back_order_lines bigint","honko_name string","alert_since string","min_adherence decimal(10,0)","max_adherence decimal(10,0)","reorder_point_quantity double","back_order_since string","location_name string","material_description string","marketing_code string","marketing_code_desc string","hinmoku_code string","hinmoku_code_desc string","product string","type string","rank_unique_id int"]}}},"Stage-1":{"Tez":{"Vertices:":{"Union 2":{"Vertex:":"Union 2"},"Map 18":{"Map Operator Tree:":[{"TableScan":{"alias:":"retail_back_order","Statistics:":"Num rows: 88963820 Data size: 338935762834 Basic stats: COMPLETE Column stats: NONE","filterExpr:":"((snapshot_date is not null and (order_date > '2017-05-01')) and (not (COALESCE(status_classification,'0')) IN ('2', '9'))) (type: boolean)","children":{"Filter Operator":{"Statistics:":"Num rows: 7413652 Data size: 28244648172 Basic stats: COMPLETE Column stats: NONE","children":{"Map Join Operator":{"HybridGraceHashJoin:":"true","Statistics:":"Num rows: 8155017 Data size: 31069113662 Basic stats: COMPLETE Column stats: NONE","keys:":{"0":"snapshot_date (type: date)","1":"_col0 (type: date)"},"input vertices:":{"1":"Reducer 21"},"children":{"Select Operator":{"Statistics:":"Num rows: 8155017 Data size: 31069113662 Basic stats: COMPLETE Column stats: NONE","children":{"Group By Operator":{"aggregations:":["max(_col26)","max(_col27)","sum(COALESCE(_col28,0))","count(CASE WHEN ((COALESCE(_col28) > 0)) THEN (_col24) END)","max(_col47)","max(CASE WHEN ((to_date(from_unixtime(unix_timestamp(CASE WHEN (_col37 is null) THEN ('19000101') ELSE (_col37) END), 'yyyyMMdd')) > CAST( '1900-01-01' AS DATE))) THEN (to_date(from_unixtime(unix_timestamp(CASE WHEN (_col37 is null) THEN ('19000101') ELSE (_col37) END), 'yyyyMMdd'))) ELSE (to_date(from_unixtime(unix_timestamp(_col9,'yyyyMMdd')))) END)"],"mode:":"hash","Statistics:":"Num rows: 8155017 Data size: 31069113662 Basic stats: COMPLETE Column stats: NONE","keys:":"_col24 (type: string), _col1 (type: string)","children":{"Reduce Output Operator":{"value expressions:":"_col2 (type: decimal(5,0)), _col3 (type: decimal(5,0)), _col4 (type: decimal(20,0)), _col5 (type: bigint), _col6 (type: date), _col7 (type: string)","sort order:":"++","Statistics:":"Num rows: 8155017 Data size: 31069113662 Basic stats: COMPLETE Column stats: NONE","Map-reduce partition columns:":"_col0 (type: string), _col1 (type: string)","key expressions:":"_col0 (type: string), _col1 (type: string)"}},"outputColumnNames:":["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]}},"outputColumnNames:":["_col24","_col1","_col26","_col27","_col28","_col47","_col37","_col9"],"expressions:":"_col24 (type: string), _col1 (type: string), _col26 (type: decimal(5,0)), _col27 (type: decimal(5,0)), _col28 (type: decimal(5,0)), _col47 (type: date), _col37 (type: string), _col9 (type: string)"}},"condition map:":[{"":"Left Semi Join 0 to 1"}],"outputColumnNames:":["_col1","_col9","_col24","_col26","_col27","_col28","_col37","_col47"]}},"predicate:":"((snapshot_date is not null and (order_date > '2017-05-01')) and (not (COALESCE(status_classification,'0')) IN ('2', '9'))) (type: boolean)"}}}}]},"Reducer 3":{"Reduce Operator Tree:":{"Group By Operator":{"mode:":"mergepartial","Statistics:":"Num rows: 3903419 Data size: 1677986755 Basic stats: COMPLETE Column stats: NONE","keys:":"KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: decimal(9,0)), KEY._col3 (type: timestamp)","children":{"Map Join Operator":{"HybridGraceHashJoin:":"true","Statistics:":"Num rows: 4293760 Data size: 1845785470 Basic stats: COMPLETE Column stats: NONE","keys:":{"0":"_col3 (type: timestamp)","1":"_col0 (type: timestamp)"},"input vertices:":{"1":"Reducer 12"},"children":{"Group By Operator":{"aggregations:":["max(_col3)","max(_col1)","max(UDFToDouble(COALESCE(_col2,0)))"],"mode:":"hash","Statistics:":"Num rows: 4293760 Data size: 1845785470 Basic stats: COMPLETE Column stats: NONE","keys:":"_col0 (type: string)","children":{"Reduce Output Operator":{"value expressions:":"_col1 (type: timestamp), _col2 (type: string), _col3 (type: double)","sort order:":"+","Statistics:":"Num rows: 4293760 Data size: 1845785470 Basic stats: COMPLETE Column stats: NONE","Map-reduce partition columns:":"_col0 (type: string)","key expressions:":"_col0 (type: string)"}},"outputColumnNames:":["_col0","_col1","_col2","_col3"]}},"condition map:":[{"":"Left Semi Join 0 to 1"}],"outputColumnNames:":["_col0","_col1","_col2","_col3"]}},"outputColumnNames:":["_col0","_col1","_col2","_col3"]}}},"Map 16":{"Execution mode:":"vectorized","Map Operator Tree:":[{"TableScan":{"alias:":"l1_tbl_dms_parts_inventory_master","Statistics:":"Num rows: 141125412 Data size: 5645016505 Basic stats: PARTIAL Column stats: NONE","children":{"Select Operator":{"Statistics:":"Num rows: 141125412 Data size: 5645016505 Basic stats: PARTIAL Column stats: NONE","children":{"Group By Operator":{"aggregations:":["max(_col25)"],"mode:":"hash","Statistics:":"Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats: NONE","children":{"Reduce Output Operator":{"value expressions:":"_col0 (type: timestamp)","sort order:":"","Statistics:":"Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats: NONE"}},"outputColumnNames:":["_col0"]}},"outputColumnNames:":["_col25"],"expressions:":"snapshot_date (type: timestamp)"}}}}]},"Map 1":{"Execution mode:":"vectorized","Map Operator Tree:":[{"TableScan":{"alias:":"l1_tbl_dms_parts_price_master","Statistics:":"Num rows: 9534016 Data size: 3355973940 Basic stats: PARTIAL Column stats: NONE","filterExpr:":"snapshot_date is not null (type: boolean)","children":{"Filter Operator":{"Statistics:":"Num rows: 4767008 Data size: 1677986970 Basic stats: COMPLETE Column stats: NONE","children":{"Select Operator":{"Statistics:":"Num rows: 4767008 Data size: 1677986970 Basic stats: COMPLETE Column stats: NONE","children":{"Group By Operator":{"mode:":"hash","Statistics:":"Num rows: 7806839 Data size: 3355973940 Basic stats: COMPLETE Column stats: NONE","keys:":"_col0 (type: string), _col1 (type: string), _col2 (type: decimal(9,0)), _col3 (type: timestamp)","children":{"Reduce Output Operator":{"sort order:":"++++","Statistics:":"Num rows: 7806839 Data size: 3355973940 Basic stats: COMPLETE Column stats: NONE","Map-reduce partition columns:":"_col0 (type: string), _col1 (type: string), _col2 (type: decimal(9,0)), _col3 (type: timestamp)","key expressions:":"_col0 (type: string), _col1 (type: string), _col2 (type: decimal(9,0)), _col3 (type: timestamp)"}},"outputColumnNames:":["_col0","_col1","_col2","_col3"]}},"outputColumnNames:":["_col0","_col1","_col2","_col3"],"expressions:":"parts_number_1 (type: string), expand_sales_item_code (type: string), cost_price (type: decimal(9,0)), snapshot_date (type: timestamp)"}},"predicate:":"snapshot_date is not null (type: boolean)"}}}}]},"Map 14":{"Execution mode:":"vectorized","Map Operator Tree:":[{"TableScan":{"alias:":"l1_tbl_dms_parts_inventory_master","Statistics:":"Num rows: 9800375 Data size: 5645016505 Basic stats: PARTIAL Column stats: NONE","filterExpr:":"snapshot_date is not null (type: boolean)","children":{"Filter Operator":{"Statistics:":"Num rows: 4900188 Data size: 2822508540 Basic stats: COMPLETE Column stats: NONE","children":{"Select Operator":{"Statistics:":"Num rows: 4900188 Data size: 2822508540 Basic stats: COMPLETE Column stats: NONE","children":{"Map Join Operator":{"HybridGraceHashJoin:":"true","Statistics:":"Num rows: 5390206 Data size: 3104759461 Basic stats: COMPLETE Column stats: NONE","keys:":{"0":"_col25 (type: timestamp)","1":"_col0 (type: timestamp)"},"input vertices:":{"1":"Reducer 17"},"children":{"Select Operator":{"Statistics:":"Num rows: 5390206 Data size: 3104759461 Basic stats: COMPLETE Column stats: NONE","children":{"Group By Operator":{"aggregations:":["max(UDFToDouble(COALESCE(_col10,0)))","max(COALESCE(_col9,0))","max(COALESCE(_col8,0))"],"mode:":"hash","Statistics:":"Num rows: 5390206 Data size: 3104759461 Basic stats: COMPLETE Column stats: NONE","keys:":"_col2 (type: string), _col1 (type: string)","children":{"Reduce Output Operator":{"value expressions:":"_col2 (type: double), _col3 (type: decimal(10,0)), _col4 (type: decimal(10,0))","sort order:":"++","Statistics:":"Num rows: 5390206 Data size: 3104759461 Basic stats: COMPLETE Column stats: NONE","Map-reduce partition columns:":"_col0 (type: string), _col1 (type: string)","key expressions:":"_col0 (type: string), _col1 (type: string)"}},"outputColumnNames:":["_col0","_col1","_col2","_col3","_col4"]}},"outputColumnNames:":["_col2","_col1","_col10","_col9","_col8"],"expressions:":"_col2 (type: string), _col1 (type: string), _col10 (type: decimal(5,0)), _col9 (type: decimal(5,0)), _col8 (type: decimal(5,0))"}},"condition map:":[{"":"Left Semi Join 0 to 1"}],"outputColumnNames:":["_col1","_col2","_col8","_col9","_col10"]}},"outputColumnNames:":["_col1","_col10","_col2","_col25","_col8","_col9"],"expressions:":"parts_number (type: string), current_stock_quantity (type: decimal(5,0)), location_code (type: string), snapshot_date (type: timestamp), max_stock_quantity (type: decimal(5,0)), order_quantity (type: decimal(5,0))"}},"predicate:":"snapshot_date is not null (type: boolean)"}}}}]},"Map 13":{"Execution mode:":"vectorized","Map Operator Tree:":[{"TableScan":{"alias:":"a","Statistics:":"Num rows: 2733452 Data size: 7988658241 Basic stats: COMPLETE Column stats: NONE","children":{"Reduce Output Operator":{"value expressions:":"location_code (type: string), location_name (type: string), branch_name (type: string), branch_region (type: string), regional_warehouse (type: string), inventory_unit_cost (type: double), orderlines_12_month (type: bigint), genuine (type: string), genuine_type (type: string), recall (type: string), marketing_code (type: string), marketing_code_desc (type: string), hinmoku_code (type: string), hinmoku_code_desc (type: string), product (type: string), type (type: string), material_description (type: string), outbound_sq_12_month (type: double), segment_sql (type: string), moving_avg_outbound_demand (type: double), safety_stock_quantity (type: double), reorder_point_quantity (type: double), max_inventory_target_quantity (type: double)","sort order:":"+","Statistics:":"Num rows: 2733452 Data size: 7988658241 Basic stats: COMPLETE Column stats: NONE","Map-reduce partition columns:":"parts_number (type: string)","key expressions:":"parts_number (type: string)"}}}}]},"Map 11":{"Execution mode:":"vectorized","Map Operator Tree:":[{"TableScan":{"alias:":"l1_tbl_dms_parts_price_master","Statistics:":"Num rows: 83899348 Data size: 3355973940 Basic stats: PARTIAL Column stats: NONE","children":{"Select Operator":{"Statistics:":"Num rows: 83899348 Data size: 3355973940 Basic stats: PARTIAL Column stats: NONE","children":{"Group By Operator":{"aggregations:":["max(_col37)"],"mode:":"hash","Statistics:":"Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats: NONE","children":{"Reduce Output Operator":{"value expressions:":"_col0 (type: timestamp)","sort order:":"","Statistics:":"Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats: NONE"}},"outputColumnNames:":["_col0"]}},"outputColumnNames:":["_col37"],"expressions:":"snapshot_date (type: timestamp)"}}}}]},"Map 22":{"Execution mode:":"vectorized","Map Operator Tree:":[{"TableScan":{"alias:":"l3_stock_rebal_insufficiency_final","Statistics:":"Num rows: 54791 Data size: 175622701 Basic stats: COMPLETE Column stats: NONE","filterExpr:":"(alert_closed_on = '') (type: boolean)","children":{"Filter Operator":{"Statistics:":"Num rows: 27395 Data size: 87809747 Basic stats: COMPLETE Column stats: NONE","children":{"Select Operator":{"Statistics:":"Num rows: 27395 Data size: 87809747 Basic stats: COMPLETE Column stats: NONE","children":{"Group By Operator":{"mode:":"hash","Statistics:":"Num rows: 27395 Data size: 87809747 Basic stats: COMPLETE Column stats: NONE","keys:":"parts_number (type: string), location_code (type: string), alert_since (type: string)","children":{"Reduce Output Operator":{"sort order:":"+++","Statistics:":"Num rows: 27395 Data size: 87809747 Basic stats: COMPLETE Column stats: NONE","Map-reduce partition columns:":"_col0 (type: string), _col1 (type: string), _col2 (type: string)","key expressions:":"_col0 (type: string), _col1 (type: string), _col2 (type: string)"}},"outputColumnNames:":["_col0","_col1","_col2"]}},"outputColumnNames:":["parts_number","location_code","alert_since"],"expressions:":"parts_number (type: string), location_code (type: string), alert_since (type: string)"}},"predicate:":"(alert_closed_on = '') (type: boolean)"}}}}]},"Map 10":{"Execution mode:":"vectorized","Map Operator Tree:":[{"TableScan":{"alias:":"l1_tbl_dms_parts_price_master","Statistics:":"Num rows: 6079662 Data size: 3355973940 Basic stats: PARTIAL Column stats: NONE","filterExpr:":"snapshot_date is not null (type: boolean)","children":{"Filter Operator":{"Statistics:":"Num rows: 3039831 Data size: 1677986970 Basic stats: COMPLETE Column stats: NONE","children":{"Select Operator":{"Statistics:":"Num rows: 3039831 Data size: 1677986970 Basic stats: COMPLETE Column stats: NONE","children":{"Group By Operator":{"mode:":"hash","Statistics:":"Num rows: 7806839 Data size: 3355973940 Basic stats: COMPLETE Column stats: NONE","keys:":"_col0 (type: string), _col1 (type: string), _col2 (type: decimal(9,0)), _col3 (type: timestamp)","children":{"Reduce Output Operator":{"sort order:":"++++","Statistics:":"Num rows: 7806839 Data size: 3355973940 Basic stats: COMPLETE Column stats: NONE","Map-reduce partition columns:":"_col0 (type: string), _col1 (type: string), _col2 (type: decimal(9,0)), _col3 (type: timestamp)","key expressions:":"_col0 (type: string), _col1 (type: string), _col2 (type: decimal(9,0)), _col3 (type: timestamp)"}},"outputColumnNames:":["_col0","_col1","_col2","_col3"]}},"outputColumnNames:":["_col0","_col1","_col2","_col3"],"expressions:":"concat(trim(parts_number_1), trim(parts_number_2), trim(parts_number_3)) (type: string), expand_sales_item_code (type: string), cost_price (type: decimal(9,0)), snapshot_date (type: timestamp)"}},"predicate:":"snapshot_date is not null (type: boolean)"}}}}]},"Map 20":{"Execution mode:":"vectorized","Map Operator Tree:":[{"TableScan":{"alias:":"retail_back_order","Statistics:":"Num rows: 88963820 Data size: 338935762834 Basic stats: COMPLETE Column stats: NONE","children":{"Select Operator":{"Statistics:":"Num rows: 88963820 Data size: 338935762834 Basic stats: COMPLETE Column stats: NONE","children":{"Group By Operator":{"aggregations:":["max(snapshot_date)"],"mode:":"hash","Statistics:":"Num rows: 1 Data size: 56 Basic stats: COMPLETE Column stats: NONE","children":{"Reduce Output Operator":{"value expressions:":"_col0 (type: date)","sort order:":"","Statistics:":"Num rows: 1 Data size: 56 Basic stats: COMPLETE Column stats: NONE"}},"outputColumnNames:":["_col0"]}},"outputColumnNames:":["snapshot_date"],"expressions:":"snapshot_date (type: date)"}}}}]},"Reducer 12":{"Reduce Operator Tree:":{"Group By Operator":{"aggregations:":["max(VALUE._col0)"],"mode:":"mergepartial","Statistics:":"Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats: NONE","children":{"Filter Operator":{"Statistics:":"Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats: NONE","children":{"Group By Operator":{"mode:":"hash","Statistics:":"Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats: NONE","keys:":"_col0 (type: timestamp)","children":{"Reduce Output Operator":{"sort order:":"+","Statistics:":"Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats: NONE","Map-reduce partition columns:":"_col0 (type: timestamp)","key expressions:":"_col0 (type: timestamp)"}},"outputColumnNames:":["_col0"]}},"predicate:":"_col0 is not null (type: boolean)"}},"outputColumnNames:":["_col0"]}}},"Reducer 23":{"Execution mode:":"vectorized","Reduce Operator Tree:":{"Group By Operator":{"mode:":"mergepartial","Statistics:":"Num rows: 13697 Data size: 43903270 Basic stats: COMPLETE Column stats: NONE","keys:":"KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: string)","children":{"Reduce Output Operator":{"value expressions:":"_col2 (type: string)","sort order:":"++","Statistics:":"Num rows: 13697 Data size: 43903270 Basic stats: COMPLETE Column stats: NONE","Map-reduce partition columns:":"_col0 (type: string), _col1 (type: string)","key expressions:":"_col0 (type: string), _col1 (type: string)"}},"outputColumnNames:":["_col0","_col1","_col2"]}}},"Reducer 21":{"Reduce Operator Tree:":{"Group By Operator":{"aggregations:":["max(VALUE._col0)"],"mode:":"mergepartial","Statistics:":"Num rows: 1 Data size: 56 Basic stats: COMPLETE Column stats: NONE","children":{"Filter Operator":{"Statistics:":"Num rows: 1 Data size: 56 Basic stats: COMPLETE Column stats: NONE","children":{"Group By Operator":{"mode:":"hash","Statistics:":"Num rows: 1 Data size: 56 Basic stats: COMPLETE Column stats: NONE","keys:":"_col0 (type: date)","children":{"Reduce Output Operator":{"sort order:":"+","Statistics:":"Num rows: 1 Data size: 56 Basic stats: COMPLETE Column stats: NONE","Map-reduce partition columns:":"_col0 (type: date)","key expressions:":"_col0 (type: date)"}},"outputColumnNames:":["_col0"]}},"predicate:":"_col0 is not null (type: boolean)"}},"outputColumnNames:":["_col0"]}}},"Reducer 7":{"Reduce Operator Tree:":{"Merge Join Operator":{"Statistics:":"Num rows: 7276447 Data size: 21265809618 Basic stats: COMPLETE Column stats: NONE","keys:":{"0":"trim(_col0) (type: string), trim(_col1) (type: string)","1":"trim(_col0) (type: string), trim(_col1) (type: string)","2":"_col0 (type: string), _col1 (type: string)"},"children":{"Select Operator":{"Statistics:":"Num rows: 7276447 Data size: 21265809618 Basic stats: COMPLETE Column stats: NONE","children":{"Filter Operator":{"Statistics:":"Num rows: 2425482 Data size: 7088602231 Basic stats: COMPLETE Column stats: NONE","children":{"Group By Operator":{"mode:":"hash","Statistics:":"Num rows: 2425482 Data size: 7088602231 Basic stats: COMPLETE Column stats: NONE","keys:":"_col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string), _col7 (type: string), _col8 (type: double), _col9 (type: bigint), _col10 (type: double), _col11 (type: double), _col12 (type: double), _col13 (type: double), _col14 (type: double), _col15 (type: double), _col16 (type: double), _col17 (type: double), _col18 (type: double), _col19 (type: double), _col20 (type: double), _col21 (type: decimal(20,0)), _col22 (type: bigint), _col23 (type: string), _col24 (type: string), _col25 (type: decimal(10,0)), _col26 (type: decimal(10,0)), _col27 (type: double), _col28 (type: string), _col29 (type: string), _col30 (type: string), _col31 (type: string), _col32 (type: string), _col33 (type: string), _col34 (type: string), _col35 (type: string), _col36 (type: string)","children":{"Reduce Output Operator":{"sort order:":"+++++++++++++++++++++++++++++++++++++","Statistics:":"Num rows: 2425482 Data size: 7088602231 Basic stats: COMPLETE Column stats: NONE","Map-reduce partition columns:":"_col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string), _col7 (type: string), _col8 (type: double), _col9 (type: bigint), _col10 (type: double), _col11 (type: double), _col12 (type: double), _col13 (type: double), _col14 (type: double), _col15 (type: double), _col16 (type: double), _col17 (type: double), _col18 (type: double), _col19 (type: double), _col20 (type: double), _col21 (type: decimal(20,0)), _col22 (type: bigint), _col23 (type: string), _col24 (type: string), _col25 (type: decimal(10,0)), _col26 (type: decimal(10,0)), _col27 (type: double), _col28 (type: string), _col29 (type: string), _col30 (type: string), _col31 (type: string), _col32 (type: string), _col33 (type: string), _col34 (type: string), _col35 (type: string), _col36 (type: string)","key expressions:":"_col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string), _col7 (type: string), _col8 (type: double), _col9 (type: bigint), _col10 (type: double), _col11 (type: double), _col12 (type: double), _col13 (type: double), _col14 (type: double), _col15 (type: double), _col16 (type: double), _col17 (type: double), _col18 (type: double), _col19 (type: double), _col20 (type: double), _col21 (type: decimal(20,0)), _col22 (type: bigint), _col23 (type: string), _col24 (type: string), _col25 (type: decimal(10,0)), _col26 (type: decimal(10,0)), _col27 (type: double), _col28 (type: string), _col29 (type: string), _col30 (type: string), _col31 (type: string), _col32 (type: string), _col33 (type: string), _col34 (type: string), _col35 (type: string), _col36 (type: string)"}},"outputColumnNames:":["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col20","_col21","_col22","_col23","_col24","_col25","_col26","_col27","_col28","_col29","_col30","_col31","_col32","_col33","_col34","_col35","_col36"]}},"predicate:":"(_col17 > 0.0) (type: boolean)"}},"outputColumnNames:":["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col20","_col21","_col22","_col23","_col24","_col25","_col26","_col27","_col28","_col29","_col30","_col31","_col32","_col33","_col34","_col35","_col36"],"expressions:":"_col1 (type: string), _col0 (type: string), _col2 (type: string), _col8 (type: string), _col3 (type: string), _col4 (type: string), _col9 (type: string), _col10 (type: string), _col11 (type: double), _col12 (type: bigint), _col25 (type: double), _col5 (type: double), _col13 (type: double), _col6 (type: double), CASE WHEN ((_col25 > _col15)) THEN ((_col15 - _col25)) ELSE (0) END (type: double), CASE WHEN (CASE WHEN ((_col25 > _col15)) THEN (((_col15 - _col25) = 0)) ELSE (true) END) THEN (0) WHEN ((_col6 = 0.0)) THEN (180) ELSE ((CASE WHEN ((_col25 > _col15)) THEN ((_col15 - _col25)) ELSE (0) END / _col6)) END (type: double), CASE WHEN ((_col6 = 0.0)) THEN (180) ELSE ((_col25 / _col6)) END (type: double), CASE WHEN (_col32 is not null) THEN (CASE WHEN (((_col25 - _col32) < _col13)) THEN (((_col13 - _col25) + _col32)) ELSE (0) END) ELSE (CASE WHEN ((_col25 < _col13)) THEN ((_col13 - _col25)) ELSE (0) END) END (type: double), (CASE WHEN (_col32 is not null) THEN ((CASE WHEN (((_col25 - _col32) < _col13)) THEN ((_col13 - _col25)) ELSE (0) END + _col32)) ELSE (CASE WHEN ((_col25 < _col13)) THEN ((_col13 - _col25)) ELSE (0) END) END * _col5) (type: double), _col25 (type: double), _col15 (type: double), CASE WHEN (_col32 is not null) THEN (_col32) ELSE (0) END (type: decimal(20,0)), CASE WHEN (_col33 is not null) THEN (_col33) ELSE (0) END (type: bigint), _col7 (type: string), CASE WHEN (_col38 is not null) THEN (_col38) ELSE ('2017-08-07') END (type: string), COALESCE(_col26,0) (type: decimal(10,0)), COALESCE(_col27,0) (type: decimal(10,0)), _col14 (type: double), _col35 (type: string), _col17 (type: string), _col18 (type: string), _col19 (type: string), _col20 (type: string), _col21 (type: string), _col22 (type: string), _col23 (type: string), _col24 (type: string)"}},"condition map:":[{"":"Left Outer Join0 to 1"},{"":"Left Outer Join0 to 2"}],"outputColumnNames:":["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col17","_col18","_col19","_col20","_col21","_col22","_col23","_col24","_col25","_col26","_col27","_col32","_col33","_col35","_col38"]}}},"Reducer 6":{"Reduce Operator Tree:":{"Merge Join Operator":{"Statistics:":"Num rows: 3307476 Data size: 9666276890 Basic stats: COMPLETE Column stats: NONE","keys:":{"0":"trim(_col0) (type: string), trim(_col1) (type: string)","1":"trim(_col1) (type: string), trim(_col0) (type: string)"},"children":{"Select Operator":{"Statistics:":"Num rows: 3307476 Data size: 9666276890 Basic stats: COMPLETE Column stats: NONE","children":{"Reduce Output Operator":{"value expressions:":"_col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: double), _col6 (type: double), _col7 (type: string), _col8 (type: string), _col9 (type: string), _col10 (type: string), _col11 (type: double), _col12 (type: bigint), _col13 (type: double), _col14 (type: double), _col15 (type: double), _col17 (type: string), _col18 (type: string), _col19 (type: string), _col20 (type: string), _col21 (type: string), _col22 (type: string), _col23 (type: string), _col24 (type: string), _col25 (type: double), _col26 (type: decimal(10,0)), _col27 (type: decimal(10,0))","sort order:":"++","Statistics:":"Num rows: 3307476 Data size: 9666276890 Basic stats: COMPLETE Column stats: NONE","Map-reduce partition columns:":"trim(_col0) (type: string), trim(_col1) (type: string)","key expressions:":"trim(_col0) (type: string), trim(_col1) (type: string)"}},"outputColumnNames:":["_col0","_col1","_col10","_col11","_col12","_col13","_col14","_col15","_col17","_col18","_col19","_col2","_col20","_col21","_col22","_col23","_col24","_col25","_col26","_col27","_col3","_col4","_col5","_col6","_col7","_col8","_col9"],"expressions:":"_col0 (type: string), _col1 (type: string), _col10 (type: string), _col11 (type: double), _col12 (type: bigint), _col13 (type: double), _col14 (type: double), _col15 (type: double), _col17 (type: string), _col18 (type: string), _col19 (type: string), _col2 (type: string), _col20 (type: string), _col21 (type: string), _col22 (type: string), _col23 (type: string), _col24 (type: string), CASE WHEN (_col27 is null) THEN (0) ELSE (_col27) END (type: double), _col28 (type: decimal(10,0)), _col29 (type: decimal(10,0)), _col3 (type: string), _col4 (type: string), _col5 (type: double), _col6 (type: double), _col7 (type: string), _col8 (type: string), _col9 (type: string)"}},"condition map:":[{"":"Left Outer Join0 to 1"}],"outputColumnNames:":["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col17","_col18","_col19","_col20","_col21","_col22","_col23","_col24","_col27","_col28","_col29"]}}},"Reducer 5":{"Reduce Operator Tree:":{"Merge Join Operator":{"Statistics:":"Num rows: 3006797 Data size: 8787524255 Basic stats: COMPLETE Column stats: NONE","keys:":{"0":"parts_number (type: string)","1":"_col0 (type: string)"},"children":{"Select Operator":{"Statistics:":"Num rows: 3006797 Data size: 8787524255 Basic stats: COMPLETE Column stats: NONE","children":{"Reduce Output Operator":{"value expressions:":"_col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: double), _col6 (type: double), _col7 (type: string), _col8 (type: string), _col9 (type: string), _col10 (type: string), _col11 (type: double), _col12 (type: bigint), _col13 (type: double), _col14 (type: double), _col15 (type: double), _col17 (type: string), _col18 (type: string), _col19 (type: string), _col20 (type: string), _col21 (type: string), _col22 (type: string), _col23 (type: string), _col24 (type: string)","sort order:":"++","Statistics:":"Num rows: 3006797 Data size: 8787524255 Basic stats: COMPLETE Column stats: NONE","Map-reduce partition columns:":"trim(_col0) (type: string), trim(_col1) (type: string)","key expressions:":"trim(_col0) (type: string), trim(_col1) (type: string)"}},"outputColumnNames:":["_col0","_col1","_col10","_col11","_col12","_col13","_col14","_col15","_col17","_col18","_col19","_col2","_col20","_col21","_col22","_col23","_col24","_col3","_col4","_col5","_col6","_col7","_col8","_col9"],"expressions:":"_col0 (type: string), _col1 (type: string), _col18 (type: string), _col42 (type: double), _col14 (type: bigint), _col52 (type: double), _col54 (type: double), _col55 (type: double), _col2 (type: string), _col36 (type: string), _col30 (type: string), _col45 (type: string), _col31 (type: string), _col32 (type: string), _col33 (type: string), _col34 (type: string), _col35 (type: string), _col4 (type: string), _col5 (type: string), CASE WHEN (_col84 is null) THEN (_col11) ELSE (_col84) END (type: double), _col47 (type: double), _col7 (type: string), _col19 (type: string), _col17 (type: string)"}},"condition map:":[{"":"Left Outer Join0 to 1"}],"outputColumnNames:":["_col0","_col1","_col2","_col4","_col5","_col7","_col11","_col14","_col17","_col18","_col19","_col30","_col31","_col32","_col33","_col34","_col35","_col36","_col42","_col45","_col47","_col52","_col54","_col55","_col84"]}}},"Reducer 19":{"Execution mode:":"vectorized","Reduce Operator Tree:":{"Group By Operator":{"aggregations:":["max(VALUE._col0)","max(VALUE._col1)","sum(VALUE._col2)","count(VALUE._col3)","max(VALUE._col4)","max(VALUE._col5)"],"mode:":"mergepartial","Statistics:":"Num rows: 4077508 Data size: 15534554926 Basic stats: COMPLETE Column stats: NONE","keys:":"KEY._col0 (type: string), KEY._col1 (type: string)","children":{"Select Operator":{"Statistics:":"Num rows: 4077508 Data size: 15534554926 Basic stats: COMPLETE Column stats: NONE","children":{"Filter Operator":{"Statistics:":"Num rows: 1359169 Data size: 5178183705 Basic stats: COMPLETE Column stats: NONE","children":{"Select Operator":{"Statistics:":"Num rows: 1359169 Data size: 5178183705 Basic stats: COMPLETE Column stats: NONE","children":{"Reduce Output Operator":{"value expressions:":"_col4 (type: decimal(20,0)), _col5 (type: bigint), _col7 (type: string)","sort order:":"++","Statistics:":"Num rows: 1359169 Data size: 5178183705 Basic stats: COMPLETE Column stats: NONE","Map-reduce partition columns:":"trim(_col0) (type: string), trim(_col1) (type: string)","key expressions:":"trim(_col0) (type: string), trim(_col1) (type: string)"}},"outputColumnNames:":["_col0","_col1","_col4","_col5","_col7"],"expressions:":"trim(_col0) (type: string), trim(_col1) (type: string), _col4 (type: decimal(20,0)), _col5 (type: bigint), _col7 (type: string)"}},"predicate:":"(_col7 > '2017-05-01') (type: boolean)"}},"outputColumnNames:":["_col0","_col1","_col4","_col5","_col7"],"expressions:":"_col0 (type: string), _col1 (type: string), _col4 (type: decimal(20,0)), _col5 (type: bigint), _col7 (type: string)"}},"outputColumnNames:":["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]}}},"Reducer 4":{"Execution mode:":"vectorized","Reduce Operator Tree:":{"Group By Operator":{"aggregations:":["max(VALUE._col0)","max(VALUE._col1)","max(VALUE._col2)"],"mode:":"mergepartial","Statistics:":"Num rows: 2146880 Data size: 922892735 Basic stats: COMPLETE Column stats: NONE","keys:":"KEY._col0 (type: string)","children":{"Select Operator":{"Statistics:":"Num rows: 2146880 Data size: 922892735 Basic stats: COMPLETE Column stats: NONE","children":{"Reduce Output Operator":{"value expressions:":"_col3 (type: double)","sort order:":"+","Statistics:":"Num rows: 2146880 Data size: 922892735 Basic stats: COMPLETE Column stats: NONE","Map-reduce partition columns:":"_col0 (type: string)","key expressions:":"_col0 (type: string)"}},"outputColumnNames:":["_col0","_col3"],"expressions:":"trim(_col0) (type: string), _col3 (type: double)"}},"outputColumnNames:":["_col0","_col1","_col2","_col3"]}}},"Reducer 17":{"Reduce Operator Tree:":{"Group By Operator":{"aggregations:":["max(VALUE._col0)"],"mode:":"mergepartial","Statistics:":"Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats: NONE","children":{"Filter Operator":{"Statistics:":"Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats: NONE","children":{"Group By Operator":{"mode:":"hash","Statistics:":"Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats: NONE","keys:":"_col0 (type: timestamp)","children":{"Reduce Output Operator":{"sort order:":"+","Statistics:":"Num rows: 1 Data size: 40 Basic stats: COMPLETE Column stats: NONE","Map-reduce partition columns:":"_col0 (type: timestamp)","key expressions:":"_col0 (type: timestamp)"}},"outputColumnNames:":["_col0"]}},"predicate:":"_col0 is not null (type: boolean)"}},"outputColumnNames:":["_col0"]}}},"Reducer 9":{"Reduce Operator Tree:":{"Select Operator":{"Statistics:":"Num rows: 1212741 Data size: 3544301115 Basic stats: COMPLETE Column stats: NONE","children":{"PTF Operator":{"Statistics:":"Num rows: 1212741 Data size: 3544301115 Basic stats: COMPLETE Column stats: NONE","children":{"Select Operator":{"Statistics:":"Num rows: 1212741 Data size: 3544301115 Basic stats: COMPLETE Column stats: NONE","children":{"File Output Operator":{"compressed:":"false","Statistics:":"Num rows: 1212741 Data size: 3544301115 Basic stats: COMPLETE Column stats: NONE","table:":{"name:":"dmlr_scm_l3.l3_stock_rebal_insufficiency_temp1","input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"}}},"outputColumnNames:":["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col20","_col21","_col22","_col23","_col24","_col25","_col26","_col27","_col28","_col29","_col30","_col31","_col32","_col33","_col34","_col35","_col36","_col37"],"expressions:":"_col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string), _col7 (type: string), _col8 (type: double), _col9 (type: bigint), _col10 (type: double), _col11 (type: double), _col12 (type: double), _col13 (type: double), _col14 (type: double), _col15 (type: double), _col16 (type: double), _col17 (type: double), _col18 (type: double), _col19 (type: double), _col20 (type: double), _col21 (type: decimal(20,0)), _col22 (type: bigint), _col23 (type: string), _col24 (type: string), _col25 (type: decimal(10,0)), _col26 (type: decimal(10,0)), _col27 (type: double), _col28 (type: string), _col29 (type: string), _col30 (type: string), _col31 (type: string), _col32 (type: string), _col33 (type: string), _col34 (type: string), _col35 (type: string), _col36 (type: string), ROW_NUMBER_window_0 (type: int)"}},"Function definitions:":[{"Input definition":{"input alias:":"ptf_0","output shape:":"_col0: string, _col1: string, _col2: string, _col3: string, _col4: string, _col5: string, _col6: string, _col7: string, _col8: double, _col9: bigint, _col10: double, _col11: double, _col12: double, _col13: double, _col14: double, _col15: double, _col16: double, _col17: double, _col18: double, _col19: double, _col20: double, _col21: decimal(20,0), _col22: bigint, _col23: string, _col24: string, _col25: decimal(10,0), _col26: decimal(10,0), _col27: double, _col28: string, _col29: string, _col30: string, _col31: string, _col32: string, _col33: string, _col34: string, _col35: string, _col36: string","type:":"WINDOWING"}},{"Windowing table definition":{"order by:":"_col22(DESC), substr(CASE WHEN (_col2 is null) THEN ('Z-ZZZ') ELSE (_col2) END, 0, 1), CASE WHEN ((_col13 = 0.0)) THEN (180) ELSE ((_col19 / _col13)) END, _col9(DESC)","input alias:":"ptf_1","name:":"windowingtablefunction","raw input shape:":{},"partition by:":"0","window functions:":[{"window function definition":{"isPivotResult:":"true","alias:":"ROW_NUMBER_window_0","name:":"ROW_NUMBER","window frame:":"PRECEDING(MAX)~FOLLOWING(MAX)","window function:":"GenericUDAFRowNumberEvaluator"}}]}}]}},"outputColumnNames:":["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col20","_col21","_col22","_col23","_col24","_col25","_col26","_col27","_col28","_col29","_col30","_col31","_col32","_col33","_col34","_col35","_col36"],"expressions:":"VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: string), VALUE._col3 (type: string), VALUE._col4 (type: string), VALUE._col5 (type: string), VALUE._col6 (type: string), VALUE._col7 (type: string), VALUE._col8 (type: double), KEY.reducesinkkey4 (type: bigint), VALUE._col9 (type: double), VALUE._col10 (type: double), VALUE._col11 (type: double), VALUE._col12 (type: double), VALUE._col13 (type: double), VALUE._col14 (type: double), VALUE._col15 (type: double), VALUE._col16 (type: double), VALUE._col17 (type: double), VALUE._col18 (type: double), VALUE._col19 (type: double), VALUE._col20 (type: decimal(20,0)), KEY.reducesinkkey1 (type: bigint), VALUE._col21 (type: string), VALUE._col22 (type: string), VALUE._col23 (type: decimal(10,0)), VALUE._col24 (type: decimal(10,0)), VALUE._col25 (type: double), VALUE._col26 (type: string), VALUE._col27 (type: string), VALUE._col28 (type: string), VALUE._col29 (type: string), VALUE._col30 (type: string), VALUE._col31 (type: string), VALUE._col32 (type: string), VALUE._col33 (type: string), VALUE._col34 (type: string)"}}},"Reducer 15":{"Execution mode:":"vectorized","Reduce Operator Tree:":{"Group By Operator":{"aggregations:":["max(VALUE._col0)","max(VALUE._col1)","max(VALUE._col2)"],"mode:":"mergepartial","Statistics:":"Num rows: 2695103 Data size: 1552379730 Basic stats: COMPLETE Column stats: NONE","keys:":"KEY._col0 (type: string), KEY._col1 (type: string)","children":{"Select Operator":{"Statistics:":"Num rows: 2695103 Data size: 1552379730 Basic stats: COMPLETE Column stats: NONE","children":{"Reduce Output Operator":{"value expressions:":"_col2 (type: double), _col3 (type: decimal(10,0)), _col4 (type: decimal(10,0))","sort order:":"++","Statistics:":"Num rows: 2695103 Data size: 1552379730 Basic stats: COMPLETE Column stats: NONE","Map-reduce partition columns:":"trim(_col1) (type: string), trim(_col0) (type: string)","key expressions:":"trim(_col1) (type: string), trim(_col0) (type: string)"}},"outputColumnNames:":["_col0","_col1","_col2","_col3","_col4"],"expressions:":"trim(_col0) (type: string), trim(_col1) (type: string), _col2 (type: double), _col3 (type: decimal(10,0)), _col4 (type: decimal(10,0))"}},"outputColumnNames:":["_col0","_col1","_col2","_col3","_col4"]}}},"Reducer 8":{"Execution mode:":"vectorized","Reduce Operator Tree:":{"Group By Operator":{"mode:":"mergepartial","Statistics:":"Num rows: 1212741 Data size: 3544301115 Basic stats: COMPLETE Column stats: NONE","keys:":"KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: string), KEY._col3 (type: string), KEY._col4 (type: string), KEY._col5 (type: string), KEY._col6 (type: string), KEY._col7 (type: string), KEY._col8 (type: double), KEY._col9 (type: bigint), KEY._col10 (type: double), KEY._col11 (type: double), KEY._col12 (type: double), KEY._col13 (type: double), KEY._col14 (type: double), KEY._col15 (type: double), KEY._col16 (type: double), KEY._col17 (type: double), KEY._col18 (type: double), KEY._col19 (type: double), KEY._col20 (type: double), KEY._col21 (type: decimal(20,0)), KEY._col22 (type: bigint), KEY._col23 (type: string), KEY._col24 (type: string), KEY._col25 (type: decimal(10,0)), KEY._col26 (type: decimal(10,0)), KEY._col27 (type: double), KEY._col28 (type: string), KEY._col29 (type: string), KEY._col30 (type: string), KEY._col31 (type: string), KEY._col32 (type: string), KEY._col33 (type: string), KEY._col34 (type: string), KEY._col35 (type: string), KEY._col36 (type: string)","children":{"Reduce Output Operator":{"value expressions:":"_col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string), _col7 (type: string), _col8 (type: double), _col10 (type: double), _col11 (type: double), _col12 (type: double), _col13 (type: double), _col14 (type: double), _col15 (type: double), _col16 (type: double), _col17 (type: double), _col18 (type: double), _col19 (type: double), _col20 (type: double), _col21 (type: decimal(20,0)), _col23 (type: string), _col24 (type: string), _col25 (type: decimal(10,0)), _col26 (type: decimal(10,0)), _col27 (type: double), _col28 (type: string), _col29 (type: string), _col30 (type: string), _col31 (type: string), _col32 (type: string), _col33 (type: string), _col34 (type: string), _col35 (type: string), _col36 (type: string)","sort order:":"+-++-","Statistics:":"Num rows: 1212741 Data size: 3544301115 Basic stats: COMPLETE Column stats: NONE","Map-reduce partition columns:":"0 (type: int)","key expressions:":"0 (type: int), _col22 (type: bigint), substr(CASE WHEN (_col2 is null) THEN ('Z-ZZZ') ELSE (_col2) END, 0, 1) (type: string), CASE WHEN ((_col13 = 0.0)) THEN (180) ELSE ((_col19 / _col13)) END (type: double), _col9 (type: bigint)"}},"outputColumnNames:":["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15","_col16","_col17","_col18","_col19","_col20","_col21","_col22","_col23","_col24","_col25","_col26","_col27","_col28","_col29","_col30","_col31","_col32","_col33","_col34","_col35","_col36"]}}}},"DagId:":"a575_s_dtae2esvc_20170807085303_b9975d0b-09c4-46d4-afa1-41bd1c8f345a:1","Edges:":{"Map 18":{"parent":"Reducer 21","type":"BROADCAST_EDGE"},"Reducer 3":[{"parent":"Reducer 12","type":"BROADCAST_EDGE"},{"parent":"Union 2","type":"SIMPLE_EDGE"}],"Map 1":{"parent":"Union 2","type":"CONTAINS"},"Map 14":{"parent":"Reducer 17","type":"BROADCAST_EDGE"},"Map 10":{"parent":"Union 2","type":"CONTAINS"},"Reducer 12":{"parent":"Map 11","type":"SIMPLE_EDGE"},"Reducer 23":{"parent":"Map 22","type":"SIMPLE_EDGE"},"Reducer 21":{"parent":"Map 20","type":"SIMPLE_EDGE"},"Reducer 7":[{"parent":"Reducer 19","type":"SIMPLE_EDGE"},{"parent":"Reducer 23","type":"SIMPLE_EDGE"},{"parent":"Reducer 6","type":"SIMPLE_EDGE"}],"Reducer 6":[{"parent":"Reducer 15","type":"SIMPLE_EDGE"},{"parent":"Reducer 5","type":"SIMPLE_EDGE"}],"Reducer 5":[{"parent":"Map 13","type":"SIMPLE_EDGE"},{"parent":"Reducer 4","type":"SIMPLE_EDGE"}],"Reducer 19":{"parent":"Map 18","type":"SIMPLE_EDGE"},"Reducer 4":{"parent":"Reducer 3","type":"SIMPLE_EDGE"},"Reducer 17":{"parent":"Map 16","type":"SIMPLE_EDGE"},"Reducer 9":{"parent":"Reducer 8","type":"SIMPLE_EDGE"},"Reducer 15":{"parent":"Map 14","type":"SIMPLE_EDGE"},"Reducer 8":{"parent":"Reducer 7","type":"SIMPLE_EDGE"}}}},"Stage-2":{"Dependency Collection":{}},"Stage-0":{"Move Operator":{"files:":{"hdfs directory:":"true","destination:":"wasb://sparkcp01@sparkcp01sa.blob.core.windows.net/data/fuso/e2e_supplychain_master/l3/l3_stock_rebal_insufficiency_temp1"}}}}}