EVAL1_SPC2 - Details for Query 18

Details for Query 18

Submitted Time: 2025/09/15 13:30:21
Duration: 0.8 s
Succeeded Jobs: 25
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: 596 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: 83 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#3922 AS CHAPITRE_2798#4387, Code+LOINC#3912 AS CODE_LOINC_2788#4388, Composant+anglais#3914 AS COMPOSANT_ANGLA_2790#4389, Composant+fran%C3%A7ais#3915 AS COMPOSANT_FRANC_2791#4390, cast(Date+de+retrait+ANS#3927 as timestamp) AS DATE_DE_RETRAIT_2803#4391, cast(Date+de+retrait+LOINC#3928 as timestamp) AS DATE_DE_RETRAIT_2804#4392, cast(Date+de+validation#3923 as timestamp) AS DATE_DE_VALIDAT_2799#4393, Echelle#3920 AS ECHELLE_2796#4394, Grandeur#3917 AS GRANDEUR_2793#4395, Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#3913 AS LIBELLE_FRANCAI_2789#4396, Milieu+biologique#3919 AS MILIEU_BIOLOGIQ_2795#4397, Remplac%C3%A9+par#3929 AS REMPLACE_PAR_2805#4398, Statut#3925 AS STATUT_2801#4399, Synonymes#3916 AS SYNONYMES_2792#4400, Technique#3921 AS TECHNIQUE_2797#4401, Temps#3918 AS TEMPS_2794#4402, Version+de+l%27item+corrig%C3%A9#3926 AS VERSION_DE_L_IT_2802#4403, Version+VP#3924 AS VERSION_VP_2800#4404]
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [Code+LOINC#3912,Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#3913,Composant+anglais#3914,Composant+fran%C3%A7ais#3915,Synonymes#3916,Grandeur#3917,Temps#3918,Milieu+biologique#3919,Echelle#3920,Technique#3921,Chapitre#3922,Date+de+validation#3923,Version+VP#3924,Statut#3925,Version+de+l%27item+corrig%C3%A9#3926,Date+de+retrait+ANS#3927,Date+de+retrait+LOINC#3928,Remplac%C3%A9+par#3929] 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#4387, CODE_LOINC_2788#4388, COMPOSANT_ANGLA_2790#4389, COMPOSANT_FRANC_2791#4390, DATE_DE_RETRAIT_2803#4391, DATE_DE_RETRAIT_2804#4392, DATE_DE_VALIDAT_2799#4393, ECHELLE_2796#4394, GRANDEUR_2793#4395, LIBELLE_FRANCAI_2789#4396, MILIEU_BIOLOGIQ_2795#4397, REMPLACE_PAR_2805#4398, STATUT_2801#4399, SYNONYMES_2792#4400, TECHNIQUE_2797#4401, TEMPS_2794#4402, VERSION_DE_L_IT_2802#4403, VERSION_VP_2800#4404]
   +- Project [Chapitre#4340 AS CHAPITRE_2798#4387, Code LOINC#4330 AS CODE_LOINC_2788#4388, Composant anglais#4332 AS COMPOSANT_ANGLA_2790#4389, Composant français#4333 AS COMPOSANT_FRANC_2791#4390, to_timestamp(Date de retrait ANS#4345, None) AS DATE_DE_RETRAIT_2803#4391, to_timestamp(Date de retrait LOINC#4346, None) AS DATE_DE_RETRAIT_2804#4392, to_timestamp(Date de validation#4341, None) AS DATE_DE_VALIDAT_2799#4393, Echelle#4338 AS ECHELLE_2796#4394, Grandeur#4335 AS GRANDEUR_2793#4395, Libellé français de référence#4331 AS LIBELLE_FRANCAI_2789#4396, Milieu biologique#4337 AS MILIEU_BIOLOGIQ_2795#4397, Remplacé par#4347 AS REMPLACE_PAR_2805#4398, Statut#4343 AS STATUT_2801#4399, Synonymes#4334 AS SYNONYMES_2792#4400, Technique#4339 AS TECHNIQUE_2797#4401, Temps#4336 AS TEMPS_2794#4402, Version de l'item corrigé#4344 AS VERSION_DE_L_IT_2802#4403, Version VP#4342 AS VERSION_VP_2800#4404]
      +- Project [Code LOINC#4330, Libellé français de référence#4331, Composant anglais#4332, Composant français#4333, Synonymes#4334, Grandeur#4335, Temps#4336, Milieu biologique#4337, Echelle#4338, Technique#4339, Chapitre#4340, Date de validation#4341, Version VP#4342, Statut#4343, Version de l'item corrigé#4344, Date de retrait ANS#4345, Date de retrait LOINC#4346, Remplacé par#4347, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#4348]
         +- Project [Code LOINC#3950 AS Code LOINC#4330, Libellé français de référence#3970 AS Libellé français de référence#4331, Composant anglais#3990 AS Composant anglais#4332, Composant français#4010 AS Composant français#4333, Synonymes#4030 AS Synonymes#4334, Grandeur#4050 AS Grandeur#4335, Temps#4070 AS Temps#4336, Milieu biologique#4090 AS Milieu biologique#4337, Echelle#4110 AS Echelle#4338, Technique#4130 AS Technique#4339, Chapitre#4150 AS Chapitre#4340, Date de validation#4170 AS Date de validation#4341, Version VP#4190 AS Version VP#4342, Statut#4210 AS Statut#4343, Version de l'item corrigé#4230 AS Version de l'item corrigé#4344, Date de retrait ANS#4250 AS Date de retrait ANS#4345, Date de retrait LOINC#4270 AS Date de retrait LOINC#4346, Remplacé par#4290 AS Remplacé par#4347, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#4310 AS 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#4348]
            +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#4130, Chapitre#4150, Date de validation#4170, Version VP#4190, Statut#4210, Version de l'item corrigé#4230, Date de retrait ANS#4250, Date de retrait LOINC#4270, Remplacé par#4290, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930 AS 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#4310]
               +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#4130, Chapitre#4150, Date de validation#4170, Version VP#4190, Statut#4210, Version de l'item corrigé#4230, Date de retrait ANS#4250, Date de retrait LOINC#4270, Remplac%C3%A9+par#3929 AS Remplacé par#4290, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                  +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#4130, Chapitre#4150, Date de validation#4170, Version VP#4190, Statut#4210, Version de l'item corrigé#4230, Date de retrait ANS#4250, Date+de+retrait+LOINC#3928 AS Date de retrait LOINC#4270, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                     +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#4130, Chapitre#4150, Date de validation#4170, Version VP#4190, Statut#4210, Version de l'item corrigé#4230, Date+de+retrait+ANS#3927 AS Date de retrait ANS#4250, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                        +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#4130, Chapitre#4150, Date de validation#4170, Version VP#4190, Statut#4210, Version+de+l%27item+corrig%C3%A9#3926 AS Version de l'item corrigé#4230, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                           +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#4130, Chapitre#4150, Date de validation#4170, Version VP#4190, Statut#3925 AS Statut#4210, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                              +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#4130, Chapitre#4150, Date de validation#4170, Version+VP#3924 AS Version VP#4190, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                 +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#4130, Chapitre#4150, Date+de+validation#3923 AS Date de validation#4170, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                    +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#4130, Chapitre#3922 AS Chapitre#4150, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                       +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#3921 AS Technique#4130, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                          +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#3920 AS Echelle#4110, Technique#3921, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                             +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu+biologique#3919 AS Milieu biologique#4090, Echelle#3920, Technique#3921, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                                +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#3918 AS Temps#4070, Milieu+biologique#3919, Echelle#3920, Technique#3921, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                                   +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#3917 AS Grandeur#4050, Temps#3918, Milieu+biologique#3919, Echelle#3920, Technique#3921, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                                      +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#3916 AS Synonymes#4030, Grandeur#3917, Temps#3918, Milieu+biologique#3919, Echelle#3920, Technique#3921, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                                         +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant+fran%C3%A7ais#3915 AS Composant français#4010, Synonymes#3916, Grandeur#3917, Temps#3918, Milieu+biologique#3919, Echelle#3920, Technique#3921, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                                            +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant+anglais#3914 AS Composant anglais#3990, Composant+fran%C3%A7ais#3915, Synonymes#3916, Grandeur#3917, Temps#3918, Milieu+biologique#3919, Echelle#3920, Technique#3921, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                                               +- Project [Code LOINC#3950, Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#3913 AS Libellé français de référence#3970, Composant+anglais#3914, Composant+fran%C3%A7ais#3915, Synonymes#3916, Grandeur#3917, Temps#3918, Milieu+biologique#3919, Echelle#3920, Technique#3921, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                                                  +- Project [Code+LOINC#3912 AS Code LOINC#3950, Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#3913, Composant+anglais#3914, Composant+fran%C3%A7ais#3915, Synonymes#3916, Grandeur#3917, Temps#3918, Milieu+biologique#3919, Echelle#3920, Technique#3921, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                                                     +- Relation[Code+LOINC#3912,Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#3913,Composant+anglais#3914,Composant+fran%C3%A7ais#3915,Synonymes#3916,Grandeur#3917,Temps#3918,Milieu+biologique#3919,Echelle#3920,Technique#3921,Chapitre#3922,Date+de+validation#3923,Version+VP#3924,Statut#3925,Version+de+l%27item+corrig%C3%A9#3926,Date+de+retrait+ANS#3927,Date+de+retrait+LOINC#3928,Remplac%C3%A9+par#3929,43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930] 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#4387, CODE_LOINC_2788#4388, COMPOSANT_ANGLA_2790#4389, COMPOSANT_FRANC_2791#4390, DATE_DE_RETRAIT_2803#4391, DATE_DE_RETRAIT_2804#4392, DATE_DE_VALIDAT_2799#4393, ECHELLE_2796#4394, GRANDEUR_2793#4395, LIBELLE_FRANCAI_2789#4396, MILIEU_BIOLOGIQ_2795#4397, REMPLACE_PAR_2805#4398, STATUT_2801#4399, SYNONYMES_2792#4400, TECHNIQUE_2797#4401, TEMPS_2794#4402, VERSION_DE_L_IT_2802#4403, VERSION_VP_2800#4404]
   +- Project [Chapitre#4340 AS CHAPITRE_2798#4387, Code LOINC#4330 AS CODE_LOINC_2788#4388, Composant anglais#4332 AS COMPOSANT_ANGLA_2790#4389, Composant français#4333 AS COMPOSANT_FRANC_2791#4390, to_timestamp(Date de retrait ANS#4345, None) AS DATE_DE_RETRAIT_2803#4391, to_timestamp(Date de retrait LOINC#4346, None) AS DATE_DE_RETRAIT_2804#4392, to_timestamp(Date de validation#4341, None) AS DATE_DE_VALIDAT_2799#4393, Echelle#4338 AS ECHELLE_2796#4394, Grandeur#4335 AS GRANDEUR_2793#4395, Libellé français de référence#4331 AS LIBELLE_FRANCAI_2789#4396, Milieu biologique#4337 AS MILIEU_BIOLOGIQ_2795#4397, Remplacé par#4347 AS REMPLACE_PAR_2805#4398, Statut#4343 AS STATUT_2801#4399, Synonymes#4334 AS SYNONYMES_2792#4400, Technique#4339 AS TECHNIQUE_2797#4401, Temps#4336 AS TEMPS_2794#4402, Version de l'item corrigé#4344 AS VERSION_DE_L_IT_2802#4403, Version VP#4342 AS VERSION_VP_2800#4404]
      +- Project [Code LOINC#4330, Libellé français de référence#4331, Composant anglais#4332, Composant français#4333, Synonymes#4334, Grandeur#4335, Temps#4336, Milieu biologique#4337, Echelle#4338, Technique#4339, Chapitre#4340, Date de validation#4341, Version VP#4342, Statut#4343, Version de l'item corrigé#4344, Date de retrait ANS#4345, Date de retrait LOINC#4346, Remplacé par#4347, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#4348]
         +- Project [Code LOINC#3950 AS Code LOINC#4330, Libellé français de référence#3970 AS Libellé français de référence#4331, Composant anglais#3990 AS Composant anglais#4332, Composant français#4010 AS Composant français#4333, Synonymes#4030 AS Synonymes#4334, Grandeur#4050 AS Grandeur#4335, Temps#4070 AS Temps#4336, Milieu biologique#4090 AS Milieu biologique#4337, Echelle#4110 AS Echelle#4338, Technique#4130 AS Technique#4339, Chapitre#4150 AS Chapitre#4340, Date de validation#4170 AS Date de validation#4341, Version VP#4190 AS Version VP#4342, Statut#4210 AS Statut#4343, Version de l'item corrigé#4230 AS Version de l'item corrigé#4344, Date de retrait ANS#4250 AS Date de retrait ANS#4345, Date de retrait LOINC#4270 AS Date de retrait LOINC#4346, Remplacé par#4290 AS Remplacé par#4347, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#4310 AS 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#4348]
            +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#4130, Chapitre#4150, Date de validation#4170, Version VP#4190, Statut#4210, Version de l'item corrigé#4230, Date de retrait ANS#4250, Date de retrait LOINC#4270, Remplacé par#4290, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930 AS 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#4310]
               +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#4130, Chapitre#4150, Date de validation#4170, Version VP#4190, Statut#4210, Version de l'item corrigé#4230, Date de retrait ANS#4250, Date de retrait LOINC#4270, Remplac%C3%A9+par#3929 AS Remplacé par#4290, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                  +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#4130, Chapitre#4150, Date de validation#4170, Version VP#4190, Statut#4210, Version de l'item corrigé#4230, Date de retrait ANS#4250, Date+de+retrait+LOINC#3928 AS Date de retrait LOINC#4270, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                     +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#4130, Chapitre#4150, Date de validation#4170, Version VP#4190, Statut#4210, Version de l'item corrigé#4230, Date+de+retrait+ANS#3927 AS Date de retrait ANS#4250, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                        +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#4130, Chapitre#4150, Date de validation#4170, Version VP#4190, Statut#4210, Version+de+l%27item+corrig%C3%A9#3926 AS Version de l'item corrigé#4230, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                           +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#4130, Chapitre#4150, Date de validation#4170, Version VP#4190, Statut#3925 AS Statut#4210, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                              +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#4130, Chapitre#4150, Date de validation#4170, Version+VP#3924 AS Version VP#4190, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                 +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#4130, Chapitre#4150, Date+de+validation#3923 AS Date de validation#4170, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                    +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#4130, Chapitre#3922 AS Chapitre#4150, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                       +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#4110, Technique#3921 AS Technique#4130, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                          +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu biologique#4090, Echelle#3920 AS Echelle#4110, Technique#3921, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                             +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#4070, Milieu+biologique#3919 AS Milieu biologique#4090, Echelle#3920, Technique#3921, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                                +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#4050, Temps#3918 AS Temps#4070, Milieu+biologique#3919, Echelle#3920, Technique#3921, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                                   +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#4030, Grandeur#3917 AS Grandeur#4050, Temps#3918, Milieu+biologique#3919, Echelle#3920, Technique#3921, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                                      +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant français#4010, Synonymes#3916 AS Synonymes#4030, Grandeur#3917, Temps#3918, Milieu+biologique#3919, Echelle#3920, Technique#3921, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                                         +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant anglais#3990, Composant+fran%C3%A7ais#3915 AS Composant français#4010, Synonymes#3916, Grandeur#3917, Temps#3918, Milieu+biologique#3919, Echelle#3920, Technique#3921, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                                            +- Project [Code LOINC#3950, Libellé français de référence#3970, Composant+anglais#3914 AS Composant anglais#3990, Composant+fran%C3%A7ais#3915, Synonymes#3916, Grandeur#3917, Temps#3918, Milieu+biologique#3919, Echelle#3920, Technique#3921, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                                               +- Project [Code LOINC#3950, Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#3913 AS Libellé français de référence#3970, Composant+anglais#3914, Composant+fran%C3%A7ais#3915, Synonymes#3916, Grandeur#3917, Temps#3918, Milieu+biologique#3919, Echelle#3920, Technique#3921, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                                                  +- Project [Code+LOINC#3912 AS Code LOINC#3950, Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#3913, Composant+anglais#3914, Composant+fran%C3%A7ais#3915, Synonymes#3916, Grandeur#3917, Temps#3918, Milieu+biologique#3919, Echelle#3920, Technique#3921, Chapitre#3922, Date+de+validation#3923, Version+VP#3924, Statut#3925, Version+de+l%27item+corrig%C3%A9#3926, Date+de+retrait+ANS#3927, Date+de+retrait+LOINC#3928, Remplac%C3%A9+par#3929, 43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930]
                                                                     +- Relation[Code+LOINC#3912,Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#3913,Composant+anglais#3914,Composant+fran%C3%A7ais#3915,Synonymes#3916,Grandeur#3917,Temps#3918,Milieu+biologique#3919,Echelle#3920,Technique#3921,Chapitre#3922,Date+de+validation#3923,Version+VP#3924,Statut#3925,Version+de+l%27item+corrig%C3%A9#3926,Date+de+retrait+ANS#3927,Date+de+retrait+LOINC#3928,Remplac%C3%A9+par#3929,43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930] 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#3922 AS CHAPITRE_2798#4387, Code+LOINC#3912 AS CODE_LOINC_2788#4388, Composant+anglais#3914 AS COMPOSANT_ANGLA_2790#4389, Composant+fran%C3%A7ais#3915 AS COMPOSANT_FRANC_2791#4390, cast(Date+de+retrait+ANS#3927 as timestamp) AS DATE_DE_RETRAIT_2803#4391, cast(Date+de+retrait+LOINC#3928 as timestamp) AS DATE_DE_RETRAIT_2804#4392, cast(Date+de+validation#3923 as timestamp) AS DATE_DE_VALIDAT_2799#4393, Echelle#3920 AS ECHELLE_2796#4394, Grandeur#3917 AS GRANDEUR_2793#4395, Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#3913 AS LIBELLE_FRANCAI_2789#4396, Milieu+biologique#3919 AS MILIEU_BIOLOGIQ_2795#4397, Remplac%C3%A9+par#3929 AS REMPLACE_PAR_2805#4398, Statut#3925 AS STATUT_2801#4399, Synonymes#3916 AS SYNONYMES_2792#4400, Technique#3921 AS TECHNIQUE_2797#4401, Temps#3918 AS TEMPS_2794#4402, Version+de+l%27item+corrig%C3%A9#3926 AS VERSION_DE_L_IT_2802#4403, Version+VP#3924 AS VERSION_VP_2800#4404]
   +- Relation[Code+LOINC#3912,Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#3913,Composant+anglais#3914,Composant+fran%C3%A7ais#3915,Synonymes#3916,Grandeur#3917,Temps#3918,Milieu+biologique#3919,Echelle#3920,Technique#3921,Chapitre#3922,Date+de+validation#3923,Version+VP#3924,Statut#3925,Version+de+l%27item+corrig%C3%A9#3926,Date+de+retrait+ANS#3927,Date+de+retrait+LOINC#3928,Remplac%C3%A9+par#3929,43778DA4_23A5_4A60_95C2_DFAED1C9CE0EHEADER_COL_DETAIL_DEPOT#3930] 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#3922 AS CHAPITRE_2798#4387, Code+LOINC#3912 AS CODE_LOINC_2788#4388, Composant+anglais#3914 AS COMPOSANT_ANGLA_2790#4389, Composant+fran%C3%A7ais#3915 AS COMPOSANT_FRANC_2791#4390, cast(Date+de+retrait+ANS#3927 as timestamp) AS DATE_DE_RETRAIT_2803#4391, cast(Date+de+retrait+LOINC#3928 as timestamp) AS DATE_DE_RETRAIT_2804#4392, cast(Date+de+validation#3923 as timestamp) AS DATE_DE_VALIDAT_2799#4393, Echelle#3920 AS ECHELLE_2796#4394, Grandeur#3917 AS GRANDEUR_2793#4395, Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#3913 AS LIBELLE_FRANCAI_2789#4396, Milieu+biologique#3919 AS MILIEU_BIOLOGIQ_2795#4397, Remplac%C3%A9+par#3929 AS REMPLACE_PAR_2805#4398, Statut#3925 AS STATUT_2801#4399, Synonymes#3916 AS SYNONYMES_2792#4400, Technique#3921 AS TECHNIQUE_2797#4401, Temps#3918 AS TEMPS_2794#4402, Version+de+l%27item+corrig%C3%A9#3926 AS VERSION_DE_L_IT_2802#4403, Version+VP#3924 AS VERSION_VP_2800#4404]
   +- *(1) ColumnarToRow
      +- FileScan parquet [Code+LOINC#3912,Libell%C3%A9+fran%C3%A7ais+de+r%C3%A9f%C3%A9rence#3913,Composant+anglais#3914,Composant+fran%C3%A7ais#3915,Synonymes#3916,Grandeur#3917,Temps#3918,Milieu+biologique#3919,Echelle#3920,Technique#3921,Chapitre#3922,Date+de+validation#3923,Version+VP#3924,Statut#3925,Version+de+l%27item+corrig%C3%A9#3926,Date+de+retrait+ANS#3927,Date+de+retrait+LOINC#3928,Remplac%C3%A9+par#3929] 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...