EVAL1_SPC2 - Details for Query 1

Details for Query 1

Submitted Time: 2025/09/15 13:12:40
Duration: 5 s
Succeeded Jobs: 1
Show the Stage ID and Task ID that corresponds to the max metric
Details
== Parsed Logical Plan ==
InsertIntoHadoopFsRelationCommand file:/data/input/depot/excel/cache/1E141C3C_4381_4E6F_9D5B_20E374029A33_4b2e6d37eb261434dd486ceaac8f6a7b/ADICAP_2024.xlsx_7408f75fae832371870f17596e69350e, false, Parquet, [path=file:///data/input/depot/excel/cache/1E141C3C_4381_4E6F_9D5B_20E374029A33_4b2e6d37eb261434dd486ceaac8f6a7b/ADICAP_2024.xlsx_7408f75fae832371870f17596e69350e], ErrorIfExists, [URI, code, Parent, codeParent, libelle, libelleParent, anatomyCode, anatomyLabel, startDate, endDate, dictionaryCode, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT]
+- Project [URI#155, code#168, Parent#181, codeParent#194, libelle#207, libelleParent#220, anatomyCode#233, anatomyLabel#246, startDate#259, endDate#272, dictionaryCode#285, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142 AS 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#298]
   +- Project [URI#155, code#168, Parent#181, codeParent#194, libelle#207, libelleParent#220, anatomyCode#233, anatomyLabel#246, startDate#259, endDate#272, dictionaryCode#119 AS dictionaryCode#285, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
      +- Project [URI#155, code#168, Parent#181, codeParent#194, libelle#207, libelleParent#220, anatomyCode#233, anatomyLabel#246, startDate#259, endDate#118 AS endDate#272, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
         +- Project [URI#155, code#168, Parent#181, codeParent#194, libelle#207, libelleParent#220, anatomyCode#233, anatomyLabel#246, startDate#117 AS startDate#259, endDate#118, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
            +- Project [URI#155, code#168, Parent#181, codeParent#194, libelle#207, libelleParent#220, anatomyCode#233, anatomyLabel#116 AS anatomyLabel#246, startDate#117, endDate#118, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
               +- Project [URI#155, code#168, Parent#181, codeParent#194, libelle#207, libelleParent#220, anatomyCode#115 AS anatomyCode#233, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
                  +- Project [URI#155, code#168, Parent#181, codeParent#194, libelle#207, libelleParent#114 AS libelleParent#220, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
                     +- Project [URI#155, code#168, Parent#181, codeParent#194, libelle#113 AS libelle#207, libelleParent#114, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
                        +- Project [URI#155, code#168, Parent#181, codeParent#112 AS codeParent#194, libelle#113, libelleParent#114, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
                           +- Project [URI#155, code#168, Parent#111 AS Parent#181, codeParent#112, libelle#113, libelleParent#114, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
                              +- Project [URI#155, code#110 AS code#168, Parent#111, codeParent#112, libelle#113, libelleParent#114, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
                                 +- Project [URI#109 AS URI#155, code#110, Parent#111, codeParent#112, libelle#113, libelleParent#114, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
                                    +- Project [URI#109, code#110, Parent#111, codeParent#112, libelle#113, libelleParent#114, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119, file:/data/input/depot/excel/execution/1E141C3C_4381_4E6F_9D5B_20E374029A33/current/ADICAP_2024.xlsx AS 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
                                       +- RelationV2[URI#109, code#110, Parent#111, codeParent#112, libelle#113, libelleParent#114, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119] excel file:/data/input/depot/excel/execution/1E141C3C_4381_4E6F_9D5B_20E374029A33/current/ADICAP_2024.xlsx

== Analyzed Logical Plan ==

InsertIntoHadoopFsRelationCommand file:/data/input/depot/excel/cache/1E141C3C_4381_4E6F_9D5B_20E374029A33_4b2e6d37eb261434dd486ceaac8f6a7b/ADICAP_2024.xlsx_7408f75fae832371870f17596e69350e, false, Parquet, [path=file:///data/input/depot/excel/cache/1E141C3C_4381_4E6F_9D5B_20E374029A33_4b2e6d37eb261434dd486ceaac8f6a7b/ADICAP_2024.xlsx_7408f75fae832371870f17596e69350e], ErrorIfExists, [URI, code, Parent, codeParent, libelle, libelleParent, anatomyCode, anatomyLabel, startDate, endDate, dictionaryCode, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT]
+- Project [URI#155, code#168, Parent#181, codeParent#194, libelle#207, libelleParent#220, anatomyCode#233, anatomyLabel#246, startDate#259, endDate#272, dictionaryCode#285, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142 AS 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#298]
   +- Project [URI#155, code#168, Parent#181, codeParent#194, libelle#207, libelleParent#220, anatomyCode#233, anatomyLabel#246, startDate#259, endDate#272, dictionaryCode#119 AS dictionaryCode#285, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
      +- Project [URI#155, code#168, Parent#181, codeParent#194, libelle#207, libelleParent#220, anatomyCode#233, anatomyLabel#246, startDate#259, endDate#118 AS endDate#272, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
         +- Project [URI#155, code#168, Parent#181, codeParent#194, libelle#207, libelleParent#220, anatomyCode#233, anatomyLabel#246, startDate#117 AS startDate#259, endDate#118, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
            +- Project [URI#155, code#168, Parent#181, codeParent#194, libelle#207, libelleParent#220, anatomyCode#233, anatomyLabel#116 AS anatomyLabel#246, startDate#117, endDate#118, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
               +- Project [URI#155, code#168, Parent#181, codeParent#194, libelle#207, libelleParent#220, anatomyCode#115 AS anatomyCode#233, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
                  +- Project [URI#155, code#168, Parent#181, codeParent#194, libelle#207, libelleParent#114 AS libelleParent#220, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
                     +- Project [URI#155, code#168, Parent#181, codeParent#194, libelle#113 AS libelle#207, libelleParent#114, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
                        +- Project [URI#155, code#168, Parent#181, codeParent#112 AS codeParent#194, libelle#113, libelleParent#114, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
                           +- Project [URI#155, code#168, Parent#111 AS Parent#181, codeParent#112, libelle#113, libelleParent#114, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
                              +- Project [URI#155, code#110 AS code#168, Parent#111, codeParent#112, libelle#113, libelleParent#114, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
                                 +- Project [URI#109 AS URI#155, code#110, Parent#111, codeParent#112, libelle#113, libelleParent#114, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
                                    +- Project [URI#109, code#110, Parent#111, codeParent#112, libelle#113, libelleParent#114, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119, file:/data/input/depot/excel/execution/1E141C3C_4381_4E6F_9D5B_20E374029A33/current/ADICAP_2024.xlsx AS 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#142]
                                       +- RelationV2[URI#109, code#110, Parent#111, codeParent#112, libelle#113, libelleParent#114, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119] excel file:/data/input/depot/excel/execution/1E141C3C_4381_4E6F_9D5B_20E374029A33/current/ADICAP_2024.xlsx

== Optimized Logical Plan ==
InsertIntoHadoopFsRelationCommand file:/data/input/depot/excel/cache/1E141C3C_4381_4E6F_9D5B_20E374029A33_4b2e6d37eb261434dd486ceaac8f6a7b/ADICAP_2024.xlsx_7408f75fae832371870f17596e69350e, false, Parquet, [path=file:///data/input/depot/excel/cache/1E141C3C_4381_4E6F_9D5B_20E374029A33_4b2e6d37eb261434dd486ceaac8f6a7b/ADICAP_2024.xlsx_7408f75fae832371870f17596e69350e], ErrorIfExists, [URI, code, Parent, codeParent, libelle, libelleParent, anatomyCode, anatomyLabel, startDate, endDate, dictionaryCode, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT]
+- Project [URI#109, code#110, Parent#111, codeParent#112, libelle#113, libelleParent#114, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119, file:/data/input/depot/excel/execution/1E141C3C_4381_4E6F_9D5B_20E374029A33/current/ADICAP_2024.xlsx AS 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#298]
   +- RelationV2[URI#109, code#110, Parent#111, codeParent#112, libelle#113, libelleParent#114, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119] excel file:/data/input/depot/excel/execution/1E141C3C_4381_4E6F_9D5B_20E374029A33/current/ADICAP_2024.xlsx

== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand file:/data/input/depot/excel/cache/1E141C3C_4381_4E6F_9D5B_20E374029A33_4b2e6d37eb261434dd486ceaac8f6a7b/ADICAP_2024.xlsx_7408f75fae832371870f17596e69350e, false, Parquet, [path=file:///data/input/depot/excel/cache/1E141C3C_4381_4E6F_9D5B_20E374029A33_4b2e6d37eb261434dd486ceaac8f6a7b/ADICAP_2024.xlsx_7408f75fae832371870f17596e69350e], ErrorIfExists, [URI, code, Parent, codeParent, libelle, libelleParent, anatomyCode, anatomyLabel, startDate, endDate, dictionaryCode, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT]
+- *(1) Project [URI#109, code#110, Parent#111, codeParent#112, libelle#113, libelleParent#114, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119, file:/data/input/depot/excel/execution/1E141C3C_4381_4E6F_9D5B_20E374029A33/current/ADICAP_2024.xlsx AS 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#298]
   +- BatchScan[URI#109, code#110, Parent#111, codeParent#112, libelle#113, libelleParent#114, anatomyCode#115, anatomyLabel#116, startDate#117, endDate#118, dictionaryCode#119] ExcelScan DataFilters: [], Location: InMemoryFileIndex[file:/data/input/depot/excel/execution/1E141C3C_4381_4E6F_9D5B_20E374029A33/cur..., PartitionFilters: [], ReadSchema: struct<URI:string,code:string,Parent:string,codeParent:string,libelle:string,libelleParent:string..., PushedFilters: []