SP1 - Details for Query 2125

Submitted Time: 2026/09/17 16:11:21
Duration: 0.4 s
Succeeded Jobs: 3046 3047 3049 3053
Show the Stage ID and Task ID that corresponds to the max metric
Details
== Physical Plan ==
AdaptiveSparkPlan (39)
+- == Final Plan ==
   Execute InsertIntoHadoopFsRelationCommand (3)
   +- WriteFiles (2)
      +- LocalTableScan (1)
+- == Initial Plan ==
   Execute InsertIntoHadoopFsRelationCommand (38)
   +- WriteFiles (37)
      +- Project (36)
         +- Project (35)
            +- Project (34)
               +- SortMergeJoin Inner (33)
                  :- Project (25)
                  :  +- SortMergeJoin Inner (24)
                  :     :- Sort (18)
                  :     :  +- Exchange (17)
                  :     :     +- Project (16)
                  :     :        +- CartesianProduct Inner (15)
                  :     :           :- Project (11)
                  :     :           :  +- Filter (10)
                  :     :           :     +- Window (9)
                  :     :           :        +- Sort (8)
                  :     :           :           +- Exchange (7)
                  :     :           :              +- Project (6)
                  :     :           :                 +- Filter (5)
                  :     :           :                    +- Scan csv  (4)
                  :     :           +- Project (14)
                  :     :              +- Filter (13)
                  :     :                 +- Scan csv  (12)
                  :     +- Sort (23)
                  :        +- Exchange (22)
                  :           +- Project (21)
                  :              +- Filter (20)
                  :                 +- Scan parquet  (19)
                  +- Sort (32)
                     +- ObjectHashAggregate (31)
                        +- Exchange (30)
                           +- ObjectHashAggregate (29)
                              +- Project (28)
                                 +- Filter (27)
                                    +- Scan parquet  (26)


(1) LocalTableScan
Output [8]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#526875, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#527153, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#527186, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#526974, COL_EB745243_852A_470C_A1E1_722CE684E626#527348, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#526589, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#527156]
Arguments: <empty>, [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#526875, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#527153, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#527186, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#526974, COL_EB745243_852A_470C_A1E1_722CE684E626#527348, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#526589, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#527156]

(2) WriteFiles
Input [8]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#526875, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#527153, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#527186, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#526974, COL_EB745243_852A_470C_A1E1_722CE684E626#527348, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#526589, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#527156]

(3) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR5_SU2_SU3_226031, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR5_SU2_SU3_226031], Overwrite, [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4, COL_EB745243_852A_470C_A1E1_722CE684E626, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850, COL_EF5B8E51_0EA9_4466_A691_A2B708205606]

(4) Scan csv 
Output [2]: [Numéro Séjour#524603, Niveau CCMU#524608]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/02_PASSAGE_PATI_225508/passage_Patient.csv]
PushedFilters: [IsNotNull(Numéro Séjour)]
ReadSchema: struct<Numéro Séjour:string,Niveau CCMU:string>

(5) Filter
Input [2]: [Numéro Séjour#524603, Niveau CCMU#524608]
Condition : (NOT CASE WHEN isnull(StartsWith(Numéro Séjour#524603, #)) THEN false ELSE StartsWith(Numéro Séjour#524603, #) END AND isnotnull(Numéro Séjour#524603))

(6) Project
Output [2]: [Numéro Séjour#524603 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719, str_remove_space(str_list_get(str_extract_by_regex(Niveau CCMU#524608, [+\d]+), 0), ALL) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524722]
Input [2]: [Numéro Séjour#524603, Niveau CCMU#524608]

(7) Exchange
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524722]
Arguments: hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719, 10), ENSURE_REQUIREMENTS, [plan_id=320758]

(8) Sort
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524722]
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(9) Window
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524722]
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#524768], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719], [1 DESC NULLS LAST]

(10) Filter
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524722, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#524768]
Condition : (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#524768 <=> 1)

(11) Project
Output [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719 AS COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524722 AS COL_15586747_17B8_4040_ACEB_0A327605038C#526449]
Input [3]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524722, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#524768]

(12) Scan csv 
Output [2]: [REGLES#524370, APPLICABLE#524371]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_225515/REGLES-A-TTT new.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SU2-SU3), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>

(13) Filter
Input [2]: [REGLES#524370, APPLICABLE#524371]
Condition : ((isnotnull(REGLES#524370) AND (RC-SU2-SU3 = REGLES#524370)) AND (APPLICABLE#524371 <=> O))

(14) Project
Output [1]: [APPLICABLE#524371 AS REGLES_A_APPLIQ_225642_APPLICABLE_225644#526493]
Input [2]: [REGLES#524370, APPLICABLE#524371]

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

(16) Project
Output [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446, COL_15586747_17B8_4040_ACEB_0A327605038C#526449, REGLES_A_APPLIQ_225642_APPLICABLE_225644#526493 AS COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#526589]
Input [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446, COL_15586747_17B8_4040_ACEB_0A327605038C#526449, REGLES_A_APPLIQ_225642_APPLICABLE_225644#526493]

(17) Exchange
Input [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446, COL_15586747_17B8_4040_ACEB_0A327605038C#526449, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#526589]
Arguments: hashpartitioning(COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446, 10), ENSURE_REQUIREMENTS, [plan_id=320769]

(18) Sort
Input [3]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446, COL_15586747_17B8_4040_ACEB_0A327605038C#526449, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#526589]
Arguments: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446 ASC NULLS FIRST], false, 0

(19) Scan parquet 
Output [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#525408, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#525412, COL_60F7C888_9836_4535_A22F_D43D2994E019#525420]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_225663]
PushedFilters: [IsNotNull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F), IsNotNull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8)]
ReadSchema: struct<COL_F1E7803C_F059_4667_8E32_963E2B3DA65F:string,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8:string,COL_60F7C888_9836_4535_A22F_D43D2994E019:string>

(20) Filter
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#525408, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#525412, COL_60F7C888_9836_4535_A22F_D43D2994E019#525420]
Condition : ((isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#525408) AND NOT CASE WHEN isnull(StartsWith(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#525412, #)) THEN false ELSE StartsWith(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#525412, #) END) AND isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#525412))

(21) Project
Output [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#525408 AS 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#526642, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#525412 AS 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#526646, COL_60F7C888_9836_4535_A22F_D43D2994E019#525420 AS 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#526654]
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#525408, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#525412, COL_60F7C888_9836_4535_A22F_D43D2994E019#525420]

(22) Exchange
Input [3]: [03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#526642, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#526646, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#526654]
Arguments: hashpartitioning(03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#526646, 10), ENSURE_REQUIREMENTS, [plan_id=320770]

(23) Sort
Input [3]: [03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#526642, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#526646, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#526654]
Arguments: [03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#526646 ASC NULLS FIRST], false, 0

(24) SortMergeJoin
Left keys [1]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446]
Right keys [1]: [03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#526646]
Join type: Inner
Join condition: None

(25) Project
Output [5]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446, COL_15586747_17B8_4040_ACEB_0A327605038C#526449, 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#526642 AS COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#526875, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#526654 AS COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#526589]
Input [6]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446, COL_15586747_17B8_4040_ACEB_0A327605038C#526449, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#526589, 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#526642, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#526646, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#526654]

(26) Scan parquet 
Output [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#525771, COL_F94DAC07_127C_4495_A440_68EF585E7F25#525780, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#525794, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#525798, COL_1996D387_9E74_479E_8427_83B4DBA88131#525817]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_225863]
PushedFilters: [IsNotNull(COL_64ED17E5_A991_405B_AEED_8A2977283F76)]
ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_F94DAC07_127C_4495_A440_68EF585E7F25:string,COL_6A8C3138_77B0_404C_B949_FC01E1C85545:string,COL_EA6371C8_0F76_4199_B797_A5888F7D4D43:timestamp,COL_1996D387_9E74_479E_8427_83B4DBA88131:string>

(27) Filter
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#525771, COL_F94DAC07_127C_4495_A440_68EF585E7F25#525780, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#525794, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#525798, COL_1996D387_9E74_479E_8427_83B4DBA88131#525817]
Condition : (isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#525771) AND NOT CASE WHEN isnull(StartsWith(COL_64ED17E5_A991_405B_AEED_8A2977283F76#525771, #)) THEN false ELSE StartsWith(COL_64ED17E5_A991_405B_AEED_8A2977283F76#525771, #) END)

(28) Project
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#525771 AS COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526176, str_if_with_rule(((COL_F94DAC07_127C_4495_A440_68EF585E7F25#525780 <=> 1) AND CASE WHEN isnull(Contains(COL_6A8C3138_77B0_404C_B949_FC01E1C85545#525794, 2)) THEN false ELSE Contains(COL_6A8C3138_77B0_404C_B949_FC01E1C85545#525794, 2) END), SU2, str_if_with_rule((((COL_6A8C3138_77B0_404C_B949_FC01E1C85545#525794 <=> 3) OR (COL_6A8C3138_77B0_404C_B949_FC01E1C85545#525794 <=> 4)) OR (COL_6A8C3138_77B0_404C_B949_FC01E1C85545#525794 <=> 5)), SU3, null)) AS COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#526278, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#525798 AS COL_FBB15BE3_311B_4A50_A657_811052E44533#526179, COL_1996D387_9E74_479E_8427_83B4DBA88131#525817 AS COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#526180]
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#525771, COL_F94DAC07_127C_4495_A440_68EF585E7F25#525780, COL_6A8C3138_77B0_404C_B949_FC01E1C85545#525794, COL_EA6371C8_0F76_4199_B797_A5888F7D4D43#525798, COL_1996D387_9E74_479E_8427_83B4DBA88131#525817]

(29) ObjectHashAggregate
Input [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526176, COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#526278, COL_FBB15BE3_311B_4A50_A657_811052E44533#526179, COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#526180]
Keys [1]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526176]
Functions [3]: [partial_collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#526278, 0, 0), partial_min(COL_FBB15BE3_311B_4A50_A657_811052E44533#526179), partial_collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#526180, 0, 0)]
Aggregate Attributes [3]: [buf#526988, min#527487, buf#527488]
Results [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526176, buf#526991, min#527489, buf#527490]

(30) Exchange
Input [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526176, buf#526991, min#527489, buf#527490]
Arguments: hashpartitioning(COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526176, 10), ENSURE_REQUIREMENTS, [plan_id=320775]

(31) ObjectHashAggregate
Input [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526176, buf#526991, min#527489, buf#527490]
Keys [1]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526176]
Functions [3]: [collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#526278, 0, 0), min(COL_FBB15BE3_311B_4A50_A657_811052E44533#526179), collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#526180, 0, 0)]
Aggregate Attributes [3]: [collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#526278, 0, 0)#526294, min(COL_FBB15BE3_311B_4A50_A657_811052E44533#526179)#526296, collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#526180, 0, 0)#526298]
Results [4]: [COL_A2B1BF52_4026_4023_A1B8_EA04642990B1#526176 AS 02_ACTES_PATIEN_225933_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#526925, str_list_get(collect_set(COL_641930F3_E2B4_4831_94F7_79C0F43C12D9#526278, 0, 0)#526294, 0) AS 02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927, date_time_to_str(min(COL_FBB15BE3_311B_4A50_A657_811052E44533#526179)#526296, ddMMyyyy, Europe/Paris, fr_FR) AS 02_ACTES_PATIEN_225933_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#526928, collect_set(COL_20B7E30A_73A4_469F_B51D_282D30BA8EFF#526180, 0, 0)#526298 AS 02_ACTES_PATIEN_225933_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#526929]

(32) Sort
Input [4]: [02_ACTES_PATIEN_225933_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#526925, 02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927, 02_ACTES_PATIEN_225933_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#526928, 02_ACTES_PATIEN_225933_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#526929]
Arguments: [02_ACTES_PATIEN_225933_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#526925 ASC NULLS FIRST], false, 0

(33) SortMergeJoin
Left keys [1]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446]
Right keys [1]: [02_ACTES_PATIEN_225933_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#526925]
Join type: Inner
Join condition: (NOT (str_if_with_rule(CASE WHEN isnull(Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END, SU3-, null)), null))))), >)) THEN false ELSE Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END, SU3-, null)), null))))), >) END, str_join(array(str_concat(array(str_extract_by_str(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END, SU3-, null)), null))))), >, LEFT), -)), str_concat(array(str_extract_by_str(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END, SU3-, null)), null))))), >, RIGHT), +))), ,), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END, SU3-, null)), null)))))) <=> ) AND isnotnull(str_if_with_rule(CASE WHEN isnull(Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END, SU3-, null)), null))))), >)) THEN false ELSE Contains(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END, SU3-, null)), null))))), >) END, str_join(array(str_concat(array(str_extract_by_str(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END, SU3-, null)), null))))), >, LEFT), -)), str_concat(array(str_extract_by_str(str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END, SU3-, null)), null))))), >, RIGHT), +))), ,), str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END, SU3-, null)), null))))))))

(34) Project
Output [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#526875, str_if_with_rule(((NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND NOT CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END) AND isnotnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927)), str_concat(array(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927, +)), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU2,SU3], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU3)), str_join([SU3,SU2], >), str_if_with_rule((CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END AND (02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927 <=> SU2)), str_join([SU3,SU2], >), str_if_with_rule(isnull(02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927), str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU2) END, SU2-, str_if_with_rule(CASE WHEN isnull(Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3)) THEN false ELSE Contains(COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, SU3) END, SU3-, null)), null))))) AS COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#527152, str_create(RC-SU2-SU3) AS COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#527153, 02_ACTES_PATIEN_225933_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#526928 AS COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#526974, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#526589, str_join(array(str_join(array(CCMU , COL_15586747_17B8_4040_ACEB_0A327605038C#526449),  : ), str_join(array(Acte Eligible SU2 , str_list_as_str(02_ACTES_PATIEN_225933_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#526929)),  : )),  - ) AS COL_EF5B8E51_0EA9_4466_A691_A2B708205606#527156]
Input [9]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446, COL_15586747_17B8_4040_ACEB_0A327605038C#526449, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#526875, COL_2A791AAF_BBFF_4E1B_ABE7_9933D1E03ADD#526876, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#526589, 02_ACTES_PATIEN_225933_COL_4E8586E7_1688_42D8_BF89_FB1E0E59C6F9#526925, 02_ACTES_PATIEN_225933_COL_98193CA9_9380_48E6_8792_463790C0A819#526927, 02_ACTES_PATIEN_225933_COL_9A06318E_CF05_49E9_94F4_B9B28BCC2340#526928, 02_ACTES_PATIEN_225933_COL_6EA82114_3FEC_442C_89AF_1DF75AE6587E#526929]

(35) Project
Output [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#526875, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#527153, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#526974, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#526589, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#527156, str_if_with_rule(CASE WHEN isnull(Contains(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#527152, >)) THEN false ELSE Contains(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#527152, >) END, str_join(array(str_concat(array(str_extract_by_str(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#527152, >, LEFT), -)), str_concat(array(str_extract_by_str(COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#527152, >, RIGHT), +))), ,), COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#527152) AS COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#527186]
Input [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#526875, COL_89CF50A1_8B5C_4BFB_9C59_6E63BB37D059#527152, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#527153, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#526974, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#526589, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#527156]

(36) Project
Output [8]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#526875, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#527153, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#527186, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#526974, str_if_with_rule(isnotnull(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#527186), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#527186, +)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#527186, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#527186, -)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#527186, -) END, Switch de forfait (SU*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#527186, -)) THEN false ELSE Contains(COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#527186, -) END, Suppression de Forfait, )), COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#526974), @), ) AS COL_EB745243_852A_470C_A1E1_722CE684E626#527348, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#526589, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#527156]
Input [7]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#526875, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#527153, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#526974, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#526589, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#527156, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#527186]

(37) WriteFiles
Input [8]: [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0#526446, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA#526875, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D#527153, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B#527186, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4#526974, COL_EB745243_852A_470C_A1E1_722CE684E626#527348, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850#526589, COL_EF5B8E51_0EA9_4466_A691_A2B708205606#527156]

(38) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR5_SU2_SU3_226031, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR5_SU2_SU3_226031], Overwrite, [COL_3BB817E2_7134_465C_BB2D_103FF5885DA0, COL_3B7359AF_6E02_449F_ABF7_5DCBEF7AE1BA, COL_8E2A8507_ECB8_45B0_92FC_F3CA08E4A36D, COL_3EE00032_991E_4E24_9D7A_31B9BFBBB55B, COL_235B2FEB_4835_4B9C_A3BF_888B1D3C33D4, COL_EB745243_852A_470C_A1E1_722CE684E626, COL_FCED5C44_FADC_43E3_BA48_A0EAA4676850, COL_EF5B8E51_0EA9_4466_A691_A2B708205606]

(39) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true
SQL / DataFrame Properties
Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet