EVAL1_SPC2 - Details for Query 22

Details for Query 22

Submitted Time: 2025/09/15 13:33:23
Duration: 0 ms
Show the Stage ID and Task ID that corresponds to the max metric
Details
== Parsed Logical Plan ==
CreateViewCommand `ALIGNEMENT_NABM_2807108`, false, true, LocalTempView
   +- Project [CODE_LOINC_2810#5042, CODE_NABM_2808#5043, LIBELLE_LOINC_2811#5044, LIBELLE_NABM_2809#5045]
      +- Project [Code LOINC#5029 AS CODE_LOINC_2810#5042, Code NABM#5027 AS CODE_NABM_2808#5043, Libelle LOINC#5030 AS LIBELLE_LOINC_2811#5044, Libellé NABM#5028 AS LIBELLE_NABM_2809#5045]
         +- Project [Code NABM#5027, Libellé NABM#5028, Code LOINC#5029, Libelle LOINC#5030, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5031]
            +- Project [Code NABM#4997 AS Code NABM#5027, Libellé NABM#5003 AS Libellé NABM#5028, Code LOINC#5009 AS Code LOINC#5029, Libelle LOINC#5015 AS Libelle LOINC#5030, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5021 AS 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5031]
               +- Project [Code NABM#4997, Libellé NABM#5003, Code LOINC#5009, Libelle LOINC#5015, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991 AS 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5021]
                  +- Project [Code NABM#4997, Libellé NABM#5003, Code LOINC#5009, Libelle+LOINC#4990 AS Libelle LOINC#5015, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991]
                     +- Project [Code NABM#4997, Libellé NABM#5003, Code+LOINC#4989 AS Code LOINC#5009, Libelle+LOINC#4990, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991]
                        +- Project [Code NABM#4997, Libell%C3%A9+NABM#4988 AS Libellé NABM#5003, Code+LOINC#4989, Libelle+LOINC#4990, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991]
                           +- Project [Code+NABM#4987 AS Code NABM#4997, Libell%C3%A9+NABM#4988, Code+LOINC#4989, Libelle+LOINC#4990, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991]
                              +- Relation[Code+NABM#4987,Libell%C3%A9+NABM#4988,Code+LOINC#4989,Libelle+LOINC#4990,3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991] parquet

== Analyzed Logical Plan ==

CreateViewCommand `ALIGNEMENT_NABM_2807108`, false, true, LocalTempView
   +- Project [CODE_LOINC_2810#5042, CODE_NABM_2808#5043, LIBELLE_LOINC_2811#5044, LIBELLE_NABM_2809#5045]
      +- Project [Code LOINC#5029 AS CODE_LOINC_2810#5042, Code NABM#5027 AS CODE_NABM_2808#5043, Libelle LOINC#5030 AS LIBELLE_LOINC_2811#5044, Libellé NABM#5028 AS LIBELLE_NABM_2809#5045]
         +- Project [Code NABM#5027, Libellé NABM#5028, Code LOINC#5029, Libelle LOINC#5030, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5031]
            +- Project [Code NABM#4997 AS Code NABM#5027, Libellé NABM#5003 AS Libellé NABM#5028, Code LOINC#5009 AS Code LOINC#5029, Libelle LOINC#5015 AS Libelle LOINC#5030, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5021 AS 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5031]
               +- Project [Code NABM#4997, Libellé NABM#5003, Code LOINC#5009, Libelle LOINC#5015, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991 AS 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5021]
                  +- Project [Code NABM#4997, Libellé NABM#5003, Code LOINC#5009, Libelle+LOINC#4990 AS Libelle LOINC#5015, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991]
                     +- Project [Code NABM#4997, Libellé NABM#5003, Code+LOINC#4989 AS Code LOINC#5009, Libelle+LOINC#4990, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991]
                        +- Project [Code NABM#4997, Libell%C3%A9+NABM#4988 AS Libellé NABM#5003, Code+LOINC#4989, Libelle+LOINC#4990, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991]
                           +- Project [Code+NABM#4987 AS Code NABM#4997, Libell%C3%A9+NABM#4988, Code+LOINC#4989, Libelle+LOINC#4990, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991]
                              +- Relation[Code+NABM#4987,Libell%C3%A9+NABM#4988,Code+LOINC#4989,Libelle+LOINC#4990,3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991] parquet

== Optimized Logical Plan ==
CreateViewCommand `ALIGNEMENT_NABM_2807108`, false, true, LocalTempView
   +- Project [CODE_LOINC_2810#5042, CODE_NABM_2808#5043, LIBELLE_LOINC_2811#5044, LIBELLE_NABM_2809#5045]
      +- Project [Code LOINC#5029 AS CODE_LOINC_2810#5042, Code NABM#5027 AS CODE_NABM_2808#5043, Libelle LOINC#5030 AS LIBELLE_LOINC_2811#5044, Libellé NABM#5028 AS LIBELLE_NABM_2809#5045]
         +- Project [Code NABM#5027, Libellé NABM#5028, Code LOINC#5029, Libelle LOINC#5030, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5031]
            +- Project [Code NABM#4997 AS Code NABM#5027, Libellé NABM#5003 AS Libellé NABM#5028, Code LOINC#5009 AS Code LOINC#5029, Libelle LOINC#5015 AS Libelle LOINC#5030, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5021 AS 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5031]
               +- Project [Code NABM#4997, Libellé NABM#5003, Code LOINC#5009, Libelle LOINC#5015, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991 AS 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5021]
                  +- Project [Code NABM#4997, Libellé NABM#5003, Code LOINC#5009, Libelle+LOINC#4990 AS Libelle LOINC#5015, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991]
                     +- Project [Code NABM#4997, Libellé NABM#5003, Code+LOINC#4989 AS Code LOINC#5009, Libelle+LOINC#4990, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991]
                        +- Project [Code NABM#4997, Libell%C3%A9+NABM#4988 AS Libellé NABM#5003, Code+LOINC#4989, Libelle+LOINC#4990, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991]
                           +- Project [Code+NABM#4987 AS Code NABM#4997, Libell%C3%A9+NABM#4988, Code+LOINC#4989, Libelle+LOINC#4990, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991]
                              +- Relation[Code+NABM#4987,Libell%C3%A9+NABM#4988,Code+LOINC#4989,Libelle+LOINC#4990,3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991] parquet

== Physical Plan ==
Execute CreateViewCommand
   +- CreateViewCommand `ALIGNEMENT_NABM_2807108`, false, true, LocalTempView
         +- Project [CODE_LOINC_2810#5042, CODE_NABM_2808#5043, LIBELLE_LOINC_2811#5044, LIBELLE_NABM_2809#5045]
            +- Project [Code LOINC#5029 AS CODE_LOINC_2810#5042, Code NABM#5027 AS CODE_NABM_2808#5043, Libelle LOINC#5030 AS LIBELLE_LOINC_2811#5044, Libellé NABM#5028 AS LIBELLE_NABM_2809#5045]
               +- Project [Code NABM#5027, Libellé NABM#5028, Code LOINC#5029, Libelle LOINC#5030, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5031]
                  +- Project [Code NABM#4997 AS Code NABM#5027, Libellé NABM#5003 AS Libellé NABM#5028, Code LOINC#5009 AS Code LOINC#5029, Libelle LOINC#5015 AS Libelle LOINC#5030, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5021 AS 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5031]
                     +- Project [Code NABM#4997, Libellé NABM#5003, Code LOINC#5009, Libelle LOINC#5015, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991 AS 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5021]
                        +- Project [Code NABM#4997, Libellé NABM#5003, Code LOINC#5009, Libelle+LOINC#4990 AS Libelle LOINC#5015, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991]
                           +- Project [Code NABM#4997, Libellé NABM#5003, Code+LOINC#4989 AS Code LOINC#5009, Libelle+LOINC#4990, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991]
                              +- Project [Code NABM#4997, Libell%C3%A9+NABM#4988 AS Libellé NABM#5003, Code+LOINC#4989, Libelle+LOINC#4990, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991]
                                 +- Project [Code+NABM#4987 AS Code NABM#4997, Libell%C3%A9+NABM#4988, Code+LOINC#4989, Libelle+LOINC#4990, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991]
                                    +- Relation[Code+NABM#4987,Libell%C3%A9+NABM#4988,Code+LOINC#4989,Libelle+LOINC#4990,3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#4991] parquet