EVAL1_SPC2 - Details for Query 19

Details for Query 19

Submitted Time: 2025/09/15 13:30:43
Duration: 0.2 s
Succeeded Jobs: 27

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: 6 written output: 225.8 KiB number of output rows: 6,945 number of dynamic part: 0"]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n417 ms (57 ms, 72 ms, 73 ms (stage 30.0: task 43))"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="ColumnarToRow number of output rows: 6,945 number of input batches: 6"]; } 4 [labelType="html" label="Scan parquet number of files read: 6 scan time total (min, med, max (stageId: taskId)) 66 ms (10 ms, 11 ms, 12 ms (stage 30.0: task 43)) metadata time: 0 ms size of files read: 232.9 KiB number of output rows: 6,945"]; 2->0; 3->2; 4->3; }

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/ATC_2776, false, Parquet, [path=file:///data/output/cache/parquet/uet/ATC_2776], Overwrite, [ATC_CODEPERE_2779, ATC_CODE_2778, COMMENTAIRES_2782, CREATION_2783, INACTIVATION_2785, LIBELLE_ANGLAIS_2780, LIBELLE_FRANCAI_2781, MODIFICATION_2784, NIVEAU_CODE_2777]

Project [ATC_codePere#4462 AS ATC_CODEPERE_2779#4620, ATC_code#4461 AS ATC_CODE_2778#4621, Commentaires#4465 AS COMMENTAIRES_2782#4622, Cr%C3%A9ation#4466 AS CREATION_2783#4623, Inactivation#4468 AS INACTIVATION_2785#4624, Libell%C3%A9+anglais#4463 AS LIBELLE_ANGLAIS_2780#4625, Libell%C3%A9+fran%C3%A7ais#4464 AS LIBELLE_FRANCAI_2781#4626, Modification#4467 AS MODIFICATION_2784#4627, Niveau+code#4460 AS NIVEAU_CODE_2777#4628]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [Niveau+code#4460,ATC_code#4461,ATC_codePere#4462,Libell%C3%A9+anglais#4463,Libell%C3%A9+fran%C3%A7ais#4464,Commentaires#4465,Cr%C3%A9ation#4466,Modification#4467,Inactivation#4468] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/input/depot/excel/cache/693D1968_C0BA_4D71_AD27_BFE39CB5F506_993619b..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<Niveau+code:string,ATC_code:string,ATC_codePere:string,Libell%C3%A9+anglais:string,Libell%...

Details

== Parsed Logical Plan ==
InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/ATC_2776, false, Parquet, [path=file:///data/output/cache/parquet/uet/ATC_2776], Overwrite, [ATC_CODEPERE_2779, ATC_CODE_2778, COMMENTAIRES_2782, CREATION_2783, INACTIVATION_2785, LIBELLE_ANGLAIS_2780, LIBELLE_FRANCAI_2781, MODIFICATION_2784, NIVEAU_CODE_2777]
+- Project [ATC_CODEPERE_2779#4620, ATC_CODE_2778#4621, COMMENTAIRES_2782#4622, CREATION_2783#4623, INACTIVATION_2785#4624, LIBELLE_ANGLAIS_2780#4625, LIBELLE_FRANCAI_2781#4626, MODIFICATION_2784#4627, NIVEAU_CODE_2777#4628]
   +- Project [ATC_codePere#4592 AS ATC_CODEPERE_2779#4620, ATC_code#4591 AS ATC_CODE_2778#4621, Commentaires#4595 AS COMMENTAIRES_2782#4622, Création#4596 AS CREATION_2783#4623, Inactivation#4598 AS INACTIVATION_2785#4624, Libellé anglais#4593 AS LIBELLE_ANGLAIS_2780#4625, Libellé français#4594 AS LIBELLE_FRANCAI_2781#4626, Modification#4597 AS MODIFICATION_2784#4627, Niveau code#4590 AS NIVEAU_CODE_2777#4628]
      +- Project [Niveau code#4590, ATC_code#4591, ATC_codePere#4592, Libellé anglais#4593, Libellé français#4594, Commentaires#4595, Création#4596, Modification#4597, Inactivation#4598, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4599]
         +- Project [Niveau code#4480 AS Niveau code#4590, ATC_code#4491 AS ATC_code#4591, ATC_codePere#4502 AS ATC_codePere#4592, Libellé anglais#4513 AS Libellé anglais#4593, Libellé français#4524 AS Libellé français#4594, Commentaires#4535 AS Commentaires#4595, Création#4546 AS Création#4596, Modification#4557 AS Modification#4597, Inactivation#4568 AS Inactivation#4598, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4579 AS 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4599]
            +- Project [Niveau code#4480, ATC_code#4491, ATC_codePere#4502, Libellé anglais#4513, Libellé français#4524, Commentaires#4535, Création#4546, Modification#4557, Inactivation#4568, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469 AS 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4579]
               +- Project [Niveau code#4480, ATC_code#4491, ATC_codePere#4502, Libellé anglais#4513, Libellé français#4524, Commentaires#4535, Création#4546, Modification#4557, Inactivation#4468 AS Inactivation#4568, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469]
                  +- Project [Niveau code#4480, ATC_code#4491, ATC_codePere#4502, Libellé anglais#4513, Libellé français#4524, Commentaires#4535, Création#4546, Modification#4467 AS Modification#4557, Inactivation#4468, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469]
                     +- Project [Niveau code#4480, ATC_code#4491, ATC_codePere#4502, Libellé anglais#4513, Libellé français#4524, Commentaires#4535, Cr%C3%A9ation#4466 AS Création#4546, Modification#4467, Inactivation#4468, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469]
                        +- Project [Niveau code#4480, ATC_code#4491, ATC_codePere#4502, Libellé anglais#4513, Libellé français#4524, Commentaires#4465 AS Commentaires#4535, Cr%C3%A9ation#4466, Modification#4467, Inactivation#4468, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469]
                           +- Project [Niveau code#4480, ATC_code#4491, ATC_codePere#4502, Libellé anglais#4513, Libell%C3%A9+fran%C3%A7ais#4464 AS Libellé français#4524, Commentaires#4465, Cr%C3%A9ation#4466, Modification#4467, Inactivation#4468, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469]
                              +- Project [Niveau code#4480, ATC_code#4491, ATC_codePere#4502, Libell%C3%A9+anglais#4463 AS Libellé anglais#4513, Libell%C3%A9+fran%C3%A7ais#4464, Commentaires#4465, Cr%C3%A9ation#4466, Modification#4467, Inactivation#4468, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469]
                                 +- Project [Niveau code#4480, ATC_code#4491, ATC_codePere#4462 AS ATC_codePere#4502, Libell%C3%A9+anglais#4463, Libell%C3%A9+fran%C3%A7ais#4464, Commentaires#4465, Cr%C3%A9ation#4466, Modification#4467, Inactivation#4468, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469]
                                    +- Project [Niveau code#4480, ATC_code#4461 AS ATC_code#4491, ATC_codePere#4462, Libell%C3%A9+anglais#4463, Libell%C3%A9+fran%C3%A7ais#4464, Commentaires#4465, Cr%C3%A9ation#4466, Modification#4467, Inactivation#4468, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469]
                                       +- Project [Niveau+code#4460 AS Niveau code#4480, ATC_code#4461, ATC_codePere#4462, Libell%C3%A9+anglais#4463, Libell%C3%A9+fran%C3%A7ais#4464, Commentaires#4465, Cr%C3%A9ation#4466, Modification#4467, Inactivation#4468, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469]
                                          +- Relation[Niveau+code#4460,ATC_code#4461,ATC_codePere#4462,Libell%C3%A9+anglais#4463,Libell%C3%A9+fran%C3%A7ais#4464,Commentaires#4465,Cr%C3%A9ation#4466,Modification#4467,Inactivation#4468,693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469] parquet

== Analyzed Logical Plan ==

InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/ATC_2776, false, Parquet, [path=file:///data/output/cache/parquet/uet/ATC_2776], Overwrite, [ATC_CODEPERE_2779, ATC_CODE_2778, COMMENTAIRES_2782, CREATION_2783, INACTIVATION_2785, LIBELLE_ANGLAIS_2780, LIBELLE_FRANCAI_2781, MODIFICATION_2784, NIVEAU_CODE_2777]
+- Project [ATC_CODEPERE_2779#4620, ATC_CODE_2778#4621, COMMENTAIRES_2782#4622, CREATION_2783#4623, INACTIVATION_2785#4624, LIBELLE_ANGLAIS_2780#4625, LIBELLE_FRANCAI_2781#4626, MODIFICATION_2784#4627, NIVEAU_CODE_2777#4628]
   +- Project [ATC_codePere#4592 AS ATC_CODEPERE_2779#4620, ATC_code#4591 AS ATC_CODE_2778#4621, Commentaires#4595 AS COMMENTAIRES_2782#4622, Création#4596 AS CREATION_2783#4623, Inactivation#4598 AS INACTIVATION_2785#4624, Libellé anglais#4593 AS LIBELLE_ANGLAIS_2780#4625, Libellé français#4594 AS LIBELLE_FRANCAI_2781#4626, Modification#4597 AS MODIFICATION_2784#4627, Niveau code#4590 AS NIVEAU_CODE_2777#4628]
      +- Project [Niveau code#4590, ATC_code#4591, ATC_codePere#4592, Libellé anglais#4593, Libellé français#4594, Commentaires#4595, Création#4596, Modification#4597, Inactivation#4598, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4599]
         +- Project [Niveau code#4480 AS Niveau code#4590, ATC_code#4491 AS ATC_code#4591, ATC_codePere#4502 AS ATC_codePere#4592, Libellé anglais#4513 AS Libellé anglais#4593, Libellé français#4524 AS Libellé français#4594, Commentaires#4535 AS Commentaires#4595, Création#4546 AS Création#4596, Modification#4557 AS Modification#4597, Inactivation#4568 AS Inactivation#4598, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4579 AS 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4599]
            +- Project [Niveau code#4480, ATC_code#4491, ATC_codePere#4502, Libellé anglais#4513, Libellé français#4524, Commentaires#4535, Création#4546, Modification#4557, Inactivation#4568, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469 AS 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4579]
               +- Project [Niveau code#4480, ATC_code#4491, ATC_codePere#4502, Libellé anglais#4513, Libellé français#4524, Commentaires#4535, Création#4546, Modification#4557, Inactivation#4468 AS Inactivation#4568, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469]
                  +- Project [Niveau code#4480, ATC_code#4491, ATC_codePere#4502, Libellé anglais#4513, Libellé français#4524, Commentaires#4535, Création#4546, Modification#4467 AS Modification#4557, Inactivation#4468, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469]
                     +- Project [Niveau code#4480, ATC_code#4491, ATC_codePere#4502, Libellé anglais#4513, Libellé français#4524, Commentaires#4535, Cr%C3%A9ation#4466 AS Création#4546, Modification#4467, Inactivation#4468, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469]
                        +- Project [Niveau code#4480, ATC_code#4491, ATC_codePere#4502, Libellé anglais#4513, Libellé français#4524, Commentaires#4465 AS Commentaires#4535, Cr%C3%A9ation#4466, Modification#4467, Inactivation#4468, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469]
                           +- Project [Niveau code#4480, ATC_code#4491, ATC_codePere#4502, Libellé anglais#4513, Libell%C3%A9+fran%C3%A7ais#4464 AS Libellé français#4524, Commentaires#4465, Cr%C3%A9ation#4466, Modification#4467, Inactivation#4468, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469]
                              +- Project [Niveau code#4480, ATC_code#4491, ATC_codePere#4502, Libell%C3%A9+anglais#4463 AS Libellé anglais#4513, Libell%C3%A9+fran%C3%A7ais#4464, Commentaires#4465, Cr%C3%A9ation#4466, Modification#4467, Inactivation#4468, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469]
                                 +- Project [Niveau code#4480, ATC_code#4491, ATC_codePere#4462 AS ATC_codePere#4502, Libell%C3%A9+anglais#4463, Libell%C3%A9+fran%C3%A7ais#4464, Commentaires#4465, Cr%C3%A9ation#4466, Modification#4467, Inactivation#4468, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469]
                                    +- Project [Niveau code#4480, ATC_code#4461 AS ATC_code#4491, ATC_codePere#4462, Libell%C3%A9+anglais#4463, Libell%C3%A9+fran%C3%A7ais#4464, Commentaires#4465, Cr%C3%A9ation#4466, Modification#4467, Inactivation#4468, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469]
                                       +- Project [Niveau+code#4460 AS Niveau code#4480, ATC_code#4461, ATC_codePere#4462, Libell%C3%A9+anglais#4463, Libell%C3%A9+fran%C3%A7ais#4464, Commentaires#4465, Cr%C3%A9ation#4466, Modification#4467, Inactivation#4468, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469]
                                          +- Relation[Niveau+code#4460,ATC_code#4461,ATC_codePere#4462,Libell%C3%A9+anglais#4463,Libell%C3%A9+fran%C3%A7ais#4464,Commentaires#4465,Cr%C3%A9ation#4466,Modification#4467,Inactivation#4468,693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469] parquet

== Optimized Logical Plan ==
InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/ATC_2776, false, Parquet, [path=file:///data/output/cache/parquet/uet/ATC_2776], Overwrite, [ATC_CODEPERE_2779, ATC_CODE_2778, COMMENTAIRES_2782, CREATION_2783, INACTIVATION_2785, LIBELLE_ANGLAIS_2780, LIBELLE_FRANCAI_2781, MODIFICATION_2784, NIVEAU_CODE_2777]
+- Project [ATC_codePere#4462 AS ATC_CODEPERE_2779#4620, ATC_code#4461 AS ATC_CODE_2778#4621, Commentaires#4465 AS COMMENTAIRES_2782#4622, Cr%C3%A9ation#4466 AS CREATION_2783#4623, Inactivation#4468 AS INACTIVATION_2785#4624, Libell%C3%A9+anglais#4463 AS LIBELLE_ANGLAIS_2780#4625, Libell%C3%A9+fran%C3%A7ais#4464 AS LIBELLE_FRANCAI_2781#4626, Modification#4467 AS MODIFICATION_2784#4627, Niveau+code#4460 AS NIVEAU_CODE_2777#4628]
   +- Relation[Niveau+code#4460,ATC_code#4461,ATC_codePere#4462,Libell%C3%A9+anglais#4463,Libell%C3%A9+fran%C3%A7ais#4464,Commentaires#4465,Cr%C3%A9ation#4466,Modification#4467,Inactivation#4468,693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#4469] parquet

== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/ATC_2776, false, Parquet, [path=file:///data/output/cache/parquet/uet/ATC_2776], Overwrite, [ATC_CODEPERE_2779, ATC_CODE_2778, COMMENTAIRES_2782, CREATION_2783, INACTIVATION_2785, LIBELLE_ANGLAIS_2780, LIBELLE_FRANCAI_2781, MODIFICATION_2784, NIVEAU_CODE_2777]
+- *(1) Project [ATC_codePere#4462 AS ATC_CODEPERE_2779#4620, ATC_code#4461 AS ATC_CODE_2778#4621, Commentaires#4465 AS COMMENTAIRES_2782#4622, Cr%C3%A9ation#4466 AS CREATION_2783#4623, Inactivation#4468 AS INACTIVATION_2785#4624, Libell%C3%A9+anglais#4463 AS LIBELLE_ANGLAIS_2780#4625, Libell%C3%A9+fran%C3%A7ais#4464 AS LIBELLE_FRANCAI_2781#4626, Modification#4467 AS MODIFICATION_2784#4627, Niveau+code#4460 AS NIVEAU_CODE_2777#4628]
   +- *(1) ColumnarToRow
      +- FileScan parquet [Niveau+code#4460,ATC_code#4461,ATC_codePere#4462,Libell%C3%A9+anglais#4463,Libell%C3%A9+fran%C3%A7ais#4464,Commentaires#4465,Cr%C3%A9ation#4466,Modification#4467,Inactivation#4468] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/input/depot/excel/cache/693D1968_C0BA_4D71_AD27_BFE39CB5F506_993619b..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<Niveau+code:string,ATC_code:string,ATC_codePere:string,Libell%C3%A9+anglais:string,Libell%...