EVAL1_SPC2 - Details for Query 40

Details for Query 40

Submitted Time: 2025/09/15 13:42:38
Duration: 0.6 s
Succeeded Jobs: 57
Show the Stage ID and Task ID that corresponds to the max metric
digraph G { 0 [labelType="html" label="Execute InsertIntoHadoopFsRelationCommand number of written files: 1 written output: 2.3 MiB number of output rows: 60,245 number of dynamic part: 0"]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 466 ms"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="ColumnarToRow number of output rows: 60,245 number of input batches: 15"]; } 4 [labelType="html" label="Scan parquet number of files read: 1 scan time: 26 ms metadata time: 0 ms size of files read: 2.4 MiB number of output rows: 60,245"]; 2->0; 3->2; 4->3; }
Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/LOINC_2_22_2_78_2787, false, Parquet, [path=file:///data/output/cache/parquet/uet/LOINC_2_22_2_78_2787], Overwrite, [CHAPITRE_2798, CODE_LOINC_2788, COMPOSANT_ANGLA_2790, COMPOSANT_FRANC_2791, DATE_DE_RETRAIT_2803, DATE_DE_RETRAIT_2804, DATE_DE_VALIDAT_2799, ECHELLE_2796, GRANDEUR_2793, LIBELLE_FRANCAI_2789, MILIEU_BIOLOGIQ_2795, REMPLACE_PAR_2805, STATUT_2801, SYNONYMES_2792, TECHNIQUE_2797, TEMPS_2794, VERSION_DE_L_IT_2802, VERSION_VP_2800]
Project [Chapitre#6032 AS CHAPITRE_2798#6497, Code+LOINC#6022 AS CODE_LOINC_2788#6498, Composant+anglais#6024 AS COMPOSANT_ANGLA_2790#6499, Composant+fran%C3%A7ais#6025 AS COMPOSANT_FRANC_2791#6500, cast(Date+de+retrait+ANS#6037 as timestamp) AS DATE_DE_RETRAIT_2803#6501, cast(Date+de+retrait+LOINC#6038 as timestamp) AS DATE_DE_RETRAIT_2804#6502, cast(Date+de+validation#6033 as timestamp) AS DATE_DE_VALIDAT_2799#6503, Echelle#6030 AS ECHELLE_2796#6504, Grandeur#6027 AS GRANDEUR_2793#6505, Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#6023 AS LIBELLE_FRANCAI_2789#6506, Milieu+biologique#6029 AS MILIEU_BIOLOGIQ_2795#6507, Remplac%C3%A9+par#6039 AS REMPLACE_PAR_2805#6508, Statut#6035 AS STATUT_2801#6509, Synonymes#6026 AS SYNONYMES_2792#6510, Technique#6031 AS TECHNIQUE_2797#6511, Temps#6028 AS TEMPS_2794#6512, Version+de+l%27item+corrig%C3%A9#6036 AS VERSION_DE_L_IT_2802#6513, Version+VP#6034 AS VERSION_VP_2800#6514]
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [Code+LOINC#6022,Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#6023,Composant+anglais#6024,Composant+fran%C3%A7ais#6025,Synonymes#6026,Grandeur#6027,Temps#6028,Milieu+biologique#6029,Echelle#6030,Technique#6031,Chapitre#6032,Date+de+validation#6033,Version+VP#6034,Statut#6035,Version+de+l%27item+corrig%C3%A9#6036,Date+de+retrait+ANS#6037,Date+de+retrait+LOINC#6038,Remplac%C3%A9+par#6039] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/input/depot/excel/cache/43778DA4_23A5_4A60_95C2_DFAED1C9CE0E_654677b..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<Code+LOINC:string,Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence:string,Composant+angla...
Details
== Parsed Logical Plan ==
InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/LOINC_2_22_2_78_2787, false, Parquet, [path=file:///data/output/cache/parquet/uet/LOINC_2_22_2_78_2787], Overwrite, [CHAPITRE_2798, CODE_LOINC_2788, COMPOSANT_ANGLA_2790, COMPOSANT_FRANC_2791, DATE_DE_RETRAIT_2803, DATE_DE_RETRAIT_2804, DATE_DE_VALIDAT_2799, ECHELLE_2796, GRANDEUR_2793, LIBELLE_FRANCAI_2789, MILIEU_BIOLOGIQ_2795, REMPLACE_PAR_2805, STATUT_2801, SYNONYMES_2792, TECHNIQUE_2797, TEMPS_2794, VERSION_DE_L_IT_2802, VERSION_VP_2800]
+- Project [CHAPITRE_2798#6497, CODE_LOINC_2788#6498, COMPOSANT_ANGLA_2790#6499, COMPOSANT_FRANC_2791#6500, DATE_DE_RETRAIT_2803#6501, DATE_DE_RETRAIT_2804#6502, DATE_DE_VALIDAT_2799#6503, ECHELLE_2796#6504, GRANDEUR_2793#6505, LIBELLE_FRANCAI_2789#6506, MILIEU_BIOLOGIQ_2795#6507, REMPLACE_PAR_2805#6508, STATUT_2801#6509, SYNONYMES_2792#6510, TECHNIQUE_2797#6511, TEMPS_2794#6512, VERSION_DE_L_IT_2802#6513, VERSION_VP_2800#6514]
   +- Project [Chapitre#6450 AS CHAPITRE_2798#6497, Code LOINC#6440 AS CODE_LOINC_2788#6498, Composant anglais#6442 AS COMPOSANT_ANGLA_2790#6499, Composant français#6443 AS COMPOSANT_FRANC_2791#6500, to_timestamp(Date de retrait ANS#6455, None) AS DATE_DE_RETRAIT_2803#6501, to_timestamp(Date de retrait LOINC#6456, None) AS DATE_DE_RETRAIT_2804#6502, to_timestamp(Date de validation#6451, None) AS DATE_DE_VALIDAT_2799#6503, Echelle#6448 AS ECHELLE_2796#6504, Grandeur#6445 AS GRANDEUR_2793#6505, Libellé français de référence#6441 AS LIBELLE_FRANCAI_2789#6506, Milieu biologique#6447 AS MILIEU_BIOLOGIQ_2795#6507, Remplacé par#6457 AS REMPLACE_PAR_2805#6508, Statut#6453 AS STATUT_2801#6509, Synonymes#6444 AS SYNONYMES_2792#6510, Technique#6449 AS TECHNIQUE_2797#6511, Temps#6446 AS TEMPS_2794#6512, Version de l'item corrigé#6454 AS VERSION_DE_L_IT_2802#6513, Version VP#6452 AS VERSION_VP_2800#6514]
      +- Project [Code LOINC#6440, Libellé français de référence#6441, Composant anglais#6442, Composant français#6443, Synonymes#6444, Grandeur#6445, Temps#6446, Milieu biologique#6447, Echelle#6448, Technique#6449, Chapitre#6450, Date de validation#6451, Version VP#6452, Statut#6453, Version de l'item corrigé#6454, Date de retrait ANS#6455, Date de retrait LOINC#6456, Remplacé par#6457, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6458]
         +- Project [Code LOINC#6060 AS Code LOINC#6440, Libellé français de référence#6080 AS Libellé français de référence#6441, Composant anglais#6100 AS Composant anglais#6442, Composant français#6120 AS Composant français#6443, Synonymes#6140 AS Synonymes#6444, Grandeur#6160 AS Grandeur#6445, Temps#6180 AS Temps#6446, Milieu biologique#6200 AS Milieu biologique#6447, Echelle#6220 AS Echelle#6448, Technique#6240 AS Technique#6449, Chapitre#6260 AS Chapitre#6450, Date de validation#6280 AS Date de validation#6451, Version VP#6300 AS Version VP#6452, Statut#6320 AS Statut#6453, Version de l'item corrigé#6340 AS Version de l'item corrigé#6454, Date de retrait ANS#6360 AS Date de retrait ANS#6455, Date de retrait LOINC#6380 AS Date de retrait LOINC#6456, Remplacé par#6400 AS Remplacé par#6457, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6420 AS 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6458]
            +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6240, Chapitre#6260, Date de validation#6280, Version VP#6300, Statut#6320, Version de l'item corrigé#6340, Date de retrait ANS#6360, Date de retrait LOINC#6380, Remplacé par#6400, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040 AS 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6420]
               +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6240, Chapitre#6260, Date de validation#6280, Version VP#6300, Statut#6320, Version de l'item corrigé#6340, Date de retrait ANS#6360, Date de retrait LOINC#6380, Remplac%C3%A9+par#6039 AS Remplacé par#6400, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                  +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6240, Chapitre#6260, Date de validation#6280, Version VP#6300, Statut#6320, Version de l'item corrigé#6340, Date de retrait ANS#6360, Date+de+retrait+LOINC#6038 AS Date de retrait LOINC#6380, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                     +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6240, Chapitre#6260, Date de validation#6280, Version VP#6300, Statut#6320, Version de l'item corrigé#6340, Date+de+retrait+ANS#6037 AS Date de retrait ANS#6360, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                        +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6240, Chapitre#6260, Date de validation#6280, Version VP#6300, Statut#6320, Version+de+l%27item+corrig%C3%A9#6036 AS Version de l'item corrigé#6340, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                           +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6240, Chapitre#6260, Date de validation#6280, Version VP#6300, Statut#6035 AS Statut#6320, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                              +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6240, Chapitre#6260, Date de validation#6280, Version+VP#6034 AS Version VP#6300, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                 +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6240, Chapitre#6260, Date+de+validation#6033 AS Date de validation#6280, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                    +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6240, Chapitre#6032 AS Chapitre#6260, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                       +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6031 AS Technique#6240, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                          +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6030 AS Echelle#6220, Technique#6031, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                             +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu+biologique#6029 AS Milieu biologique#6200, Echelle#6030, Technique#6031, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                                +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6028 AS Temps#6180, Milieu+biologique#6029, Echelle#6030, Technique#6031, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                                   +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6027 AS Grandeur#6160, Temps#6028, Milieu+biologique#6029, Echelle#6030, Technique#6031, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                                      +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6026 AS Synonymes#6140, Grandeur#6027, Temps#6028, Milieu+biologique#6029, Echelle#6030, Technique#6031, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                                         +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant+fran%C3%A7ais#6025 AS Composant français#6120, Synonymes#6026, Grandeur#6027, Temps#6028, Milieu+biologique#6029, Echelle#6030, Technique#6031, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                                            +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant+anglais#6024 AS Composant anglais#6100, Composant+fran%C3%A7ais#6025, Synonymes#6026, Grandeur#6027, Temps#6028, Milieu+biologique#6029, Echelle#6030, Technique#6031, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                                               +- Project [Code LOINC#6060, Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#6023 AS Libellé français de référence#6080, Composant+anglais#6024, Composant+fran%C3%A7ais#6025, Synonymes#6026, Grandeur#6027, Temps#6028, Milieu+biologique#6029, Echelle#6030, Technique#6031, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                                                  +- Project [Code+LOINC#6022 AS Code LOINC#6060, Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#6023, Composant+anglais#6024, Composant+fran%C3%A7ais#6025, Synonymes#6026, Grandeur#6027, Temps#6028, Milieu+biologique#6029, Echelle#6030, Technique#6031, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                                                     +- Relation[Code+LOINC#6022,Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#6023,Composant+anglais#6024,Composant+fran%C3%A7ais#6025,Synonymes#6026,Grandeur#6027,Temps#6028,Milieu+biologique#6029,Echelle#6030,Technique#6031,Chapitre#6032,Date+de+validation#6033,Version+VP#6034,Statut#6035,Version+de+l%27item+corrig%C3%A9#6036,Date+de+retrait+ANS#6037,Date+de+retrait+LOINC#6038,Remplac%C3%A9+par#6039,43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040] parquet

== Analyzed Logical Plan ==

InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/LOINC_2_22_2_78_2787, false, Parquet, [path=file:///data/output/cache/parquet/uet/LOINC_2_22_2_78_2787], Overwrite, [CHAPITRE_2798, CODE_LOINC_2788, COMPOSANT_ANGLA_2790, COMPOSANT_FRANC_2791, DATE_DE_RETRAIT_2803, DATE_DE_RETRAIT_2804, DATE_DE_VALIDAT_2799, ECHELLE_2796, GRANDEUR_2793, LIBELLE_FRANCAI_2789, MILIEU_BIOLOGIQ_2795, REMPLACE_PAR_2805, STATUT_2801, SYNONYMES_2792, TECHNIQUE_2797, TEMPS_2794, VERSION_DE_L_IT_2802, VERSION_VP_2800]
+- Project [CHAPITRE_2798#6497, CODE_LOINC_2788#6498, COMPOSANT_ANGLA_2790#6499, COMPOSANT_FRANC_2791#6500, DATE_DE_RETRAIT_2803#6501, DATE_DE_RETRAIT_2804#6502, DATE_DE_VALIDAT_2799#6503, ECHELLE_2796#6504, GRANDEUR_2793#6505, LIBELLE_FRANCAI_2789#6506, MILIEU_BIOLOGIQ_2795#6507, REMPLACE_PAR_2805#6508, STATUT_2801#6509, SYNONYMES_2792#6510, TECHNIQUE_2797#6511, TEMPS_2794#6512, VERSION_DE_L_IT_2802#6513, VERSION_VP_2800#6514]
   +- Project [Chapitre#6450 AS CHAPITRE_2798#6497, Code LOINC#6440 AS CODE_LOINC_2788#6498, Composant anglais#6442 AS COMPOSANT_ANGLA_2790#6499, Composant français#6443 AS COMPOSANT_FRANC_2791#6500, to_timestamp(Date de retrait ANS#6455, None) AS DATE_DE_RETRAIT_2803#6501, to_timestamp(Date de retrait LOINC#6456, None) AS DATE_DE_RETRAIT_2804#6502, to_timestamp(Date de validation#6451, None) AS DATE_DE_VALIDAT_2799#6503, Echelle#6448 AS ECHELLE_2796#6504, Grandeur#6445 AS GRANDEUR_2793#6505, Libellé français de référence#6441 AS LIBELLE_FRANCAI_2789#6506, Milieu biologique#6447 AS MILIEU_BIOLOGIQ_2795#6507, Remplacé par#6457 AS REMPLACE_PAR_2805#6508, Statut#6453 AS STATUT_2801#6509, Synonymes#6444 AS SYNONYMES_2792#6510, Technique#6449 AS TECHNIQUE_2797#6511, Temps#6446 AS TEMPS_2794#6512, Version de l'item corrigé#6454 AS VERSION_DE_L_IT_2802#6513, Version VP#6452 AS VERSION_VP_2800#6514]
      +- Project [Code LOINC#6440, Libellé français de référence#6441, Composant anglais#6442, Composant français#6443, Synonymes#6444, Grandeur#6445, Temps#6446, Milieu biologique#6447, Echelle#6448, Technique#6449, Chapitre#6450, Date de validation#6451, Version VP#6452, Statut#6453, Version de l'item corrigé#6454, Date de retrait ANS#6455, Date de retrait LOINC#6456, Remplacé par#6457, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6458]
         +- Project [Code LOINC#6060 AS Code LOINC#6440, Libellé français de référence#6080 AS Libellé français de référence#6441, Composant anglais#6100 AS Composant anglais#6442, Composant français#6120 AS Composant français#6443, Synonymes#6140 AS Synonymes#6444, Grandeur#6160 AS Grandeur#6445, Temps#6180 AS Temps#6446, Milieu biologique#6200 AS Milieu biologique#6447, Echelle#6220 AS Echelle#6448, Technique#6240 AS Technique#6449, Chapitre#6260 AS Chapitre#6450, Date de validation#6280 AS Date de validation#6451, Version VP#6300 AS Version VP#6452, Statut#6320 AS Statut#6453, Version de l'item corrigé#6340 AS Version de l'item corrigé#6454, Date de retrait ANS#6360 AS Date de retrait ANS#6455, Date de retrait LOINC#6380 AS Date de retrait LOINC#6456, Remplacé par#6400 AS Remplacé par#6457, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6420 AS 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6458]
            +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6240, Chapitre#6260, Date de validation#6280, Version VP#6300, Statut#6320, Version de l'item corrigé#6340, Date de retrait ANS#6360, Date de retrait LOINC#6380, Remplacé par#6400, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040 AS 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6420]
               +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6240, Chapitre#6260, Date de validation#6280, Version VP#6300, Statut#6320, Version de l'item corrigé#6340, Date de retrait ANS#6360, Date de retrait LOINC#6380, Remplac%C3%A9+par#6039 AS Remplacé par#6400, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                  +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6240, Chapitre#6260, Date de validation#6280, Version VP#6300, Statut#6320, Version de l'item corrigé#6340, Date de retrait ANS#6360, Date+de+retrait+LOINC#6038 AS Date de retrait LOINC#6380, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                     +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6240, Chapitre#6260, Date de validation#6280, Version VP#6300, Statut#6320, Version de l'item corrigé#6340, Date+de+retrait+ANS#6037 AS Date de retrait ANS#6360, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                        +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6240, Chapitre#6260, Date de validation#6280, Version VP#6300, Statut#6320, Version+de+l%27item+corrig%C3%A9#6036 AS Version de l'item corrigé#6340, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                           +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6240, Chapitre#6260, Date de validation#6280, Version VP#6300, Statut#6035 AS Statut#6320, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                              +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6240, Chapitre#6260, Date de validation#6280, Version+VP#6034 AS Version VP#6300, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                 +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6240, Chapitre#6260, Date+de+validation#6033 AS Date de validation#6280, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                    +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6240, Chapitre#6032 AS Chapitre#6260, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                       +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6220, Technique#6031 AS Technique#6240, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                          +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu biologique#6200, Echelle#6030 AS Echelle#6220, Technique#6031, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                             +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6180, Milieu+biologique#6029 AS Milieu biologique#6200, Echelle#6030, Technique#6031, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                                +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6160, Temps#6028 AS Temps#6180, Milieu+biologique#6029, Echelle#6030, Technique#6031, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                                   +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6140, Grandeur#6027 AS Grandeur#6160, Temps#6028, Milieu+biologique#6029, Echelle#6030, Technique#6031, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                                      +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant français#6120, Synonymes#6026 AS Synonymes#6140, Grandeur#6027, Temps#6028, Milieu+biologique#6029, Echelle#6030, Technique#6031, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                                         +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant anglais#6100, Composant+fran%C3%A7ais#6025 AS Composant français#6120, Synonymes#6026, Grandeur#6027, Temps#6028, Milieu+biologique#6029, Echelle#6030, Technique#6031, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                                            +- Project [Code LOINC#6060, Libellé français de référence#6080, Composant+anglais#6024 AS Composant anglais#6100, Composant+fran%C3%A7ais#6025, Synonymes#6026, Grandeur#6027, Temps#6028, Milieu+biologique#6029, Echelle#6030, Technique#6031, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                                               +- Project [Code LOINC#6060, Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#6023 AS Libellé français de référence#6080, Composant+anglais#6024, Composant+fran%C3%A7ais#6025, Synonymes#6026, Grandeur#6027, Temps#6028, Milieu+biologique#6029, Echelle#6030, Technique#6031, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                                                  +- Project [Code+LOINC#6022 AS Code LOINC#6060, Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#6023, Composant+anglais#6024, Composant+fran%C3%A7ais#6025, Synonymes#6026, Grandeur#6027, Temps#6028, Milieu+biologique#6029, Echelle#6030, Technique#6031, Chapitre#6032, Date+de+validation#6033, Version+VP#6034, Statut#6035, Version+de+l%27item+corrig%C3%A9#6036, Date+de+retrait+ANS#6037, Date+de+retrait+LOINC#6038, Remplac%C3%A9+par#6039, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040]
                                                                     +- Relation[Code+LOINC#6022,Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#6023,Composant+anglais#6024,Composant+fran%C3%A7ais#6025,Synonymes#6026,Grandeur#6027,Temps#6028,Milieu+biologique#6029,Echelle#6030,Technique#6031,Chapitre#6032,Date+de+validation#6033,Version+VP#6034,Statut#6035,Version+de+l%27item+corrig%C3%A9#6036,Date+de+retrait+ANS#6037,Date+de+retrait+LOINC#6038,Remplac%C3%A9+par#6039,43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040] parquet

== Optimized Logical Plan ==
InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/LOINC_2_22_2_78_2787, false, Parquet, [path=file:///data/output/cache/parquet/uet/LOINC_2_22_2_78_2787], Overwrite, [CHAPITRE_2798, CODE_LOINC_2788, COMPOSANT_ANGLA_2790, COMPOSANT_FRANC_2791, DATE_DE_RETRAIT_2803, DATE_DE_RETRAIT_2804, DATE_DE_VALIDAT_2799, ECHELLE_2796, GRANDEUR_2793, LIBELLE_FRANCAI_2789, MILIEU_BIOLOGIQ_2795, REMPLACE_PAR_2805, STATUT_2801, SYNONYMES_2792, TECHNIQUE_2797, TEMPS_2794, VERSION_DE_L_IT_2802, VERSION_VP_2800]
+- Project [Chapitre#6032 AS CHAPITRE_2798#6497, Code+LOINC#6022 AS CODE_LOINC_2788#6498, Composant+anglais#6024 AS COMPOSANT_ANGLA_2790#6499, Composant+fran%C3%A7ais#6025 AS COMPOSANT_FRANC_2791#6500, cast(Date+de+retrait+ANS#6037 as timestamp) AS DATE_DE_RETRAIT_2803#6501, cast(Date+de+retrait+LOINC#6038 as timestamp) AS DATE_DE_RETRAIT_2804#6502, cast(Date+de+validation#6033 as timestamp) AS DATE_DE_VALIDAT_2799#6503, Echelle#6030 AS ECHELLE_2796#6504, Grandeur#6027 AS GRANDEUR_2793#6505, Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#6023 AS LIBELLE_FRANCAI_2789#6506, Milieu+biologique#6029 AS MILIEU_BIOLOGIQ_2795#6507, Remplac%C3%A9+par#6039 AS REMPLACE_PAR_2805#6508, Statut#6035 AS STATUT_2801#6509, Synonymes#6026 AS SYNONYMES_2792#6510, Technique#6031 AS TECHNIQUE_2797#6511, Temps#6028 AS TEMPS_2794#6512, Version+de+l%27item+corrig%C3%A9#6036 AS VERSION_DE_L_IT_2802#6513, Version+VP#6034 AS VERSION_VP_2800#6514]
   +- Relation[Code+LOINC#6022,Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#6023,Composant+anglais#6024,Composant+fran%C3%A7ais#6025,Synonymes#6026,Grandeur#6027,Temps#6028,Milieu+biologique#6029,Echelle#6030,Technique#6031,Chapitre#6032,Date+de+validation#6033,Version+VP#6034,Statut#6035,Version+de+l%27item+corrig%C3%A9#6036,Date+de+retrait+ANS#6037,Date+de+retrait+LOINC#6038,Remplac%C3%A9+par#6039,43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#6040] parquet

== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/LOINC_2_22_2_78_2787, false, Parquet, [path=file:///data/output/cache/parquet/uet/LOINC_2_22_2_78_2787], Overwrite, [CHAPITRE_2798, CODE_LOINC_2788, COMPOSANT_ANGLA_2790, COMPOSANT_FRANC_2791, DATE_DE_RETRAIT_2803, DATE_DE_RETRAIT_2804, DATE_DE_VALIDAT_2799, ECHELLE_2796, GRANDEUR_2793, LIBELLE_FRANCAI_2789, MILIEU_BIOLOGIQ_2795, REMPLACE_PAR_2805, STATUT_2801, SYNONYMES_2792, TECHNIQUE_2797, TEMPS_2794, VERSION_DE_L_IT_2802, VERSION_VP_2800]
+- *(1) Project [Chapitre#6032 AS CHAPITRE_2798#6497, Code+LOINC#6022 AS CODE_LOINC_2788#6498, Composant+anglais#6024 AS COMPOSANT_ANGLA_2790#6499, Composant+fran%C3%A7ais#6025 AS COMPOSANT_FRANC_2791#6500, cast(Date+de+retrait+ANS#6037 as timestamp) AS DATE_DE_RETRAIT_2803#6501, cast(Date+de+retrait+LOINC#6038 as timestamp) AS DATE_DE_RETRAIT_2804#6502, cast(Date+de+validation#6033 as timestamp) AS DATE_DE_VALIDAT_2799#6503, Echelle#6030 AS ECHELLE_2796#6504, Grandeur#6027 AS GRANDEUR_2793#6505, Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#6023 AS LIBELLE_FRANCAI_2789#6506, Milieu+biologique#6029 AS MILIEU_BIOLOGIQ_2795#6507, Remplac%C3%A9+par#6039 AS REMPLACE_PAR_2805#6508, Statut#6035 AS STATUT_2801#6509, Synonymes#6026 AS SYNONYMES_2792#6510, Technique#6031 AS TECHNIQUE_2797#6511, Temps#6028 AS TEMPS_2794#6512, Version+de+l%27item+corrig%C3%A9#6036 AS VERSION_DE_L_IT_2802#6513, Version+VP#6034 AS VERSION_VP_2800#6514]
   +- *(1) ColumnarToRow
      +- FileScan parquet [Code+LOINC#6022,Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#6023,Composant+anglais#6024,Composant+fran%C3%A7ais#6025,Synonymes#6026,Grandeur#6027,Temps#6028,Milieu+biologique#6029,Echelle#6030,Technique#6031,Chapitre#6032,Date+de+validation#6033,Version+VP#6034,Statut#6035,Version+de+l%27item+corrig%C3%A9#6036,Date+de+retrait+ANS#6037,Date+de+retrait+LOINC#6038,Remplac%C3%A9+par#6039] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/input/depot/excel/cache/43778DA4_23A5_4A60_95C2_DFAED1C9CE0E_654677b..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<Code+LOINC:string,Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence:string,Composant+angla...