SP1 - Details for Query 3428

Submitted Time: 2026/06/12 05:57:07
Duration: 0.7 s
Succeeded Jobs: 5321 5322 5323 5324 5325 5326

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (16)\n \nduration: 2 ms"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="SortMergeJoin number of output rows: 1 spill size: 0.0 B"]; } subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (14)\n \nduration: 61 ms"; 6 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 7 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 171.0 B number of coalesced partitions: 1"]; 8 [labelType="html" label="Exchange shuffle records written: 1 local merged chunks fetched: 0 shuffle write time: 0 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: 1 local bytes read: 166.0 B 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: 144.0 B local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 166.0 B"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (13)\n \nduration: 16 ms"; 10 [labelType="html" label=" Project "]; } 11 [labelType="html" label="CartesianProduct number of output rows: 1"]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: 29 ms"; 13 [labelType="html" label=" Project "]; 14 [labelType="html" label="Filter number of output rows: 1"]; } 15 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 62 ms"; 17 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 18 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 32 ms"; 20 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 21 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 156.0 B number of coalesced partitions: 1"]; 22 [labelType="html" label="Exchange shuffle records written: 1 local merged chunks fetched: 0 shuffle write time: 0 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: 1 local bytes read: 144.0 B 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: 104.0 B local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 144.0 B"]; subgraph cluster23 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 1 ms"; 24 [labelType="html" label=" Project "]; 25 [labelType="html" label="Generate number of output rows: 1"]; 26 [labelType="html" label=" Project "]; } 27 [labelType="html" label="CartesianProduct number of output rows: 1"]; subgraph cluster28 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 13 ms"; 29 [labelType="html" label=" Project "]; 30 [labelType="html" label="SortMergeJoin number of output rows: 1 spill size: 0.0 B"]; } subgraph cluster31 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 15 ms"; 32 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 33 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 142.0 B number of coalesced partitions: 1"]; 34 [labelType="html" label="Exchange shuffle records written: 1 local merged chunks fetched: 0 shuffle write time: 0 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: 1 local bytes read: 136.0 B 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: 96.0 B local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 136.0 B"]; subgraph cluster35 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n898 ms (10 ms, 97 ms, 113 ms (stage 12348.0: task 12861))"; 36 [labelType="html" label=" Project "]; 37 [labelType="html" label="Filter number of output rows: 1"]; } 38 [labelType="html" label="Scan csv number of output rows: 1 number of files read: 1 metadata time: 0 ms size of files read: 36.3 MiB"]; subgraph cluster39 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; 40 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 41 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 223.0 B number of coalesced partitions: 1"]; 42 [labelType="html" label="Exchange shuffle records written: 2 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: 2 local bytes read: 213.0 B 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: 136.0 B local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 213.0 B"]; subgraph cluster43 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 7 ms"; 44 [labelType="html" label=" Project "]; 45 [labelType="html" label="Filter number of output rows: 2"]; 46 [labelType="html" label="ColumnarToRow number of output rows: 13 number of input batches: 1"]; } 47 [labelType="html" label="Scan parquet number of files read: 1 scan time: 4 ms metadata time: 0 ms size of files read: 2.5 KiB number of output rows: 13"]; subgraph cluster48 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 3 ms"; 49 [labelType="html" label=" Project "]; 50 [labelType="html" label="Filter number of output rows: 1"]; } 51 [labelType="html" label="Scan csv number of output rows: 1 number of files read: 1 metadata time: 0 ms size of files read: 174.0 B"]; subgraph cluster52 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: 2 ms"; 53 [labelType="html" label=" Project "]; 54 [labelType="html" label="ColumnarToRow number of output rows: 1 number of input batches: 1"]; } 55 [labelType="html" label="Scan parquet number of files read: 1 scan time: 1 ms metadata time: 0 ms size of files read: 2044.0 B number of output rows: 1"]; subgraph cluster56 { isCluster="true"; label="WholeStageCodegen (15)\n \nduration: 0 ms"; 57 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 58 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 2.4 KiB number of coalesced partitions: 1"]; 59 [labelType="html" label="Exchange shuffle records written: 52 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: 52 local bytes read: 2.3 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: 3.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: 2.3 KiB"]; subgraph cluster60 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 6 ms"; 61 [labelType="html" label=" Project "]; 62 [labelType="html" label="Filter number of output rows: 52"]; } 63 [labelType="html" label="Scan csv number of output rows: 52 number of files read: 1 metadata time: 0 ms size of files read: 2.3 KiB"]; 2->0; 3->2; 4->3; 6->4; 7->6; 8->7; 10->8; 11->10; 13->11; 14->13; 15->14; 17->15; 18->17; 20->18; 21->20; 22->21; 24->22; 25->24; 26->25; 27->26; 29->27; 30->29; 32->30; 33->32; 34->33; 36->34; 37->36; 38->37; 40->30; 41->40; 42->41; 44->42; 45->44; 46->45; 47->46; 49->27; 50->49; 51->50; 53->11; 54->53; 55->54; 57->4; 58->57; 59->58; 61->59; 62->61; 63->62; }

AdaptiveSparkPlan isFinalPlan=true

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, str_if_with_rule((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 < 480) END OR CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 >= 1320) END), str_join(array(SUN, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1078970), !), str_if_with_rule(((((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 >= 480) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 < 1200) END) AND ((str_if_with_rule((isnotnull(COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1078949) AND ((COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1078950 <=> ALL) OR (COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1078991 > 0))), O, N) <=> O) OR (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761 <=> dimanche))) OR ((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 >= 840) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 < 1320) END) AND (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761 <=> samedi))) OR (CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 >= 1200) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 < 1320) END)), str_join(array(SUF, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1078970), !), null)) AS COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1079062, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1078950]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, JOURS_FERIES_ME_210058_NOM_JOUR_FERIE_210062#1078899 AS COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1078949, JOURS_FERIES_ME_210058_DEPARTEMENT_210063#1078898 AS COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1078950, str_join(array(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, 9, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, 6, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, 1, 4)), ) AS COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1078970, size(str_list_intersect_fixed(str_split(JOURS_FERIES_ME_210058_DEPARTEMENT_210063#1078898, ;), array(COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1078874)), true) AS COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1078991]

SortMergeJoin [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763], [JOURS_FERIES_ME_210058_DATE_210059#1078897], LeftOuter

WholeStageCodegen (16)

Sort [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763 ASC NULLS FIRST], false, 0

WholeStageCodegen (14)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763, 10), ENSURE_REQUIREMENTS, [plan_id=652467]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763, 09_INFORMATION__210121_DEPARTEMENTETAB_210125#1078786 AS COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1078874]

WholeStageCodegen (13)

CartesianProduct

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, date_time_to_str(COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, EEEE, Europe/Paris, fr_FR) AS COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, int_sum(array(int_mult(array(str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, 12, 2)), 60)), str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, 15, 2)))) AS COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, str_extract(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, LEFT, 10) AS COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763]

Filter ((COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1078600 <=> 1) AND (COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1078517 <=> 1))

WholeStageCodegen (11)

Window [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1078517], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424 ASC NULLS LAST]

Sort [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424 ASC NULLS LAST], false, 0

WholeStageCodegen (10)

Window [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1078600], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424 ASC NULLS LAST]

Sort [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424 ASC NULLS LAST], false, 0

WholeStageCodegen (9)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, 10), ENSURE_REQUIREMENTS, [plan_id=652312]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1078435), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491]

Generate explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#1078415), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1078435]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1078324 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, str_split(LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1078327, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#1078415, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424]

WholeStageCodegen (8)

CartesianProduct

SortMergeJoin [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274], [LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326], Inner

WholeStageCodegen (6)

Sort [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274 ASC NULLS FIRST], false, 0

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274, 10), ENSURE_REQUIREMENTS, [plan_id=651901]

Project [Numéro Séjour#1076974 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, Date soins#1076977 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1076978, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274]

Filter ((Numéro Séjour#1076974 <=> 011038404) AND isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1076978, ONLY_ONE), [ ], [-])), UPPER)))

WholeStageCodegen (1)

FileScan csv [Numéro Séjour#1076974,Date soins#1076977,Spécialité exécutant#1076978] Batched: false, DataFilters: [(Numéro Séjour#1076974 <=> 011038404), isnotnull(str_transform_case(str_remove_accent(str_replac..., Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/03_ACTES_PATIEN_209974/Horodatage_actes..., PartitionFilters: [], PushedFilters: [EqualNullSafe(Numéro Séjour,011038404)], ReadSchema: struct<Numéro Séjour:string,Date soins:string,Spécialité exécutant:string>

Sort [LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326 ASC NULLS FIRST], false, 0

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326, 10), ENSURE_REQUIREMENTS, [plan_id=651921]

Project [Codes+officiels#1078090 AS LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1078324, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1078088, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091 AS LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1078327]

Filter (((isnotnull(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091) AND isnotnull(str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1078088, ONLY_ONE)), UPPER), [ ], [-]))) AND (size(str_split(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091, ;), true) > 0)) AND isnotnull(str_split(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091, ;)))

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [Sp%C3%A9cialit%C3%A9+etab#1078088,Codes+officiels#1078090,Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091] Batched: true, DataFilters: [isnotnull(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091), isnotnull(str_replace_extend(str_transfor..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/LISTE_UF_SUN_SU_210006_d71b6e1bc19c..., PartitionFilters: [], PushedFilters: [IsNotNull(`Sp%C3%A9cialit%C3%A9+urgentiste+UF`)], ReadSchema: struct<Sp%C3%A9cialit%C3%A9+etab:string,Codes+officiels:string,Sp%C3%A9cialit%C3%A9+urgentiste+UF...

Project

Filter ((isnotnull(REGLES#1077111) AND (RC-SUN-AUTO = REGLES#1077111)) AND (APPLICABLE#1077112 <=> O))

WholeStageCodegen (7)

FileScan csv [REGLES#1077111,APPLICABLE#1077112] Batched: false, DataFilters: [isnotnull(REGLES#1077111), (RC-SUN-AUTO = REGLES#1077111), (APPLICABLE#1077112 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_209983/REGLES-A-TTT new..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SUN-AUTO), EqualNullSafe(APPLICABLE,O)], ReadSchema: struct<REGLES:string,APPLICABLE:string>

Project [str_extract(Finess#1077145, LEFT, 2) AS 09_INFORMATION__210121_DEPARTEMENTETAB_210125#1078786]

ColumnarToRow

WholeStageCodegen (12)

FileScan parquet [Finess#1077145] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/09_INFORMATION__209985_16b54f457978..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<Finess:string>

Sort [JOURS_FERIES_ME_210058_DATE_210059#1078897 ASC NULLS FIRST], false, 0

WholeStageCodegen (15)

AQEShuffleRead coalesced

Exchange hashpartitioning(JOURS_FERIES_ME_210058_DATE_210059#1078897, 10), ENSURE_REQUIREMENTS, [plan_id=651961]

Project [date#1078194 AS JOURS_FERIES_ME_210058_DATE_210059#1078897, departement#1078198 AS JOURS_FERIES_ME_210058_DEPARTEMENT_210063#1078898, nom_jour_ferie#1078197 AS JOURS_FERIES_ME_210058_NOM_JOUR_FERIE_210062#1078899]

Filter isnotnull(date#1078194)

WholeStageCodegen (3)

FileScan csv [date#1078194,nom_jour_ferie#1078197,departement#1078198] Batched: false, DataFilters: [isnotnull(date#1078194)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/JOURS_FERIES_ME_209980/jours_feries_met..., PartitionFilters: [], PushedFilters: [IsNotNull(date)], ReadSchema: struct<date:string,nom_jour_ferie:string,departement:string>

Details

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


(1) Scan csv 
Output [3]: [Numéro Séjour#1076974, Date soins#1076977, Spécialité exécutant#1076978]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/03_ACTES_PATIEN_209974/Horodatage_actes_Patient_CHSF_M122025.csv]
PushedFilters: [EqualNullSafe(Numéro Séjour,011038404)]
ReadSchema: struct<Numéro Séjour:string,Date soins:string,Spécialité exécutant:string>

(2) Filter [codegen id : 1]
Input [3]: [Numéro Séjour#1076974, Date soins#1076977, Spécialité exécutant#1076978]
Condition : ((Numéro Séjour#1076974 <=> 011038404) AND isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1076978, ONLY_ONE), [ ], [-])), UPPER)))

(3) Project [codegen id : 1]
Output [3]: [Numéro Séjour#1076974 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, Date soins#1076977 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1076978, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274]
Input [3]: [Numéro Séjour#1076974, Date soins#1076977, Spécialité exécutant#1076978]

(4) Exchange
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274]
Arguments: hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274, 10), ENSURE_REQUIREMENTS, [plan_id=651901]

(5) ShuffleQueryStage
Output [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274]
Arguments: 0

(6) AQEShuffleRead
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274]
Arguments: coalesced

(7) Sort [codegen id : 4]
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274]
Arguments: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274 ASC NULLS FIRST], false, 0

(8) Scan parquet 
Output [3]: [Sp%C3%A9cialit%C3%A9+etab#1078088, Codes+officiels#1078090, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/LISTE_UF_SUN_SU_210006_d71b6e1bc19c35b449324ff5fa82dd29/Info_Etab_init_v1.1 CHSF.xlsx_c4fec235cdf44be0f054527cfa6840ed]
PushedFilters: [IsNotNull(`Sp%C3%A9cialit%C3%A9+urgentiste+UF`)]
ReadSchema: struct<Sp%C3%A9cialit%C3%A9+etab:string,Codes+officiels:string,Sp%C3%A9cialit%C3%A9+urgentiste+UF:string>

(9) ColumnarToRow [codegen id : 2]
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1078088, Codes+officiels#1078090, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091]

(10) Filter [codegen id : 2]
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1078088, Codes+officiels#1078090, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091]
Condition : (((isnotnull(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091) AND isnotnull(str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1078088, ONLY_ONE)), UPPER), [ ], [-]))) AND (size(str_split(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091, ;), true) > 0)) AND isnotnull(str_split(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091, ;)))

(11) Project [codegen id : 2]
Output [3]: [Codes+officiels#1078090 AS LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1078324, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1078088, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091 AS LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1078327]
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1078088, Codes+officiels#1078090, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091]

(12) Exchange
Input [3]: [LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1078324, LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1078327]
Arguments: hashpartitioning(LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326, 10), ENSURE_REQUIREMENTS, [plan_id=651921]

(13) ShuffleQueryStage
Output [3]: [LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1078324, LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1078327]
Arguments: 1

(14) AQEShuffleRead
Input [3]: [LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1078324, LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1078327]
Arguments: coalesced

(15) Sort [codegen id : 5]
Input [3]: [LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1078324, LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1078327]
Arguments: [LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326 ASC NULLS FIRST], false, 0

(16) SortMergeJoin [codegen id : 6]
Left keys [1]: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274]
Right keys [1]: [LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326]
Join type: Inner
Join condition: None

(17) Project [codegen id : 6]
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1078324, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1078327]
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274, LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1078324, LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1078327]

(18) Scan csv 
Output [2]: [REGLES#1077111, APPLICABLE#1077112]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_209983/REGLES-A-TTT new.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SUN-AUTO), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>

(19) Filter [codegen id : 7]
Input [2]: [REGLES#1077111, APPLICABLE#1077112]
Condition : ((isnotnull(REGLES#1077111) AND (RC-SUN-AUTO = REGLES#1077111)) AND (APPLICABLE#1077112 <=> O))

(20) Project [codegen id : 7]
Output: []
Input [2]: [REGLES#1077111, APPLICABLE#1077112]

(21) CartesianProduct
Join type: Inner
Join condition: None

(22) Project [codegen id : 8]
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1078324 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, str_split(LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1078327, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#1078415, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424]
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1078324, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1078327]

(23) Generate [codegen id : 8]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_9E049AD5_127E_4665_A135_38C7D69F0524#1078415, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424]
Arguments: explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#1078415), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1078435]

(24) Project [codegen id : 8]
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1078435), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1078435]

(25) Exchange
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491]
Arguments: hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, 10), ENSURE_REQUIREMENTS, [plan_id=652312]

(26) ShuffleQueryStage
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491]
Arguments: 3

(27) AQEShuffleRead
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491]
Arguments: coalesced

(28) Sort [codegen id : 9]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424 ASC NULLS LAST], false, 0

(29) Window
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1078600], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424 ASC NULLS LAST]

(30) Sort [codegen id : 10]
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1078600]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424 ASC NULLS LAST], false, 0

(31) Window
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1078600]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1078517], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424 ASC NULLS LAST]

(32) Filter [codegen id : 11]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1078600, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1078517]
Condition : ((COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1078600 <=> 1) AND (COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1078517 <=> 1))

(33) Project [codegen id : 11]
Output [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, date_time_to_str(COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, EEEE, Europe/Paris, fr_FR) AS COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, int_sum(array(int_mult(array(str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, 12, 2)), 60)), str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, 15, 2)))) AS COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, str_extract(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, LEFT, 10) AS COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1078600, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1078517]

(34) Scan parquet 
Output [1]: [Finess#1077145]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/09_INFORMATION__209985_16b54f45797834c8181d09b272ecbea3/Info_Etab_init_v1.1 CHSF.xlsx_1ab25517c9bbf37714f2739a531aa141]
ReadSchema: struct<Finess:string>

(35) ColumnarToRow [codegen id : 12]
Input [1]: [Finess#1077145]

(36) Project [codegen id : 12]
Output [1]: [str_extract(Finess#1077145, LEFT, 2) AS 09_INFORMATION__210121_DEPARTEMENTETAB_210125#1078786]
Input [1]: [Finess#1077145]

(37) CartesianProduct
Join type: Inner
Join condition: None

(38) Project [codegen id : 13]
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763, 09_INFORMATION__210121_DEPARTEMENTETAB_210125#1078786 AS COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1078874]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763, 09_INFORMATION__210121_DEPARTEMENTETAB_210125#1078786]

(39) Exchange
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1078874]
Arguments: hashpartitioning(COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763, 10), ENSURE_REQUIREMENTS, [plan_id=652467]

(40) ShuffleQueryStage
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1078874]
Arguments: 4

(41) AQEShuffleRead
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1078874]
Arguments: coalesced

(42) Sort [codegen id : 14]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1078874]
Arguments: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763 ASC NULLS FIRST], false, 0

(43) Scan csv 
Output [3]: [date#1078194, nom_jour_ferie#1078197, departement#1078198]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/JOURS_FERIES_ME_209980/jours_feries_metropole.csv]
PushedFilters: [IsNotNull(date)]
ReadSchema: struct<date:string,nom_jour_ferie:string,departement:string>

(44) Filter [codegen id : 3]
Input [3]: [date#1078194, nom_jour_ferie#1078197, departement#1078198]
Condition : isnotnull(date#1078194)

(45) Project [codegen id : 3]
Output [3]: [date#1078194 AS JOURS_FERIES_ME_210058_DATE_210059#1078897, departement#1078198 AS JOURS_FERIES_ME_210058_DEPARTEMENT_210063#1078898, nom_jour_ferie#1078197 AS JOURS_FERIES_ME_210058_NOM_JOUR_FERIE_210062#1078899]
Input [3]: [date#1078194, nom_jour_ferie#1078197, departement#1078198]

(46) Exchange
Input [3]: [JOURS_FERIES_ME_210058_DATE_210059#1078897, JOURS_FERIES_ME_210058_DEPARTEMENT_210063#1078898, JOURS_FERIES_ME_210058_NOM_JOUR_FERIE_210062#1078899]
Arguments: hashpartitioning(JOURS_FERIES_ME_210058_DATE_210059#1078897, 10), ENSURE_REQUIREMENTS, [plan_id=651961]

(47) ShuffleQueryStage
Output [3]: [JOURS_FERIES_ME_210058_DATE_210059#1078897, JOURS_FERIES_ME_210058_DEPARTEMENT_210063#1078898, JOURS_FERIES_ME_210058_NOM_JOUR_FERIE_210062#1078899]
Arguments: 2

(48) AQEShuffleRead
Input [3]: [JOURS_FERIES_ME_210058_DATE_210059#1078897, JOURS_FERIES_ME_210058_DEPARTEMENT_210063#1078898, JOURS_FERIES_ME_210058_NOM_JOUR_FERIE_210062#1078899]
Arguments: coalesced

(49) Sort [codegen id : 15]
Input [3]: [JOURS_FERIES_ME_210058_DATE_210059#1078897, JOURS_FERIES_ME_210058_DEPARTEMENT_210063#1078898, JOURS_FERIES_ME_210058_NOM_JOUR_FERIE_210062#1078899]
Arguments: [JOURS_FERIES_ME_210058_DATE_210059#1078897 ASC NULLS FIRST], false, 0

(50) SortMergeJoin [codegen id : 16]
Left keys [1]: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763]
Right keys [1]: [JOURS_FERIES_ME_210058_DATE_210059#1078897]
Join type: LeftOuter
Join condition: None

(51) Project [codegen id : 16]
Output [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, JOURS_FERIES_ME_210058_NOM_JOUR_FERIE_210062#1078899 AS COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1078949, JOURS_FERIES_ME_210058_DEPARTEMENT_210063#1078898 AS COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1078950, str_join(array(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, 9, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, 6, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, 1, 4)), ) AS COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1078970, size(str_list_intersect_fixed(str_split(JOURS_FERIES_ME_210058_DEPARTEMENT_210063#1078898, ;), array(COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1078874)), true) AS COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1078991]
Input [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1078874, JOURS_FERIES_ME_210058_DATE_210059#1078897, JOURS_FERIES_ME_210058_DEPARTEMENT_210063#1078898, JOURS_FERIES_ME_210058_NOM_JOUR_FERIE_210062#1078899]

(52) Project [codegen id : 16]
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, str_if_with_rule((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 < 480) END OR CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 >= 1320) END), str_join(array(SUN, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1078970), !), str_if_with_rule(((((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 >= 480) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 < 1200) END) AND ((str_if_with_rule((isnotnull(COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1078949) AND ((COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1078950 <=> ALL) OR (COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1078991 > 0))), O, N) <=> O) OR (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761 <=> dimanche))) OR ((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 >= 840) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 < 1320) END) AND (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761 <=> samedi))) OR (CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 >= 1200) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 < 1320) END)), str_join(array(SUF, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1078970), !), null)) AS COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1079062, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1078950]
Input [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1078949, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1078950, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1078970, COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1078991]

(53) Filter
Input [3]: [Numéro Séjour#1076974, Date soins#1076977, Spécialité exécutant#1076978]
Condition : ((Numéro Séjour#1076974 <=> 011038404) AND isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1076978, ONLY_ONE), [ ], [-])), UPPER)))

(54) Project
Output [3]: [Numéro Séjour#1076974 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, Date soins#1076977 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1076978, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274]
Input [3]: [Numéro Séjour#1076974, Date soins#1076977, Spécialité exécutant#1076978]

(55) Exchange
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274]
Arguments: hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274, 10), ENSURE_REQUIREMENTS, [plan_id=651809]

(56) Sort
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274]
Arguments: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274 ASC NULLS FIRST], false, 0

(57) Filter
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1078088, Codes+officiels#1078090, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091]
Condition : (((isnotnull(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091) AND isnotnull(str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1078088, ONLY_ONE)), UPPER), [ ], [-]))) AND (size(str_split(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091, ;), true) > 0)) AND isnotnull(str_split(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091, ;)))

(58) Project
Output [3]: [Codes+officiels#1078090 AS LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1078324, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1078088, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091 AS LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1078327]
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1078088, Codes+officiels#1078090, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1078091]

(59) Exchange
Input [3]: [LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1078324, LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1078327]
Arguments: hashpartitioning(LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326, 10), ENSURE_REQUIREMENTS, [plan_id=651810]

(60) Sort
Input [3]: [LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1078324, LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1078327]
Arguments: [LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326 ASC NULLS FIRST], false, 0

(61) SortMergeJoin
Left keys [1]: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274]
Right keys [1]: [LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326]
Join type: Inner
Join condition: None

(62) Project
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1078324, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1078327]
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1078274, LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1078324, LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1078326, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1078327]

(63) Filter
Input [2]: [REGLES#1077111, APPLICABLE#1077112]
Condition : ((isnotnull(REGLES#1077111) AND (RC-SUN-AUTO = REGLES#1077111)) AND (APPLICABLE#1077112 <=> O))

(64) Project
Output: []
Input [2]: [REGLES#1077111, APPLICABLE#1077112]

(65) CartesianProduct
Join type: Inner
Join condition: None

(66) Project
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1078324 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, str_split(LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1078327, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#1078415, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424]
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1078324, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1078327]

(67) Generate
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_9E049AD5_127E_4665_A135_38C7D69F0524#1078415, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424]
Arguments: explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#1078415), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1078435]

(68) Project
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1078435), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1078435]

(69) Exchange
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491]
Arguments: hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, 10), ENSURE_REQUIREMENTS, [plan_id=651820]

(70) Sort
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424 ASC NULLS LAST], false, 0

(71) Window
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1078600], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424 ASC NULLS LAST]

(72) Sort
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1078600]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424 ASC NULLS LAST], false, 0

(73) Window
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1078600]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1078517], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424 ASC NULLS LAST]

(74) Filter
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1078600, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1078517]
Condition : ((COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1078600 <=> 1) AND (COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1078517 <=> 1))

(75) Project
Output [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, date_time_to_str(COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, EEEE, Europe/Paris, fr_FR) AS COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, int_sum(array(int_mult(array(str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, 12, 2)), 60)), str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, 15, 2)))) AS COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, str_extract(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, LEFT, 10) AS COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1078424, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1078491, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1078600, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1078517]

(76) Project
Output [1]: [str_extract(Finess#1077145, LEFT, 2) AS 09_INFORMATION__210121_DEPARTEMENTETAB_210125#1078786]
Input [1]: [Finess#1077145]

(77) CartesianProduct
Join type: Inner
Join condition: None

(78) Project
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763, 09_INFORMATION__210121_DEPARTEMENTETAB_210125#1078786 AS COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1078874]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763, 09_INFORMATION__210121_DEPARTEMENTETAB_210125#1078786]

(79) Exchange
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1078874]
Arguments: hashpartitioning(COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763, 10), ENSURE_REQUIREMENTS, [plan_id=651834]

(80) Sort
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1078874]
Arguments: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763 ASC NULLS FIRST], false, 0

(81) Filter
Input [3]: [date#1078194, nom_jour_ferie#1078197, departement#1078198]
Condition : isnotnull(date#1078194)

(82) Project
Output [3]: [date#1078194 AS JOURS_FERIES_ME_210058_DATE_210059#1078897, departement#1078198 AS JOURS_FERIES_ME_210058_DEPARTEMENT_210063#1078898, nom_jour_ferie#1078197 AS JOURS_FERIES_ME_210058_NOM_JOUR_FERIE_210062#1078899]
Input [3]: [date#1078194, nom_jour_ferie#1078197, departement#1078198]

(83) Exchange
Input [3]: [JOURS_FERIES_ME_210058_DATE_210059#1078897, JOURS_FERIES_ME_210058_DEPARTEMENT_210063#1078898, JOURS_FERIES_ME_210058_NOM_JOUR_FERIE_210062#1078899]
Arguments: hashpartitioning(JOURS_FERIES_ME_210058_DATE_210059#1078897, 10), ENSURE_REQUIREMENTS, [plan_id=651835]

(84) Sort
Input [3]: [JOURS_FERIES_ME_210058_DATE_210059#1078897, JOURS_FERIES_ME_210058_DEPARTEMENT_210063#1078898, JOURS_FERIES_ME_210058_NOM_JOUR_FERIE_210062#1078899]
Arguments: [JOURS_FERIES_ME_210058_DATE_210059#1078897 ASC NULLS FIRST], false, 0

(85) SortMergeJoin
Left keys [1]: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763]
Right keys [1]: [JOURS_FERIES_ME_210058_DATE_210059#1078897]
Join type: LeftOuter
Join condition: None

(86) Project
Output [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, JOURS_FERIES_ME_210058_NOM_JOUR_FERIE_210062#1078899 AS COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1078949, JOURS_FERIES_ME_210058_DEPARTEMENT_210063#1078898 AS COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1078950, str_join(array(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, 9, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, 6, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, 1, 4)), ) AS COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1078970, size(str_list_intersect_fixed(str_split(JOURS_FERIES_ME_210058_DEPARTEMENT_210063#1078898, ;), array(COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1078874)), true) AS COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1078991]
Input [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1078273, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1078763, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1078874, JOURS_FERIES_ME_210058_DATE_210059#1078897, JOURS_FERIES_ME_210058_DEPARTEMENT_210063#1078898, JOURS_FERIES_ME_210058_NOM_JOUR_FERIE_210062#1078899]

(87) Project
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, str_if_with_rule((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 < 480) END OR CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 >= 1320) END), str_join(array(SUN, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1078970), !), str_if_with_rule(((((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 >= 480) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 < 1200) END) AND ((str_if_with_rule((isnotnull(COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1078949) AND ((COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1078950 <=> ALL) OR (COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1078991 > 0))), O, N) <=> O) OR (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761 <=> dimanche))) OR ((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 >= 840) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 < 1320) END) AND (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761 <=> samedi))) OR (CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 >= 1200) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762 < 1320) END)), str_join(array(SUF, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1078970), !), null)) AS COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1079062, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1078950]
Input [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1078761, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1078762, COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1078949, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1078950, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1078970, COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1078991]

(88) CollectLimit
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1079062, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1078950]
Arguments: 1500

(89) AdaptiveSparkPlan
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1078270, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1078407, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1079062, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1078950]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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