SP1 - Details for Query 2736

Submitted Time: 2026/10/12 09:23:44
Duration: 0.7 s
Succeeded Jobs: 4157 4158 4159 4160 4161 4162 4163

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 (15)\n \nduration: 21 ms"; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label="Filter number of output rows: 243"]; 6 [labelType="html" label="SortMergeJoin number of output rows: 6,213 spill size: 0.0 B"]; } subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (13)\n \nduration: 48 ms"; 8 [labelType="html" label="Sort sort time: 1 ms peak memory: 16.3 MiB spill size: 0.0 B"]; } 9 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 457.6 KiB number of coalesced partitions: 1"]; 10 [labelType="html" label="Exchange shuffle records written: 6,213 local merged chunks fetched: 0 shuffle write time: 1 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: 6,213 local bytes read: 441.0 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 1914.7 KiB 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: 441.0 KiB"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: 21 ms"; 12 [labelType="html" label=" Project "]; 13 [labelType="html" label="SortMergeJoin number of output rows: 6,213 spill size: 0.0 B"]; } subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 24 ms"; 15 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.3 MiB spill size: 0.0 B"]; } 16 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 460.1 KiB number of coalesced partitions: 1"]; 17 [labelType="html" label="Exchange shuffle records written: 6,213 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: 6,213 local bytes read: 437.5 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 1866.1 KiB 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: 437.5 KiB"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 55 ms"; 19 [labelType="html" label=" Project "]; 20 [labelType="html" label=" Project "]; } 21 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster22 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 84 ms"; 23 [labelType="html" label="Sort sort time: 1 ms peak memory: 16.3 MiB spill size: 0.0 B"]; } 24 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 389.9 KiB number of coalesced partitions: 1"]; 25 [labelType="html" label="Exchange shuffle records written: 6,213 local merged chunks fetched: 0 shuffle write time: 1 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: 6,213 local bytes read: 373.9 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 1568.9 KiB 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: 373.9 KiB"]; subgraph cluster26 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 101 ms"; 27 [labelType="html" label=" Project "]; 28 [labelType="html" label="SortMergeJoin number of output rows: 6,213 spill size: 0.0 B"]; } subgraph cluster29 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 114 ms"; 30 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 31 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 158.5 KiB number of coalesced partitions: 1"]; 32 [labelType="html" label="Exchange shuffle records written: 4,001 local merged chunks fetched: 0 shuffle write time: 1 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: 4,001 local bytes read: 153.6 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 562.6 KiB 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: 153.6 KiB"]; subgraph cluster33 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 26 ms"; 34 [labelType="html" label=" Project "]; } 35 [labelType="html" label="Scan csv number of output rows: 4,001 number of files read: 1 metadata time: 0 ms size of files read: 219.3 KiB"]; subgraph cluster36 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 112 ms"; 37 [labelType="html" label="Sort sort time: 1 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 38 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 161.5 KiB number of coalesced partitions: 1"]; 39 [labelType="html" label="Exchange shuffle records written: 3,810 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: 3,810 local bytes read: 155.1 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 553.2 KiB 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: 155.1 KiB"]; subgraph cluster40 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 24 ms"; 41 [labelType="html" label=" Project "]; 42 [labelType="html" label="Filter number of output rows: 3,810"]; } 43 [labelType="html" label="Scan csv number of output rows: 3,810 number of files read: 1 metadata time: 0 ms size of files read: 269.6 KiB"]; subgraph cluster44 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: 0 ms"; 45 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 46 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 4.2 KiB number of coalesced partitions: 1"]; 47 [labelType="html" label="Exchange shuffle records written: 206 local merged chunks fetched: 0 shuffle write time: 1 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: 412 local bytes read total (min, med, max (stageId: taskId)) 8.0 KiB (4.0 KiB, 4.0 KiB, 4.0 KiB (stage 8155.0: task 11056)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 8155.0: task 11056)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size: 9.7 KiB 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: 4.0 KiB"]; subgraph cluster48 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 14 ms"; 49 [labelType="html" label=" Project "]; 50 [labelType="html" label="Filter number of output rows: 206"]; 51 [labelType="html" label="ColumnarToRow number of output rows: 207 number of input batches: 1"]; } 52 [labelType="html" label="Scan parquet number of files read: 1 scan time: 2 ms metadata time: 0 ms size of files read: 4.6 KiB number of output rows: 207"]; subgraph cluster53 { isCluster="true"; label="WholeStageCodegen (14)\n \nduration: 0 ms"; 54 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 55 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 4.2 KiB number of coalesced partitions: 1"]; 1->0; 3->1; 4->3; 5->4; 6->5; 8->6; 9->8; 10->9; 12->10; 13->12; 15->13; 16->15; 17->16; 19->17; 20->19; 21->20; 23->21; 24->23; 25->24; 27->25; 28->27; 30->28; 31->30; 32->31; 34->32; 35->34; 37->28; 38->37; 39->38; 41->39; 42->41; 43->42; 45->13; 46->45; 47->46; 49->47; 50->49; 51->50; 52->51; 54->6; 55->54; 47->55; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

Project [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052 AS COL_BBBCD253_8FF2_4500_A5AC_96CBD8816359#582383, dec_if_with_rule((isnotnull(COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024) AND isnotnull(NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052)), dec_diff(array(NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024)), null) AS COL_8DB232C4_F229_4420_943D_2571B9A2FBC2#582384, str_join(array(str_join(array(Dossier :, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, IPP :, COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, Eligibilité :), ), COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, Spécialité :, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, Consultation, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, du, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, avec courrier, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, du, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553), ) AS COL_E572C8FC_38F4_4E37_B24F_C8858B1FFF5E#582406, str_join(array(Consultation antèrieure :, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, le, date_time_to_str(COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, dd/MM/yyyy HH:mm:ss, Europe/Paris, fr_FR), il y a, bigint_to_str(COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L), mois, pour spécialité, COL_0323952F_EE16_429A_A587_A09931AF787B#581637), ) AS COL_86719F90_F628_486E_A5FB_D9757B38CEC8#582429]

Filter CASE WHEN isnull(dec_if_with_rule((isnotnull(COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024) AND isnotnull(NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052)), dec_diff(array(NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024)), null)) THEN false ELSE (dec_if_with_rule((isnotnull(COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024) AND isnotnull(NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052)), dec_diff(array(NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024)), null) > 0.0) END

SortMergeJoin [COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944], [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#582049], LeftOuter, ((COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 >= NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#582050) AND (COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 <= NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#582051))

WholeStageCodegen (15)

Sort [COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944 ASC NULLS FIRST], false, 0

WholeStageCodegen (13)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, 10), ENSURE_REQUIREMENTS, [plan_id=389462]

SortMergeJoin [COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380], [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968], LeftOuter, ((COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 >= NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#581969) AND (COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 <= NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#581970))

WholeStageCodegen (12)

Sort [COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380 ASC NULLS FIRST], false, 0

WholeStageCodegen (10)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, 10), ENSURE_REQUIREMENTS, [plan_id=389369]

Project [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, str_remove_space(str_if_with_rule((((CASE WHEN isnull(COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L) THEN false ELSE (COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L > 4) END AND CASE WHEN isnull(StartsWith(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, CS)) THEN false ELSE StartsWith(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, CS) END) AND (COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556 <=> Validé)) AND (COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384 <=> O)), str_join(array(APC, str_if_with_rule((CASE WHEN isnull(Contains(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, F)) THEN false ELSE Contains(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, F) END OR CASE WHEN isnull(Contains(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, N)) THEN false ELSE Contains(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, N) END), str_extract(str_remove_space(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, ONLY_ONE), RIGHT, 1), )), ), null), ONLY_ONE) AS COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944]

WholeStageCodegen (9)

Window [lag(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, -1, null) windowspecdefinition(COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 ASC NULLS LAST, specifiedwindowframe(RowFrame, -1, -1)) AS COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, lag(COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, -1, null) windowspecdefinition(COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 ASC NULLS LAST, specifiedwindowframe(RowFrame, -1, -1)) AS COL_0323952F_EE16_429A_A587_A09931AF787B#581637, lag(COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, -1, null) windowspecdefinition(COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 ASC NULLS LAST, specifiedwindowframe(RowFrame, -1, -1)) AS COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688], [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381], [COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 ASC NULLS LAST]

Sort [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378 ASC NULLS FIRST, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381 ASC NULLS FIRST, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 ASC NULLS LAST], false, 0

WholeStageCodegen (8)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, 10), ENSURE_REQUIREMENTS, [plan_id=389191]

SortMergeJoin [COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378], [COURRIERS_FICTI_227799__IEP#581402, COURRIERS_FICTI_227799__IPP#581403], LeftOuter

WholeStageCodegen (7)

Sort [COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379 ASC NULLS FIRST, COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378 ASC NULLS FIRST], false, 0

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, 10), ENSURE_REQUIREMENTS, [plan_id=388910]

Project [ipp#581077 AS COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, iep#581078 AS COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, code_acte#581079 AS COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, code_spe#581080 AS COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, date_acte#581081 AS COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, date_naissance#581082 AS COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, parcours#581083 AS COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384]

WholeStageCodegen (1)

FileScan csv [ipp#581077,iep#581078,code_acte#581079,code_spe#581080,date_acte#581081,date_naissance#581082,parcours#581083] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/FADCB12B_36CA_40FC_B01F_3DD2C64D5..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<ipp:string,iep:string,code_acte:string,code_spe:string,date_acte:string,date_naissance:str...

Sort [COURRIERS_FICTI_227799__IEP#581402 ASC NULLS FIRST, COURRIERS_FICTI_227799__IPP#581403 ASC NULLS FIRST], false, 0

WholeStageCodegen (6)

AQEShuffleRead coalesced

Exchange hashpartitioning(COURRIERS_FICTI_227799__IEP#581402, COURRIERS_FICTI_227799__IPP#581403, 10), ENSURE_REQUIREMENTS, [plan_id=388923]

Project [auteur#580998 AS COURRIERS_FICTI_227799__AUTEUR#581399, code_spe_courrier#581000 AS COURRIERS_FICTI_227799__CODE_SPE_COURRIER#581400, date_courrier#581002 AS COURRIERS_FICTI_227799__DATE_COURRIER#581401, iep#580997 AS COURRIERS_FICTI_227799__IEP#581402, ipp#580996 AS COURRIERS_FICTI_227799__IPP#581403, statut#581001 AS COURRIERS_FICTI_227799__STATUT#581404, type_courrier#580999 AS COURRIERS_FICTI_227799__TYPE_COURRIER#581405]

Filter (isnotnull(iep#580997) AND isnotnull(ipp#580996))

WholeStageCodegen (2)

FileScan csv [ipp#580996,iep#580997,auteur#580998,type_courrier#580999,code_spe_courrier#581000,statut#581001,date_courrier#581002] Batched: false, DataFilters: [isnotnull(iep#580997), isnotnull(ipp#580996)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/5DC66825_AB06_470F_8B00_2AE6C1370..., PartitionFilters: [], PushedFilters: [IsNotNull(iep), IsNotNull(ipp)], ReadSchema: struct<ipp:string,iep:string,auteur:string,type_courrier:string,code_spe_courrier:string,statut:s...

Sort [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968 ASC NULLS FIRST], false, 0

WholeStageCodegen (11)

AQEShuffleRead coalesced

Exchange hashpartitioning(NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968, 10), ENSURE_REQUIREMENTS, [plan_id=388952]

Project [Code+Acte#581141 AS NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968, str_to_datez(Date_effet#581144, dd/MM/yyyy, Europe/Paris, fr_FR) AS NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#581969, str_to_datez(Date_r%C3%A9vocation#581145, dd/MM/yyyy, Europe/Paris, fr_FR) AS NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#581970, str_to_dec(str_replace(Montant#581142, ., ,), ##,##) AS NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#581971]

Filter ((isnotnull(Code+Acte#581141) AND isnotnull(str_to_datez(Date_effet#581144, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#581145, dd/MM/yyyy, Europe/Paris, fr_FR)))

ColumnarToRow

WholeStageCodegen (3)

FileScan parquet [Code+Acte#581141,Montant#581142,Date_effet#581144,Date_r%C3%A9vocation#581145] Batched: true, DataFilters: [isnotnull(Code+Acte#581141), isnotnull(str_to_datez(Date_effet#581144, dd/MM/yyyy, Europe/Paris,..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/B327EFC6_2C56_4F02_941C_F0209F65C43..., PartitionFilters: [], PushedFilters: [IsNotNull(`Code+Acte`)], ReadSchema: struct<Code+Acte:string,Montant:string,Date_effet:string,Date_r%C3%A9vocation:string>

Sort [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#582049 ASC NULLS FIRST], false, 0

WholeStageCodegen (14)

AQEShuffleRead coalesced

Details

== Physical Plan ==
AdaptiveSparkPlan (84)
+- == Final Plan ==
   CollectLimit (49)
   +- * Project (48)
      +- * Project (47)
         +- * Filter (46)
            +- * SortMergeJoin LeftOuter (45)
               :- * Sort (40)
               :  +- AQEShuffleRead (39)
               :     +- ShuffleQueryStage (38), Statistics(sizeInBytes=1914.7 KiB, rowCount=6.21E+3)
               :        +- Exchange (37)
               :           +- * Project (36)
               :              +- * SortMergeJoin LeftOuter (35)
               :                 :- * Sort (26)
               :                 :  +- AQEShuffleRead (25)
               :                 :     +- ShuffleQueryStage (24), Statistics(sizeInBytes=1866.1 KiB, rowCount=6.21E+3)
               :                 :        +- Exchange (23)
               :                 :           +- * Project (22)
               :                 :              +- * Project (21)
               :                 :                 +- Window (20)
               :                 :                    +- * Sort (19)
               :                 :                       +- AQEShuffleRead (18)
               :                 :                          +- ShuffleQueryStage (17), Statistics(sizeInBytes=1568.9 KiB, rowCount=6.21E+3)
               :                 :                             +- Exchange (16)
               :                 :                                +- * Project (15)
               :                 :                                   +- * SortMergeJoin LeftOuter (14)
               :                 :                                      :- * Sort (6)
               :                 :                                      :  +- AQEShuffleRead (5)
               :                 :                                      :     +- ShuffleQueryStage (4), Statistics(sizeInBytes=562.6 KiB, rowCount=4.00E+3)
               :                 :                                      :        +- Exchange (3)
               :                 :                                      :           +- * Project (2)
               :                 :                                      :              +- Scan csv  (1)
               :                 :                                      +- * Sort (13)
               :                 :                                         +- AQEShuffleRead (12)
               :                 :                                            +- ShuffleQueryStage (11), Statistics(sizeInBytes=553.2 KiB, rowCount=3.81E+3)
               :                 :                                               +- Exchange (10)
               :                 :                                                  +- * Project (9)
               :                 :                                                     +- * Filter (8)
               :                 :                                                        +- Scan csv  (7)
               :                 +- * Sort (34)
               :                    +- AQEShuffleRead (33)
               :                       +- ShuffleQueryStage (32), Statistics(sizeInBytes=9.7 KiB, rowCount=206)
               :                          +- Exchange (31)
               :                             +- * Project (30)
               :                                +- * Filter (29)
               :                                   +- * ColumnarToRow (28)
               :                                      +- Scan parquet  (27)
               +- * Sort (44)
                  +- AQEShuffleRead (43)
                     +- ShuffleQueryStage (42), Statistics(sizeInBytes=9.7 KiB, rowCount=206)
                        +- ReusedExchange (41)
+- == Initial Plan ==
   CollectLimit (83)
   +- Project (82)
      +- Project (81)
         +- Filter (80)
            +- SortMergeJoin LeftOuter (79)
               :- Sort (73)
               :  +- Exchange (72)
               :     +- Project (71)
               :        +- SortMergeJoin LeftOuter (70)
               :           :- Sort (65)
               :           :  +- Exchange (64)
               :           :     +- Project (63)
               :           :        +- Project (62)
               :           :           +- Window (61)
               :           :              +- Sort (60)
               :           :                 +- Exchange (59)
               :           :                    +- Project (58)
               :           :                       +- SortMergeJoin LeftOuter (57)
               :           :                          :- Sort (52)
               :           :                          :  +- Exchange (51)
               :           :                          :     +- Project (50)
               :           :                          :        +- Scan csv  (1)
               :           :                          +- Sort (56)
               :           :                             +- Exchange (55)
               :           :                                +- Project (54)
               :           :                                   +- Filter (53)
               :           :                                      +- Scan csv  (7)
               :           +- Sort (69)
               :              +- Exchange (68)
               :                 +- Project (67)
               :                    +- Filter (66)
               :                       +- Scan parquet  (27)
               +- Sort (78)
                  +- Exchange (77)
                     +- Project (76)
                        +- Filter (75)
                           +- Scan parquet  (74)


(1) Scan csv 
Output [7]: [ipp#581077, iep#581078, code_acte#581079, code_spe#581080, date_acte#581081, date_naissance#581082, parcours#581083]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/FADCB12B_36CA_40FC_B01F_3DD2C64D526A/current/actes_fictifs.csv]
ReadSchema: struct<ipp:string,iep:string,code_acte:string,code_spe:string,date_acte:string,date_naissance:string,parcours:string>

(2) Project [codegen id : 1]
Output [7]: [ipp#581077 AS COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, iep#581078 AS COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, code_acte#581079 AS COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, code_spe#581080 AS COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, date_acte#581081 AS COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, date_naissance#581082 AS COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, parcours#581083 AS COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384]
Input [7]: [ipp#581077, iep#581078, code_acte#581079, code_spe#581080, date_acte#581081, date_naissance#581082, parcours#581083]

(3) Exchange
Input [7]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384]
Arguments: hashpartitioning(COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, 10), ENSURE_REQUIREMENTS, [plan_id=388910]

(4) ShuffleQueryStage
Output [7]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384]
Arguments: 0

(5) AQEShuffleRead
Input [7]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384]
Arguments: coalesced

(6) Sort [codegen id : 5]
Input [7]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384]
Arguments: [COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379 ASC NULLS FIRST, COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378 ASC NULLS FIRST], false, 0

(7) Scan csv 
Output [7]: [ipp#580996, iep#580997, auteur#580998, type_courrier#580999, code_spe_courrier#581000, statut#581001, date_courrier#581002]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/5DC66825_AB06_470F_8B00_2AE6C1370A39/current/courriers_fictifs.csv]
PushedFilters: [IsNotNull(iep), IsNotNull(ipp)]
ReadSchema: struct<ipp:string,iep:string,auteur:string,type_courrier:string,code_spe_courrier:string,statut:string,date_courrier:string>

(8) Filter [codegen id : 2]
Input [7]: [ipp#580996, iep#580997, auteur#580998, type_courrier#580999, code_spe_courrier#581000, statut#581001, date_courrier#581002]
Condition : (isnotnull(iep#580997) AND isnotnull(ipp#580996))

(9) Project [codegen id : 2]
Output [7]: [auteur#580998 AS COURRIERS_FICTI_227799__AUTEUR#581399, code_spe_courrier#581000 AS COURRIERS_FICTI_227799__CODE_SPE_COURRIER#581400, date_courrier#581002 AS COURRIERS_FICTI_227799__DATE_COURRIER#581401, iep#580997 AS COURRIERS_FICTI_227799__IEP#581402, ipp#580996 AS COURRIERS_FICTI_227799__IPP#581403, statut#581001 AS COURRIERS_FICTI_227799__STATUT#581404, type_courrier#580999 AS COURRIERS_FICTI_227799__TYPE_COURRIER#581405]
Input [7]: [ipp#580996, iep#580997, auteur#580998, type_courrier#580999, code_spe_courrier#581000, statut#581001, date_courrier#581002]

(10) Exchange
Input [7]: [COURRIERS_FICTI_227799__AUTEUR#581399, COURRIERS_FICTI_227799__CODE_SPE_COURRIER#581400, COURRIERS_FICTI_227799__DATE_COURRIER#581401, COURRIERS_FICTI_227799__IEP#581402, COURRIERS_FICTI_227799__IPP#581403, COURRIERS_FICTI_227799__STATUT#581404, COURRIERS_FICTI_227799__TYPE_COURRIER#581405]
Arguments: hashpartitioning(COURRIERS_FICTI_227799__IEP#581402, COURRIERS_FICTI_227799__IPP#581403, 10), ENSURE_REQUIREMENTS, [plan_id=388923]

(11) ShuffleQueryStage
Output [7]: [COURRIERS_FICTI_227799__AUTEUR#581399, COURRIERS_FICTI_227799__CODE_SPE_COURRIER#581400, COURRIERS_FICTI_227799__DATE_COURRIER#581401, COURRIERS_FICTI_227799__IEP#581402, COURRIERS_FICTI_227799__IPP#581403, COURRIERS_FICTI_227799__STATUT#581404, COURRIERS_FICTI_227799__TYPE_COURRIER#581405]
Arguments: 1

(12) AQEShuffleRead
Input [7]: [COURRIERS_FICTI_227799__AUTEUR#581399, COURRIERS_FICTI_227799__CODE_SPE_COURRIER#581400, COURRIERS_FICTI_227799__DATE_COURRIER#581401, COURRIERS_FICTI_227799__IEP#581402, COURRIERS_FICTI_227799__IPP#581403, COURRIERS_FICTI_227799__STATUT#581404, COURRIERS_FICTI_227799__TYPE_COURRIER#581405]
Arguments: coalesced

(13) Sort [codegen id : 6]
Input [7]: [COURRIERS_FICTI_227799__AUTEUR#581399, COURRIERS_FICTI_227799__CODE_SPE_COURRIER#581400, COURRIERS_FICTI_227799__DATE_COURRIER#581401, COURRIERS_FICTI_227799__IEP#581402, COURRIERS_FICTI_227799__IPP#581403, COURRIERS_FICTI_227799__STATUT#581404, COURRIERS_FICTI_227799__TYPE_COURRIER#581405]
Arguments: [COURRIERS_FICTI_227799__IEP#581402 ASC NULLS FIRST, COURRIERS_FICTI_227799__IPP#581403 ASC NULLS FIRST], false, 0

(14) SortMergeJoin [codegen id : 7]
Left keys [2]: [COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378]
Right keys [2]: [COURRIERS_FICTI_227799__IEP#581402, COURRIERS_FICTI_227799__IPP#581403]
Join type: LeftOuter
Join condition: None

(15) Project [codegen id : 7]
Output [13]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COURRIERS_FICTI_227799__AUTEUR#581399 AS COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COURRIERS_FICTI_227799__TYPE_COURRIER#581405 AS COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COURRIERS_FICTI_227799__CODE_SPE_COURRIER#581400 AS COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COURRIERS_FICTI_227799__STATUT#581404 AS COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COURRIERS_FICTI_227799__DATE_COURRIER#581401 AS COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, str_to_datez(str_extract(COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, LEFT, 10), dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558]
Input [14]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COURRIERS_FICTI_227799__AUTEUR#581399, COURRIERS_FICTI_227799__CODE_SPE_COURRIER#581400, COURRIERS_FICTI_227799__DATE_COURRIER#581401, COURRIERS_FICTI_227799__IEP#581402, COURRIERS_FICTI_227799__IPP#581403, COURRIERS_FICTI_227799__STATUT#581404, COURRIERS_FICTI_227799__TYPE_COURRIER#581405]

(16) Exchange
Input [13]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558]
Arguments: hashpartitioning(COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, 10), ENSURE_REQUIREMENTS, [plan_id=389191]

(17) ShuffleQueryStage
Output [13]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558]
Arguments: 5

(18) AQEShuffleRead
Input [13]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558]
Arguments: coalesced

(19) Sort [codegen id : 8]
Input [13]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558]
Arguments: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378 ASC NULLS FIRST, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381 ASC NULLS FIRST, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 ASC NULLS LAST], false, 0

(20) Window
Input [13]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558]
Arguments: [lag(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, -1, null) windowspecdefinition(COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 ASC NULLS LAST, specifiedwindowframe(RowFrame, -1, -1)) AS COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, lag(COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, -1, null) windowspecdefinition(COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 ASC NULLS LAST, specifiedwindowframe(RowFrame, -1, -1)) AS COL_0323952F_EE16_429A_A587_A09931AF787B#581637, lag(COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, -1, null) windowspecdefinition(COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 ASC NULLS LAST, specifiedwindowframe(RowFrame, -1, -1)) AS COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688], [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381], [COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 ASC NULLS LAST]

(21) Project [codegen id : 9]
Output [17]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, date_diff(MONTH, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688) AS COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L]
Input [16]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688]

(22) Project [codegen id : 9]
Output [18]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, str_remove_space(str_if_with_rule((((CASE WHEN isnull(COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L) THEN false ELSE (COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L > 4) END AND CASE WHEN isnull(StartsWith(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, CS)) THEN false ELSE StartsWith(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, CS) END) AND (COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556 <=> Validé)) AND (COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384 <=> O)), str_join(array(APC, str_if_with_rule((CASE WHEN isnull(Contains(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, F)) THEN false ELSE Contains(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, F) END OR CASE WHEN isnull(Contains(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, N)) THEN false ELSE Contains(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, N) END), str_extract(str_remove_space(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, ONLY_ONE), RIGHT, 1), )),  ), null), ONLY_ONE) AS COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944]
Input [17]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L]

(23) Exchange
Input [18]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944]
Arguments: hashpartitioning(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, 10), ENSURE_REQUIREMENTS, [plan_id=389369]

(24) ShuffleQueryStage
Output [18]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944]
Arguments: 6

(25) AQEShuffleRead
Input [18]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944]
Arguments: coalesced

(26) Sort [codegen id : 10]
Input [18]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944]
Arguments: [COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380 ASC NULLS FIRST], false, 0

(27) Scan parquet 
Output [4]: [Code+Acte#581141, Montant#581142, Date_effet#581144, Date_r%C3%A9vocation#581145]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/B327EFC6_2C56_4F02_941C_F0209F65C43D_f96390024f47ad1fd8d43d92a6c7a982/Region-PUBMET_tarifs_forfait_urgences_(1).xlsx_9f5cc06a8bb7ca4fd2c05636743786ea]
PushedFilters: [IsNotNull(`Code+Acte`)]
ReadSchema: struct<Code+Acte:string,Montant:string,Date_effet:string,Date_r%C3%A9vocation:string>

(28) ColumnarToRow [codegen id : 3]
Input [4]: [Code+Acte#581141, Montant#581142, Date_effet#581144, Date_r%C3%A9vocation#581145]

(29) Filter [codegen id : 3]
Input [4]: [Code+Acte#581141, Montant#581142, Date_effet#581144, Date_r%C3%A9vocation#581145]
Condition : ((isnotnull(Code+Acte#581141) AND isnotnull(str_to_datez(Date_effet#581144, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#581145, dd/MM/yyyy, Europe/Paris, fr_FR)))

(30) Project [codegen id : 3]
Output [4]: [Code+Acte#581141 AS NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968, str_to_datez(Date_effet#581144, dd/MM/yyyy, Europe/Paris, fr_FR) AS NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#581969, str_to_datez(Date_r%C3%A9vocation#581145, dd/MM/yyyy, Europe/Paris, fr_FR) AS NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#581970, str_to_dec(str_replace(Montant#581142, ., ,), ##,##) AS NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#581971]
Input [4]: [Code+Acte#581141, Montant#581142, Date_effet#581144, Date_r%C3%A9vocation#581145]

(31) Exchange
Input [4]: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968, NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#581969, NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#581970, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#581971]
Arguments: hashpartitioning(NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968, 10), ENSURE_REQUIREMENTS, [plan_id=388952]

(32) ShuffleQueryStage
Output [4]: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968, NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#581969, NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#581970, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#581971]
Arguments: 2

(33) AQEShuffleRead
Input [4]: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968, NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#581969, NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#581970, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#581971]
Arguments: coalesced

(34) Sort [codegen id : 11]
Input [4]: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968, NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#581969, NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#581970, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#581971]
Arguments: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968 ASC NULLS FIRST], false, 0

(35) SortMergeJoin [codegen id : 12]
Left keys [1]: [COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380]
Right keys [1]: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968]
Join type: LeftOuter
Join condition: ((COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 >= NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#581969) AND (COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 <= NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#581970))

(36) Project [codegen id : 12]
Output [19]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#581971 AS COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024]
Input [22]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968, NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#581969, NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#581970, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#581971]

(37) Exchange
Input [19]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024]
Arguments: hashpartitioning(COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, 10), ENSURE_REQUIREMENTS, [plan_id=389462]

(38) ShuffleQueryStage
Output [19]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024]
Arguments: 7

(39) AQEShuffleRead
Input [19]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024]
Arguments: coalesced

(40) Sort [codegen id : 13]
Input [19]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024]
Arguments: [COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944 ASC NULLS FIRST], false, 0

(41) ReusedExchange [Reuses operator id: 31]
Output [4]: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#582049, NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#582050, NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#582051, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052]

(42) ShuffleQueryStage
Output [4]: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#582049, NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#582050, NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#582051, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052]
Arguments: 4

(43) AQEShuffleRead
Input [4]: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#582049, NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#582050, NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#582051, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052]
Arguments: coalesced

(44) Sort [codegen id : 14]
Input [4]: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#582049, NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#582050, NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#582051, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052]
Arguments: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#582049 ASC NULLS FIRST], false, 0

(45) SortMergeJoin [codegen id : 15]
Left keys [1]: [COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944]
Right keys [1]: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#582049]
Join type: LeftOuter
Join condition: ((COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 >= NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#582050) AND (COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 <= NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#582051))

(46) Filter [codegen id : 15]
Input [23]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024, NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#582049, NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#582050, NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#582051, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052]
Condition : CASE WHEN isnull(dec_if_with_rule((isnotnull(COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024) AND isnotnull(NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052)), dec_diff(array(NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024)), null)) THEN false ELSE (dec_if_with_rule((isnotnull(COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024) AND isnotnull(NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052)), dec_diff(array(NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024)), null) > 0.0) END

(47) Project [codegen id : 15]
Output [23]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052 AS COL_BBBCD253_8FF2_4500_A5AC_96CBD8816359#582383, dec_if_with_rule((isnotnull(COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024) AND isnotnull(NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052)), dec_diff(array(NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024)), null) AS COL_8DB232C4_F229_4420_943D_2571B9A2FBC2#582384, str_join(array(str_join(array(Dossier :, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, IPP :, COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, Eligibilité :),  ), COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, Spécialité :, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, Consultation, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, du, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, avec courrier, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, du, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553),  ) AS COL_E572C8FC_38F4_4E37_B24F_C8858B1FFF5E#582406, str_join(array(Consultation antèrieure :, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, le, date_time_to_str(COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, dd/MM/yyyy HH:mm:ss, Europe/Paris, fr_FR), il y a, bigint_to_str(COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L), mois, pour spécialité, COL_0323952F_EE16_429A_A587_A09931AF787B#581637), ) AS COL_86719F90_F628_486E_A5FB_D9757B38CEC8#582429]
Input [23]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024, NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#582049, NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#582050, NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#582051, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052]

(48) Project [codegen id : 15]
Output [24]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, date_to_strz(COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#582586, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, date_to_str(COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, YYYY-MM-DD HH:mm:ss) AS COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#582589, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024, COL_BBBCD253_8FF2_4500_A5AC_96CBD8816359#582383, COL_8DB232C4_F229_4420_943D_2571B9A2FBC2#582384, COL_E572C8FC_38F4_4E37_B24F_C8858B1FFF5E#582406, COL_86719F90_F628_486E_A5FB_D9757B38CEC8#582429, str_join(array(COL_E572C8FC_38F4_4E37_B24F_C8858B1FFF5E#582406, COL_86719F90_F628_486E_A5FB_D9757B38CEC8#582429),  >> ) AS COL_3710ED59_E795_4C6B_B149_9C359E93ABDF#582597]
Input [23]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024, COL_BBBCD253_8FF2_4500_A5AC_96CBD8816359#582383, COL_8DB232C4_F229_4420_943D_2571B9A2FBC2#582384, COL_E572C8FC_38F4_4E37_B24F_C8858B1FFF5E#582406, COL_86719F90_F628_486E_A5FB_D9757B38CEC8#582429]

(49) CollectLimit
Input [24]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#582586, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#582589, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024, COL_BBBCD253_8FF2_4500_A5AC_96CBD8816359#582383, COL_8DB232C4_F229_4420_943D_2571B9A2FBC2#582384, COL_E572C8FC_38F4_4E37_B24F_C8858B1FFF5E#582406, COL_86719F90_F628_486E_A5FB_D9757B38CEC8#582429, COL_3710ED59_E795_4C6B_B149_9C359E93ABDF#582597]
Arguments: 1500

(50) Project
Output [7]: [ipp#581077 AS COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, iep#581078 AS COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, code_acte#581079 AS COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, code_spe#581080 AS COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, date_acte#581081 AS COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, date_naissance#581082 AS COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, parcours#581083 AS COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384]
Input [7]: [ipp#581077, iep#581078, code_acte#581079, code_spe#581080, date_acte#581081, date_naissance#581082, parcours#581083]

(51) Exchange
Input [7]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384]
Arguments: hashpartitioning(COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, 10), ENSURE_REQUIREMENTS, [plan_id=388823]

(52) Sort
Input [7]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384]
Arguments: [COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379 ASC NULLS FIRST, COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378 ASC NULLS FIRST], false, 0

(53) Filter
Input [7]: [ipp#580996, iep#580997, auteur#580998, type_courrier#580999, code_spe_courrier#581000, statut#581001, date_courrier#581002]
Condition : (isnotnull(iep#580997) AND isnotnull(ipp#580996))

(54) Project
Output [7]: [auteur#580998 AS COURRIERS_FICTI_227799__AUTEUR#581399, code_spe_courrier#581000 AS COURRIERS_FICTI_227799__CODE_SPE_COURRIER#581400, date_courrier#581002 AS COURRIERS_FICTI_227799__DATE_COURRIER#581401, iep#580997 AS COURRIERS_FICTI_227799__IEP#581402, ipp#580996 AS COURRIERS_FICTI_227799__IPP#581403, statut#581001 AS COURRIERS_FICTI_227799__STATUT#581404, type_courrier#580999 AS COURRIERS_FICTI_227799__TYPE_COURRIER#581405]
Input [7]: [ipp#580996, iep#580997, auteur#580998, type_courrier#580999, code_spe_courrier#581000, statut#581001, date_courrier#581002]

(55) Exchange
Input [7]: [COURRIERS_FICTI_227799__AUTEUR#581399, COURRIERS_FICTI_227799__CODE_SPE_COURRIER#581400, COURRIERS_FICTI_227799__DATE_COURRIER#581401, COURRIERS_FICTI_227799__IEP#581402, COURRIERS_FICTI_227799__IPP#581403, COURRIERS_FICTI_227799__STATUT#581404, COURRIERS_FICTI_227799__TYPE_COURRIER#581405]
Arguments: hashpartitioning(COURRIERS_FICTI_227799__IEP#581402, COURRIERS_FICTI_227799__IPP#581403, 10), ENSURE_REQUIREMENTS, [plan_id=388824]

(56) Sort
Input [7]: [COURRIERS_FICTI_227799__AUTEUR#581399, COURRIERS_FICTI_227799__CODE_SPE_COURRIER#581400, COURRIERS_FICTI_227799__DATE_COURRIER#581401, COURRIERS_FICTI_227799__IEP#581402, COURRIERS_FICTI_227799__IPP#581403, COURRIERS_FICTI_227799__STATUT#581404, COURRIERS_FICTI_227799__TYPE_COURRIER#581405]
Arguments: [COURRIERS_FICTI_227799__IEP#581402 ASC NULLS FIRST, COURRIERS_FICTI_227799__IPP#581403 ASC NULLS FIRST], false, 0

(57) SortMergeJoin
Left keys [2]: [COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378]
Right keys [2]: [COURRIERS_FICTI_227799__IEP#581402, COURRIERS_FICTI_227799__IPP#581403]
Join type: LeftOuter
Join condition: None

(58) Project
Output [13]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COURRIERS_FICTI_227799__AUTEUR#581399 AS COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COURRIERS_FICTI_227799__TYPE_COURRIER#581405 AS COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COURRIERS_FICTI_227799__CODE_SPE_COURRIER#581400 AS COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COURRIERS_FICTI_227799__STATUT#581404 AS COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COURRIERS_FICTI_227799__DATE_COURRIER#581401 AS COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, str_to_datez(str_extract(COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, LEFT, 10), dd/MM/yyyy, Europe/Paris, fr_FR) AS COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558]
Input [14]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COURRIERS_FICTI_227799__AUTEUR#581399, COURRIERS_FICTI_227799__CODE_SPE_COURRIER#581400, COURRIERS_FICTI_227799__DATE_COURRIER#581401, COURRIERS_FICTI_227799__IEP#581402, COURRIERS_FICTI_227799__IPP#581403, COURRIERS_FICTI_227799__STATUT#581404, COURRIERS_FICTI_227799__TYPE_COURRIER#581405]

(59) Exchange
Input [13]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558]
Arguments: hashpartitioning(COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, 10), ENSURE_REQUIREMENTS, [plan_id=388830]

(60) Sort
Input [13]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558]
Arguments: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378 ASC NULLS FIRST, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381 ASC NULLS FIRST, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 ASC NULLS LAST], false, 0

(61) Window
Input [13]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558]
Arguments: [lag(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, -1, null) windowspecdefinition(COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 ASC NULLS LAST, specifiedwindowframe(RowFrame, -1, -1)) AS COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, lag(COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, -1, null) windowspecdefinition(COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 ASC NULLS LAST, specifiedwindowframe(RowFrame, -1, -1)) AS COL_0323952F_EE16_429A_A587_A09931AF787B#581637, lag(COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, -1, null) windowspecdefinition(COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 ASC NULLS LAST, specifiedwindowframe(RowFrame, -1, -1)) AS COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688], [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381], [COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 ASC NULLS LAST]

(62) Project
Output [17]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, date_diff(MONTH, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688) AS COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L]
Input [16]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688]

(63) Project
Output [18]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, str_remove_space(str_if_with_rule((((CASE WHEN isnull(COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L) THEN false ELSE (COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L > 4) END AND CASE WHEN isnull(StartsWith(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, CS)) THEN false ELSE StartsWith(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, CS) END) AND (COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556 <=> Validé)) AND (COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384 <=> O)), str_join(array(APC, str_if_with_rule((CASE WHEN isnull(Contains(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, F)) THEN false ELSE Contains(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, F) END OR CASE WHEN isnull(Contains(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, N)) THEN false ELSE Contains(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, N) END), str_extract(str_remove_space(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, ONLY_ONE), RIGHT, 1), )),  ), null), ONLY_ONE) AS COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944]
Input [17]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L]

(64) Exchange
Input [18]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944]
Arguments: hashpartitioning(COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, 10), ENSURE_REQUIREMENTS, [plan_id=388839]

(65) Sort
Input [18]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944]
Arguments: [COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380 ASC NULLS FIRST], false, 0

(66) Filter
Input [4]: [Code+Acte#581141, Montant#581142, Date_effet#581144, Date_r%C3%A9vocation#581145]
Condition : ((isnotnull(Code+Acte#581141) AND isnotnull(str_to_datez(Date_effet#581144, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#581145, dd/MM/yyyy, Europe/Paris, fr_FR)))

(67) Project
Output [4]: [Code+Acte#581141 AS NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968, str_to_datez(Date_effet#581144, dd/MM/yyyy, Europe/Paris, fr_FR) AS NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#581969, str_to_datez(Date_r%C3%A9vocation#581145, dd/MM/yyyy, Europe/Paris, fr_FR) AS NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#581970, str_to_dec(str_replace(Montant#581142, ., ,), ##,##) AS NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#581971]
Input [4]: [Code+Acte#581141, Montant#581142, Date_effet#581144, Date_r%C3%A9vocation#581145]

(68) Exchange
Input [4]: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968, NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#581969, NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#581970, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#581971]
Arguments: hashpartitioning(NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968, 10), ENSURE_REQUIREMENTS, [plan_id=388840]

(69) Sort
Input [4]: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968, NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#581969, NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#581970, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#581971]
Arguments: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968 ASC NULLS FIRST], false, 0

(70) SortMergeJoin
Left keys [1]: [COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380]
Right keys [1]: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968]
Join type: LeftOuter
Join condition: ((COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 >= NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#581969) AND (COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 <= NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#581970))

(71) Project
Output [19]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#581971 AS COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024]
Input [22]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#581968, NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#581969, NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#581970, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#581971]

(72) Exchange
Input [19]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024]
Arguments: hashpartitioning(COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, 10), ENSURE_REQUIREMENTS, [plan_id=388849]

(73) Sort
Input [19]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024]
Arguments: [COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944 ASC NULLS FIRST], false, 0

(74) Scan parquet 
Output [4]: [Code+Acte#582059, Montant#582060, Date_effet#582062, Date_r%C3%A9vocation#582063]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/B327EFC6_2C56_4F02_941C_F0209F65C43D_f96390024f47ad1fd8d43d92a6c7a982/Region-PUBMET_tarifs_forfait_urgences_(1).xlsx_9f5cc06a8bb7ca4fd2c05636743786ea]
PushedFilters: [IsNotNull(`Code+Acte`)]
ReadSchema: struct<Code+Acte:string,Montant:string,Date_effet:string,Date_r%C3%A9vocation:string>

(75) Filter
Input [4]: [Code+Acte#582059, Montant#582060, Date_effet#582062, Date_r%C3%A9vocation#582063]
Condition : ((isnotnull(Code+Acte#582059) AND isnotnull(str_to_datez(Date_effet#582062, dd/MM/yyyy, Europe/Paris, fr_FR))) AND isnotnull(str_to_datez(Date_r%C3%A9vocation#582063, dd/MM/yyyy, Europe/Paris, fr_FR)))

(76) Project
Output [4]: [Code+Acte#582059 AS NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#582049, str_to_datez(Date_effet#582062, dd/MM/yyyy, Europe/Paris, fr_FR) AS NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#582050, str_to_datez(Date_r%C3%A9vocation#582063, dd/MM/yyyy, Europe/Paris, fr_FR) AS NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#582051, str_to_dec(str_replace(Montant#582060, ., ,), ##,##) AS NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052]
Input [4]: [Code+Acte#582059, Montant#582060, Date_effet#582062, Date_r%C3%A9vocation#582063]

(77) Exchange
Input [4]: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#582049, NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#582050, NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#582051, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052]
Arguments: hashpartitioning(NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#582049, 10), ENSURE_REQUIREMENTS, [plan_id=388850]

(78) Sort
Input [4]: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#582049, NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#582050, NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#582051, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052]
Arguments: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#582049 ASC NULLS FIRST], false, 0

(79) SortMergeJoin
Left keys [1]: [COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944]
Right keys [1]: [NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#582049]
Join type: LeftOuter
Join condition: ((COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 >= NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#582050) AND (COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558 <= NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#582051))

(80) Filter
Input [23]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024, NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#582049, NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#582050, NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#582051, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052]
Condition : CASE WHEN isnull(dec_if_with_rule((isnotnull(COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024) AND isnotnull(NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052)), dec_diff(array(NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024)), null)) THEN false ELSE (dec_if_with_rule((isnotnull(COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024) AND isnotnull(NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052)), dec_diff(array(NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024)), null) > 0.0) END

(81) Project
Output [23]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052 AS COL_BBBCD253_8FF2_4500_A5AC_96CBD8816359#582383, dec_if_with_rule((isnotnull(COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024) AND isnotnull(NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052)), dec_diff(array(NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024)), null) AS COL_8DB232C4_F229_4420_943D_2571B9A2FBC2#582384, str_join(array(str_join(array(Dossier :, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, IPP :, COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, Eligibilité :),  ), COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, Spécialité :, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, Consultation, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, du, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, avec courrier, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, du, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553),  ) AS COL_E572C8FC_38F4_4E37_B24F_C8858B1FFF5E#582406, str_join(array(Consultation antèrieure :, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, le, date_time_to_str(COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, dd/MM/yyyy HH:mm:ss, Europe/Paris, fr_FR), il y a, bigint_to_str(COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L), mois, pour spécialité, COL_0323952F_EE16_429A_A587_A09931AF787B#581637), ) AS COL_86719F90_F628_486E_A5FB_D9757B38CEC8#582429]
Input [23]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024, NOMENCLATURE_TA_227815_COL_379E97DF_7BAF_440C_9E4E_8591EBA1ADA2#582049, NOMENCLATURE_TA_227815_COL_42E31ADD_0D58_4C3A_A5D1_F603C65BA0D5#582050, NOMENCLATURE_TA_227815_COL_F1B40FAE_6290_4F90_AC6C_391899A88964#582051, NOMENCLATURE_TA_227815_COL_7366AAC2_10DF_4BC5_91D6_AB7C50D5C1CA#582052]

(82) Project
Output [24]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, date_to_strz(COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#582586, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, date_to_str(COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, YYYY-MM-DD HH:mm:ss) AS COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#582589, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024, COL_BBBCD253_8FF2_4500_A5AC_96CBD8816359#582383, COL_8DB232C4_F229_4420_943D_2571B9A2FBC2#582384, COL_E572C8FC_38F4_4E37_B24F_C8858B1FFF5E#582406, COL_86719F90_F628_486E_A5FB_D9757B38CEC8#582429, str_join(array(COL_E572C8FC_38F4_4E37_B24F_C8858B1FFF5E#582406, COL_86719F90_F628_486E_A5FB_D9757B38CEC8#582429),  >> ) AS COL_3710ED59_E795_4C6B_B149_9C359E93ABDF#582597]
Input [23]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#581558, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#581688, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024, COL_BBBCD253_8FF2_4500_A5AC_96CBD8816359#582383, COL_8DB232C4_F229_4420_943D_2571B9A2FBC2#582384, COL_E572C8FC_38F4_4E37_B24F_C8858B1FFF5E#582406, COL_86719F90_F628_486E_A5FB_D9757B38CEC8#582429]

(83) CollectLimit
Input [24]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#582586, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#582589, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024, COL_BBBCD253_8FF2_4500_A5AC_96CBD8816359#582383, COL_8DB232C4_F229_4420_943D_2571B9A2FBC2#582384, COL_E572C8FC_38F4_4E37_B24F_C8858B1FFF5E#582406, COL_86719F90_F628_486E_A5FB_D9757B38CEC8#582429, COL_3710ED59_E795_4C6B_B149_9C359E93ABDF#582597]
Arguments: 1500

(84) AdaptiveSparkPlan
Output [24]: [COL_2481D273_01EA_466C_9500_8360E19AF4FD#581378, COL_5106492B_ACCD_4032_975C_75C2C163EB89#581379, COL_21AE0C8E_7400_4993_B2CD_7B7B8C67B612#581380, COL_C9F5BDA0_9F74_44BD_BE59_2124B410F046#581381, COL_4051F7FE_E7A4_46BB_8324_4110A7514371#581382, COL_B3E86325_981E_4FF7_83F3_582CE95DB573#581383, COL_F7466482_6DC2_4D42_A655_77F8A0264B5C#581384, COL_A0AE0A59_A738_4F8F_B8C0_3013DDB3CA97#581553, COL_ACCEEC40_A413_4F60_8F87_8BCA675EBEE5#581554, COL_8B373A7D_70A1_4ECC_81F7_B07F335267A4#581555, COL_A5D72A2E_03D4_4B92_85C7_7B3DEF22F898#581556, COL_32A747A2_F068_4034_8CD3_CE6A7C4224F4#581557, COL_60FF8B14_AF9B_46D7_8AC7_A4E57CB7EED6#582586, COL_37C96ACF_5B7C_457F_956F_8E14FF88A5F0#581589, COL_0323952F_EE16_429A_A587_A09931AF787B#581637, COL_A3830018_3F65_4ECA_87D2_DD2D5CB92DD9#582589, COL_31435B2E_C261_4915_84A4_88A1109C6780#581854L, COL_71F90B4F_4662_47F8_8CDC_8D340D91929E#581944, COL_F77763CC_DEA5_48B6_90BB_79BC33B0354C#582024, COL_BBBCD253_8FF2_4500_A5AC_96CBD8816359#582383, COL_8DB232C4_F229_4420_943D_2571B9A2FBC2#582384, COL_E572C8FC_38F4_4E37_B24F_C8858B1FFF5E#582406, COL_86719F90_F628_486E_A5FB_D9757B38CEC8#582429, COL_3710ED59_E795_4C6B_B149_9C359E93ABDF#582597]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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