SP1 - Details for Query 2005

Submitted Time: 2026/11/05 12:23:52
Duration: 2 s
Succeeded Jobs: 2843 2844 2847

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 "]; 2 [labelType="html" label="ObjectHashAggregate number of output rows: 1,500 time in aggregation build: 17 ms spill size: 0.0 B number of sort fallback tasks: 1"]; 3 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 57.3 KiB number of coalesced partitions: 1"]; 4 [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 5380.0: task 5943)) 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 5380.0: task 5943)) 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 5380.0: task 5943))"]; 5 [labelType="html" label="ObjectHashAggregate number of output rows: 1,733 time in aggregation build total (min, med, max (stageId: taskId)) 11.9 s (1.0 s, 1.2 s, 1.3 s (stage 5380.0: task 5942)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 5380.0: task 5940)) number of sort fallback tasks: 10"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n11.9 s (1.0 s, 1.2 s, 1.3 s (stage 5380.0: task 5942))"; 7 [labelType="html" label=" Project "]; 8 [labelType="html" label=" Project "]; } 9 [labelType="html" label="CartesianProduct number of output rows: 2,139"]; 10 [labelType="html" label="CartesianProduct number of output rows: 2,139"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n11.9 s (1.1 s, 1.2 s, 1.3 s (stage 5380.0: task 5942))"; 12 [labelType="html" label=" Project "]; 13 [labelType="html" label="Filter number of output rows: 1,457,791"]; 14 [labelType="html" label="ColumnarToRow number of output rows: 2,199,023 number of input batches: 541"]; } 15 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 283 ms (18 ms, 26 ms, 47 ms (stage 5380.0: task 5942)) metadata time: 0 ms size of files read: 146.8 MiB number of output rows: 2,199,023"]; 16 [labelType="html" label="ObjectHashAggregate number of output rows: 10 time in aggregation build total (min, med, max (stageId: taskId)) 17 ms (0 ms, 1 ms, 9 ms (stage 5380.0: task 5940)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 5380.0: task 5940)) number of sort fallback tasks: 0"]; 17 [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 5380.0: task 5940)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 5380.0: task 5940)) 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"]; 18 [labelType="html" label="ObjectHashAggregate number of output rows: 1 time in aggregation build: 3 ms spill size: 0.0 B number of sort fallback tasks: 0"]; subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 3 ms"; 20 [labelType="html" label=" Project "]; } 21 [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 cluster22 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n25 ms (2 ms, 2 ms, 4 ms (stage 5380.0: task 5940))"; 23 [labelType="html" label=" Project "]; 24 [labelType="html" label="Filter number of output rows: 10"]; } 25 [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; 2->1; 3->2; 4->3; 5->4; 7->5; 8->7; 9->8; 10->9; 12->10; 13->12; 14->13; 15->14; 16->10; 17->16; 18->17; 20->18; 21->20; 23->9; 24->23; 25->24; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

ObjectHashAggregate(keys=[COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999], functions=[collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567, 0, 0), collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#472598, 0, 0)])

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, 10), ENSURE_REQUIREMENTS, [plan_id=193721]

ObjectHashAggregate(keys=[COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999], functions=[partial_collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567, 0, 0), partial_collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#472598, 0, 0)])

Project [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567, str_if_with_rule((NOT (COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567 <=> ) AND isnotnull(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567)), str_join(array(Déclencheur , COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#472002, : , Exécutant , COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989, @, str_join(array(str_extract(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#471988, RIGHT, 4), str_extract_middle(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#471988, 3, 2), str_extract(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#471988, LEFT, 2)), -)), ), null) AS COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#472598]

Project [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#471988, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#472002, str_if_with_rule(((((((COL_E43C6574_A3E3_4056_BB55_EA935E04502C#471995 <=> 1) AND (COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#471996 <=> 1)) AND (COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#472004 <=> 0)) AND (size(str_list_intersect_fixed(COL_3377534C_2BCD_43B6_853A_869D44C151B3#472003, [MCS]), true) <=> 0)) AND (size(str_list_intersect_fixed(99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#472358, array(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#472002)), true) > 0)) AND (((CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L < 16) END AND NOT (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 01)) OR (CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L < 26) END AND (((COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 17) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 33)) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 75)))) OR (COL_085E5798_40D8_4726_B01C_7D83841C9C25#472001 <=> O))), MCS, ) AS COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567]

WholeStageCodegen (4)

CartesianProduct

CartesianProduct (str_if_with_rule(((((((COL_E43C6574_A3E3_4056_BB55_EA935E04502C#471995 <=> 1) AND (COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#471996 <=> 1)) AND (COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#472004 <=> 0)) AND (size(str_list_intersect_fixed(COL_3377534C_2BCD_43B6_853A_869D44C151B3#472003, [MCS]), true) <=> 0)) AND (size(str_list_intersect_fixed(99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#472358, array(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#472002)), true) > 0)) AND (((CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L < 16) END AND NOT (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 01)) OR (CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L < 26) END AND (((COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 17) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 33)) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 75)))) OR (COL_085E5798_40D8_4726_B01C_7D83841C9C25#472001 <=> O))), MCS, ) <=> MCS)

Project [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#471744 AS COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#471988, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#471745 AS COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#471751 AS COL_E43C6574_A3E3_4056_BB55_EA935E04502C#471995, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#471752 AS COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#471996, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#471755 AS COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#471756L AS COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#471757 AS COL_085E5798_40D8_4726_B01C_7D83841C9C25#472001, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#471758 AS COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#472002, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#471759 AS COL_3377534C_2BCD_43B6_853A_869D44C151B3#472003, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#471761 AS COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#472004]

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

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#471744,COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#471745,COL_346C27DC_6D06_4FCF_A022_7FF177053D81#471751,COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#471752,COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#471755,COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#471756L,COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#471757,COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#471758,COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#471759,COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#471761] Batched: true, DataFilters: [NOT (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#471758 <=> ), 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#471826, 0, 0)])

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=193632]

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

Project [str_remove_space(Code-MCS#471808, ONLY_ONE) AS COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#471826]

WholeStageCodegen (1)

FileScan csv [Code-MCS#471808] 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#471720) AND (MCS = REGLES#471720)) AND (APPLICABLE#471721 <=> O))

WholeStageCodegen (3)

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


(1) Scan parquet 
Output [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#471744, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#471745, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#471751, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#471752, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#471755, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#471756L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#471757, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#471758, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#471759, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#471761]
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#471744, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#471745, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#471751, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#471752, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#471755, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#471756L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#471757, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#471758, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#471759, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#471761]

(3) Filter [codegen id : 2]
Input [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#471744, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#471745, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#471751, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#471752, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#471755, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#471756L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#471757, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#471758, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#471759, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#471761]
Condition : (NOT (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#471758 <=> ) AND isnotnull(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#471758))

(4) Project [codegen id : 2]
Output [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#471744 AS COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#471988, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#471745 AS COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#471751 AS COL_E43C6574_A3E3_4056_BB55_EA935E04502C#471995, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#471752 AS COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#471996, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#471755 AS COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#471756L AS COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#471757 AS COL_085E5798_40D8_4726_B01C_7D83841C9C25#472001, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#471758 AS COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#472002, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#471759 AS COL_3377534C_2BCD_43B6_853A_869D44C151B3#472003, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#471761 AS COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#472004]
Input [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#471744, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#471745, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#471751, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#471752, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#471755, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#471756L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#471757, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#471758, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#471759, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#471761]

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

(7) ObjectHashAggregate
Input [1]: [COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#471826]
Keys: []
Functions [1]: [partial_collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#471826, 0, 0)]
Aggregate Attributes [1]: [buf#472701]
Results [1]: [buf#472702]

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

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

(10) ObjectHashAggregate
Input [1]: [buf#472702]
Keys: []
Functions [1]: [collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#471826, 0, 0)]
Aggregate Attributes [1]: [collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#471826, 0, 0)#471831]
Results [1]: [collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#471826, 0, 0)#471831 AS 99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#472358]

(11) CartesianProduct
Join type: Inner
Join condition: (str_if_with_rule(((((((COL_E43C6574_A3E3_4056_BB55_EA935E04502C#471995 <=> 1) AND (COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#471996 <=> 1)) AND (COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#472004 <=> 0)) AND (size(str_list_intersect_fixed(COL_3377534C_2BCD_43B6_853A_869D44C151B3#472003, [MCS]), true) <=> 0)) AND (size(str_list_intersect_fixed(99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#472358, array(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#472002)), true) > 0)) AND (((CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L < 16) END AND NOT (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 01)) OR (CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L < 26) END AND (((COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 17) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 33)) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 75)))) OR (COL_085E5798_40D8_4726_B01C_7D83841C9C25#472001 <=> O))), MCS, ) <=> MCS)

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

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

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

(16) Project [codegen id : 4]
Output [5]: [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#471988, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#472002, str_if_with_rule(((((((COL_E43C6574_A3E3_4056_BB55_EA935E04502C#471995 <=> 1) AND (COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#471996 <=> 1)) AND (COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#472004 <=> 0)) AND (size(str_list_intersect_fixed(COL_3377534C_2BCD_43B6_853A_869D44C151B3#472003, [MCS]), true) <=> 0)) AND (size(str_list_intersect_fixed(99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#472358, array(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#472002)), true) > 0)) AND (((CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L < 16) END AND NOT (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 01)) OR (CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L < 26) END AND (((COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 17) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 33)) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 75)))) OR (COL_085E5798_40D8_4726_B01C_7D83841C9C25#472001 <=> O))), MCS, ) AS COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567]
Input [11]: [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#471988, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989, COL_E43C6574_A3E3_4056_BB55_EA935E04502C#471995, COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#471996, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L, COL_085E5798_40D8_4726_B01C_7D83841C9C25#472001, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#472002, COL_3377534C_2BCD_43B6_853A_869D44C151B3#472003, COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#472004, 99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#472358]

(17) Project [codegen id : 4]
Output [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567, str_if_with_rule((NOT (COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567 <=> ) AND isnotnull(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567)), str_join(array(Déclencheur , COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#472002, : , Exécutant , COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989, @, str_join(array(str_extract(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#471988, RIGHT, 4), str_extract_middle(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#471988, 3, 2), str_extract(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#471988, LEFT, 2)), -)),  ), null) AS COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#472598]
Input [5]: [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#471988, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#472002, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567]

(18) ObjectHashAggregate
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567, COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#472598]
Keys [1]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999]
Functions [2]: [partial_collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567, 0, 0), partial_collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#472598, 0, 0)]
Aggregate Attributes [2]: [buf#472697, buf#472698]
Results [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, buf#472699, buf#472700]

(19) Exchange
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, buf#472699, buf#472700]
Arguments: hashpartitioning(COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, 10), ENSURE_REQUIREMENTS, [plan_id=193721]

(20) ShuffleQueryStage
Output [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, buf#472699, buf#472700]
Arguments: 1

(21) AQEShuffleRead
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, buf#472699, buf#472700]
Arguments: coalesced

(22) ObjectHashAggregate
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, buf#472699, buf#472700]
Keys [1]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999]
Functions [2]: [collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567, 0, 0), collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#472598, 0, 0)]
Aggregate Attributes [2]: [collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567, 0, 0)#472656, collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#472598, 0, 0)#472658]
Results [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999 AS COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#472691, str_list_get(collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567, 0, 0)#472656, 0) AS COL_6841DD78_881F_4FF5_8139_B45CB0535307#472692, str_remove_extend(str_list_as_str(collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#472598, 0, 0)#472658), [[,],"]) AS COL_B71AED96_D44A_4496_B1D2_F66096545E56#472693]

(23) CollectLimit
Input [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#472691, COL_6841DD78_881F_4FF5_8139_B45CB0535307#472692, COL_B71AED96_D44A_4496_B1D2_F66096545E56#472693]
Arguments: 1500

(24) Filter
Input [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#471744, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#471745, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#471751, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#471752, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#471755, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#471756L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#471757, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#471758, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#471759, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#471761]
Condition : (NOT (COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#471758 <=> ) AND isnotnull(COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#471758))

(25) Project
Output [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#471744 AS COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#471988, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#471745 AS COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#471751 AS COL_E43C6574_A3E3_4056_BB55_EA935E04502C#471995, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#471752 AS COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#471996, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#471755 AS COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#471756L AS COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#471757 AS COL_085E5798_40D8_4726_B01C_7D83841C9C25#472001, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#471758 AS COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#472002, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#471759 AS COL_3377534C_2BCD_43B6_853A_869D44C151B3#472003, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#471761 AS COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#472004]
Input [10]: [COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#471744, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#471745, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#471751, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#471752, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#471755, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#471756L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#471757, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#471758, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#471759, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#471761]

(26) Project
Output [1]: [str_remove_space(Code-MCS#471808, ONLY_ONE) AS COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#471826]
Input [1]: [Code-MCS#471808]

(27) ObjectHashAggregate
Input [1]: [COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#471826]
Keys: []
Functions [1]: [partial_collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#471826, 0, 0)]
Aggregate Attributes [1]: [buf#472701]
Results [1]: [buf#472702]

(28) Exchange
Input [1]: [buf#472702]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=193589]

(29) ObjectHashAggregate
Input [1]: [buf#472702]
Keys: []
Functions [1]: [collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#471826, 0, 0)]
Aggregate Attributes [1]: [collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#471826, 0, 0)#471831]
Results [1]: [collect_set(COL_B3233636_E2EB_49EB_9DD1_68C9BAA0E86F#471826, 0, 0)#471831 AS 99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#472358]

(30) CartesianProduct
Join type: Inner
Join condition: (str_if_with_rule(((((((COL_E43C6574_A3E3_4056_BB55_EA935E04502C#471995 <=> 1) AND (COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#471996 <=> 1)) AND (COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#472004 <=> 0)) AND (size(str_list_intersect_fixed(COL_3377534C_2BCD_43B6_853A_869D44C151B3#472003, [MCS]), true) <=> 0)) AND (size(str_list_intersect_fixed(99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#472358, array(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#472002)), true) > 0)) AND (((CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L < 16) END AND NOT (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 01)) OR (CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L < 26) END AND (((COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 17) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 33)) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 75)))) OR (COL_085E5798_40D8_4726_B01C_7D83841C9C25#472001 <=> O))), MCS, ) <=> MCS)

(31) Filter
Input [2]: [REGLES#471720, APPLICABLE#471721]
Condition : ((isnotnull(REGLES#471720) AND (MCS = REGLES#471720)) AND (APPLICABLE#471721 <=> O))

(32) Project
Output: []
Input [2]: [REGLES#471720, APPLICABLE#471721]

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

(34) Project
Output [5]: [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#471988, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#472002, str_if_with_rule(((((((COL_E43C6574_A3E3_4056_BB55_EA935E04502C#471995 <=> 1) AND (COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#471996 <=> 1)) AND (COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#472004 <=> 0)) AND (size(str_list_intersect_fixed(COL_3377534C_2BCD_43B6_853A_869D44C151B3#472003, [MCS]), true) <=> 0)) AND (size(str_list_intersect_fixed(99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#472358, array(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#472002)), true) > 0)) AND (((CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L < 16) END AND NOT (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 01)) OR (CASE WHEN isnull(COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L) THEN false ELSE (COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L < 26) END AND (((COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 17) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 33)) OR (COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989 <=> 75)))) OR (COL_085E5798_40D8_4726_B01C_7D83841C9C25#472001 <=> O))), MCS, ) AS COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567]
Input [11]: [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#471988, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989, COL_E43C6574_A3E3_4056_BB55_EA935E04502C#471995, COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#471996, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, COL_414BA164_8DC3_4834_BDD7_434B2278858B#472000L, COL_085E5798_40D8_4726_B01C_7D83841C9C25#472001, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#472002, COL_3377534C_2BCD_43B6_853A_869D44C151B3#472003, COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#472004, 99_ACTES_ELIGIB_231708_COL_61C476F6_706A_4DB7_97C1_3E8CEB931839#472358]

(35) Project
Output [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567, str_if_with_rule((NOT (COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567 <=> ) AND isnotnull(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567)), str_join(array(Déclencheur , COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#472002, : , Exécutant , COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989, @, str_join(array(str_extract(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#471988, RIGHT, 4), str_extract_middle(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#471988, 3, 2), str_extract(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#471988, LEFT, 2)), -)),  ), null) AS COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#472598]
Input [5]: [COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#471988, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#471989, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#472002, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567]

(36) ObjectHashAggregate
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567, COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#472598]
Keys [1]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999]
Functions [2]: [partial_collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567, 0, 0), partial_collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#472598, 0, 0)]
Aggregate Attributes [2]: [buf#472697, buf#472698]
Results [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, buf#472699, buf#472700]

(37) Exchange
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, buf#472699, buf#472700]
Arguments: hashpartitioning(COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, 10), ENSURE_REQUIREMENTS, [plan_id=193597]

(38) ObjectHashAggregate
Input [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999, buf#472699, buf#472700]
Keys [1]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999]
Functions [2]: [collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567, 0, 0), collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#472598, 0, 0)]
Aggregate Attributes [2]: [collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567, 0, 0)#472656, collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#472598, 0, 0)#472658]
Results [3]: [COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#471999 AS COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#472691, str_list_get(collect_set(COL_5BD3501A_EDB6_4CA3_97B2_111DB176847B#472567, 0, 0)#472656, 0) AS COL_6841DD78_881F_4FF5_8139_B45CB0535307#472692, str_remove_extend(str_list_as_str(collect_set(COL_08680241_8EC9_4EA2_80D7_B4E741D5EB5C#472598, 0, 0)#472658), [[,],"]) AS COL_B71AED96_D44A_4496_B1D2_F66096545E56#472693]

(39) CollectLimit
Input [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#472691, COL_6841DD78_881F_4FF5_8139_B45CB0535307#472692, COL_B71AED96_D44A_4496_B1D2_F66096545E56#472693]
Arguments: 1500

(40) AdaptiveSparkPlan
Output [3]: [COL_DE03DDD5_DFD7_4921_8E39_F0B46AC88716#472691, COL_6841DD78_881F_4FF5_8139_B45CB0535307#472692, COL_B71AED96_D44A_4496_B1D2_F66096545E56#472693]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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