SP1 - Details for Query 2019

Submitted Time: 2026/11/05 12:24:06
Duration: 0.9 s
Succeeded Jobs: 2856 2857 2860

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" CollectLimit "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 49 ms"; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="Filter number of output rows: 1"]; } 5 [labelType="html" label="ObjectHashAggregate number of output rows: 1,733 time in aggregation build: 4 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 6 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 57.3 KiB number of coalesced partitions: 1"]; 7 [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 5402.0: task 5970)) 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 5402.0: task 5974)) 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 5402.0: task 5974))"]; 8 [labelType="html" label="ObjectHashAggregate number of output rows: 1,733 time in aggregation build total (min, med, max (stageId: taskId)) 5.9 s (550 ms, 561 ms, 649 ms (stage 5402.0: task 5970)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 5402.0: task 5972)) number of sort fallback tasks: 10"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n5.9 s (550 ms, 561 ms, 649 ms (stage 5402.0: task 5970))"; 10 [labelType="html" label=" Project "]; 11 [labelType="html" label=" Project "]; } 12 [labelType="html" label="CartesianProduct number of output rows: 2,139"]; 13 [labelType="html" label="CartesianProduct number of output rows: 2,139"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n5.9 s (554 ms, 565 ms, 654 ms (stage 5402.0: task 5976))"; 15 [labelType="html" label=" Project "]; 16 [labelType="html" label="Filter number of output rows: 1,457,791"]; 17 [labelType="html" label="ColumnarToRow number of output rows: 2,199,023 number of input batches: 541"]; } 18 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 206 ms (16 ms, 20 ms, 33 ms (stage 5402.0: task 5972)) metadata time: 0 ms size of files read: 146.8 MiB number of output rows: 2,199,023"]; 19 [labelType="html" label="ObjectHashAggregate number of output rows: 10 time in aggregation build total (min, med, max (stageId: taskId)) 11 ms (1 ms, 1 ms, 2 ms (stage 5402.0: task 5978)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 5402.0: task 5972)) number of sort fallback tasks: 0"]; 20 [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 5402.0: task 5972)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 5402.0: task 5972)) 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"]; 21 [labelType="html" label="ObjectHashAggregate number of output rows: 1 time in aggregation build: 6 ms spill size: 0.0 B number of sort fallback tasks: 0"]; subgraph cluster22 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 6 ms"; 23 [labelType="html" label=" Project "]; } 24 [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 cluster25 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n43 ms (3 ms, 4 ms, 6 ms (stage 5402.0: task 5976))"; 26 [labelType="html" label=" Project "]; 27 [labelType="html" label="Filter number of output rows: 10"]; } 28 [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"]; 1->0; 3->1; 4->3; 5->4; 6->5; 7->6; 8->7; 10->8; 11->10; 12->11; 13->12; 15->13; 16->15; 17->16; 18->17; 19->13; 20->19; 21->20; 23->21; 24->23; 26->12; 27->26; 28->27; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

Project [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#474925, str_list_get(COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#474955, 0) AS COL_6841DD78_881F_4FF5_8139_B45CB0535307#474990, str_remove_extend(str_list_as_str(COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#474957), [[,],"]) AS COL_B71AED96_D44A_4496_B1D2_F66096545E56#474991]

Filter ((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#474925)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#474925)), 030027795) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_list_get(COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#474955, 0))), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(str_list_get(COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#474955, 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#474957), [[,],"]))), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_extend(str_list_as_str(COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#474957), [[,],"]))), 030027795) END)

WholeStageCodegen (5)

ObjectHashAggregate(keys=[COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297], functions=[collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865, 0, 0), collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#474896, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, 10), ENSURE_REQUIREMENTS, [plan_id=194370]

ObjectHashAggregate(keys=[COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297], functions=[partial_collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865, 0, 0), partial_collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#474896, 0, 0)])

Project [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865, str_if_with_rule((NOT (COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865 <=> ) AND isnotnull(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865)), str_join(array(Déclencheur , COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#474300, : , Exécutant , COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287, @, str_join(array(str_extract(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#474286, RIGHT, 4), str_extract_middle(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#474286, 3, 2), str_extract(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#474286, LEFT, 2)), -)), ), null) AS COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#474896]

Project [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#474286, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#474300, str_if_with_rule(((((((COL_E43C6574_A3E3_4056_BB55_EA935E04502C#474293 <=> 1) AND (COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#474294 <=> 1)) AND (COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#474302 <=> 0)) AND (size(str_list_intersect_fixed(COL_3377534C_2BCD_43B6_853A_869D44C151B3#474301, [MCS]), true) <=> 0)) AND (size(str_list_intersect_fixed(99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#474656, array(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#474300)), true) > 0)) AND (((CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L < 16) END AND NOT (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 01)) OR (CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L < 26) END AND (((COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 17) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 33)) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 75)))) OR (COL_085E5798_40D8_4726_B01C_7D83841C9C25#474299 <=> O))), MCS, ) AS COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865]

WholeStageCodegen (4)

CartesianProduct

CartesianProduct (str_if_with_rule(((((((COL_E43C6574_A3E3_4056_BB55_EA935E04502C#474293 <=> 1) AND (COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#474294 <=> 1)) AND (COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#474302 <=> 0)) AND (size(str_list_intersect_fixed(COL_3377534C_2BCD_43B6_853A_869D44C151B3#474301, [MCS]), true) <=> 0)) AND (size(str_list_intersect_fixed(99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#474656, array(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#474300)), true) > 0)) AND (((CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L < 16) END AND NOT (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 01)) OR (CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L < 26) END AND (((COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 17) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 33)) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 75)))) OR (COL_085E5798_40D8_4726_B01C_7D83841C9C25#474299 <=> O))), MCS, ) <=> MCS)

Project [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#474042 AS COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#474286, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#474043 AS COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#474049 AS COL_E43C6574_A3E3_4056_BB55_EA935E04502C#474293, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#474050 AS COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#474294, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#474053 AS COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#474054L AS COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#474055 AS COL_085E5798_40D8_4726_B01C_7D83841C9C25#474299, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#474056 AS COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#474300, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#474057 AS COL_3377534C_2BCD_43B6_853A_869D44C151B3#474301, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#474059 AS COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#474302]

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

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#474042,COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#474043,COL_346C27DC_6D06_4FCF_A022_7FF177053D81#474049,COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#474050,COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#474053,COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#474054L,COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#474055,COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#474056,COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#474057,COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#474059] Batched: true, DataFilters: [NOT (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#474056 <=> ), 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#474124, 0, 0)])

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=194271]

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

Project [str_remove_space(Code-MCS#474106, ONLY_ONE) AS COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#474124]

WholeStageCodegen (1)

FileScan csv [Code-MCS#474106] 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#474018) AND (MCS = REGLES#474018)) AND (APPLICABLE#474019 <=> O))

WholeStageCodegen (3)

FileScan csv [REGLES#474018,APPLICABLE#474019] Batched: false, DataFilters: [isnotnull(REGLES#474018), (MCS = REGLES#474018), (APPLICABLE#474019 <=> 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 (44)
+- == Final Plan ==
   CollectLimit (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 ==
   CollectLimit (43)
   +- Project (42)
      +- Filter (41)
         +- ObjectHashAggregate (40)
            +- Exchange (39)
               +- ObjectHashAggregate (38)
                  +- Project (37)
                     +- Project (36)
                        +- CartesianProduct Inner (35)
                           :- CartesianProduct Inner (32)
                           :  :- Project (27)
                           :  :  +- Filter (26)
                           :  :     +- Scan parquet  (1)
                           :  +- ObjectHashAggregate (31)
                           :     +- Exchange (30)
                           :        +- ObjectHashAggregate (29)
                           :           +- Project (28)
                           :              +- Scan csv  (5)
                           +- Project (34)
                              +- Filter (33)
                                 +- Scan csv  (12)


(1) Scan parquet 
Output [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#474042, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#474043, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#474049, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#474050, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#474053, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#474054L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#474055, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#474056, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#474057, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#474059]
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#474042, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#474043, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#474049, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#474050, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#474053, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#474054L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#474055, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#474056, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#474057, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#474059]

(3) Filter [codegen id : 2]
Input [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#474042, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#474043, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#474049, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#474050, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#474053, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#474054L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#474055, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#474056, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#474057, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#474059]
Condition : (NOT (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#474056 <=> ) AND isnotnull(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#474056))

(4) Project [codegen id : 2]
Output [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#474042 AS COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#474286, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#474043 AS COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#474049 AS COL_E43C6574_A3E3_4056_BB55_EA935E04502C#474293, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#474050 AS COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#474294, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#474053 AS COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#474054L AS COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#474055 AS COL_085E5798_40D8_4726_B01C_7D83841C9C25#474299, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#474056 AS COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#474300, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#474057 AS COL_3377534C_2BCD_43B6_853A_869D44C151B3#474301, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#474059 AS COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#474302]
Input [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#474042, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#474043, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#474049, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#474050, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#474053, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#474054L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#474055, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#474056, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#474057, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#474059]

(5) Scan csv 
Output [1]: [Code-MCS#474106]
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#474106, ONLY_ONE) AS COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#474124]
Input [1]: [Code-MCS#474106]

(7) ObjectHashAggregate
Input [1]: [COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#474124]
Keys: []
Functions [1]: [partial_collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#474124, 0, 0)]
Aggregate Attributes [1]: [buf#474999]
Results [1]: [buf#475000]

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

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

(10) ObjectHashAggregate
Input [1]: [buf#475000]
Keys: []
Functions [1]: [collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#474124, 0, 0)]
Aggregate Attributes [1]: [collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#474124, 0, 0)#474129]
Results [1]: [collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#474124, 0, 0)#474129 AS 99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#474656]

(11) CartesianProduct
Join type: Inner
Join condition: (str_if_with_rule(((((((COL_E43C6574_A3E3_4056_BB55_EA935E04502C#474293 <=> 1) AND (COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#474294 <=> 1)) AND (COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#474302 <=> 0)) AND (size(str_list_intersect_fixed(COL_3377534C_2BCD_43B6_853A_869D44C151B3#474301, [MCS]), true) <=> 0)) AND (size(str_list_intersect_fixed(99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#474656, array(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#474300)), true) > 0)) AND (((CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L < 16) END AND NOT (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 01)) OR (CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L < 26) END AND (((COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 17) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 33)) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 75)))) OR (COL_085E5798_40D8_4726_B01C_7D83841C9C25#474299 <=> O))), MCS, ) <=> MCS)

(12) Scan csv 
Output [2]: [REGLES#474018, APPLICABLE#474019]
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#474018, APPLICABLE#474019]
Condition : ((isnotnull(REGLES#474018) AND (MCS = REGLES#474018)) AND (APPLICABLE#474019 <=> O))

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

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

(16) Project [codegen id : 4]
Output [5]: [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#474286, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#474300, str_if_with_rule(((((((COL_E43C6574_A3E3_4056_BB55_EA935E04502C#474293 <=> 1) AND (COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#474294 <=> 1)) AND (COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#474302 <=> 0)) AND (size(str_list_intersect_fixed(COL_3377534C_2BCD_43B6_853A_869D44C151B3#474301, [MCS]), true) <=> 0)) AND (size(str_list_intersect_fixed(99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#474656, array(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#474300)), true) > 0)) AND (((CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L < 16) END AND NOT (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 01)) OR (CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L < 26) END AND (((COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 17) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 33)) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 75)))) OR (COL_085E5798_40D8_4726_B01C_7D83841C9C25#474299 <=> O))), MCS, ) AS COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865]
Input [11]: [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#474286, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287, COL_E43C6574_A3E3_4056_BB55_EA935E04502C#474293, COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#474294, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L, COL_085E5798_40D8_4726_B01C_7D83841C9C25#474299, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#474300, COL_3377534C_2BCD_43B6_853A_869D44C151B3#474301, COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#474302, 99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#474656]

(17) Project [codegen id : 4]
Output [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865, str_if_with_rule((NOT (COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865 <=> ) AND isnotnull(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865)), str_join(array(Déclencheur , COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#474300, : , Exécutant , COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287, @, str_join(array(str_extract(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#474286, RIGHT, 4), str_extract_middle(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#474286, 3, 2), str_extract(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#474286, LEFT, 2)), -)),  ), null) AS COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#474896]
Input [5]: [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#474286, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#474300, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865]

(18) ObjectHashAggregate
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865, COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#474896]
Keys [1]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297]
Functions [2]: [partial_collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865, 0, 0), partial_collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#474896, 0, 0)]
Aggregate Attributes [2]: [buf#474995, buf#474996]
Results [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, buf#474997, buf#474998]

(19) Exchange
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, buf#474997, buf#474998]
Arguments: hashpartitioning(COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, 10), ENSURE_REQUIREMENTS, [plan_id=194370]

(20) ShuffleQueryStage
Output [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, buf#474997, buf#474998]
Arguments: 1

(21) AQEShuffleRead
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, buf#474997, buf#474998]
Arguments: coalesced

(22) ObjectHashAggregate
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, buf#474997, buf#474998]
Keys [1]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297]
Functions [2]: [collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865, 0, 0), collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#474896, 0, 0)]
Aggregate Attributes [2]: [collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865, 0, 0)#474954, collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#474896, 0, 0)#474956]
Results [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297 AS COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#474925, collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865, 0, 0)#474954 AS COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#474955, collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#474896, 0, 0)#474956 AS COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#474957]

(23) Filter [codegen id : 5]
Input [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#474925, COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#474955, COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#474957]
Condition : ((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#474925)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#474925)), 030027795) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_list_get(COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#474955, 0))), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(str_list_get(COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#474955, 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#474957), [[,],"]))), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_extend(str_list_as_str(COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#474957), [[,],"]))), 030027795) END)

(24) Project [codegen id : 5]
Output [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#474925, str_list_get(COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#474955, 0) AS COL_6841DD78_881F_4FF5_8139_B45CB0535307#474990, str_remove_extend(str_list_as_str(COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#474957), [[,],"]) AS COL_B71AED96_D44A_4496_B1D2_F66096545E56#474991]
Input [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#474925, COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#474955, COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#474957]

(25) CollectLimit
Input [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#474925, COL_6841DD78_881F_4FF5_8139_B45CB0535307#474990, COL_B71AED96_D44A_4496_B1D2_F66096545E56#474991]
Arguments: 1500

(26) Filter
Input [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#474042, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#474043, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#474049, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#474050, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#474053, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#474054L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#474055, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#474056, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#474057, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#474059]
Condition : (NOT (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#474056 <=> ) AND isnotnull(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#474056))

(27) Project
Output [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#474042 AS COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#474286, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#474043 AS COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#474049 AS COL_E43C6574_A3E3_4056_BB55_EA935E04502C#474293, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#474050 AS COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#474294, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#474053 AS COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#474054L AS COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#474055 AS COL_085E5798_40D8_4726_B01C_7D83841C9C25#474299, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#474056 AS COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#474300, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#474057 AS COL_3377534C_2BCD_43B6_853A_869D44C151B3#474301, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#474059 AS COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#474302]
Input [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#474042, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#474043, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#474049, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#474050, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#474053, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#474054L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#474055, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#474056, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#474057, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#474059]

(28) Project
Output [1]: [str_remove_space(Code-MCS#474106, ONLY_ONE) AS COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#474124]
Input [1]: [Code-MCS#474106]

(29) ObjectHashAggregate
Input [1]: [COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#474124]
Keys: []
Functions [1]: [partial_collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#474124, 0, 0)]
Aggregate Attributes [1]: [buf#474999]
Results [1]: [buf#475000]

(30) Exchange
Input [1]: [buf#475000]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=194226]

(31) ObjectHashAggregate
Input [1]: [buf#475000]
Keys: []
Functions [1]: [collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#474124, 0, 0)]
Aggregate Attributes [1]: [collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#474124, 0, 0)#474129]
Results [1]: [collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#474124, 0, 0)#474129 AS 99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#474656]

(32) CartesianProduct
Join type: Inner
Join condition: (str_if_with_rule(((((((COL_E43C6574_A3E3_4056_BB55_EA935E04502C#474293 <=> 1) AND (COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#474294 <=> 1)) AND (COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#474302 <=> 0)) AND (size(str_list_intersect_fixed(COL_3377534C_2BCD_43B6_853A_869D44C151B3#474301, [MCS]), true) <=> 0)) AND (size(str_list_intersect_fixed(99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#474656, array(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#474300)), true) > 0)) AND (((CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L < 16) END AND NOT (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 01)) OR (CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L < 26) END AND (((COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 17) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 33)) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 75)))) OR (COL_085E5798_40D8_4726_B01C_7D83841C9C25#474299 <=> O))), MCS, ) <=> MCS)

(33) Filter
Input [2]: [REGLES#474018, APPLICABLE#474019]
Condition : ((isnotnull(REGLES#474018) AND (MCS = REGLES#474018)) AND (APPLICABLE#474019 <=> O))

(34) Project
Output: []
Input [2]: [REGLES#474018, APPLICABLE#474019]

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

(36) Project
Output [5]: [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#474286, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#474300, str_if_with_rule(((((((COL_E43C6574_A3E3_4056_BB55_EA935E04502C#474293 <=> 1) AND (COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#474294 <=> 1)) AND (COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#474302 <=> 0)) AND (size(str_list_intersect_fixed(COL_3377534C_2BCD_43B6_853A_869D44C151B3#474301, [MCS]), true) <=> 0)) AND (size(str_list_intersect_fixed(99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#474656, array(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#474300)), true) > 0)) AND (((CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L < 16) END AND NOT (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 01)) OR (CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L < 26) END AND (((COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 17) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 33)) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287 <=> 75)))) OR (COL_085E5798_40D8_4726_B01C_7D83841C9C25#474299 <=> O))), MCS, ) AS COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865]
Input [11]: [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#474286, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287, COL_E43C6574_A3E3_4056_BB55_EA935E04502C#474293, COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#474294, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, COL_414BA164_8DC3_4834_BDD7_434B2278858B#474298L, COL_085E5798_40D8_4726_B01C_7D83841C9C25#474299, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#474300, COL_3377534C_2BCD_43B6_853A_869D44C151B3#474301, COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#474302, 99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#474656]

(37) Project
Output [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865, str_if_with_rule((NOT (COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865 <=> ) AND isnotnull(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865)), str_join(array(Déclencheur , COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#474300, : , Exécutant , COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287, @, str_join(array(str_extract(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#474286, RIGHT, 4), str_extract_middle(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#474286, 3, 2), str_extract(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#474286, LEFT, 2)), -)),  ), null) AS COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#474896]
Input [5]: [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#474286, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#474287, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#474300, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865]

(38) ObjectHashAggregate
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865, COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#474896]
Keys [1]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297]
Functions [2]: [partial_collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865, 0, 0), partial_collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#474896, 0, 0)]
Aggregate Attributes [2]: [buf#474995, buf#474996]
Results [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, buf#474997, buf#474998]

(39) Exchange
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, buf#474997, buf#474998]
Arguments: hashpartitioning(COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, 10), ENSURE_REQUIREMENTS, [plan_id=194234]

(40) ObjectHashAggregate
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297, buf#474997, buf#474998]
Keys [1]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297]
Functions [2]: [collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865, 0, 0), collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#474896, 0, 0)]
Aggregate Attributes [2]: [collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865, 0, 0)#474954, collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#474896, 0, 0)#474956]
Results [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#474297 AS COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#474925, collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#474865, 0, 0)#474954 AS COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#474955, collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#474896, 0, 0)#474956 AS COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#474957]

(41) Filter
Input [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#474925, COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#474955, COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#474957]
Condition : ((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#474925)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#474925)), 030027795) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_list_get(COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#474955, 0))), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(str_list_get(COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#474955, 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#474957), [[,],"]))), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_extend(str_list_as_str(COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#474957), [[,],"]))), 030027795) END)

(42) Project
Output [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#474925, str_list_get(COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#474955, 0) AS COL_6841DD78_881F_4FF5_8139_B45CB0535307#474990, str_remove_extend(str_list_as_str(COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#474957), [[,],"]) AS COL_B71AED96_D44A_4496_B1D2_F66096545E56#474991]
Input [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#474925, COL_D333C639_088D_43C6_B7CE_3AFF1AB0255F#474955, COL_3A253AA5_CE2C_4C9B_9EE6_E66674D9388A#474957]

(43) CollectLimit
Input [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#474925, COL_6841DD78_881F_4FF5_8139_B45CB0535307#474990, COL_B71AED96_D44A_4496_B1D2_F66096545E56#474991]
Arguments: 1500

(44) AdaptiveSparkPlan
Output [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#474925, COL_6841DD78_881F_4FF5_8139_B45CB0535307#474990, COL_B71AED96_D44A_4496_B1D2_F66096545E56#474991]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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