SP1 - Details for Query 2012

Submitted Time: 2026/11/05 12:24:05
Duration: 1 s
Succeeded Jobs: 2851 2852 2858 2859

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 (6)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [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: 59.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: 16.0 B local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 59.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 55 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 54 ms number of output rows: 1"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 1"]; } 8 [labelType="html" label="ObjectHashAggregate number of output rows: 1,733 time in aggregation build: 12 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 9 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 57.3 KiB number of coalesced partitions: 1"]; 10 [labelType="html" label="Exchange shuffle records written: 1,733 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 4 ms (0 ms, 0 ms, 0 ms (stage 5396.0: task 5960)) 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,733 local bytes read: 54.8 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 10 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 347.0 KiB (30.5 KiB, 35.0 KiB, 38.3 KiB (stage 5396.0: task 5960)) 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 total (min, med, max (stageId: taskId)) 54.8 KiB (4.7 KiB, 5.6 KiB, 6.0 KiB (stage 5396.0: task 5960))"]; 11 [labelType="html" label="ObjectHashAggregate number of output rows: 1,733 time in aggregation build total (min, med, max (stageId: taskId)) 7.7 s (744 ms, 764 ms, 806 ms (stage 5396.0: task 5957)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 5396.0: task 5963)) number of sort fallback tasks: 10"]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n7.7 s (744 ms, 764 ms, 806 ms (stage 5396.0: task 5957))"; 13 [labelType="html" label=" Project "]; 14 [labelType="html" label=" Project "]; } 15 [labelType="html" label="CartesianProduct number of output rows: 2,139"]; 16 [labelType="html" label="CartesianProduct number of output rows: 2,139"]; subgraph cluster17 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n7.8 s (750 ms, 771 ms, 813 ms (stage 5396.0: task 5957))"; 18 [labelType="html" label=" Project "]; 19 [labelType="html" label="Filter number of output rows: 1,457,791"]; 20 [labelType="html" label="ColumnarToRow number of output rows: 2,199,023 number of input batches: 541"]; } 21 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 427 ms (35 ms, 40 ms, 57 ms (stage 5396.0: task 5963)) metadata time: 0 ms size of files read: 146.8 MiB number of output rows: 2,199,023"]; 22 [labelType="html" label="ObjectHashAggregate number of output rows: 10 time in aggregation build total (min, med, max (stageId: taskId)) 20 ms (2 ms, 2 ms, 2 ms (stage 5396.0: task 5963)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 5396.0: task 5963)) number of sort fallback tasks: 0"]; 23 [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: 10 local bytes read total (min, med, max (stageId: taskId)) 1840.0 B (184.0 B, 184.0 B, 184.0 B (stage 5396.0: task 5963)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 5396.0: task 5963)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 10 remote merged chunks fetched: 0 remote blocks read: 0 data size: 192.0 B local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 184.0 B"]; 24 [labelType="html" label="ObjectHashAggregate number of output rows: 1 time in aggregation build: 12 ms spill size: 0.0 B number of sort fallback tasks: 0"]; subgraph cluster25 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 12 ms"; 26 [labelType="html" label=" Project "]; } 27 [labelType="html" label="Scan csv number of output rows: 9 number of files read: 1 metadata time: 0 ms size of files read: 50.0 B"]; subgraph cluster28 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n97 ms (8 ms, 10 ms, 13 ms (stage 5396.0: task 5957))"; 29 [labelType="html" label=" Project "]; 30 [labelType="html" label="Filter number of output rows: 10"]; } 31 [labelType="html" label="Scan csv number of output rows: 10 number of files read: 1 metadata time: 0 ms size of files read: 110.0 B"]; 2->0; 3->2; 5->3; 6->5; 7->6; 8->7; 9->8; 10->9; 11->10; 13->11; 14->13; 15->14; 16->15; 18->16; 19->18; 20->19; 21->20; 22->16; 23->22; 24->23; 26->24; 27->26; 29->15; 30->29; 31->30; }

AdaptiveSparkPlan isFinalPlan=true

HashAggregate(keys=[], functions=[count(1)])

WholeStageCodegen (6)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=194434]

HashAggregate(keys=[], functions=[partial_count(1)])

Project

Filter ((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#473776)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#473776)), 030027795) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_list_get(COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#473806, 0))), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(str_list_get(COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#473806, 0))), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_extend(str_list_as_str(COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#473808), [[,],"]))), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_extend(str_list_as_str(COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#473808), [[,],"]))), 030027795) END)

WholeStageCodegen (5)

ObjectHashAggregate(keys=[COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148], functions=[collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716, 0, 0), collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#473747, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, 10), ENSURE_REQUIREMENTS, [plan_id=194080]

ObjectHashAggregate(keys=[COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148], functions=[partial_collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716, 0, 0), partial_collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#473747, 0, 0)])

Project [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716, str_if_with_rule((NOT (COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716 <=> ) AND isnotnull(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716)), str_join(array(Déclencheur , COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#473151, : , Exécutant , COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138, @, str_join(array(str_extract(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#473137, RIGHT, 4), str_extract_middle(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#473137, 3, 2), str_extract(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#473137, LEFT, 2)), -)), ), null) AS COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#473747]

Project [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#473137, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#473151, str_if_with_rule(((((((COL_E43C6574_A3E3_4056_BB55_EA935E04502C#473144 <=> 1) AND (COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#473145 <=> 1)) AND (COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#473153 <=> 0)) AND (size(str_list_intersect_fixed(COL_3377534C_2BCD_43B6_853A_869D44C151B3#473152, [MCS]), true) <=> 0)) AND (size(str_list_intersect_fixed(99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#473507, array(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#473151)), true) > 0)) AND (((CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L < 16) END AND NOT (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 01)) OR (CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L < 26) END AND (((COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 17) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 33)) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 75)))) OR (COL_085E5798_40D8_4726_B01C_7D83841C9C25#473150 <=> O))), MCS, ) AS COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716]

WholeStageCodegen (4)

CartesianProduct

CartesianProduct (str_if_with_rule(((((((COL_E43C6574_A3E3_4056_BB55_EA935E04502C#473144 <=> 1) AND (COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#473145 <=> 1)) AND (COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#473153 <=> 0)) AND (size(str_list_intersect_fixed(COL_3377534C_2BCD_43B6_853A_869D44C151B3#473152, [MCS]), true) <=> 0)) AND (size(str_list_intersect_fixed(99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#473507, array(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#473151)), true) > 0)) AND (((CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L < 16) END AND NOT (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 01)) OR (CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L < 26) END AND (((COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 17) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 33)) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 75)))) OR (COL_085E5798_40D8_4726_B01C_7D83841C9C25#473150 <=> O))), MCS, ) <=> MCS)

Project [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#472893 AS COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#473137, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#472894 AS COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#472900 AS COL_E43C6574_A3E3_4056_BB55_EA935E04502C#473144, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#472901 AS COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#473145, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#472904 AS COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#472905L AS COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#472906 AS COL_085E5798_40D8_4726_B01C_7D83841C9C25#473150, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#472907 AS COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#473151, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#472908 AS COL_3377534C_2BCD_43B6_853A_869D44C151B3#473152, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#472910 AS COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#473153]

Filter (NOT (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#472907 <=> ) AND isnotnull(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#472907))

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#472893,COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#472894,COL_346C27DC_6D06_4FCF_A022_7FF177053D81#472900,COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#472901,COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#472904,COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#472905L,COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#472906,COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#472907,COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#472908,COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#472910] Batched: true, DataFilters: [NOT (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#472907 <=> ), isnotnull(COL_A4AF3049_C967_4B58_9D3..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/01_A_STEP_1_RSF_231581], PartitionFilters: [], PushedFilters: [Not(EqualNullSafe(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC,)), IsNotNull(COL_A4AF3049_C967_4B58_..., ReadSchema: struct<COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86:string,COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F:s...

ObjectHashAggregate(keys=[], functions=[collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#472975, 0, 0)])

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=193965]

ObjectHashAggregate(keys=[], functions=[partial_collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#472975, 0, 0)])

Project [str_remove_space(Code-MCS#472957, ONLY_ONE) AS COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#472975]

WholeStageCodegen (1)

FileScan csv [Code-MCS#472957] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/ACTES_ELIGIBLIT_231426/Code-MCS.csv], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<Code-MCS:string>

Project

Filter ((isnotnull(REGLES#472869) AND (MCS = REGLES#472869)) AND (APPLICABLE#472870 <=> O))

WholeStageCodegen (3)

FileScan csv [REGLES#472869,APPLICABLE#472870] Batched: false, DataFilters: [isnotnull(REGLES#472869), (MCS = REGLES#472869), (APPLICABLE#472870 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_231407/REGLES-A-TTT_EXT..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,MCS), EqualNullSafe(APPLICABLE,O)], ReadSchema: struct<REGLES:string,APPLICABLE:string>

Details

== Physical Plan ==
AdaptiveSparkPlan (49)
+- == Final Plan ==
   * HashAggregate (28)
   +- ShuffleQueryStage (27), Statistics(sizeInBytes=16.0 B, rowCount=1)
      +- Exchange (26)
         +- * HashAggregate (25)
            +- * Project (24)
               +- * Filter (23)
                  +- ObjectHashAggregate (22)
                     +- AQEShuffleRead (21)
                        +- ShuffleQueryStage (20), Statistics(sizeInBytes=347.0 KiB, rowCount=1.73E+3)
                           +- Exchange (19)
                              +- ObjectHashAggregate (18)
                                 +- * Project (17)
                                    +- * Project (16)
                                       +- CartesianProduct Inner (15)
                                          :- CartesianProduct Inner (11)
                                          :  :- * Project (4)
                                          :  :  +- * Filter (3)
                                          :  :     +- * ColumnarToRow (2)
                                          :  :        +- Scan parquet  (1)
                                          :  +- ObjectHashAggregate (10)
                                          :     +- ShuffleQueryStage (9), Statistics(sizeInBytes=192.0 B, rowCount=1)
                                          :        +- Exchange (8)
                                          :           +- ObjectHashAggregate (7)
                                          :              +- * Project (6)
                                          :                 +- Scan csv  (5)
                                          +- * Project (14)
                                             +- * Filter (13)
                                                +- Scan csv  (12)
+- == Initial Plan ==
   HashAggregate (48)
   +- Exchange (47)
      +- HashAggregate (46)
         +- Project (45)
            +- Filter (44)
               +- ObjectHashAggregate (43)
                  +- Exchange (42)
                     +- ObjectHashAggregate (41)
                        +- Project (40)
                           +- Project (39)
                              +- CartesianProduct Inner (38)
                                 :- CartesianProduct Inner (35)
                                 :  :- Project (30)
                                 :  :  +- Filter (29)
                                 :  :     +- Scan parquet  (1)
                                 :  +- ObjectHashAggregate (34)
                                 :     +- Exchange (33)
                                 :        +- ObjectHashAggregate (32)
                                 :           +- Project (31)
                                 :              +- Scan csv  (5)
                                 +- Project (37)
                                    +- Filter (36)
                                       +- Scan csv  (12)


(1) Scan parquet 
Output [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#472893, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#472894, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#472900, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#472901, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#472904, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#472905L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#472906, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#472907, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#472908, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#472910]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/01_A_STEP_1_RSF_231581]
PushedFilters: [Not(EqualNullSafe(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC,)), IsNotNull(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC)]
ReadSchema: struct<COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86:string,COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F:string,COL_346C27DC_6D06_4FCF_A022_7FF177053D81:string,COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62:string,COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0:string,COL_969EAFA1_AD39_4285_AD05_6146CD6F9342:bigint,COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487:string,COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC:string,COL_714AB906_7002_4ADC_AA1A_38467A3EDE10:array<string>,COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6:int>

(2) ColumnarToRow [codegen id : 2]
Input [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#472893, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#472894, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#472900, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#472901, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#472904, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#472905L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#472906, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#472907, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#472908, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#472910]

(3) Filter [codegen id : 2]
Input [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#472893, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#472894, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#472900, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#472901, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#472904, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#472905L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#472906, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#472907, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#472908, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#472910]
Condition : (NOT (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#472907 <=> ) AND isnotnull(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#472907))

(4) Project [codegen id : 2]
Output [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#472893 AS COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#473137, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#472894 AS COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#472900 AS COL_E43C6574_A3E3_4056_BB55_EA935E04502C#473144, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#472901 AS COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#473145, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#472904 AS COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#472905L AS COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#472906 AS COL_085E5798_40D8_4726_B01C_7D83841C9C25#473150, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#472907 AS COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#473151, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#472908 AS COL_3377534C_2BCD_43B6_853A_869D44C151B3#473152, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#472910 AS COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#473153]
Input [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#472893, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#472894, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#472900, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#472901, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#472904, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#472905L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#472906, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#472907, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#472908, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#472910]

(5) Scan csv 
Output [1]: [Code-MCS#472957]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/ACTES_ELIGIBLIT_231426/Code-MCS.csv]
ReadSchema: struct<Code-MCS:string>

(6) Project [codegen id : 1]
Output [1]: [str_remove_space(Code-MCS#472957, ONLY_ONE) AS COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#472975]
Input [1]: [Code-MCS#472957]

(7) ObjectHashAggregate
Input [1]: [COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#472975]
Keys: []
Functions [1]: [partial_collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#472975, 0, 0)]
Aggregate Attributes [1]: [buf#473858]
Results [1]: [buf#473859]

(8) Exchange
Input [1]: [buf#473859]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=193965]

(9) ShuffleQueryStage
Output [1]: [buf#473859]
Arguments: 0

(10) ObjectHashAggregate
Input [1]: [buf#473859]
Keys: []
Functions [1]: [collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#472975, 0, 0)]
Aggregate Attributes [1]: [collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#472975, 0, 0)#472980]
Results [1]: [collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#472975, 0, 0)#472980 AS 99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#473507]

(11) CartesianProduct
Join type: Inner
Join condition: (str_if_with_rule(((((((COL_E43C6574_A3E3_4056_BB55_EA935E04502C#473144 <=> 1) AND (COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#473145 <=> 1)) AND (COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#473153 <=> 0)) AND (size(str_list_intersect_fixed(COL_3377534C_2BCD_43B6_853A_869D44C151B3#473152, [MCS]), true) <=> 0)) AND (size(str_list_intersect_fixed(99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#473507, array(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#473151)), true) > 0)) AND (((CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L < 16) END AND NOT (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 01)) OR (CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L < 26) END AND (((COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 17) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 33)) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 75)))) OR (COL_085E5798_40D8_4726_B01C_7D83841C9C25#473150 <=> O))), MCS, ) <=> MCS)

(12) Scan csv 
Output [2]: [REGLES#472869, APPLICABLE#472870]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_231407/REGLES-A-TTT_EXT.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,MCS), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>

(13) Filter [codegen id : 3]
Input [2]: [REGLES#472869, APPLICABLE#472870]
Condition : ((isnotnull(REGLES#472869) AND (MCS = REGLES#472869)) AND (APPLICABLE#472870 <=> O))

(14) Project [codegen id : 3]
Output: []
Input [2]: [REGLES#472869, APPLICABLE#472870]

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

(16) Project [codegen id : 4]
Output [5]: [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#473137, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#473151, str_if_with_rule(((((((COL_E43C6574_A3E3_4056_BB55_EA935E04502C#473144 <=> 1) AND (COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#473145 <=> 1)) AND (COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#473153 <=> 0)) AND (size(str_list_intersect_fixed(COL_3377534C_2BCD_43B6_853A_869D44C151B3#473152, [MCS]), true) <=> 0)) AND (size(str_list_intersect_fixed(99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#473507, array(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#473151)), true) > 0)) AND (((CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L < 16) END AND NOT (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 01)) OR (CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L < 26) END AND (((COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 17) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 33)) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 75)))) OR (COL_085E5798_40D8_4726_B01C_7D83841C9C25#473150 <=> O))), MCS, ) AS COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716]
Input [11]: [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#473137, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138, COL_E43C6574_A3E3_4056_BB55_EA935E04502C#473144, COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#473145, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L, COL_085E5798_40D8_4726_B01C_7D83841C9C25#473150, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#473151, COL_3377534C_2BCD_43B6_853A_869D44C151B3#473152, COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#473153, 99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#473507]

(17) Project [codegen id : 4]
Output [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716, str_if_with_rule((NOT (COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716 <=> ) AND isnotnull(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716)), str_join(array(Déclencheur , COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#473151, : , Exécutant , COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138, @, str_join(array(str_extract(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#473137, RIGHT, 4), str_extract_middle(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#473137, 3, 2), str_extract(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#473137, LEFT, 2)), -)),  ), null) AS COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#473747]
Input [5]: [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#473137, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#473151, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716]

(18) ObjectHashAggregate
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716, COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#473747]
Keys [1]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148]
Functions [2]: [partial_collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716, 0, 0), partial_collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#473747, 0, 0)]
Aggregate Attributes [2]: [buf#473854, buf#473855]
Results [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, buf#473856, buf#473857]

(19) Exchange
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, buf#473856, buf#473857]
Arguments: hashpartitioning(COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, 10), ENSURE_REQUIREMENTS, [plan_id=194080]

(20) ShuffleQueryStage
Output [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, buf#473856, buf#473857]
Arguments: 1

(21) AQEShuffleRead
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, buf#473856, buf#473857]
Arguments: coalesced

(22) ObjectHashAggregate
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, buf#473856, buf#473857]
Keys [1]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148]
Functions [2]: [collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716, 0, 0), collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#473747, 0, 0)]
Aggregate Attributes [2]: [collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716, 0, 0)#473805, collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#473747, 0, 0)#473807]
Results [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148 AS COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#473776, collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716, 0, 0)#473805 AS COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#473806, collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#473747, 0, 0)#473807 AS COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#473808]

(23) Filter [codegen id : 5]
Input [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#473776, COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#473806, COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#473808]
Condition : ((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#473776)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#473776)), 030027795) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_list_get(COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#473806, 0))), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(str_list_get(COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#473806, 0))), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_extend(str_list_as_str(COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#473808), [[,],"]))), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_extend(str_list_as_str(COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#473808), [[,],"]))), 030027795) END)

(24) Project [codegen id : 5]
Output: []
Input [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#473776, COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#473806, COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#473808]

(25) HashAggregate [codegen id : 5]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#473852L]
Results [1]: [count#473853L]

(26) Exchange
Input [1]: [count#473853L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=194434]

(27) ShuffleQueryStage
Output [1]: [count#473853L]
Arguments: 2

(28) HashAggregate [codegen id : 6]
Input [1]: [count#473853L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#473849L]
Results [1]: [count(1)#473849L AS count#473850L]

(29) Filter
Input [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#472893, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#472894, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#472900, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#472901, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#472904, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#472905L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#472906, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#472907, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#472908, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#472910]
Condition : (NOT (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#472907 <=> ) AND isnotnull(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#472907))

(30) Project
Output [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#472893 AS COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#473137, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#472894 AS COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#472900 AS COL_E43C6574_A3E3_4056_BB55_EA935E04502C#473144, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#472901 AS COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#473145, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#472904 AS COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#472905L AS COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#472906 AS COL_085E5798_40D8_4726_B01C_7D83841C9C25#473150, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#472907 AS COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#473151, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#472908 AS COL_3377534C_2BCD_43B6_853A_869D44C151B3#473152, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#472910 AS COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#473153]
Input [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#472893, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#472894, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#472900, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#472901, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#472904, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#472905L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#472906, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#472907, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#472908, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#472910]

(31) Project
Output [1]: [str_remove_space(Code-MCS#472957, ONLY_ONE) AS COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#472975]
Input [1]: [Code-MCS#472957]

(32) ObjectHashAggregate
Input [1]: [COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#472975]
Keys: []
Functions [1]: [partial_collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#472975, 0, 0)]
Aggregate Attributes [1]: [buf#473858]
Results [1]: [buf#473859]

(33) Exchange
Input [1]: [buf#473859]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=193909]

(34) ObjectHashAggregate
Input [1]: [buf#473859]
Keys: []
Functions [1]: [collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#472975, 0, 0)]
Aggregate Attributes [1]: [collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#472975, 0, 0)#472980]
Results [1]: [collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#472975, 0, 0)#472980 AS 99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#473507]

(35) CartesianProduct
Join type: Inner
Join condition: (str_if_with_rule(((((((COL_E43C6574_A3E3_4056_BB55_EA935E04502C#473144 <=> 1) AND (COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#473145 <=> 1)) AND (COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#473153 <=> 0)) AND (size(str_list_intersect_fixed(COL_3377534C_2BCD_43B6_853A_869D44C151B3#473152, [MCS]), true) <=> 0)) AND (size(str_list_intersect_fixed(99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#473507, array(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#473151)), true) > 0)) AND (((CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L < 16) END AND NOT (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 01)) OR (CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L < 26) END AND (((COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 17) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 33)) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 75)))) OR (COL_085E5798_40D8_4726_B01C_7D83841C9C25#473150 <=> O))), MCS, ) <=> MCS)

(36) Filter
Input [2]: [REGLES#472869, APPLICABLE#472870]
Condition : ((isnotnull(REGLES#472869) AND (MCS = REGLES#472869)) AND (APPLICABLE#472870 <=> O))

(37) Project
Output: []
Input [2]: [REGLES#472869, APPLICABLE#472870]

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

(39) Project
Output [5]: [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#473137, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#473151, str_if_with_rule(((((((COL_E43C6574_A3E3_4056_BB55_EA935E04502C#473144 <=> 1) AND (COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#473145 <=> 1)) AND (COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#473153 <=> 0)) AND (size(str_list_intersect_fixed(COL_3377534C_2BCD_43B6_853A_869D44C151B3#473152, [MCS]), true) <=> 0)) AND (size(str_list_intersect_fixed(99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#473507, array(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#473151)), true) > 0)) AND (((CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L < 16) END AND NOT (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 01)) OR (CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L < 26) END AND (((COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 17) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 33)) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138 <=> 75)))) OR (COL_085E5798_40D8_4726_B01C_7D83841C9C25#473150 <=> O))), MCS, ) AS COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716]
Input [11]: [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#473137, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138, COL_E43C6574_A3E3_4056_BB55_EA935E04502C#473144, COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#473145, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, COL_414BA164_8DC3_4834_BDD7_434B2278858B#473149L, COL_085E5798_40D8_4726_B01C_7D83841C9C25#473150, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#473151, COL_3377534C_2BCD_43B6_853A_869D44C151B3#473152, COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#473153, 99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#473507]

(40) Project
Output [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716, str_if_with_rule((NOT (COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716 <=> ) AND isnotnull(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716)), str_join(array(Déclencheur , COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#473151, : , Exécutant , COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138, @, str_join(array(str_extract(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#473137, RIGHT, 4), str_extract_middle(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#473137, 3, 2), str_extract(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#473137, LEFT, 2)), -)),  ), null) AS COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#473747]
Input [5]: [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#473137, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#473138, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#473151, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716]

(41) ObjectHashAggregate
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716, COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#473747]
Keys [1]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148]
Functions [2]: [partial_collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716, 0, 0), partial_collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#473747, 0, 0)]
Aggregate Attributes [2]: [buf#473854, buf#473855]
Results [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, buf#473856, buf#473857]

(42) Exchange
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, buf#473856, buf#473857]
Arguments: hashpartitioning(COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, 10), ENSURE_REQUIREMENTS, [plan_id=193917]

(43) ObjectHashAggregate
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148, buf#473856, buf#473857]
Keys [1]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148]
Functions [2]: [collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716, 0, 0), collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#473747, 0, 0)]
Aggregate Attributes [2]: [collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716, 0, 0)#473805, collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#473747, 0, 0)#473807]
Results [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#473148 AS COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#473776, collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#473716, 0, 0)#473805 AS COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#473806, collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#473747, 0, 0)#473807 AS COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#473808]

(44) Filter
Input [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#473776, COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#473806, COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#473808]
Condition : ((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#473776)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#473776)), 030027795) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_list_get(COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#473806, 0))), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(str_list_get(COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#473806, 0))), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_extend(str_list_as_str(COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#473808), [[,],"]))), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_extend(str_list_as_str(COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#473808), [[,],"]))), 030027795) END)

(45) Project
Output: []
Input [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#473776, COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#473806, COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#473808]

(46) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#473852L]
Results [1]: [count#473853L]

(47) Exchange
Input [1]: [count#473853L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=193923]

(48) HashAggregate
Input [1]: [count#473853L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#473849L]
Results [1]: [count(1)#473849L AS count#473850L]

(49) AdaptiveSparkPlan
Output [1]: [count#473850L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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