EVAL1_SPC2 - Details for Query 24

Details for Query 24

Submitted Time: 2025/09/15 13:33:24
Duration: 0 ms
Show the Stage ID and Task ID that corresponds to the max metric
Details
== Parsed Logical Plan ==
CreateViewCommand `ALIGNEMENT_NABM_2807111`, false, true, LocalTempView
   +- Project [CODE_LOINC_2810#5158, CODE_NABM_2808#5159, LIBELLE_LOINC_2811#5160, LIBELLE_NABM_2809#5161]
      +- Project [Code LOINC#5145 AS CODE_LOINC_2810#5158, Code NABM#5143 AS CODE_NABM_2808#5159, Libelle LOINC#5146 AS LIBELLE_LOINC_2811#5160, Libellé NABM#5144 AS LIBELLE_NABM_2809#5161]
         +- Project [Code NABM#5143, Libellé NABM#5144, Code LOINC#5145, Libelle LOINC#5146, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5147]
            +- Project [Code NABM#5113 AS Code NABM#5143, Libellé NABM#5119 AS Libellé NABM#5144, Code LOINC#5125 AS Code LOINC#5145, Libelle LOINC#5131 AS Libelle LOINC#5146, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5137 AS 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5147]
               +- Project [Code NABM#5113, Libellé NABM#5119, Code LOINC#5125, Libelle LOINC#5131, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107 AS 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5137]
                  +- Project [Code NABM#5113, Libellé NABM#5119, Code LOINC#5125, Libelle+LOINC#5106 AS Libelle LOINC#5131, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107]
                     +- Project [Code NABM#5113, Libellé NABM#5119, Code+LOINC#5105 AS Code LOINC#5125, Libelle+LOINC#5106, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107]
                        +- Project [Code NABM#5113, Libell%C3%A9+NABM#5104 AS Libellé NABM#5119, Code+LOINC#5105, Libelle+LOINC#5106, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107]
                           +- Project [Code+NABM#5103 AS Code NABM#5113, Libell%C3%A9+NABM#5104, Code+LOINC#5105, Libelle+LOINC#5106, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107]
                              +- Relation[Code+NABM#5103,Libell%C3%A9+NABM#5104,Code+LOINC#5105,Libelle+LOINC#5106,3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107] parquet

== Analyzed Logical Plan ==

CreateViewCommand `ALIGNEMENT_NABM_2807111`, false, true, LocalTempView
   +- Project [CODE_LOINC_2810#5158, CODE_NABM_2808#5159, LIBELLE_LOINC_2811#5160, LIBELLE_NABM_2809#5161]
      +- Project [Code LOINC#5145 AS CODE_LOINC_2810#5158, Code NABM#5143 AS CODE_NABM_2808#5159, Libelle LOINC#5146 AS LIBELLE_LOINC_2811#5160, Libellé NABM#5144 AS LIBELLE_NABM_2809#5161]
         +- Project [Code NABM#5143, Libellé NABM#5144, Code LOINC#5145, Libelle LOINC#5146, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5147]
            +- Project [Code NABM#5113 AS Code NABM#5143, Libellé NABM#5119 AS Libellé NABM#5144, Code LOINC#5125 AS Code LOINC#5145, Libelle LOINC#5131 AS Libelle LOINC#5146, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5137 AS 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5147]
               +- Project [Code NABM#5113, Libellé NABM#5119, Code LOINC#5125, Libelle LOINC#5131, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107 AS 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5137]
                  +- Project [Code NABM#5113, Libellé NABM#5119, Code LOINC#5125, Libelle+LOINC#5106 AS Libelle LOINC#5131, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107]
                     +- Project [Code NABM#5113, Libellé NABM#5119, Code+LOINC#5105 AS Code LOINC#5125, Libelle+LOINC#5106, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107]
                        +- Project [Code NABM#5113, Libell%C3%A9+NABM#5104 AS Libellé NABM#5119, Code+LOINC#5105, Libelle+LOINC#5106, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107]
                           +- Project [Code+NABM#5103 AS Code NABM#5113, Libell%C3%A9+NABM#5104, Code+LOINC#5105, Libelle+LOINC#5106, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107]
                              +- Relation[Code+NABM#5103,Libell%C3%A9+NABM#5104,Code+LOINC#5105,Libelle+LOINC#5106,3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107] parquet

== Optimized Logical Plan ==
CreateViewCommand `ALIGNEMENT_NABM_2807111`, false, true, LocalTempView
   +- Project [CODE_LOINC_2810#5158, CODE_NABM_2808#5159, LIBELLE_LOINC_2811#5160, LIBELLE_NABM_2809#5161]
      +- Project [Code LOINC#5145 AS CODE_LOINC_2810#5158, Code NABM#5143 AS CODE_NABM_2808#5159, Libelle LOINC#5146 AS LIBELLE_LOINC_2811#5160, Libellé NABM#5144 AS LIBELLE_NABM_2809#5161]
         +- Project [Code NABM#5143, Libellé NABM#5144, Code LOINC#5145, Libelle LOINC#5146, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5147]
            +- Project [Code NABM#5113 AS Code NABM#5143, Libellé NABM#5119 AS Libellé NABM#5144, Code LOINC#5125 AS Code LOINC#5145, Libelle LOINC#5131 AS Libelle LOINC#5146, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5137 AS 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5147]
               +- Project [Code NABM#5113, Libellé NABM#5119, Code LOINC#5125, Libelle LOINC#5131, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107 AS 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5137]
                  +- Project [Code NABM#5113, Libellé NABM#5119, Code LOINC#5125, Libelle+LOINC#5106 AS Libelle LOINC#5131, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107]
                     +- Project [Code NABM#5113, Libellé NABM#5119, Code+LOINC#5105 AS Code LOINC#5125, Libelle+LOINC#5106, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107]
                        +- Project [Code NABM#5113, Libell%C3%A9+NABM#5104 AS Libellé NABM#5119, Code+LOINC#5105, Libelle+LOINC#5106, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107]
                           +- Project [Code+NABM#5103 AS Code NABM#5113, Libell%C3%A9+NABM#5104, Code+LOINC#5105, Libelle+LOINC#5106, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107]
                              +- Relation[Code+NABM#5103,Libell%C3%A9+NABM#5104,Code+LOINC#5105,Libelle+LOINC#5106,3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107] parquet

== Physical Plan ==
Execute CreateViewCommand
   +- CreateViewCommand `ALIGNEMENT_NABM_2807111`, false, true, LocalTempView
         +- Project [CODE_LOINC_2810#5158, CODE_NABM_2808#5159, LIBELLE_LOINC_2811#5160, LIBELLE_NABM_2809#5161]
            +- Project [Code LOINC#5145 AS CODE_LOINC_2810#5158, Code NABM#5143 AS CODE_NABM_2808#5159, Libelle LOINC#5146 AS LIBELLE_LOINC_2811#5160, Libellé NABM#5144 AS LIBELLE_NABM_2809#5161]
               +- Project [Code NABM#5143, Libellé NABM#5144, Code LOINC#5145, Libelle LOINC#5146, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5147]
                  +- Project [Code NABM#5113 AS Code NABM#5143, Libellé NABM#5119 AS Libellé NABM#5144, Code LOINC#5125 AS Code LOINC#5145, Libelle LOINC#5131 AS Libelle LOINC#5146, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5137 AS 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5147]
                     +- Project [Code NABM#5113, Libellé NABM#5119, Code LOINC#5125, Libelle LOINC#5131, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107 AS 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5137]
                        +- Project [Code NABM#5113, Libellé NABM#5119, Code LOINC#5125, Libelle+LOINC#5106 AS Libelle LOINC#5131, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107]
                           +- Project [Code NABM#5113, Libellé NABM#5119, Code+LOINC#5105 AS Code LOINC#5125, Libelle+LOINC#5106, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107]
                              +- Project [Code NABM#5113, Libell%C3%A9+NABM#5104 AS Libellé NABM#5119, Code+LOINC#5105, Libelle+LOINC#5106, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107]
                                 +- Project [Code+NABM#5103 AS Code NABM#5113, Libell%C3%A9+NABM#5104, Code+LOINC#5105, Libelle+LOINC#5106, 3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107]
                                    +- Relation[Code+NABM#5103,Libell%C3%A9+NABM#5104,Code+LOINC#5105,Libelle+LOINC#5106,3DE21D73_16F0_4792_AAB2_181209819E7FHEADER_COL_DETAIL_DEPOT#5107] parquet