SP1 - Details for Query 2086

Submitted Time: 2026/09/17 16:11:15
Duration: 0.2 s
Succeeded Jobs: 2998 2999 3000
Show the Stage ID and Task ID that corresponds to the max metric
Details
== Physical Plan ==
AdaptiveSparkPlan (28)
+- == Final Plan ==
   Execute InsertIntoHadoopFsRelationCommand (3)
   +- WriteFiles (2)
      +- LocalTableScan (1)
+- == Initial Plan ==
   Execute InsertIntoHadoopFsRelationCommand (27)
   +- WriteFiles (26)
      +- Project (25)
         +- Project (24)
            +- Project (23)
               +- Project (22)
                  +- SortMergeJoin Inner (21)
                     :- Sort (15)
                     :  +- ObjectHashAggregate (14)
                     :     +- Exchange (13)
                     :        +- ObjectHashAggregate (12)
                     :           +- Project (11)
                     :              +- CartesianProduct Inner (10)
                     :                 :- Project (6)
                     :                 :  +- Filter (5)
                     :                 :     +- Scan parquet  (4)
                     :                 +- Project (9)
                     :                    +- Filter (8)
                     :                       +- Scan csv  (7)
                     +- Sort (20)
                        +- Exchange (19)
                           +- Project (18)
                              +- Filter (17)
                                 +- Scan parquet  (16)


(1) LocalTableScan
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#516405, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#516586, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#516791, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#516775, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#516874, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#516756, COL_2F038993_76B5_4030_8D3B_7718F322492A#516587, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#516588, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#516591, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#516408]
Arguments: <empty>, [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#516405, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#516586, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#516791, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#516775, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#516874, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#516756, COL_2F038993_76B5_4030_8D3B_7718F322492A#516587, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#516588, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#516591, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#516408]

(2) WriteFiles
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#516405, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#516586, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#516791, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#516775, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#516874, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#516756, COL_2F038993_76B5_4030_8D3B_7718F322492A#516587, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#516588, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#516591, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#516408]

(3) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR3_SUB_SB2__226357, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR3_SUB_SB2__226357], Overwrite, [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08, COL_46598A01_D8BC_436B_975B_00D168E3C4D6, COL_2F038993_76B5_4030_8D3B_7718F322492A, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9]

(4) Scan parquet 
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#515669, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#515687, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#515688, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#515713]
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_BDB05EC9_9A57_48FC_837C_09C53AD9A07C:string,COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE:string,COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799:string>

(5) Filter
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#515669, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#515687, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#515688, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#515713]
Condition : isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#515669)

(6) Project
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#515669 AS COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#516063, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#515687 AS COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#516067, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#515688 AS COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#516082, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#515713 AS COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#516083]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#515669, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#515687, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#515688, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#515713]

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

(8) Filter
Input [2]: [REGLES#515648, APPLICABLE#515649]
Condition : ((isnotnull(REGLES#515648) AND (RC-SUB = REGLES#515648)) AND (APPLICABLE#515649 <=> O))

(9) Project
Output: []
Input [2]: [REGLES#515648, APPLICABLE#515649]

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

(11) Project
Output [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#516063, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#516082, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#516083, str_to_datez(COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#516067, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#516333]
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#516063, COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#516067, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#516082, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#516083]

(12) ObjectHashAggregate
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#516063, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#516082, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#516083, COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#516333]
Keys [1]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#516063]
Functions [3]: [partial_min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#516333), partial_collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#516082, 0, 0), partial_collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#516083, 0, 0)]
Aggregate Attributes [3]: [min#516602, buf#516913, buf#516914]
Results [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#516063, min#516605, buf#516915, buf#516916]

(13) Exchange
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#516063, min#516605, buf#516915, buf#516916]
Arguments: hashpartitioning(COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#516063, 10), ENSURE_REQUIREMENTS, [plan_id=316373]

(14) ObjectHashAggregate
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#516063, min#516605, buf#516915, buf#516916]
Keys [1]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#516063]
Functions [3]: [min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#516333), collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#516082, 0, 0), collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#516083, 0, 0)]
Aggregate Attributes [3]: [min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#516333)#516381, collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#516082, 0, 0)#516383, collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#516083, 0, 0)#516385]
Results [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#516063 AS COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#516405, min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#516333)#516381 AS COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#516406, collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#516082, 0, 0)#516383 AS COL_504D9344_0D6D_448F_B93B_8070A8498F87#516407, collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#516083, 0, 0)#516385 AS COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#516408]

(15) Sort
Input [4]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#516405, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#516406, COL_504D9344_0D6D_448F_B93B_8070A8498F87#516407, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#516408]
Arguments: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#516405 ASC NULLS FIRST], false, 0

(16) Scan parquet 
Output [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#515779, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#515782, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#515783, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#515784, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#515786, COL_60F7C888_9836_4535_A22F_D43D2994E019#515791, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#515794]
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_8761272F_9915_40EB_8429_20EFEF6A9A31:string,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8:string,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46:string,COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A:double,COL_60F7C888_9836_4535_A22F_D43D2994E019:string,COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3:array<string>>

(17) Filter
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#515779, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#515782, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#515783, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#515784, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#515786, COL_60F7C888_9836_4535_A22F_D43D2994E019#515791, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#515794]
Condition : (isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#515779) AND isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#515783))

(18) Project
Output [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#515779 AS 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#516450, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#515782 AS 03_PIVOT_INFORM_225663_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#516453, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#515783 AS 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#516454, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#515784 AS 03_PIVOT_INFORM_225663_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#516455, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#515786 AS 03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457, COL_60F7C888_9836_4535_A22F_D43D2994E019#515791 AS 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#516462, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#515794 AS 03_PIVOT_INFORM_225663_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#516465]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#515779, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#515782, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#515783, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#515784, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#515786, COL_60F7C888_9836_4535_A22F_D43D2994E019#515791, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#515794]

(19) Exchange
Input [7]: [03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#516450, 03_PIVOT_INFORM_225663_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#516453, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#516454, 03_PIVOT_INFORM_225663_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#516455, 03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#516462, 03_PIVOT_INFORM_225663_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#516465]
Arguments: hashpartitioning(03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#516454, 10), ENSURE_REQUIREMENTS, [plan_id=316377]

(20) Sort
Input [7]: [03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#516450, 03_PIVOT_INFORM_225663_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#516453, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#516454, 03_PIVOT_INFORM_225663_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#516455, 03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#516462, 03_PIVOT_INFORM_225663_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#516465]
Arguments: [03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#516454 ASC NULLS FIRST], false, 0

(21) SortMergeJoin
Left keys [1]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#516405]
Right keys [1]: [03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#516454]
Join type: Inner
Join condition: (isnotnull(str_if_with_rule((isnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#516407, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#516462, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#516462, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#516407, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 45.0) END, SB3, null))), null)), null, str_if_with_rule((isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#516407, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#516462, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#516407, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#516407, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#516462, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#516462, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#516407, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#516407, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 45.0) END, SB3, null))), null), +)), null))), null))))) AND NOT (str_if_with_rule((isnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#516407, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#516462, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#516462, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#516407, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 45.0) END, SB3, null))), null)), null, str_if_with_rule((isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#516407, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#516462, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#516407, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#516407, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#516462, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#516462, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#516407, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#516407, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 16.0) AND (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457) THEN false ELSE (03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 >= 45.0) END, SB3, null))), null), +)), null))), null)))) <=> ))

(22) Project
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#516405, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#516406, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#516408, 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#516450 AS COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#516586, 03_PIVOT_INFORM_225663_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#516453 AS COL_2F038993_76B5_4030_8D3B_7718F322492A#516587, 03_PIVOT_INFORM_225663_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#516455 AS COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#516588, 03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457 AS COL_50001E33_210D_4379_9D53_00CD383D4C9E#516589, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#516462 AS COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#516590, 03_PIVOT_INFORM_225663_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#516465 AS COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#516591, str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#516407, 0) AS COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#516608]
Input [11]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#516405, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#516406, COL_504D9344_0D6D_448F_B93B_8070A8498F87#516407, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#516408, 03_PIVOT_INFORM_225663_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#516450, 03_PIVOT_INFORM_225663_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#516453, 03_PIVOT_INFORM_225663_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#516454, 03_PIVOT_INFORM_225663_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#516455, 03_PIVOT_INFORM_225663_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#516457, 03_PIVOT_INFORM_225663_COL_60F7C888_9836_4535_A22F_D43D2994E019#516462, 03_PIVOT_INFORM_225663_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#516465]

(23) Project
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#516405, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#516586, str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#516608 <=> 1), str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#516589) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#516589 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((COL_50001E33_210D_4379_9D53_00CD383D4C9E#516589 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#516589 <= 44.99))) THEN false ELSE ((COL_50001E33_210D_4379_9D53_00CD383D4C9E#516589 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#516589 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#516589) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#516589 >= 45.0) END, SB3, null))), null) AS COL_5FBE30A1_AFD9_4037_B848_6C939797E947#516753, str_list_get(str_list_intersect_fixed(str_split(COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#516590, ;), [SUB,SB2,SB3]), 0) AS COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#516754, date_time_to_str(COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#516406, ddMMyyyy, Europe/Paris, fr_FR) AS COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#516755, str_join(array(str_join(array(Age (en Année) , dec_to_str(COL_50001E33_210D_4379_9D53_00CD383D4C9E#516589)),  : ), , str_join(array(Date Naissance , str_join(array(str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#516587, LEFT, 2), str_extract_middle(COL_2F038993_76B5_4030_8D3B_7718F322492A#516587, 3, 2), str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#516587, RIGHT, 4)), -)),  : ), str_join(array(Date Entrée, str_join(array(str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#516588, LEFT, 2), str_extract_middle(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#516588, 3, 2), str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#516588, RIGHT, 4)), -)),  : ), str_join(array(Date Biologie, str_list_as_str(COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#516408)),  : ), str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#516608 <=> 1), Eligible Bio : OUI, Eligible Bio : NON)),  - ) AS COL_46598A01_D8BC_436B_975B_00D168E3C4D6#516756, COL_2F038993_76B5_4030_8D3B_7718F322492A#516587, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#516588, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#516591, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#516408]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#516405, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#516406, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#516408, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#516586, COL_2F038993_76B5_4030_8D3B_7718F322492A#516587, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#516588, COL_50001E33_210D_4379_9D53_00CD383D4C9E#516589, COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#516590, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#516591, COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#516608]

(24) Project
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#516405, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#516586, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#516755, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#516756, COL_2F038993_76B5_4030_8D3B_7718F322492A#516587, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#516588, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#516591, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#516408, str_if_with_rule((isnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#516753) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#516754)), null, str_if_with_rule((COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#516754 <=> COL_5FBE30A1_AFD9_4037_B848_6C939797E947#516753), null, str_if_with_rule((isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#516753) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#516754)), str_concat(array(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#516753, +)), str_if_with_rule(NOT (COL_5FBE30A1_AFD9_4037_B848_6C939797E947#516753 <=> COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#516754), str_concat(array(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#516754, -, str_if_with_rule(isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#516753), str_concat(array(,, COL_5FBE30A1_AFD9_4037_B848_6C939797E947#516753, +)), null))), null)))) AS COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#516775, str_create(RC-SUB) AS COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#516791]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#516405, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#516586, COL_5FBE30A1_AFD9_4037_B848_6C939797E947#516753, COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#516754, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#516755, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#516756, COL_2F038993_76B5_4030_8D3B_7718F322492A#516587, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#516588, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#516591, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#516408]

(25) Project
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#516405, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#516586, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#516791, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#516775, str_if_with_rule((isnotnull(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#516775) AND NOT (COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#516775 <=> )), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#516775, +)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#516775, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#516775, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#516775, -) END, Switch de forfait (SU Bio*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#516775, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#516775, -) END, Suppression de Forfait, )), COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#516755), @), ) AS COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#516874, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#516756, COL_2F038993_76B5_4030_8D3B_7718F322492A#516587, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#516588, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#516591, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#516408]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#516405, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#516586, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#516755, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#516756, COL_2F038993_76B5_4030_8D3B_7718F322492A#516587, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#516588, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#516591, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#516408, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#516775, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#516791]

(26) WriteFiles
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#516405, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#516586, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#516791, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#516775, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#516874, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#516756, COL_2F038993_76B5_4030_8D3B_7718F322492A#516587, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#516588, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#516591, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#516408]

(27) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR3_SUB_SB2__226357, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR3_SUB_SB2__226357], Overwrite, [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08, COL_46598A01_D8BC_436B_975B_00D168E3C4D6, COL_2F038993_76B5_4030_8D3B_7718F322492A, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9]

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