SP1 - Details for Query 1133

Submitted Time: 2026/02/24 11:26:36
Duration: 1 s
Succeeded Jobs: 1572 1573 1574

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

digraph G { 0 [labelType="html" label=" CollectLimit "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n1.7 s (201 ms, 250 ms, 278 ms (stage 2646.0: task 2883))"; 2 [labelType="html" label="Generate number of output rows: 1,393"]; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label="Filter number of output rows: 7"]; } 7 [labelType="html" label="Scan binaryFile number of output rows: 7 number of files read: 7 metadata time: 0 ms size of files read: 992.7 KiB"]; 2->0; 3->2; 4->3; 5->4; 6->5; 7->6; }

CollectLimit 1500

Generate explode(COL_469EFA20_191C_4DC7_9CD8_0A53C7DD5971#366486), [COL_3C649F11_28BE_40DA_9284_7D133F0BDDDF#365779, COL_17CBFBBC_3C4A_4EF9_99E1_8702A6403839#365802, COL_656B6785_84B9_4F34_9B6C_FF1B58D2C34F#365808, COL_5335420E_9689_4256_AAB6_453C581D354F#365814, COL_6EF443FA_76A3_4344_9967_3B41C56C7756#365821, COL_DDC5874D_33D6_47DF_A9F9_E17B31A76E68#365829, COL_0189A0EB_342F_4238_B610_826096943A6B#365838, COL_4B2B383B_9955_47E6_B537_13C9D580C841#365848, COL_BEE7D440_B13E_4FA6_83DC_FEB16333375B#365859, COL_1FCAB66B_3948_40BF_97DB_6A25E48C0634#365871, COL_453F8A3E_E9E7_4628_9178_9D883043DA30#365884, COL_C35255C5_4F27_4BEE_8FB2_E304A813ECE0#365898, COL_0CCF8C26_8F50_41D8_8D88_070D908479CA#365913, COL_0697C562_970C_4B4A_B7AE_1B26B300A44D#365929, COL_FCD24561_D7BD_4275_AE9A_AAAC63D4F8A1#365946, COL_725A5B67_9D2F_49E8_B04E_F37FAE7066C0#365964, COL_5122D98D_7C95_48C9_BC35_73AC9907388C#365983, COL_D0CE9BA7_491A_4AEB_818A_6EBA373C5684#366003, COL_C56A490E_2758_4A70_9D2C_EFFBD36BEE57#366024, COL_E00A9D2D_9F77_4292_B180_FEB83A0CC118#366046, COL_ABE3AB68_C0CD_46A7_AAE4_B2834887AA17#366069, COL_BB50CC04_C887_4A06_9360_881E85DFBB03#366093, COL_0C084E5E_5751_43B4_B325_B12D251A0976#366118, COL_8F72D23A_3D85_436B_8827_9D53B246D2C5#366480, ... 5 more fields], false, [COL_4594B752_72F8_457F_B37D_B0AB041DF9AC#366518]

Project [COL_3C649F11_28BE_40DA_9284_7D133F0BDDDF#365779, COL_17CBFBBC_3C4A_4EF9_99E1_8702A6403839#365802, COL_656B6785_84B9_4F34_9B6C_FF1B58D2C34F#365808, COL_5335420E_9689_4256_AAB6_453C581D354F#365814, COL_6EF443FA_76A3_4344_9967_3B41C56C7756#365821, COL_DDC5874D_33D6_47DF_A9F9_E17B31A76E68#365829, COL_0189A0EB_342F_4238_B610_826096943A6B#365838, COL_4B2B383B_9955_47E6_B537_13C9D580C841#365848, COL_BEE7D440_B13E_4FA6_83DC_FEB16333375B#365859, COL_1FCAB66B_3948_40BF_97DB_6A25E48C0634#365871, COL_453F8A3E_E9E7_4628_9178_9D883043DA30#365884, COL_C35255C5_4F27_4BEE_8FB2_E304A813ECE0#365898, COL_0CCF8C26_8F50_41D8_8D88_070D908479CA#365913, COL_0697C562_970C_4B4A_B7AE_1B26B300A44D#365929, COL_FCD24561_D7BD_4275_AE9A_AAAC63D4F8A1#365946, COL_725A5B67_9D2F_49E8_B04E_F37FAE7066C0#365964, COL_5122D98D_7C95_48C9_BC35_73AC9907388C#365983, COL_D0CE9BA7_491A_4AEB_818A_6EBA373C5684#366003, COL_C56A490E_2758_4A70_9D2C_EFFBD36BEE57#366024, COL_E00A9D2D_9F77_4292_B180_FEB83A0CC118#366046, COL_ABE3AB68_C0CD_46A7_AAE4_B2834887AA17#366069, COL_BB50CC04_C887_4A06_9360_881E85DFBB03#366093, COL_0C084E5E_5751_43B4_B325_B12D251A0976#366118, str_remove(str_extract(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, str_concat(array(Vérifié sur site client par (Calibrated by) , COL_0C084E5E_5751_43B4_B325_B12D251A0976#366118)), RIGHT), LEFT, 14), Le ) AS COL_8F72D23A_3D85_436B_8827_9D53B246D2C5#366480, ... 6 more fields]

Project [COL_3C649F11_28BE_40DA_9284_7D133F0BDDDF#365779, COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, str_if_with_rule(CASE WHEN isnull(Contains(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, CONSTAT DE VERIFICATION)) THEN false ELSE Contains(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, CONSTAT DE VERIFICATION) END, CONSTAT DE VERIFICATION, ) AS COL_17CBFBBC_3C4A_4EF9_99E1_8702A6403839#365802, str_replace(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, D, @) AS COL_758B1283_3781_4144_805B_8852891BBBE3#365803, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Désignation (Designation) :, RIGHT), Marque, LEFT), ONLY_ONE) AS COL_656B6785_84B9_4F34_9B6C_FF1B58D2C34F#365808, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Notre référence (Our reference) : , RIGHT), CONSTAT, LEFT), ONLY_ONE) AS COL_5335420E_9689_4256_AAB6_453C581D354F#365814, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Marque (Manufacturer) :, RIGHT), N° de série, LEFT), ONLY_ONE) AS COL_6EF443FA_76A3_4344_9967_3B41C56C7756#365821, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, N° de série (Serial number) : , RIGHT), Modèle, LEFT), ONLY_ONE) AS COL_DDC5874D_33D6_47DF_A9F9_E17B31A76E68#365829, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Modèle (Model) :, RIGHT), Identification, LEFT), ONLY_ONE) AS COL_0189A0EB_342F_4238_B610_826096943A6B#365838, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Identification client (Customer ID) :, RIGHT), Jugement, LEFT), ONLY_ONE) AS COL_4B2B383B_9955_47E6_B537_13C9D580C841#365848, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Date de vérification (Calibration Date) :, RIGHT), Désignation, LEFT), ONLY_ONE) AS COL_BEE7D440_B13E_4FA6_83DC_FEB16333375B#365859, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Procédure(s) utilisée(s) :, RIGHT), (Used procedure(s)), LEFT), ONLY_ONE) AS COL_1FCAB66B_3948_40BF_97DB_6A25E48C0634#365871, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, pécifications de référence : , RIGHT), (Reference specifications), LEFT), ONLY_ONE) AS COL_453F8A3E_E9E7_4628_9178_9D883043DA30#365884, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, (For verified functions or characteristics), RIGHT), Observations, LEFT), ONLY_ONE) AS COL_C35255C5_4F27_4BEE_8FB2_E304A813ECE0#365898, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Observations(Remarks), RIGHT), Ce document, LEFT), ONLY_ONE) AS COL_0CCF8C26_8F50_41D8_8D88_070D908479CA#365913, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Ce document comprend (this document includes) :, RIGHT), Date d'émission, LEFT), ONLY_ONE) AS COL_0697C562_970C_4B4A_B7AE_1B26B300A44D#365929, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Date d'émission (Issue date) :, RIGHT), Technicien, LEFT), ONLY_ONE) AS COL_FCD24561_D7BD_4275_AE9A_AAAC63D4F8A1#365946, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, couverture de 95%., RIGHT), Ce document, LEFT), ONLY_ONE) AS COL_725A5B67_9D2F_49E8_B04E_F37FAE7066C0#365964, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Motif de l'envoi (shipping reason) :, RIGHT), Etat du matériel avant intervention, LEFT), ONLY_ONE) AS COL_5122D98D_7C95_48C9_BC35_73AC9907388C#365983, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Etat du matériel avant intervention (Instrument status before operation) :, RIGHT), Nature de l'intervention réalisée, LEFT), ONLY_ONE) AS COL_D0CE9BA7_491A_4AEB_818A_6EBA373C5684#366003, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Nature de l'intervention réalisée (Operation type) :, RIGHT), Etat du matériel après intervention, LEFT), ONLY_ONE) AS COL_C56A490E_2758_4A70_9D2C_EFFBD36BEE57#366024, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Etat du matériel après intervention (Instrument status after operation) :, RIGHT), Conditions d'environnement, LEFT), ONLY_ONE) AS COL_E00A9D2D_9F77_4292_B180_FEB83A0CC118#366046, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Conditions d'environnement (Environmental conditions) :, RIGHT), Liste des étalons, LEFT), ONLY_ONE) AS COL_ABE3AB68_C0CD_46A7_AAE4_B2834887AA17#366069, str_if_with_rule(CASE WHEN isnull(Contains(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Informations complémentaires sur l'intervention (Additional informations) :)) THEN false ELSE Contains(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Informations complémentaires sur l'intervention (Additional informations) :) END, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Informations complémentaires sur l'intervention (Additional informations) :, RIGHT), Le , LEFT), ONLY_ONE), ) AS COL_BB50CC04_C887_4A06_9360_881E85DFBB03#366093, str_if_with_rule(CASE WHEN isnull(Contains(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Vérifié sur site client par (Calibrated by))) THEN false ELSE Contains(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Vérifié sur site client par (Calibrated by)) END, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Vérifié sur site client par (Calibrated by), RIGHT), Le , LEFT), ONLY_ONE), ) AS COL_0C084E5E_5751_43B4_B325_B12D251A0976#366118]

Project [substring_index(path#365701, /, -1) AS COL_3C649F11_28BE_40DA_9284_7D133F0BDDDF#365779, bin_content_str(pdf, content#365704) AS COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780]

Filter ((size(str_split_from_regex(bin_content_str(pdf, content#365704), \r?\n), true) > 0) AND isnotnull(str_split_from_regex(bin_content_str(pdf, content#365704), \r?\n)))

WholeStageCodegen (1)

FileScan binaryFile [path#365701,content#365704] Batched: false, DataFilters: [(size(str_split_from_regex(bin_content_str(pdf, content#365704), \r?\n), true) > 0), isnotnull(s..., Format: org.apache.spark.sql.execution.datasources.binaryfile.BinaryFileFormat@359ef889, Location: InMemoryFileIndex(7 paths)[file:/data/input/depot/binary/execution/A225B276_202D_4198_B6C6_5BF504..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<path:string,content:binary>

Details

== Physical Plan ==
CollectLimit (7)
+- * Generate (6)
   +- * Project (5)
      +- * Project (4)
         +- * Project (3)
            +- * Filter (2)
               +- Scan binaryFile  (1)


(1) Scan binaryFile 
Output [2]: [path#365701, content#365704]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/binary/execution/A225B276_202D_4198_B6C6_5BF504CB2545/current/1000388971_FR240100933.PDF, ... 6 entries]
ReadSchema: struct<path:string,content:binary>

(2) Filter [codegen id : 1]
Input [2]: [path#365701, content#365704]
Condition : ((size(str_split_from_regex(bin_content_str(pdf, content#365704), \r?\n), true) > 0) AND isnotnull(str_split_from_regex(bin_content_str(pdf, content#365704), \r?\n)))

(3) Project [codegen id : 1]
Output [2]: [substring_index(path#365701, /, -1) AS COL_3C649F11_28BE_40DA_9284_7D133F0BDDDF#365779, bin_content_str(pdf, content#365704) AS COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780]
Input [2]: [path#365701, content#365704]

(4) Project [codegen id : 1]
Output [25]: [COL_3C649F11_28BE_40DA_9284_7D133F0BDDDF#365779, COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, str_if_with_rule(CASE WHEN isnull(Contains(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, CONSTAT DE VERIFICATION)) THEN false ELSE Contains(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, CONSTAT DE VERIFICATION) END, CONSTAT DE VERIFICATION, ) AS COL_17CBFBBC_3C4A_4EF9_99E1_8702A6403839#365802, str_replace(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, D, @) AS COL_758B1283_3781_4144_805B_8852891BBBE3#365803, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Désignation (Designation) :, RIGHT), Marque, LEFT), ONLY_ONE) AS COL_656B6785_84B9_4F34_9B6C_FF1B58D2C34F#365808, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Notre référence (Our reference) : , RIGHT), CONSTAT, LEFT), ONLY_ONE) AS COL_5335420E_9689_4256_AAB6_453C581D354F#365814, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Marque (Manufacturer)  :, RIGHT), N° de série, LEFT), ONLY_ONE) AS COL_6EF443FA_76A3_4344_9967_3B41C56C7756#365821, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, N° de série (Serial number) : , RIGHT), Modèle, LEFT), ONLY_ONE) AS COL_DDC5874D_33D6_47DF_A9F9_E17B31A76E68#365829, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Modèle (Model) :, RIGHT), Identification, LEFT), ONLY_ONE) AS COL_0189A0EB_342F_4238_B610_826096943A6B#365838, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Identification client (Customer ID)  :, RIGHT), Jugement, LEFT), ONLY_ONE) AS COL_4B2B383B_9955_47E6_B537_13C9D580C841#365848, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Date de vérification (Calibration Date) :, RIGHT), Désignation, LEFT), ONLY_ONE) AS COL_BEE7D440_B13E_4FA6_83DC_FEB16333375B#365859, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Procédure(s) utilisée(s) :, RIGHT), (Used procedure(s)), LEFT), ONLY_ONE) AS COL_1FCAB66B_3948_40BF_97DB_6A25E48C0634#365871, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, pécifications de référence : , RIGHT), (Reference specifications), LEFT), ONLY_ONE) AS COL_453F8A3E_E9E7_4628_9178_9D883043DA30#365884, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, (For verified functions or characteristics), RIGHT), Observations, LEFT), ONLY_ONE) AS COL_C35255C5_4F27_4BEE_8FB2_E304A813ECE0#365898, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Observations(Remarks), RIGHT), Ce document, LEFT), ONLY_ONE) AS COL_0CCF8C26_8F50_41D8_8D88_070D908479CA#365913, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Ce document comprend (this document includes) :, RIGHT), Date d'émission, LEFT), ONLY_ONE) AS COL_0697C562_970C_4B4A_B7AE_1B26B300A44D#365929, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Date d'émission (Issue date) :, RIGHT), Technicien, LEFT), ONLY_ONE) AS COL_FCD24561_D7BD_4275_AE9A_AAAC63D4F8A1#365946, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, couverture de 95%., RIGHT), Ce document, LEFT), ONLY_ONE) AS COL_725A5B67_9D2F_49E8_B04E_F37FAE7066C0#365964, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Motif de l'envoi (shipping reason) :, RIGHT), Etat du matériel avant intervention, LEFT), ONLY_ONE) AS COL_5122D98D_7C95_48C9_BC35_73AC9907388C#365983, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Etat du matériel avant intervention (Instrument status before operation) :, RIGHT), Nature de l'intervention réalisée, LEFT), ONLY_ONE) AS COL_D0CE9BA7_491A_4AEB_818A_6EBA373C5684#366003, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Nature de l'intervention réalisée (Operation type) :, RIGHT), Etat du matériel après intervention, LEFT), ONLY_ONE) AS COL_C56A490E_2758_4A70_9D2C_EFFBD36BEE57#366024, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Etat du matériel après intervention (Instrument status after operation) :, RIGHT), Conditions d'environnement, LEFT), ONLY_ONE) AS COL_E00A9D2D_9F77_4292_B180_FEB83A0CC118#366046, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Conditions d'environnement (Environmental conditions) :, RIGHT), Liste des étalons, LEFT), ONLY_ONE) AS COL_ABE3AB68_C0CD_46A7_AAE4_B2834887AA17#366069, str_if_with_rule(CASE WHEN isnull(Contains(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Informations complémentaires sur l'intervention (Additional informations) :)) THEN false ELSE Contains(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Informations complémentaires sur l'intervention (Additional informations) :) END, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Informations complémentaires sur l'intervention (Additional informations) :, RIGHT), Le , LEFT), ONLY_ONE), ) AS COL_BB50CC04_C887_4A06_9360_881E85DFBB03#366093, str_if_with_rule(CASE WHEN isnull(Contains(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Vérifié sur site client par (Calibrated by))) THEN false ELSE Contains(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Vérifié sur site client par (Calibrated by)) END, str_remove_space(str_extract_by_str(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Vérifié sur site client par (Calibrated by), RIGHT), Le , LEFT), ONLY_ONE), ) AS COL_0C084E5E_5751_43B4_B325_B12D251A0976#366118]
Input [2]: [COL_3C649F11_28BE_40DA_9284_7D133F0BDDDF#365779, COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780]

(5) Project [codegen id : 1]
Output [30]: [COL_3C649F11_28BE_40DA_9284_7D133F0BDDDF#365779, COL_17CBFBBC_3C4A_4EF9_99E1_8702A6403839#365802, COL_656B6785_84B9_4F34_9B6C_FF1B58D2C34F#365808, COL_5335420E_9689_4256_AAB6_453C581D354F#365814, COL_6EF443FA_76A3_4344_9967_3B41C56C7756#365821, COL_DDC5874D_33D6_47DF_A9F9_E17B31A76E68#365829, COL_0189A0EB_342F_4238_B610_826096943A6B#365838, COL_4B2B383B_9955_47E6_B537_13C9D580C841#365848, COL_BEE7D440_B13E_4FA6_83DC_FEB16333375B#365859, COL_1FCAB66B_3948_40BF_97DB_6A25E48C0634#365871, COL_453F8A3E_E9E7_4628_9178_9D883043DA30#365884, COL_C35255C5_4F27_4BEE_8FB2_E304A813ECE0#365898, COL_0CCF8C26_8F50_41D8_8D88_070D908479CA#365913, COL_0697C562_970C_4B4A_B7AE_1B26B300A44D#365929, COL_FCD24561_D7BD_4275_AE9A_AAAC63D4F8A1#365946, COL_725A5B67_9D2F_49E8_B04E_F37FAE7066C0#365964, COL_5122D98D_7C95_48C9_BC35_73AC9907388C#365983, COL_D0CE9BA7_491A_4AEB_818A_6EBA373C5684#366003, COL_C56A490E_2758_4A70_9D2C_EFFBD36BEE57#366024, COL_E00A9D2D_9F77_4292_B180_FEB83A0CC118#366046, COL_ABE3AB68_C0CD_46A7_AAE4_B2834887AA17#366069, COL_BB50CC04_C887_4A06_9360_881E85DFBB03#366093, COL_0C084E5E_5751_43B4_B325_B12D251A0976#366118, str_remove(str_extract(str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, str_concat(array(Vérifié sur site client par (Calibrated by) , COL_0C084E5E_5751_43B4_B325_B12D251A0976#366118)), RIGHT), LEFT, 14), Le ) AS COL_8F72D23A_3D85_436B_8827_9D53B246D2C5#366480, COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, COL_758B1283_3781_4144_805B_8852891BBBE3#365803, str_split_from_regex(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, \n) AS COL_D6735A7B_91A1_4727_ACF2_E6636EA9E049#366483, str_if_with_rule(CASE WHEN isnull(Contains(COL_0697C562_970C_4B4A_B7AE_1B26B300A44D#365929, annexe)) THEN false ELSE Contains(COL_0697C562_970C_4B4A_B7AE_1B26B300A44D#365929, annexe) END, Oui, Non) AS COL_EBC768C2_BACB_4DB0_B017_B3865BB577D4#366484, str_extract_by_str(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, Informations complémentaires sur l'intervention, RIGHT) AS COL_DF6F84F1_C4B2_4465_AE7E_17203DB132D9#366485, str_split_from_regex(COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, \r?\n) AS COL_469EFA20_191C_4DC7_9CD8_0A53C7DD5971#366486]
Input [25]: [COL_3C649F11_28BE_40DA_9284_7D133F0BDDDF#365779, COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, COL_17CBFBBC_3C4A_4EF9_99E1_8702A6403839#365802, COL_758B1283_3781_4144_805B_8852891BBBE3#365803, COL_656B6785_84B9_4F34_9B6C_FF1B58D2C34F#365808, COL_5335420E_9689_4256_AAB6_453C581D354F#365814, COL_6EF443FA_76A3_4344_9967_3B41C56C7756#365821, COL_DDC5874D_33D6_47DF_A9F9_E17B31A76E68#365829, COL_0189A0EB_342F_4238_B610_826096943A6B#365838, COL_4B2B383B_9955_47E6_B537_13C9D580C841#365848, COL_BEE7D440_B13E_4FA6_83DC_FEB16333375B#365859, COL_1FCAB66B_3948_40BF_97DB_6A25E48C0634#365871, COL_453F8A3E_E9E7_4628_9178_9D883043DA30#365884, COL_C35255C5_4F27_4BEE_8FB2_E304A813ECE0#365898, COL_0CCF8C26_8F50_41D8_8D88_070D908479CA#365913, COL_0697C562_970C_4B4A_B7AE_1B26B300A44D#365929, COL_FCD24561_D7BD_4275_AE9A_AAAC63D4F8A1#365946, COL_725A5B67_9D2F_49E8_B04E_F37FAE7066C0#365964, COL_5122D98D_7C95_48C9_BC35_73AC9907388C#365983, COL_D0CE9BA7_491A_4AEB_818A_6EBA373C5684#366003, COL_C56A490E_2758_4A70_9D2C_EFFBD36BEE57#366024, COL_E00A9D2D_9F77_4292_B180_FEB83A0CC118#366046, COL_ABE3AB68_C0CD_46A7_AAE4_B2834887AA17#366069, COL_BB50CC04_C887_4A06_9360_881E85DFBB03#366093, COL_0C084E5E_5751_43B4_B325_B12D251A0976#366118]

(6) Generate [codegen id : 1]
Input [30]: [COL_3C649F11_28BE_40DA_9284_7D133F0BDDDF#365779, COL_17CBFBBC_3C4A_4EF9_99E1_8702A6403839#365802, COL_656B6785_84B9_4F34_9B6C_FF1B58D2C34F#365808, COL_5335420E_9689_4256_AAB6_453C581D354F#365814, COL_6EF443FA_76A3_4344_9967_3B41C56C7756#365821, COL_DDC5874D_33D6_47DF_A9F9_E17B31A76E68#365829, COL_0189A0EB_342F_4238_B610_826096943A6B#365838, COL_4B2B383B_9955_47E6_B537_13C9D580C841#365848, COL_BEE7D440_B13E_4FA6_83DC_FEB16333375B#365859, COL_1FCAB66B_3948_40BF_97DB_6A25E48C0634#365871, COL_453F8A3E_E9E7_4628_9178_9D883043DA30#365884, COL_C35255C5_4F27_4BEE_8FB2_E304A813ECE0#365898, COL_0CCF8C26_8F50_41D8_8D88_070D908479CA#365913, COL_0697C562_970C_4B4A_B7AE_1B26B300A44D#365929, COL_FCD24561_D7BD_4275_AE9A_AAAC63D4F8A1#365946, COL_725A5B67_9D2F_49E8_B04E_F37FAE7066C0#365964, COL_5122D98D_7C95_48C9_BC35_73AC9907388C#365983, COL_D0CE9BA7_491A_4AEB_818A_6EBA373C5684#366003, COL_C56A490E_2758_4A70_9D2C_EFFBD36BEE57#366024, COL_E00A9D2D_9F77_4292_B180_FEB83A0CC118#366046, COL_ABE3AB68_C0CD_46A7_AAE4_B2834887AA17#366069, COL_BB50CC04_C887_4A06_9360_881E85DFBB03#366093, COL_0C084E5E_5751_43B4_B325_B12D251A0976#366118, COL_8F72D23A_3D85_436B_8827_9D53B246D2C5#366480, COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, COL_758B1283_3781_4144_805B_8852891BBBE3#365803, COL_D6735A7B_91A1_4727_ACF2_E6636EA9E049#366483, COL_EBC768C2_BACB_4DB0_B017_B3865BB577D4#366484, COL_DF6F84F1_C4B2_4465_AE7E_17203DB132D9#366485, COL_469EFA20_191C_4DC7_9CD8_0A53C7DD5971#366486]
Arguments: explode(COL_469EFA20_191C_4DC7_9CD8_0A53C7DD5971#366486), [COL_3C649F11_28BE_40DA_9284_7D133F0BDDDF#365779, COL_17CBFBBC_3C4A_4EF9_99E1_8702A6403839#365802, COL_656B6785_84B9_4F34_9B6C_FF1B58D2C34F#365808, COL_5335420E_9689_4256_AAB6_453C581D354F#365814, COL_6EF443FA_76A3_4344_9967_3B41C56C7756#365821, COL_DDC5874D_33D6_47DF_A9F9_E17B31A76E68#365829, COL_0189A0EB_342F_4238_B610_826096943A6B#365838, COL_4B2B383B_9955_47E6_B537_13C9D580C841#365848, COL_BEE7D440_B13E_4FA6_83DC_FEB16333375B#365859, COL_1FCAB66B_3948_40BF_97DB_6A25E48C0634#365871, COL_453F8A3E_E9E7_4628_9178_9D883043DA30#365884, COL_C35255C5_4F27_4BEE_8FB2_E304A813ECE0#365898, COL_0CCF8C26_8F50_41D8_8D88_070D908479CA#365913, COL_0697C562_970C_4B4A_B7AE_1B26B300A44D#365929, COL_FCD24561_D7BD_4275_AE9A_AAAC63D4F8A1#365946, COL_725A5B67_9D2F_49E8_B04E_F37FAE7066C0#365964, COL_5122D98D_7C95_48C9_BC35_73AC9907388C#365983, COL_D0CE9BA7_491A_4AEB_818A_6EBA373C5684#366003, COL_C56A490E_2758_4A70_9D2C_EFFBD36BEE57#366024, COL_E00A9D2D_9F77_4292_B180_FEB83A0CC118#366046, COL_ABE3AB68_C0CD_46A7_AAE4_B2834887AA17#366069, COL_BB50CC04_C887_4A06_9360_881E85DFBB03#366093, COL_0C084E5E_5751_43B4_B325_B12D251A0976#366118, COL_8F72D23A_3D85_436B_8827_9D53B246D2C5#366480, ... 5 more fields], false, [COL_4594B752_72F8_457F_B37D_B0AB041DF9AC#366518]

(7) CollectLimit
Input [30]: [COL_3C649F11_28BE_40DA_9284_7D133F0BDDDF#365779, COL_17CBFBBC_3C4A_4EF9_99E1_8702A6403839#365802, COL_656B6785_84B9_4F34_9B6C_FF1B58D2C34F#365808, COL_5335420E_9689_4256_AAB6_453C581D354F#365814, COL_6EF443FA_76A3_4344_9967_3B41C56C7756#365821, COL_DDC5874D_33D6_47DF_A9F9_E17B31A76E68#365829, COL_0189A0EB_342F_4238_B610_826096943A6B#365838, COL_4B2B383B_9955_47E6_B537_13C9D580C841#365848, COL_BEE7D440_B13E_4FA6_83DC_FEB16333375B#365859, COL_1FCAB66B_3948_40BF_97DB_6A25E48C0634#365871, COL_453F8A3E_E9E7_4628_9178_9D883043DA30#365884, COL_C35255C5_4F27_4BEE_8FB2_E304A813ECE0#365898, COL_0CCF8C26_8F50_41D8_8D88_070D908479CA#365913, COL_0697C562_970C_4B4A_B7AE_1B26B300A44D#365929, COL_FCD24561_D7BD_4275_AE9A_AAAC63D4F8A1#365946, COL_725A5B67_9D2F_49E8_B04E_F37FAE7066C0#365964, COL_5122D98D_7C95_48C9_BC35_73AC9907388C#365983, COL_D0CE9BA7_491A_4AEB_818A_6EBA373C5684#366003, COL_C56A490E_2758_4A70_9D2C_EFFBD36BEE57#366024, COL_E00A9D2D_9F77_4292_B180_FEB83A0CC118#366046, COL_ABE3AB68_C0CD_46A7_AAE4_B2834887AA17#366069, COL_BB50CC04_C887_4A06_9360_881E85DFBB03#366093, COL_0C084E5E_5751_43B4_B325_B12D251A0976#366118, COL_8F72D23A_3D85_436B_8827_9D53B246D2C5#366480, COL_25C0411F_59CC_4FF2_887B_24431933C85F#365780, COL_758B1283_3781_4144_805B_8852891BBBE3#365803, COL_D6735A7B_91A1_4727_ACF2_E6636EA9E049#366483, COL_EBC768C2_BACB_4DB0_B017_B3865BB577D4#366484, COL_DF6F84F1_C4B2_4465_AE7E_17203DB132D9#366485, COL_4594B752_72F8_457F_B37D_B0AB041DF9AC#366518]
Arguments: 1500

SQL / DataFrame Properties

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