SP1 - Details for Query 3440

Submitted Time: 2026/06/12 05:57:26
Duration: 0.6 s
Succeeded Jobs: 5337 5338 5339 5340

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 (10)\n \nduration: 0 ms"; 2 [labelType="html" label=" Project "]; } 3 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 27 ms"; 5 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 6 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 36 ms"; 8 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 9 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 228.0 B number of coalesced partitions: 1"]; 10 [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: 210.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: 192.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: 210.0 B"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 4 ms"; 12 [labelType="html" label=" Project "]; 13 [labelType="html" label="Generate number of output rows: 1"]; 14 [labelType="html" label=" Project "]; } 15 [labelType="html" label="CartesianProduct number of output rows: 1"]; subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 39 ms"; 17 [labelType="html" label=" Project "]; 18 [labelType="html" label="SortMergeJoin number of output rows: 1 spill size: 0.0 B"]; } subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 60 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: 156.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: 120.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: 156.0 B"]; subgraph cluster23 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n1.1 s (36 ms, 120 ms, 129 ms (stage 12379.0: task 12896))"; 24 [labelType="html" label=" Project "]; 25 [labelType="html" label="Filter number of output rows: 1"]; } 26 [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 cluster27 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; 28 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 29 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 223.0 B number of coalesced partitions: 1"]; 30 [labelType="html" label="Exchange shuffle records written: 2 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: 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 cluster31 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 3 ms"; 32 [labelType="html" label=" Project "]; 33 [labelType="html" label="Filter number of output rows: 2"]; 34 [labelType="html" label="ColumnarToRow number of output rows: 13 number of input batches: 1"]; } 35 [labelType="html" label="Scan parquet number of files read: 1 scan time: 2 ms metadata time: 0 ms size of files read: 2.5 KiB number of output rows: 13"]; subgraph cluster36 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 5 ms"; 37 [labelType="html" label=" Project "]; 38 [labelType="html" label="Filter number of output rows: 1"]; } 39 [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"]; 2->0; 3->2; 5->3; 6->5; 8->6; 9->8; 10->9; 12->10; 13->12; 14->13; 15->14; 17->15; 18->17; 20->18; 21->20; 22->21; 24->22; 25->24; 26->25; 28->18; 29->28; 30->29; 32->30; 33->32; 34->33; 35->34; 37->15; 38->37; 39->38; }

AdaptiveSparkPlan isFinalPlan=true

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1080166, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1080249]

WholeStageCodegen (10)

Window [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1080166], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073 ASC NULLS LAST]

Sort [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073 ASC NULLS LAST], false, 0

WholeStageCodegen (9)

Window [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1080249], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073 ASC NULLS LAST]

Sort [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073 ASC NULLS LAST], false, 0

WholeStageCodegen (8)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, 10), ENSURE_REQUIREMENTS, [plan_id=653295]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140]

Generate explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#1080064), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976 AS COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1079973 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, str_split(LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#1080064, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073]

WholeStageCodegen (7)

CartesianProduct

SortMergeJoin [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923], [LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1079975], Inner

WholeStageCodegen (5)

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

WholeStageCodegen (3)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, 10), ENSURE_REQUIREMENTS, [plan_id=653091]

Project [Numéro Séjour#1079222 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, Code Acte#1079223 AS COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, Type acte#1079224 AS COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, Date soins#1079225 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1079226, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923]

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

WholeStageCodegen (1)

FileScan csv [Numéro Séjour#1079222,Code Acte#1079223,Type acte#1079224,Date soins#1079225,Spécialité exécutant#1079226] Batched: false, DataFilters: [(Numéro Séjour#1079222 <=> 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,Code Acte:string,Type acte:string,Date soins:string,Spécialité exécut...

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

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1079975, 10), ENSURE_REQUIREMENTS, [plan_id=653111]

Project [Codes+officiels#1079822 AS LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1079973, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1079820, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1079975, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1079823 AS LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976]

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

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [Sp%C3%A9cialit%C3%A9+etab#1079820,Codes+officiels#1079822,Sp%C3%A9cialit%C3%A9+urgentiste+UF#1079823] Batched: true, DataFilters: [isnotnull(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1079823), 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#1079790) AND (RC-SUN-AUTO = REGLES#1079790)) AND (APPLICABLE#1079791 <=> O))

WholeStageCodegen (6)

FileScan csv [REGLES#1079790,APPLICABLE#1079791] Batched: false, DataFilters: [isnotnull(REGLES#1079790), (RC-SUN-AUTO = REGLES#1079790), (APPLICABLE#1079791 <=> 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>

Details

== Physical Plan ==
AdaptiveSparkPlan (56)
+- == Final Plan ==
   * Project (32)
   +- Window (31)
      +- * Sort (30)
         +- Window (29)
            +- * Sort (28)
               +- AQEShuffleRead (27)
                  +- ShuffleQueryStage (26), Statistics(sizeInBytes=192.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=120.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)
+- == Initial Plan ==
   CollectLimit (55)
   +- Project (54)
      +- Window (53)
         +- Sort (52)
            +- Window (51)
               +- Sort (50)
                  +- Exchange (49)
                     +- Project (48)
                        +- Generate (47)
                           +- Project (46)
                              +- CartesianProduct Inner (45)
                                 :- Project (42)
                                 :  +- SortMergeJoin Inner (41)
                                 :     :- Sort (36)
                                 :     :  +- Exchange (35)
                                 :     :     +- Project (34)
                                 :     :        +- Filter (33)
                                 :     :           +- Scan csv  (1)
                                 :     +- Sort (40)
                                 :        +- Exchange (39)
                                 :           +- Project (38)
                                 :              +- Filter (37)
                                 :                 +- Scan parquet  (8)
                                 +- Project (44)
                                    +- Filter (43)
                                       +- Scan csv  (18)


(1) Scan csv 
Output [5]: [Numéro Séjour#1079222, Code Acte#1079223, Type acte#1079224, Date soins#1079225, Spécialité exécutant#1079226]
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,Code Acte:string,Type acte:string,Date soins:string,Spécialité exécutant:string>

(2) Filter [codegen id : 1]
Input [5]: [Numéro Séjour#1079222, Code Acte#1079223, Type acte#1079224, Date soins#1079225, Spécialité exécutant#1079226]
Condition : ((Numéro Séjour#1079222 <=> 011038404) AND isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1079226, ONLY_ONE), [ ], [-])), UPPER)))

(3) Project [codegen id : 1]
Output [5]: [Numéro Séjour#1079222 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, Code Acte#1079223 AS COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, Type acte#1079224 AS COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, Date soins#1079225 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1079226, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923]
Input [5]: [Numéro Séjour#1079222, Code Acte#1079223, Type acte#1079224, Date soins#1079225, Spécialité exécutant#1079226]

(4) Exchange
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923]
Arguments: hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, 10), ENSURE_REQUIREMENTS, [plan_id=653091]

(5) ShuffleQueryStage
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923]
Arguments: 0

(6) AQEShuffleRead
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923]
Arguments: coalesced

(7) Sort [codegen id : 3]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923]
Arguments: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923 ASC NULLS FIRST], false, 0

(8) Scan parquet 
Output [3]: [Sp%C3%A9cialit%C3%A9+etab#1079820, Codes+officiels#1079822, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1079823]
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#1079820, Codes+officiels#1079822, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1079823]

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

(11) Project [codegen id : 2]
Output [3]: [Codes+officiels#1079822 AS LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1079973, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1079820, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1079975, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1079823 AS LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976]
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1079820, Codes+officiels#1079822, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1079823]

(12) Exchange
Input [3]: [LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1079973, LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1079975, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976]
Arguments: hashpartitioning(LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1079975, 10), ENSURE_REQUIREMENTS, [plan_id=653111]

(13) ShuffleQueryStage
Output [3]: [LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1079973, LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1079975, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976]
Arguments: 1

(14) AQEShuffleRead
Input [3]: [LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1079973, LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1079975, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976]
Arguments: coalesced

(15) Sort [codegen id : 4]
Input [3]: [LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1079973, LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1079975, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976]
Arguments: [LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1079975 ASC NULLS FIRST], false, 0

(16) SortMergeJoin [codegen id : 5]
Left keys [1]: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923]
Right keys [1]: [LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1079975]
Join type: Inner
Join condition: None

(17) Project [codegen id : 5]
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1079973, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976]
Input [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1079973, LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1079975, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976]

(18) Scan csv 
Output [2]: [REGLES#1079790, APPLICABLE#1079791]
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 : 6]
Input [2]: [REGLES#1079790, APPLICABLE#1079791]
Condition : ((isnotnull(REGLES#1079790) AND (RC-SUN-AUTO = REGLES#1079790)) AND (APPLICABLE#1079791 <=> O))

(20) Project [codegen id : 6]
Output: []
Input [2]: [REGLES#1079790, APPLICABLE#1079791]

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

(22) Project [codegen id : 7]
Output [9]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976 AS COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1079973 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, str_split(LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#1080064, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1079973, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976]

(23) Generate [codegen id : 7]
Input [9]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_9E049AD5_127E_4665_A135_38C7D69F0524#1080064, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073]
Arguments: explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#1080064), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084]

(24) Project [codegen id : 7]
Output [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140]
Input [9]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084]

(25) Exchange
Input [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140]
Arguments: hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, 10), ENSURE_REQUIREMENTS, [plan_id=653295]

(26) ShuffleQueryStage
Output [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140]
Arguments: 2

(27) AQEShuffleRead
Input [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140]
Arguments: coalesced

(28) Sort [codegen id : 8]
Input [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073 ASC NULLS LAST], false, 0

(29) Window
Input [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1080249], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073 ASC NULLS LAST]

(30) Sort [codegen id : 9]
Input [11]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1080249]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073 ASC NULLS LAST], false, 0

(31) Window
Input [11]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1080249]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1080166], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073 ASC NULLS LAST]

(32) Project [codegen id : 10]
Output [12]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1080166, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1080249]
Input [12]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1080249, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1080166]

(33) Filter
Input [5]: [Numéro Séjour#1079222, Code Acte#1079223, Type acte#1079224, Date soins#1079225, Spécialité exécutant#1079226]
Condition : ((Numéro Séjour#1079222 <=> 011038404) AND isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1079226, ONLY_ONE), [ ], [-])), UPPER)))

(34) Project
Output [5]: [Numéro Séjour#1079222 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, Code Acte#1079223 AS COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, Type acte#1079224 AS COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, Date soins#1079225 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1079226, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923]
Input [5]: [Numéro Séjour#1079222, Code Acte#1079223, Type acte#1079224, Date soins#1079225, Spécialité exécutant#1079226]

(35) Exchange
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923]
Arguments: hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, 10), ENSURE_REQUIREMENTS, [plan_id=653033]

(36) Sort
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923]
Arguments: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923 ASC NULLS FIRST], false, 0

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

(38) Project
Output [3]: [Codes+officiels#1079822 AS LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1079973, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1079820, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1079975, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1079823 AS LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976]
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1079820, Codes+officiels#1079822, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1079823]

(39) Exchange
Input [3]: [LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1079973, LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1079975, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976]
Arguments: hashpartitioning(LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1079975, 10), ENSURE_REQUIREMENTS, [plan_id=653034]

(40) Sort
Input [3]: [LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1079973, LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1079975, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976]
Arguments: [LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1079975 ASC NULLS FIRST], false, 0

(41) SortMergeJoin
Left keys [1]: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923]
Right keys [1]: [LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1079975]
Join type: Inner
Join condition: None

(42) Project
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1079973, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976]
Input [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1079973, LISTE_UF_SUN_SU_210126_SPECIALITE_ETAB_210127#1079975, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976]

(43) Filter
Input [2]: [REGLES#1079790, APPLICABLE#1079791]
Condition : ((isnotnull(REGLES#1079790) AND (RC-SUN-AUTO = REGLES#1079790)) AND (APPLICABLE#1079791 <=> O))

(44) Project
Output: []
Input [2]: [REGLES#1079790, APPLICABLE#1079791]

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

(46) Project
Output [9]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976 AS COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1079973 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, str_split(LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#1080064, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, LISTE_UF_SUN_SU_210126_CODES_OFFICIELS_210129#1079973, LISTE_UF_SUN_SU_210126_SPECIALITE_URGE_210130#1079976]

(47) Generate
Input [9]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_9E049AD5_127E_4665_A135_38C7D69F0524#1080064, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073]
Arguments: explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#1080064), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084]

(48) Project
Output [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140]
Input [9]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084]

(49) Exchange
Input [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140]
Arguments: hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, 10), ENSURE_REQUIREMENTS, [plan_id=653044]

(50) Sort
Input [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073 ASC NULLS LAST], false, 0

(51) Window
Input [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1080249], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073 ASC NULLS LAST]

(52) Sort
Input [11]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1080249]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073 ASC NULLS LAST], false, 0

(53) Window
Input [11]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1080249]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1080166], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073 ASC NULLS LAST]

(54) Project
Output [12]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1080166, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1080249]
Input [12]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1080249, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1080166]

(55) CollectLimit
Input [12]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1080166, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1080249]
Arguments: 1500

(56) AdaptiveSparkPlan
Output [12]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1079919, COL_FEF7E184_5FCB_4D58_ACB5_33150F5EB7E2#1079920, COL_30A05D41_D581_4DD1_9C7D_E35CE934FD67#1079921, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1079922, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1079923, COL_C9636726_7D05_4C83_BC42_83726B5CB51B#1080055, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1080056, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1080084, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1080073, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1080140, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1080166, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1080249]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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