EVAL1_SPC2 - Details for Query 20

Details for Query 20

Submitted Time: 2025/09/15 13:30:47
Duration: 0.2 s
Succeeded Jobs: 29

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: 327.8 KiB number of output rows: 9,683 number of dynamic part: 0"]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 69 ms"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="ColumnarToRow number of output rows: 9,683 number of input batches: 3"]; } 4 [labelType="html" label="Scan parquet number of files read: 1 scan time: 10 ms metadata time: 0 ms size of files read: 328.8 KiB number of output rows: 9,683"]; 2->0; 3->2; 4->3; }

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/ADICAP_V3_2763, false, Parquet, [path=file:///data/output/cache/parquet/uet/ADICAP_V3_2763], Overwrite, [ANATOMYCODE_2770, ANATOMYLABEL_2771, CODEPARENT_2767, CODE_2765, DICTIONARYCODE_2774, ENDDATE_2773, LIBELLEPARENT_2769, LIBELLE_2768, PARENT_2766, STARTDATE_2772, URI_2764]

Project [anatomyCode#4663 AS ANATOMYCODE_2770#4873, anatomyLabel#4664 AS ANATOMYLABEL_2771#4874, codeParent#4660 AS CODEPARENT_2767#4875, code#4658 AS CODE_2765#4876, dictionaryCode#4667 AS DICTIONARYCODE_2774#4877, endDate#4666 AS ENDDATE_2773#4878, libelleParent#4662 AS LIBELLEPARENT_2769#4879, libelle#4661 AS LIBELLE_2768#4880, Parent#4659 AS PARENT_2766#4881, startDate#4665 AS STARTDATE_2772#4882, URI#4657 AS URI_2764#4883]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [URI#4657,code#4658,Parent#4659,codeParent#4660,libelle#4661,libelleParent#4662,anatomyCode#4663,anatomyLabel#4664,startDate#4665,endDate#4666,dictionaryCode#4667] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/input/depot/excel/cache/1E141C3C_4381_4E6F_9D5B_20E374029A33_4b2e6d3..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<URI:string,code:string,Parent:string,codeParent:string,libelle:string,libelleParent:string...

Details

== Parsed Logical Plan ==
InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/ADICAP_V3_2763, false, Parquet, [path=file:///data/output/cache/parquet/uet/ADICAP_V3_2763], Overwrite, [ANATOMYCODE_2770, ANATOMYLABEL_2771, CODEPARENT_2767, CODE_2765, DICTIONARYCODE_2774, ENDDATE_2773, LIBELLEPARENT_2769, LIBELLE_2768, PARENT_2766, STARTDATE_2772, URI_2764]
+- Project [ANATOMYCODE_2770#4873, ANATOMYLABEL_2771#4874, CODEPARENT_2767#4875, CODE_2765#4876, DICTIONARYCODE_2774#4877, ENDDATE_2773#4878, LIBELLEPARENT_2769#4879, LIBELLE_2768#4880, PARENT_2766#4881, STARTDATE_2772#4882, URI_2764#4883]
   +- Project [anatomyCode#4843 AS ANATOMYCODE_2770#4873, anatomyLabel#4844 AS ANATOMYLABEL_2771#4874, codeParent#4840 AS CODEPARENT_2767#4875, code#4838 AS CODE_2765#4876, dictionaryCode#4847 AS DICTIONARYCODE_2774#4877, endDate#4846 AS ENDDATE_2773#4878, libelleParent#4842 AS LIBELLEPARENT_2769#4879, libelle#4841 AS LIBELLE_2768#4880, Parent#4839 AS PARENT_2766#4881, startDate#4845 AS STARTDATE_2772#4882, URI#4837 AS URI_2764#4883]
      +- Project [URI#4837, code#4838, Parent#4839, codeParent#4840, libelle#4841, libelleParent#4842, anatomyCode#4843, anatomyLabel#4844, startDate#4845, endDate#4846, dictionaryCode#4847, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4848]
         +- Project [URI#4681 AS URI#4837, code#4694 AS code#4838, Parent#4707 AS Parent#4839, codeParent#4720 AS codeParent#4840, libelle#4733 AS libelle#4841, libelleParent#4746 AS libelleParent#4842, anatomyCode#4759 AS anatomyCode#4843, anatomyLabel#4772 AS anatomyLabel#4844, startDate#4785 AS startDate#4845, endDate#4798 AS endDate#4846, dictionaryCode#4811 AS dictionaryCode#4847, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4824 AS 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4848]
            +- Project [URI#4681, code#4694, Parent#4707, codeParent#4720, libelle#4733, libelleParent#4746, anatomyCode#4759, anatomyLabel#4772, startDate#4785, endDate#4798, dictionaryCode#4811, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668 AS 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4824]
               +- Project [URI#4681, code#4694, Parent#4707, codeParent#4720, libelle#4733, libelleParent#4746, anatomyCode#4759, anatomyLabel#4772, startDate#4785, endDate#4798, dictionaryCode#4667 AS dictionaryCode#4811, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                  +- Project [URI#4681, code#4694, Parent#4707, codeParent#4720, libelle#4733, libelleParent#4746, anatomyCode#4759, anatomyLabel#4772, startDate#4785, endDate#4666 AS endDate#4798, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                     +- Project [URI#4681, code#4694, Parent#4707, codeParent#4720, libelle#4733, libelleParent#4746, anatomyCode#4759, anatomyLabel#4772, startDate#4665 AS startDate#4785, endDate#4666, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                        +- Project [URI#4681, code#4694, Parent#4707, codeParent#4720, libelle#4733, libelleParent#4746, anatomyCode#4759, anatomyLabel#4664 AS anatomyLabel#4772, startDate#4665, endDate#4666, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                           +- Project [URI#4681, code#4694, Parent#4707, codeParent#4720, libelle#4733, libelleParent#4746, anatomyCode#4663 AS anatomyCode#4759, anatomyLabel#4664, startDate#4665, endDate#4666, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                              +- Project [URI#4681, code#4694, Parent#4707, codeParent#4720, libelle#4733, libelleParent#4662 AS libelleParent#4746, anatomyCode#4663, anatomyLabel#4664, startDate#4665, endDate#4666, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                                 +- Project [URI#4681, code#4694, Parent#4707, codeParent#4720, libelle#4661 AS libelle#4733, libelleParent#4662, anatomyCode#4663, anatomyLabel#4664, startDate#4665, endDate#4666, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                                    +- Project [URI#4681, code#4694, Parent#4707, codeParent#4660 AS codeParent#4720, libelle#4661, libelleParent#4662, anatomyCode#4663, anatomyLabel#4664, startDate#4665, endDate#4666, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                                       +- Project [URI#4681, code#4694, Parent#4659 AS Parent#4707, codeParent#4660, libelle#4661, libelleParent#4662, anatomyCode#4663, anatomyLabel#4664, startDate#4665, endDate#4666, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                                          +- Project [URI#4681, code#4658 AS code#4694, Parent#4659, codeParent#4660, libelle#4661, libelleParent#4662, anatomyCode#4663, anatomyLabel#4664, startDate#4665, endDate#4666, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                                             +- Project [URI#4657 AS URI#4681, code#4658, Parent#4659, codeParent#4660, libelle#4661, libelleParent#4662, anatomyCode#4663, anatomyLabel#4664, startDate#4665, endDate#4666, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                                                +- Relation[URI#4657,code#4658,Parent#4659,codeParent#4660,libelle#4661,libelleParent#4662,anatomyCode#4663,anatomyLabel#4664,startDate#4665,endDate#4666,dictionaryCode#4667,1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668] parquet

== Analyzed Logical Plan ==

InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/ADICAP_V3_2763, false, Parquet, [path=file:///data/output/cache/parquet/uet/ADICAP_V3_2763], Overwrite, [ANATOMYCODE_2770, ANATOMYLABEL_2771, CODEPARENT_2767, CODE_2765, DICTIONARYCODE_2774, ENDDATE_2773, LIBELLEPARENT_2769, LIBELLE_2768, PARENT_2766, STARTDATE_2772, URI_2764]
+- Project [ANATOMYCODE_2770#4873, ANATOMYLABEL_2771#4874, CODEPARENT_2767#4875, CODE_2765#4876, DICTIONARYCODE_2774#4877, ENDDATE_2773#4878, LIBELLEPARENT_2769#4879, LIBELLE_2768#4880, PARENT_2766#4881, STARTDATE_2772#4882, URI_2764#4883]
   +- Project [anatomyCode#4843 AS ANATOMYCODE_2770#4873, anatomyLabel#4844 AS ANATOMYLABEL_2771#4874, codeParent#4840 AS CODEPARENT_2767#4875, code#4838 AS CODE_2765#4876, dictionaryCode#4847 AS DICTIONARYCODE_2774#4877, endDate#4846 AS ENDDATE_2773#4878, libelleParent#4842 AS LIBELLEPARENT_2769#4879, libelle#4841 AS LIBELLE_2768#4880, Parent#4839 AS PARENT_2766#4881, startDate#4845 AS STARTDATE_2772#4882, URI#4837 AS URI_2764#4883]
      +- Project [URI#4837, code#4838, Parent#4839, codeParent#4840, libelle#4841, libelleParent#4842, anatomyCode#4843, anatomyLabel#4844, startDate#4845, endDate#4846, dictionaryCode#4847, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4848]
         +- Project [URI#4681 AS URI#4837, code#4694 AS code#4838, Parent#4707 AS Parent#4839, codeParent#4720 AS codeParent#4840, libelle#4733 AS libelle#4841, libelleParent#4746 AS libelleParent#4842, anatomyCode#4759 AS anatomyCode#4843, anatomyLabel#4772 AS anatomyLabel#4844, startDate#4785 AS startDate#4845, endDate#4798 AS endDate#4846, dictionaryCode#4811 AS dictionaryCode#4847, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4824 AS 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4848]
            +- Project [URI#4681, code#4694, Parent#4707, codeParent#4720, libelle#4733, libelleParent#4746, anatomyCode#4759, anatomyLabel#4772, startDate#4785, endDate#4798, dictionaryCode#4811, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668 AS 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4824]
               +- Project [URI#4681, code#4694, Parent#4707, codeParent#4720, libelle#4733, libelleParent#4746, anatomyCode#4759, anatomyLabel#4772, startDate#4785, endDate#4798, dictionaryCode#4667 AS dictionaryCode#4811, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                  +- Project [URI#4681, code#4694, Parent#4707, codeParent#4720, libelle#4733, libelleParent#4746, anatomyCode#4759, anatomyLabel#4772, startDate#4785, endDate#4666 AS endDate#4798, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                     +- Project [URI#4681, code#4694, Parent#4707, codeParent#4720, libelle#4733, libelleParent#4746, anatomyCode#4759, anatomyLabel#4772, startDate#4665 AS startDate#4785, endDate#4666, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                        +- Project [URI#4681, code#4694, Parent#4707, codeParent#4720, libelle#4733, libelleParent#4746, anatomyCode#4759, anatomyLabel#4664 AS anatomyLabel#4772, startDate#4665, endDate#4666, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                           +- Project [URI#4681, code#4694, Parent#4707, codeParent#4720, libelle#4733, libelleParent#4746, anatomyCode#4663 AS anatomyCode#4759, anatomyLabel#4664, startDate#4665, endDate#4666, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                              +- Project [URI#4681, code#4694, Parent#4707, codeParent#4720, libelle#4733, libelleParent#4662 AS libelleParent#4746, anatomyCode#4663, anatomyLabel#4664, startDate#4665, endDate#4666, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                                 +- Project [URI#4681, code#4694, Parent#4707, codeParent#4720, libelle#4661 AS libelle#4733, libelleParent#4662, anatomyCode#4663, anatomyLabel#4664, startDate#4665, endDate#4666, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                                    +- Project [URI#4681, code#4694, Parent#4707, codeParent#4660 AS codeParent#4720, libelle#4661, libelleParent#4662, anatomyCode#4663, anatomyLabel#4664, startDate#4665, endDate#4666, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                                       +- Project [URI#4681, code#4694, Parent#4659 AS Parent#4707, codeParent#4660, libelle#4661, libelleParent#4662, anatomyCode#4663, anatomyLabel#4664, startDate#4665, endDate#4666, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                                          +- Project [URI#4681, code#4658 AS code#4694, Parent#4659, codeParent#4660, libelle#4661, libelleParent#4662, anatomyCode#4663, anatomyLabel#4664, startDate#4665, endDate#4666, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                                             +- Project [URI#4657 AS URI#4681, code#4658, Parent#4659, codeParent#4660, libelle#4661, libelleParent#4662, anatomyCode#4663, anatomyLabel#4664, startDate#4665, endDate#4666, dictionaryCode#4667, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668]
                                                +- Relation[URI#4657,code#4658,Parent#4659,codeParent#4660,libelle#4661,libelleParent#4662,anatomyCode#4663,anatomyLabel#4664,startDate#4665,endDate#4666,dictionaryCode#4667,1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668] parquet

== Optimized Logical Plan ==
InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/ADICAP_V3_2763, false, Parquet, [path=file:///data/output/cache/parquet/uet/ADICAP_V3_2763], Overwrite, [ANATOMYCODE_2770, ANATOMYLABEL_2771, CODEPARENT_2767, CODE_2765, DICTIONARYCODE_2774, ENDDATE_2773, LIBELLEPARENT_2769, LIBELLE_2768, PARENT_2766, STARTDATE_2772, URI_2764]
+- Project [anatomyCode#4663 AS ANATOMYCODE_2770#4873, anatomyLabel#4664 AS ANATOMYLABEL_2771#4874, codeParent#4660 AS CODEPARENT_2767#4875, code#4658 AS CODE_2765#4876, dictionaryCode#4667 AS DICTIONARYCODE_2774#4877, endDate#4666 AS ENDDATE_2773#4878, libelleParent#4662 AS LIBELLEPARENT_2769#4879, libelle#4661 AS LIBELLE_2768#4880, Parent#4659 AS PARENT_2766#4881, startDate#4665 AS STARTDATE_2772#4882, URI#4657 AS URI_2764#4883]
   +- Relation[URI#4657,code#4658,Parent#4659,codeParent#4660,libelle#4661,libelleParent#4662,anatomyCode#4663,anatomyLabel#4664,startDate#4665,endDate#4666,dictionaryCode#4667,1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#4668] parquet

== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/uet/ADICAP_V3_2763, false, Parquet, [path=file:///data/output/cache/parquet/uet/ADICAP_V3_2763], Overwrite, [ANATOMYCODE_2770, ANATOMYLABEL_2771, CODEPARENT_2767, CODE_2765, DICTIONARYCODE_2774, ENDDATE_2773, LIBELLEPARENT_2769, LIBELLE_2768, PARENT_2766, STARTDATE_2772, URI_2764]
+- *(1) Project [anatomyCode#4663 AS ANATOMYCODE_2770#4873, anatomyLabel#4664 AS ANATOMYLABEL_2771#4874, codeParent#4660 AS CODEPARENT_2767#4875, code#4658 AS CODE_2765#4876, dictionaryCode#4667 AS DICTIONARYCODE_2774#4877, endDate#4666 AS ENDDATE_2773#4878, libelleParent#4662 AS LIBELLEPARENT_2769#4879, libelle#4661 AS LIBELLE_2768#4880, Parent#4659 AS PARENT_2766#4881, startDate#4665 AS STARTDATE_2772#4882, URI#4657 AS URI_2764#4883]
   +- *(1) ColumnarToRow
      +- FileScan parquet [URI#4657,code#4658,Parent#4659,codeParent#4660,libelle#4661,libelleParent#4662,anatomyCode#4663,anatomyLabel#4664,startDate#4665,endDate#4666,dictionaryCode#4667] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/input/depot/excel/cache/1E141C3C_4381_4E6F_9D5B_20E374029A33_4b2e6d3..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<URI:string,code:string,Parent:string,codeParent:string,libelle:string,libelleParent:string...