EVAL1_SPC2 - Details for Query 3

Details for Query 3

Submitted Time: 2025/09/15 13:12:46
Duration: 0.5 s
Succeeded Jobs: 4
Show the Stage ID and Task ID that corresponds to the max metric
Details
== Parsed Logical Plan ==
GlobalLimit 1500
+- LocalLimit 1500
   +- Project [COL_URI_2764#638 AS COL_URI_2764#671, COL_CODE_2765#639 AS COL_CODE_2765#672, COL_PARENT_2766#640 AS COL_PARENT_2766#673, COL_CODEPARENT_2767#641 AS COL_CODEPARENT_2767#674, COL_LIBELLE_2768#642 AS COL_LIBELLE_2768#675, COL_LIBELLEPARENT_2769#643 AS COL_LIBELLEPARENT_2769#676, COL_ANATOMYCODE_2770#644 AS COL_ANATOMYCODE_2770#677, COL_ANATOMYLABEL_2771#645 AS COL_ANATOMYLABEL_2771#678, COL_STARTDATE_2772#646 AS COL_STARTDATE_2772#679, COL_ENDDATE_2773#647 AS COL_ENDDATE_2773#680, COL_DICTIONARYCODE_2774#648 AS COL_DICTIONARYCODE_2774#681]
      +- Filter true
         +- Project [COL_URI_2764#638, COL_CODE_2765#639, COL_PARENT_2766#640, COL_CODEPARENT_2767#641, COL_LIBELLE_2768#642, COL_LIBELLEPARENT_2769#643, COL_ANATOMYCODE_2770#644, COL_ANATOMYLABEL_2771#645, COL_STARTDATE_2772#646, COL_ENDDATE_2773#647, COL_DICTIONARYCODE_2774#648]
            +- Project [cast(ADICAP_V3_2763_URI_2764#615 as string) AS COL_URI_2764#638, cast(ADICAP_V3_2763_CODE_2765#608 as string) AS COL_CODE_2765#639, cast(ADICAP_V3_2763_PARENT_2766#613 as string) AS COL_PARENT_2766#640, cast(ADICAP_V3_2763_CODEPARENT_2767#607 as string) AS COL_CODEPARENT_2767#641, cast(ADICAP_V3_2763_LIBELLE_2768#612 as string) AS COL_LIBELLE_2768#642, cast(ADICAP_V3_2763_LIBELLEPARENT_2769#611 as string) AS COL_LIBELLEPARENT_2769#643, cast(ADICAP_V3_2763_ANATOMYCODE_2770#605 as string) AS COL_ANATOMYCODE_2770#644, cast(ADICAP_V3_2763_ANATOMYLABEL_2771#606 as string) AS COL_ANATOMYLABEL_2771#645, cast(ADICAP_V3_2763_STARTDATE_2772#614 as string) AS COL_STARTDATE_2772#646, cast(ADICAP_V3_2763_ENDDATE_2773#610 as string) AS COL_ENDDATE_2773#647, cast(ADICAP_V3_2763_DICTIONARYCODE_2774#609 as string) AS COL_DICTIONARYCODE_2774#648]
               +- Project [ANATOMYCODE_2770#561 AS ADICAP_V3_2763_ANATOMYCODE_2770#605, ANATOMYLABEL_2771#562 AS ADICAP_V3_2763_ANATOMYLABEL_2771#606, CODEPARENT_2767#563 AS ADICAP_V3_2763_CODEPARENT_2767#607, CODE_2765#564 AS ADICAP_V3_2763_CODE_2765#608, DICTIONARYCODE_2774#565 AS ADICAP_V3_2763_DICTIONARYCODE_2774#609, ENDDATE_2773#566 AS ADICAP_V3_2763_ENDDATE_2773#610, LIBELLEPARENT_2769#567 AS ADICAP_V3_2763_LIBELLEPARENT_2769#611, LIBELLE_2768#568 AS ADICAP_V3_2763_LIBELLE_2768#612, PARENT_2766#569 AS ADICAP_V3_2763_PARENT_2766#613, STARTDATE_2772#570 AS ADICAP_V3_2763_STARTDATE_2772#614, URI_2764#571 AS ADICAP_V3_2763_URI_2764#615]
                  +- SubqueryAlias ADICAP_V3_2763113
                     +- Project [ANATOMYCODE_2770#561, ANATOMYLABEL_2771#562, CODEPARENT_2767#563, CODE_2765#564, DICTIONARYCODE_2774#565, ENDDATE_2773#566, LIBELLEPARENT_2769#567, LIBELLE_2768#568, PARENT_2766#569, STARTDATE_2772#570, URI_2764#571]
                        +- Project [anatomyCode#531 AS ANATOMYCODE_2770#561, anatomyLabel#532 AS ANATOMYLABEL_2771#562, codeParent#528 AS CODEPARENT_2767#563, code#526 AS CODE_2765#564, dictionaryCode#535 AS DICTIONARYCODE_2774#565, endDate#534 AS ENDDATE_2773#566, libelleParent#530 AS LIBELLEPARENT_2769#567, libelle#529 AS LIBELLE_2768#568, Parent#527 AS PARENT_2766#569, startDate#533 AS STARTDATE_2772#570, URI#525 AS URI_2764#571]
                           +- Project [URI#525, code#526, Parent#527, codeParent#528, libelle#529, libelleParent#530, anatomyCode#531, anatomyLabel#532, startDate#533, endDate#534, dictionaryCode#535, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#536]
                              +- Project [URI#369 AS URI#525, code#382 AS code#526, Parent#395 AS Parent#527, codeParent#408 AS codeParent#528, libelle#421 AS libelle#529, libelleParent#434 AS libelleParent#530, anatomyCode#447 AS anatomyCode#531, anatomyLabel#460 AS anatomyLabel#532, startDate#473 AS startDate#533, endDate#486 AS endDate#534, dictionaryCode#499 AS dictionaryCode#535, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#512 AS 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#536]
                                 +- Project [URI#369, code#382, Parent#395, codeParent#408, libelle#421, libelleParent#434, anatomyCode#447, anatomyLabel#460, startDate#473, endDate#486, dictionaryCode#499, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356 AS 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#512]
                                    +- Project [URI#369, code#382, Parent#395, codeParent#408, libelle#421, libelleParent#434, anatomyCode#447, anatomyLabel#460, startDate#473, endDate#486, dictionaryCode#355 AS dictionaryCode#499, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                       +- Project [URI#369, code#382, Parent#395, codeParent#408, libelle#421, libelleParent#434, anatomyCode#447, anatomyLabel#460, startDate#473, endDate#354 AS endDate#486, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                          +- Project [URI#369, code#382, Parent#395, codeParent#408, libelle#421, libelleParent#434, anatomyCode#447, anatomyLabel#460, startDate#353 AS startDate#473, endDate#354, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                             +- Project [URI#369, code#382, Parent#395, codeParent#408, libelle#421, libelleParent#434, anatomyCode#447, anatomyLabel#352 AS anatomyLabel#460, startDate#353, endDate#354, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                                +- Project [URI#369, code#382, Parent#395, codeParent#408, libelle#421, libelleParent#434, anatomyCode#351 AS anatomyCode#447, anatomyLabel#352, startDate#353, endDate#354, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                                   +- Project [URI#369, code#382, Parent#395, codeParent#408, libelle#421, libelleParent#350 AS libelleParent#434, anatomyCode#351, anatomyLabel#352, startDate#353, endDate#354, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                                      +- Project [URI#369, code#382, Parent#395, codeParent#408, libelle#349 AS libelle#421, libelleParent#350, anatomyCode#351, anatomyLabel#352, startDate#353, endDate#354, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                                         +- Project [URI#369, code#382, Parent#395, codeParent#348 AS codeParent#408, libelle#349, libelleParent#350, anatomyCode#351, anatomyLabel#352, startDate#353, endDate#354, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                                            +- Project [URI#369, code#382, Parent#347 AS Parent#395, codeParent#348, libelle#349, libelleParent#350, anatomyCode#351, anatomyLabel#352, startDate#353, endDate#354, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                                               +- Project [URI#369, code#346 AS code#382, Parent#347, codeParent#348, libelle#349, libelleParent#350, anatomyCode#351, anatomyLabel#352, startDate#353, endDate#354, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                                                  +- Project [URI#345 AS URI#369, code#346, Parent#347, codeParent#348, libelle#349, libelleParent#350, anatomyCode#351, anatomyLabel#352, startDate#353, endDate#354, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                                                     +- Relation[URI#345,code#346,Parent#347,codeParent#348,libelle#349,libelleParent#350,anatomyCode#351,anatomyLabel#352,startDate#353,endDate#354,dictionaryCode#355,1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356] parquet

== Analyzed Logical Plan ==
COL_URI_2764: string, COL_CODE_2765: string, COL_PARENT_2766: string, COL_CODEPARENT_2767: string, COL_LIBELLE_2768: string, COL_LIBELLEPARENT_2769: string, COL_ANATOMYCODE_2770: string, COL_ANATOMYLABEL_2771: string, COL_STARTDATE_2772: string, COL_ENDDATE_2773: string, COL_DICTIONARYCODE_2774: string
GlobalLimit 1500
+- LocalLimit 1500
   +- Project [COL_URI_2764#638 AS COL_URI_2764#671, COL_CODE_2765#639 AS COL_CODE_2765#672, COL_PARENT_2766#640 AS COL_PARENT_2766#673, COL_CODEPARENT_2767#641 AS COL_CODEPARENT_2767#674, COL_LIBELLE_2768#642 AS COL_LIBELLE_2768#675, COL_LIBELLEPARENT_2769#643 AS COL_LIBELLEPARENT_2769#676, COL_ANATOMYCODE_2770#644 AS COL_ANATOMYCODE_2770#677, COL_ANATOMYLABEL_2771#645 AS COL_ANATOMYLABEL_2771#678, COL_STARTDATE_2772#646 AS COL_STARTDATE_2772#679, COL_ENDDATE_2773#647 AS COL_ENDDATE_2773#680, COL_DICTIONARYCODE_2774#648 AS COL_DICTIONARYCODE_2774#681]
      +- Filter true
         +- Project [COL_URI_2764#638, COL_CODE_2765#639, COL_PARENT_2766#640, COL_CODEPARENT_2767#641, COL_LIBELLE_2768#642, COL_LIBELLEPARENT_2769#643, COL_ANATOMYCODE_2770#644, COL_ANATOMYLABEL_2771#645, COL_STARTDATE_2772#646, COL_ENDDATE_2773#647, COL_DICTIONARYCODE_2774#648]
            +- Project [cast(ADICAP_V3_2763_URI_2764#615 as string) AS COL_URI_2764#638, cast(ADICAP_V3_2763_CODE_2765#608 as string) AS COL_CODE_2765#639, cast(ADICAP_V3_2763_PARENT_2766#613 as string) AS COL_PARENT_2766#640, cast(ADICAP_V3_2763_CODEPARENT_2767#607 as string) AS COL_CODEPARENT_2767#641, cast(ADICAP_V3_2763_LIBELLE_2768#612 as string) AS COL_LIBELLE_2768#642, cast(ADICAP_V3_2763_LIBELLEPARENT_2769#611 as string) AS COL_LIBELLEPARENT_2769#643, cast(ADICAP_V3_2763_ANATOMYCODE_2770#605 as string) AS COL_ANATOMYCODE_2770#644, cast(ADICAP_V3_2763_ANATOMYLABEL_2771#606 as string) AS COL_ANATOMYLABEL_2771#645, cast(ADICAP_V3_2763_STARTDATE_2772#614 as string) AS COL_STARTDATE_2772#646, cast(ADICAP_V3_2763_ENDDATE_2773#610 as string) AS COL_ENDDATE_2773#647, cast(ADICAP_V3_2763_DICTIONARYCODE_2774#609 as string) AS COL_DICTIONARYCODE_2774#648]
               +- Project [ANATOMYCODE_2770#561 AS ADICAP_V3_2763_ANATOMYCODE_2770#605, ANATOMYLABEL_2771#562 AS ADICAP_V3_2763_ANATOMYLABEL_2771#606, CODEPARENT_2767#563 AS ADICAP_V3_2763_CODEPARENT_2767#607, CODE_2765#564 AS ADICAP_V3_2763_CODE_2765#608, DICTIONARYCODE_2774#565 AS ADICAP_V3_2763_DICTIONARYCODE_2774#609, ENDDATE_2773#566 AS ADICAP_V3_2763_ENDDATE_2773#610, LIBELLEPARENT_2769#567 AS ADICAP_V3_2763_LIBELLEPARENT_2769#611, LIBELLE_2768#568 AS ADICAP_V3_2763_LIBELLE_2768#612, PARENT_2766#569 AS ADICAP_V3_2763_PARENT_2766#613, STARTDATE_2772#570 AS ADICAP_V3_2763_STARTDATE_2772#614, URI_2764#571 AS ADICAP_V3_2763_URI_2764#615]
                  +- SubqueryAlias ADICAP_V3_2763113
                     +- Project [ANATOMYCODE_2770#561, ANATOMYLABEL_2771#562, CODEPARENT_2767#563, CODE_2765#564, DICTIONARYCODE_2774#565, ENDDATE_2773#566, LIBELLEPARENT_2769#567, LIBELLE_2768#568, PARENT_2766#569, STARTDATE_2772#570, URI_2764#571]
                        +- Project [anatomyCode#531 AS ANATOMYCODE_2770#561, anatomyLabel#532 AS ANATOMYLABEL_2771#562, codeParent#528 AS CODEPARENT_2767#563, code#526 AS CODE_2765#564, dictionaryCode#535 AS DICTIONARYCODE_2774#565, endDate#534 AS ENDDATE_2773#566, libelleParent#530 AS LIBELLEPARENT_2769#567, libelle#529 AS LIBELLE_2768#568, Parent#527 AS PARENT_2766#569, startDate#533 AS STARTDATE_2772#570, URI#525 AS URI_2764#571]
                           +- Project [URI#525, code#526, Parent#527, codeParent#528, libelle#529, libelleParent#530, anatomyCode#531, anatomyLabel#532, startDate#533, endDate#534, dictionaryCode#535, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#536]
                              +- Project [URI#369 AS URI#525, code#382 AS code#526, Parent#395 AS Parent#527, codeParent#408 AS codeParent#528, libelle#421 AS libelle#529, libelleParent#434 AS libelleParent#530, anatomyCode#447 AS anatomyCode#531, anatomyLabel#460 AS anatomyLabel#532, startDate#473 AS startDate#533, endDate#486 AS endDate#534, dictionaryCode#499 AS dictionaryCode#535, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#512 AS 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#536]
                                 +- Project [URI#369, code#382, Parent#395, codeParent#408, libelle#421, libelleParent#434, anatomyCode#447, anatomyLabel#460, startDate#473, endDate#486, dictionaryCode#499, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356 AS 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#512]
                                    +- Project [URI#369, code#382, Parent#395, codeParent#408, libelle#421, libelleParent#434, anatomyCode#447, anatomyLabel#460, startDate#473, endDate#486, dictionaryCode#355 AS dictionaryCode#499, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                       +- Project [URI#369, code#382, Parent#395, codeParent#408, libelle#421, libelleParent#434, anatomyCode#447, anatomyLabel#460, startDate#473, endDate#354 AS endDate#486, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                          +- Project [URI#369, code#382, Parent#395, codeParent#408, libelle#421, libelleParent#434, anatomyCode#447, anatomyLabel#460, startDate#353 AS startDate#473, endDate#354, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                             +- Project [URI#369, code#382, Parent#395, codeParent#408, libelle#421, libelleParent#434, anatomyCode#447, anatomyLabel#352 AS anatomyLabel#460, startDate#353, endDate#354, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                                +- Project [URI#369, code#382, Parent#395, codeParent#408, libelle#421, libelleParent#434, anatomyCode#351 AS anatomyCode#447, anatomyLabel#352, startDate#353, endDate#354, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                                   +- Project [URI#369, code#382, Parent#395, codeParent#408, libelle#421, libelleParent#350 AS libelleParent#434, anatomyCode#351, anatomyLabel#352, startDate#353, endDate#354, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                                      +- Project [URI#369, code#382, Parent#395, codeParent#408, libelle#349 AS libelle#421, libelleParent#350, anatomyCode#351, anatomyLabel#352, startDate#353, endDate#354, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                                         +- Project [URI#369, code#382, Parent#395, codeParent#348 AS codeParent#408, libelle#349, libelleParent#350, anatomyCode#351, anatomyLabel#352, startDate#353, endDate#354, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                                            +- Project [URI#369, code#382, Parent#347 AS Parent#395, codeParent#348, libelle#349, libelleParent#350, anatomyCode#351, anatomyLabel#352, startDate#353, endDate#354, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                                               +- Project [URI#369, code#346 AS code#382, Parent#347, codeParent#348, libelle#349, libelleParent#350, anatomyCode#351, anatomyLabel#352, startDate#353, endDate#354, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                                                  +- Project [URI#345 AS URI#369, code#346, Parent#347, codeParent#348, libelle#349, libelleParent#350, anatomyCode#351, anatomyLabel#352, startDate#353, endDate#354, dictionaryCode#355, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356]
                                                                     +- Relation[URI#345,code#346,Parent#347,codeParent#348,libelle#349,libelleParent#350,anatomyCode#351,anatomyLabel#352,startDate#353,endDate#354,dictionaryCode#355,1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356] parquet

== Optimized Logical Plan ==
GlobalLimit 1500
+- LocalLimit 1500
   +- Project [URI#345 AS COL_URI_2764#671, code#346 AS COL_CODE_2765#672, Parent#347 AS COL_PARENT_2766#673, codeParent#348 AS COL_CODEPARENT_2767#674, libelle#349 AS COL_LIBELLE_2768#675, libelleParent#350 AS COL_LIBELLEPARENT_2769#676, anatomyCode#351 AS COL_ANATOMYCODE_2770#677, anatomyLabel#352 AS COL_ANATOMYLABEL_2771#678, startDate#353 AS COL_STARTDATE_2772#679, endDate#354 AS COL_ENDDATE_2773#680, dictionaryCode#355 AS COL_DICTIONARYCODE_2774#681]
      +- Relation[URI#345,code#346,Parent#347,codeParent#348,libelle#349,libelleParent#350,anatomyCode#351,anatomyLabel#352,startDate#353,endDate#354,dictionaryCode#355,1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#356] parquet

== Physical Plan ==
CollectLimit 1500
+- *(1) Project [URI#345 AS COL_URI_2764#671, code#346 AS COL_CODE_2765#672, Parent#347 AS COL_PARENT_2766#673, codeParent#348 AS COL_CODEPARENT_2767#674, libelle#349 AS COL_LIBELLE_2768#675, libelleParent#350 AS COL_LIBELLEPARENT_2769#676, anatomyCode#351 AS COL_ANATOMYCODE_2770#677, anatomyLabel#352 AS COL_ANATOMYLABEL_2771#678, startDate#353 AS COL_STARTDATE_2772#679, endDate#354 AS COL_ENDDATE_2773#680, dictionaryCode#355 AS COL_DICTIONARYCODE_2774#681]
   +- *(1) ColumnarToRow
      +- FileScan parquet [URI#345,code#346,Parent#347,codeParent#348,libelle#349,libelleParent#350,anatomyCode#351,anatomyLabel#352,startDate#353,endDate#354,dictionaryCode#355] 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...