SP1 - Details for Query 4829

Submitted Time: 2026/05/21 14:18:33
Duration: 5 s
Succeeded Jobs: 7521 7522 7524 7525 7526

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" CollectLimit "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 0 ms"; 3 [labelType="html" label=" Project "]; } 4 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 0 ms"; 6 [labelType="html" label="Sort sort time: 13 ms peak memory: 33.0 MiB spill size: 0.0 B"]; } 7 [labelType="html" label="Exchange shuffle records written: 323,604 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 122 ms (3 ms, 10 ms, 49 ms (stage 15353.0: task 21271)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 32,751 local bytes read: 4.2 MiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 8 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 203.0 MiB (3.6 MiB, 14.2 MiB, 100.0 MiB (stage 15353.0: task 21271)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 41.7 MiB (816.8 KiB, 3.2 MiB, 19.3 MiB (stage 15353.0: task 21271))"]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: total (min, med, max (stageId: taskId))\n5.2 s (84 ms, 638 ms, 1.2 s (stage 15353.0: task 21271))"; 9 [labelType="html" label=" Project "]; 10 [labelType="html" label="SortMergeJoin number of output rows: 323,604 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15353.0: task 21270))"]; } subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n5.6 s (136 ms, 690 ms, 1.3 s (stage 15353.0: task 21271))"; 12 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 111 ms (3 ms, 14 ms, 36 ms (stage 15353.0: task 21271)) peak memory total (min, med, max (stageId: taskId)) 266.8 MiB (16.3 MiB, 17.0 MiB, 116.0 MiB (stage 15353.0: task 21271)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15353.0: task 21270))"]; } 13 [labelType="html" label="AQEShuffleRead number of partitions: 8 partition data size total (min, med, max (stageId: taskId)) 47.4 MiB (1025.8 KiB, 4.1 MiB, 20.5 MiB (driver)) number of coalesced partitions: 2"]; 14 [labelType="html" label="Exchange shuffle records written: 323,604 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 168 ms (15 ms, 16 ms, 18 ms (stage 15349.0: task 21265)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 323,604 local bytes read total (min, med, max (stageId: taskId)) 45.2 MiB (984.4 KiB, 3.9 MiB, 19.7 MiB (stage 15353.0: task 21271)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 15353.0: task 21270)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 80 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 195.3 MiB (18.9 MiB, 19.6 MiB, 20.0 MiB (stage 15349.0: task 21261)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 45.2 MiB (4.4 MiB, 4.5 MiB, 4.6 MiB (stage 15349.0: task 21267))"]; subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n5.7 s (504 ms, 555 ms, 680 ms (stage 15349.0: task 21259))"; 16 [labelType="html" label=" Project "]; } 17 [labelType="html" label="Window spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15349.0: task 21268))"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n7.1 s (639 ms, 694 ms, 816 ms (stage 15349.0: task 21259))"; 19 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 98 ms (4 ms, 11 ms, 14 ms (stage 15349.0: task 21262)) peak memory total (min, med, max (stageId: taskId)) 330.0 MiB (33.0 MiB, 33.0 MiB, 33.0 MiB (stage 15349.0: task 21268)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15349.0: task 21268))"]; } 20 [labelType="html" label="Exchange shuffle records written: 323,604 local merged chunks fetched: 0 shuffle write time: 90 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 323,604 local bytes read total (min, med, max (stageId: taskId)) 30.6 MiB (3.0 MiB, 3.1 MiB, 3.1 MiB (stage 15349.0: task 21261)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 15349.0: task 21268)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 10 remote merged chunks fetched: 0 remote blocks read: 0 data size: 167.5 MiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 30.6 MiB"]; subgraph cluster21 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n2.0 s (20 ms, 24 ms, 1.9 s (stage 15342.0: task 21253))"; 22 [labelType="html" label=" Project "]; 23 [labelType="html" label=" Project "]; 24 [labelType="html" label="ColumnarToRow number of output rows: 323,604 number of input batches: 80"]; } 25 [labelType="html" label="Scan parquet number of files read: 1 scan time total (min, med, max (stageId: taskId)) 185 ms (4 ms, 7 ms, 157 ms (stage 15342.0: task 21253)) metadata time: 0 ms size of files read: 20.4 MiB number of output rows: 323,604"]; subgraph cluster26 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n3.23 h (28.5 s, 21.2 m, 1.28 h (stage 15353.0: task 21273))"; 27 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 15353.0: task 21270)) peak memory total (min, med, max (stageId: taskId)) 128.5 MiB (16.1 MiB, 16.1 MiB, 16.1 MiB (stage 15353.0: task 21270)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 15353.0: task 21270))"]; } 28 [labelType="html" label="AQEShuffleRead number of partitions: 8 partition data size total (min, med, max (stageId: taskId)) 840.0 B (80.0 B, 88.0 B, 160.0 B (driver)) number of coalesced partitions: 2"]; 29 [labelType="html" label="Exchange shuffle records written: 26 local merged chunks fetched: 0 shuffle write time: 2 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 26 local bytes read total (min, med, max (stageId: taskId)) 795.0 B (76.0 B, 83.0 B, 152.0 B (stage 15353.0: task 21274)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 15353.0: task 21270)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 8 remote merged chunks fetched: 0 remote blocks read: 0 data size: 624.0 B local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 795.0 B"]; subgraph cluster30 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 8 ms"; 31 [labelType="html" label=" Project "]; 32 [labelType="html" label="Filter number of output rows: 26"]; } 33 [labelType="html" label="Scan csv number of output rows: 26 number of files read: 1 metadata time: 0 ms size of files read: 119.0 B"]; 1->0; 3->1; 4->3; 6->4; 7->6; 9->7; 10->9; 12->10; 13->12; 14->13; 16->14; 17->16; 19->17; 20->19; 22->20; 23->22; 24->23; 25->24; 27->10; 28->27; 29->28; 31->29; 32->31; 33->32; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

Project [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_00870525_B429_406C_B5B2_48E81839DF83#1198301, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#1198362, COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#1198449, ... 2 more fields]

WholeStageCodegen (9)

Window [max(COL_4F6483F1_21FA_4AA8_87AC_0BCE5D88D325#1198302) windowspecdefinition(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#1198362, max(COL_ACA1D876_A72F_4D96_A52A_E00884E7B282#1198303) windowspecdefinition(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#1198449], [COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566], [1 DESC NULLS LAST]

Sort [COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (8)

Exchange hashpartitioning(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, 10), ENSURE_REQUIREMENTS, [plan_id=674069]

Project [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100 AS COL_00870525_B429_406C_B5B2_48E81839DF83#1198301, int_if_with_rule(isnotnull(FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100), 1, 0) AS COL_4F6483F1_21FA_4AA8_87AC_0BCE5D88D325#1198302, int_if_with_rule((COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598 <=> ATU), 1, 0) AS COL_ACA1D876_A72F_4D96_A52A_E00884E7B282#1198303, ... 2 more fields]

SortMergeJoin [COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598], [FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100], LeftOuter

WholeStageCodegen (7)

Sort [COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598 ASC NULLS FIRST], false, 0

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, 10), ENSURE_REQUIREMENTS, [plan_id=673993]

Project [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, str_list_remove(COL_528342FA_BC66_4429_9081_253752B73FBA#1197770, ) AS COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]

WholeStageCodegen (4)

Window [collect_set(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, 0, 0) windowspecdefinition(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_528342FA_BC66_4429_9081_253752B73FBA#1197770, collect_set(COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, 0, 0) windowspecdefinition(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842], [COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566], [1 DESC NULLS LAST]

Sort [COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (3)

Exchange hashpartitioning(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, 10), ENSURE_REQUIREMENTS, [plan_id=673848]

Project [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, str_if_with_rule(((((COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598 <=> CS) OR (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598 <=> CS N)) OR (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598 <=> CS F)) OR (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598 <=> APC)), str_join(array(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554), -), null) AS COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723]

Project [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1197308 AS COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1197309 AS COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1197310 AS COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1197311 AS COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1197312 AS COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1197321 AS COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1197322 AS COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#1197325 AS COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#1197326 AS COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#1197327 AS COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#1197328 AS COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#1197329 AS COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#1197330 AS COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#1197331 AS COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#1197332 AS COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#1197333 AS COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_06CB38F0_2321_426B_AA44_D37094826BC3#1197336 AS COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#1197334L AS COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#1197335 AS COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1197311 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1197308, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1197311 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1197311 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1197308, 78, 5), )), ONLY_ONE) AS COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1197308,COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1197309,COL_D16817E6_135B_4508_A082_6C19AC9542DE#1197310,COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1197311,COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1197312,COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1197321,COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1197322,COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#1197325,COL_07AE9250_614D_4D42_854B_0EDF3D549B40#1197326,COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#1197327,COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#1197328,COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#1197329,COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#1197330,COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#1197331,COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#1197332,COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#1197333,COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#1197334L,COL_119C9448_3C3F_46EA_80E7_062422A2830D#1197335,COL_06CB38F0_2321_426B_AA44_D37094826BC3#1197336] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_A_RSF_SOURCE_208498], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF:string,COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730:s...

Sort [FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100 ASC NULLS FIRST], false, 0

WholeStageCodegen (6)

AQEShuffleRead coalesced

Exchange hashpartitioning(FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100, 10), ENSURE_REQUIREMENTS, [plan_id=673868]

Project [Forfait Urgence#1197298 AS FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100]

Filter isnotnull(Forfait Urgence#1197298)

WholeStageCodegen (2)

FileScan csv [Forfait Urgence#1197298] Batched: false, DataFilters: [isnotnull(Forfait Urgence#1197298)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/FORFAITS_URGENC_208433/Forfait_Urgence...., PartitionFilters: [], PushedFilters: [IsNotNull(Forfait Urgence)], ReadSchema: struct<Forfait Urgence:string>

Details

== Physical Plan ==
AdaptiveSparkPlan (48)
+- == Final Plan ==
   CollectLimit (28)
   +- * Project (27)
      +- Window (26)
         +- * Sort (25)
            +- ShuffleQueryStage (24), Statistics(sizeInBytes=203.0 MiB, rowCount=3.24E+5)
               +- Exchange (23)
                  +- * Project (22)
                     +- * SortMergeJoin LeftOuter (21)
                        :- * Sort (13)
                        :  +- AQEShuffleRead (12)
                        :     +- ShuffleQueryStage (11), Statistics(sizeInBytes=195.3 MiB, rowCount=3.24E+5)
                        :        +- Exchange (10)
                        :           +- * Project (9)
                        :              +- Window (8)
                        :                 +- * Sort (7)
                        :                    +- ShuffleQueryStage (6), Statistics(sizeInBytes=167.5 MiB, rowCount=3.24E+5)
                        :                       +- Exchange (5)
                        :                          +- * Project (4)
                        :                             +- * Project (3)
                        :                                +- * ColumnarToRow (2)
                        :                                   +- Scan parquet  (1)
                        +- * Sort (20)
                           +- AQEShuffleRead (19)
                              +- ShuffleQueryStage (18), Statistics(sizeInBytes=624.0 B, rowCount=26)
                                 +- Exchange (17)
                                    +- * Project (16)
                                       +- * Filter (15)
                                          +- Scan csv  (14)
+- == Initial Plan ==
   CollectLimit (47)
   +- Project (46)
      +- Window (45)
         +- Sort (44)
            +- Exchange (43)
               +- Project (42)
                  +- SortMergeJoin LeftOuter (41)
                     :- Sort (36)
                     :  +- Exchange (35)
                     :     +- Project (34)
                     :        +- Window (33)
                     :           +- Sort (32)
                     :              +- Exchange (31)
                     :                 +- Project (30)
                     :                    +- Project (29)
                     :                       +- Scan parquet  (1)
                     +- Sort (40)
                        +- Exchange (39)
                           +- Project (38)
                              +- Filter (37)
                                 +- Scan csv  (14)


(1) Scan parquet 
Output [19]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1197308, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1197309, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1197310, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1197311, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1197312, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1197321, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1197322, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#1197325, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#1197326, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#1197327, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#1197328, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#1197329, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#1197330, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#1197331, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#1197332, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#1197333, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#1197334L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#1197335, COL_06CB38F0_2321_426B_AA44_D37094826BC3#1197336]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_A_RSF_SOURCE_208498]
ReadSchema: struct<COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF:string,COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730:string,COL_D16817E6_135B_4508_A082_6C19AC9542DE:string,COL_2EE853AF_4512_4E8D_ABAE_19143D81E357:string,COL_631C3DFF_F530_4B1D_BF92_7D730B52002B:int,COL_410747F2_ADCB_4C39_B9B9_C56104DAC484:string,COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5:string,COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A:string,COL_07AE9250_614D_4D42_854B_0EDF3D549B40:string,COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A:string,COL_06D0B7A1_9E5A_4504_BE77_E30488C56572:string,COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7:string,COL_F76740BC_E84C_42AE_9492_D66CDA0E9344:string,COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B:string,COL_BFA8E75B_6083_4911_8D50_3443279CCEC8:string,COL_86734EEA_482B_4537_86F3_6ACCB97C98E9:string,COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900:bigint,COL_119C9448_3C3F_46EA_80E7_062422A2830D:string,COL_06CB38F0_2321_426B_AA44_D37094826BC3:string>

(2) ColumnarToRow [codegen id : 1]
Input [19]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1197308, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1197309, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1197310, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1197311, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1197312, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1197321, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1197322, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#1197325, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#1197326, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#1197327, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#1197328, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#1197329, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#1197330, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#1197331, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#1197332, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#1197333, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#1197334L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#1197335, COL_06CB38F0_2321_426B_AA44_D37094826BC3#1197336]

(3) Project [codegen id : 1]
Output [20]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1197308 AS COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1197309 AS COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1197310 AS COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1197311 AS COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1197312 AS COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1197321 AS COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1197322 AS COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#1197325 AS COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#1197326 AS COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#1197327 AS COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#1197328 AS COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#1197329 AS COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#1197330 AS COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#1197331 AS COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#1197332 AS COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#1197333 AS COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_06CB38F0_2321_426B_AA44_D37094826BC3#1197336 AS COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#1197334L AS COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#1197335 AS COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1197311 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1197308, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1197311 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1197311 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1197308, 78, 5), )), ONLY_ONE) AS COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598]
Input [19]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1197308, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1197309, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1197310, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1197311, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1197312, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1197321, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1197322, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#1197325, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#1197326, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#1197327, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#1197328, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#1197329, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#1197330, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#1197331, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#1197332, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#1197333, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#1197334L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#1197335, COL_06CB38F0_2321_426B_AA44_D37094826BC3#1197336]

(4) Project [codegen id : 1]
Output [21]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, str_if_with_rule(((((COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598 <=> CS) OR (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598 <=> CS N)) OR (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598 <=> CS F)) OR (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598 <=> APC)), str_join(array(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554), -), null) AS COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723]
Input [20]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598]

(5) Exchange
Input [21]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723]
Arguments: hashpartitioning(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, 10), ENSURE_REQUIREMENTS, [plan_id=673848]

(6) ShuffleQueryStage
Output [21]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723]
Arguments: 0

(7) Sort [codegen id : 3]
Input [21]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723]
Arguments: [COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(8) Window
Input [21]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723]
Arguments: [collect_set(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, 0, 0) windowspecdefinition(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_528342FA_BC66_4429_9081_253752B73FBA#1197770, collect_set(COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, 0, 0) windowspecdefinition(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842], [COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566], [1 DESC NULLS LAST]

(9) Project [codegen id : 4]
Output [23]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, str_list_remove(COL_528342FA_BC66_4429_9081_253752B73FBA#1197770, ) AS COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Input [23]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_528342FA_BC66_4429_9081_253752B73FBA#1197770, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]

(10) Exchange
Input [23]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Arguments: hashpartitioning(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, 10), ENSURE_REQUIREMENTS, [plan_id=673993]

(11) ShuffleQueryStage
Output [23]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Arguments: 2

(12) AQEShuffleRead
Input [23]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Arguments: coalesced

(13) Sort [codegen id : 5]
Input [23]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Arguments: [COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598 ASC NULLS FIRST], false, 0

(14) Scan csv 
Output [1]: [Forfait Urgence#1197298]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/FORFAITS_URGENC_208433/Forfait_Urgence.csv]
PushedFilters: [IsNotNull(Forfait Urgence)]
ReadSchema: struct<Forfait Urgence:string>

(15) Filter [codegen id : 2]
Input [1]: [Forfait Urgence#1197298]
Condition : isnotnull(Forfait Urgence#1197298)

(16) Project [codegen id : 2]
Output [1]: [Forfait Urgence#1197298 AS FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100]
Input [1]: [Forfait Urgence#1197298]

(17) Exchange
Input [1]: [FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100]
Arguments: hashpartitioning(FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100, 10), ENSURE_REQUIREMENTS, [plan_id=673868]

(18) ShuffleQueryStage
Output [1]: [FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100]
Arguments: 1

(19) AQEShuffleRead
Input [1]: [FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100]
Arguments: coalesced

(20) Sort [codegen id : 6]
Input [1]: [FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100]
Arguments: [FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100 ASC NULLS FIRST], false, 0

(21) SortMergeJoin [codegen id : 7]
Left keys [1]: [COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598]
Right keys [1]: [FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100]
Join type: LeftOuter
Join condition: None

(22) Project [codegen id : 7]
Output [26]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100 AS COL_00870525_B429_406C_B5B2_48E81839DF83#1198301, int_if_with_rule(isnotnull(FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100), 1, 0) AS COL_4F6483F1_21FA_4AA8_87AC_0BCE5D88D325#1198302, int_if_with_rule((COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598 <=> ATU), 1, 0) AS COL_ACA1D876_A72F_4D96_A52A_E00884E7B282#1198303, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Input [24]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842, FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100]

(23) Exchange
Input [26]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_00870525_B429_406C_B5B2_48E81839DF83#1198301, COL_4F6483F1_21FA_4AA8_87AC_0BCE5D88D325#1198302, COL_ACA1D876_A72F_4D96_A52A_E00884E7B282#1198303, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Arguments: hashpartitioning(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, 10), ENSURE_REQUIREMENTS, [plan_id=674069]

(24) ShuffleQueryStage
Output [26]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_00870525_B429_406C_B5B2_48E81839DF83#1198301, COL_4F6483F1_21FA_4AA8_87AC_0BCE5D88D325#1198302, COL_ACA1D876_A72F_4D96_A52A_E00884E7B282#1198303, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Arguments: 3

(25) Sort [codegen id : 8]
Input [26]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_00870525_B429_406C_B5B2_48E81839DF83#1198301, COL_4F6483F1_21FA_4AA8_87AC_0BCE5D88D325#1198302, COL_ACA1D876_A72F_4D96_A52A_E00884E7B282#1198303, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Arguments: [COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(26) Window
Input [26]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_00870525_B429_406C_B5B2_48E81839DF83#1198301, COL_4F6483F1_21FA_4AA8_87AC_0BCE5D88D325#1198302, COL_ACA1D876_A72F_4D96_A52A_E00884E7B282#1198303, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Arguments: [max(COL_4F6483F1_21FA_4AA8_87AC_0BCE5D88D325#1198302) windowspecdefinition(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#1198362, max(COL_ACA1D876_A72F_4D96_A52A_E00884E7B282#1198303) windowspecdefinition(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#1198449], [COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566], [1 DESC NULLS LAST]

(27) Project [codegen id : 9]
Output [26]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_00870525_B429_406C_B5B2_48E81839DF83#1198301, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#1198362, COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#1198449, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Input [28]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_00870525_B429_406C_B5B2_48E81839DF83#1198301, COL_4F6483F1_21FA_4AA8_87AC_0BCE5D88D325#1198302, COL_ACA1D876_A72F_4D96_A52A_E00884E7B282#1198303, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#1198362, COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#1198449]

(28) CollectLimit
Input [26]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_00870525_B429_406C_B5B2_48E81839DF83#1198301, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#1198362, COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#1198449, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Arguments: 1500

(29) Project
Output [20]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1197308 AS COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1197309 AS COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1197310 AS COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1197311 AS COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1197312 AS COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1197321 AS COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1197322 AS COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#1197325 AS COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#1197326 AS COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#1197327 AS COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#1197328 AS COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#1197329 AS COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#1197330 AS COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#1197331 AS COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#1197332 AS COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#1197333 AS COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_06CB38F0_2321_426B_AA44_D37094826BC3#1197336 AS COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#1197334L AS COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#1197335 AS COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1197311 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1197308, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1197311 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1197311 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1197308, 78, 5), )), ONLY_ONE) AS COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598]
Input [19]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#1197308, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#1197309, COL_D16817E6_135B_4508_A082_6C19AC9542DE#1197310, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#1197311, COL_631C3DFF_F530_4B1D_BF92_7D730B52002B#1197312, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#1197321, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#1197322, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#1197325, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#1197326, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#1197327, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#1197328, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#1197329, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#1197330, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#1197331, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#1197332, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#1197333, COL_7A64C431_4DCA_41DB_BCB3_5CF4EAA81900#1197334L, COL_119C9448_3C3F_46EA_80E7_062422A2830D#1197335, COL_06CB38F0_2321_426B_AA44_D37094826BC3#1197336]

(30) Project
Output [21]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, str_if_with_rule(((((COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598 <=> CS) OR (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598 <=> CS N)) OR (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598 <=> CS F)) OR (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598 <=> APC)), str_join(array(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554), -), null) AS COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723]
Input [20]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598]

(31) Exchange
Input [21]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723]
Arguments: hashpartitioning(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, 10), ENSURE_REQUIREMENTS, [plan_id=673787]

(32) Sort
Input [21]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723]
Arguments: [COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(33) Window
Input [21]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723]
Arguments: [collect_set(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, 0, 0) windowspecdefinition(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_528342FA_BC66_4429_9081_253752B73FBA#1197770, collect_set(COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, 0, 0) windowspecdefinition(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842], [COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566], [1 DESC NULLS LAST]

(34) Project
Output [23]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, str_list_remove(COL_528342FA_BC66_4429_9081_253752B73FBA#1197770, ) AS COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Input [23]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_528342FA_BC66_4429_9081_253752B73FBA#1197770, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]

(35) Exchange
Input [23]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Arguments: hashpartitioning(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, 10), ENSURE_REQUIREMENTS, [plan_id=673795]

(36) Sort
Input [23]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Arguments: [COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598 ASC NULLS FIRST], false, 0

(37) Filter
Input [1]: [Forfait Urgence#1197298]
Condition : isnotnull(Forfait Urgence#1197298)

(38) Project
Output [1]: [Forfait Urgence#1197298 AS FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100]
Input [1]: [Forfait Urgence#1197298]

(39) Exchange
Input [1]: [FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100]
Arguments: hashpartitioning(FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100, 10), ENSURE_REQUIREMENTS, [plan_id=673796]

(40) Sort
Input [1]: [FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100]
Arguments: [FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100 ASC NULLS FIRST], false, 0

(41) SortMergeJoin
Left keys [1]: [COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598]
Right keys [1]: [FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100]
Join type: LeftOuter
Join condition: None

(42) Project
Output [26]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100 AS COL_00870525_B429_406C_B5B2_48E81839DF83#1198301, int_if_with_rule(isnotnull(FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100), 1, 0) AS COL_4F6483F1_21FA_4AA8_87AC_0BCE5D88D325#1198302, int_if_with_rule((COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598 <=> ATU), 1, 0) AS COL_ACA1D876_A72F_4D96_A52A_E00884E7B282#1198303, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Input [24]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842, FORFAITURGENCE_208492_FORFAIT_URGENCE_208493#1198100]

(43) Exchange
Input [26]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_00870525_B429_406C_B5B2_48E81839DF83#1198301, COL_4F6483F1_21FA_4AA8_87AC_0BCE5D88D325#1198302, COL_ACA1D876_A72F_4D96_A52A_E00884E7B282#1198303, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Arguments: hashpartitioning(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, 10), ENSURE_REQUIREMENTS, [plan_id=673802]

(44) Sort
Input [26]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_00870525_B429_406C_B5B2_48E81839DF83#1198301, COL_4F6483F1_21FA_4AA8_87AC_0BCE5D88D325#1198302, COL_ACA1D876_A72F_4D96_A52A_E00884E7B282#1198303, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Arguments: [COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(45) Window
Input [26]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_00870525_B429_406C_B5B2_48E81839DF83#1198301, COL_4F6483F1_21FA_4AA8_87AC_0BCE5D88D325#1198302, COL_ACA1D876_A72F_4D96_A52A_E00884E7B282#1198303, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Arguments: [max(COL_4F6483F1_21FA_4AA8_87AC_0BCE5D88D325#1198302) windowspecdefinition(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#1198362, max(COL_ACA1D876_A72F_4D96_A52A_E00884E7B282#1198303) windowspecdefinition(COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#1198449], [COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566], [1 DESC NULLS LAST]

(46) Project
Output [26]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_00870525_B429_406C_B5B2_48E81839DF83#1198301, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#1198362, COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#1198449, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Input [28]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_00870525_B429_406C_B5B2_48E81839DF83#1198301, COL_4F6483F1_21FA_4AA8_87AC_0BCE5D88D325#1198302, COL_ACA1D876_A72F_4D96_A52A_E00884E7B282#1198303, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#1198362, COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#1198449]

(47) CollectLimit
Input [26]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_00870525_B429_406C_B5B2_48E81839DF83#1198301, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#1198362, COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#1198449, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Arguments: 1500

(48) AdaptiveSparkPlan
Output [26]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#1197540, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#1197541, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#1197542, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#1197543, COL_76DBABA9_CE78_451B_9E43_031763A13C92#1197544, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#1197553, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#1197554, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#1197557, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#1197558, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#1197559, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#1197560, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#1197561, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#1197562, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#1197563, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#1197564, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#1197565, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#1197566, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#1197567L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#1197568, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#1197598, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#1198073, COL_00870525_B429_406C_B5B2_48E81839DF83#1198301, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#1198362, COL_DA9B5599_81F6_4F11_BD9B_F24A1CAC4BC1#1198449, COL_A02299F0_512D_43EB_91AD_C4B4B4FBF641#1197723, COL_6C26A66E_DF0D_48C1_9F73_B1A9495AAD7C#1197842]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet