EVAL1_SPC2 - Details for Query 44

Details for Query 44

Submitted Time: 2025/09/15 13:43:15
Duration: 0.1 s
Succeeded Jobs: 62
Show the Stage ID and Task ID that corresponds to the max metric
Details
== Parsed Logical Plan ==
GlobalLimit 1500
+- LocalLimit 1500
   +- Project [cast(ADICAP_V3_2763_URI_2764#6715 as string) AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#6740, cast(ADICAP_V3_2763_CODE_2765#6708 as string) AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#6741, cast(ADICAP_V3_2763_PARENT_2766#6713 as string) AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#6742, cast(ADICAP_V3_2763_CODEPARENT_2767#6707 as string) AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#6743, cast(ADICAP_V3_2763_LIBELLE_2768#6712 as string) AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#6744, cast(ADICAP_V3_2763_LIBELLEPARENT_2769#6711 as string) AS COL_D472A873_1242_4F73_B703_84133E7F376C#6745, cast(ADICAP_V3_2763_ANATOMYCODE_2770#6705 as string) AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#6746, cast(ADICAP_V3_2763_ANATOMYLABEL_2771#6706 as string) AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#6747, cast(ADICAP_V3_2763_STARTDATE_2772#6714 as string) AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#6748, cast(ADICAP_V3_2763_ENDDATE_2773#6710 as string) AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#6749, cast(ADICAP_V3_2763_DICTIONARYCODE_2774#6709 as string) AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#6750]
      +- Project [ANATOMYCODE_2770#6614 AS ADICAP_V3_2763_ANATOMYCODE_2770#6705, ANATOMYLABEL_2771#6615 AS ADICAP_V3_2763_ANATOMYLABEL_2771#6706, CODEPARENT_2767#6616 AS ADICAP_V3_2763_CODEPARENT_2767#6707, CODE_2765#6617 AS ADICAP_V3_2763_CODE_2765#6708, DICTIONARYCODE_2774#6618 AS ADICAP_V3_2763_DICTIONARYCODE_2774#6709, ENDDATE_2773#6619 AS ADICAP_V3_2763_ENDDATE_2773#6710, LIBELLEPARENT_2769#6620 AS ADICAP_V3_2763_LIBELLEPARENT_2769#6711, LIBELLE_2768#6621 AS ADICAP_V3_2763_LIBELLE_2768#6712, PARENT_2766#6622 AS ADICAP_V3_2763_PARENT_2766#6713, STARTDATE_2772#6623 AS ADICAP_V3_2763_STARTDATE_2772#6714, URI_2764#6624 AS ADICAP_V3_2763_URI_2764#6715]
         +- SubqueryAlias ADICAP_V3_2763113
            +- Relation[ANATOMYCODE_2770#6614,ANATOMYLABEL_2771#6615,CODEPARENT_2767#6616,CODE_2765#6617,DICTIONARYCODE_2774#6618,ENDDATE_2773#6619,LIBELLEPARENT_2769#6620,LIBELLE_2768#6621,PARENT_2766#6622,STARTDATE_2772#6623,URI_2764#6624] parquet

== Analyzed Logical Plan ==
COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC: string, COL_F5FF90C9_04E5_46B3_8805_3F1026104464: string, COL_A397999A_66EC_4CA1_8A3D_38331A08634E: string, COL_62572762_1407_4D4C_905B_2FDF6DB67E90: string, COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38: string, COL_D472A873_1242_4F73_B703_84133E7F376C: string, COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94: string, COL_A7E2BC98_F636_45B9_8094_DA576E390BE8: string, COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649: string, COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8: string, COL_B752B85C_FAFD_434B_BEB1_25579727A129: string
GlobalLimit 1500
+- LocalLimit 1500
   +- Project [cast(ADICAP_V3_2763_URI_2764#6715 as string) AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#6740, cast(ADICAP_V3_2763_CODE_2765#6708 as string) AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#6741, cast(ADICAP_V3_2763_PARENT_2766#6713 as string) AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#6742, cast(ADICAP_V3_2763_CODEPARENT_2767#6707 as string) AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#6743, cast(ADICAP_V3_2763_LIBELLE_2768#6712 as string) AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#6744, cast(ADICAP_V3_2763_LIBELLEPARENT_2769#6711 as string) AS COL_D472A873_1242_4F73_B703_84133E7F376C#6745, cast(ADICAP_V3_2763_ANATOMYCODE_2770#6705 as string) AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#6746, cast(ADICAP_V3_2763_ANATOMYLABEL_2771#6706 as string) AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#6747, cast(ADICAP_V3_2763_STARTDATE_2772#6714 as string) AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#6748, cast(ADICAP_V3_2763_ENDDATE_2773#6710 as string) AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#6749, cast(ADICAP_V3_2763_DICTIONARYCODE_2774#6709 as string) AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#6750]
      +- Project [ANATOMYCODE_2770#6614 AS ADICAP_V3_2763_ANATOMYCODE_2770#6705, ANATOMYLABEL_2771#6615 AS ADICAP_V3_2763_ANATOMYLABEL_2771#6706, CODEPARENT_2767#6616 AS ADICAP_V3_2763_CODEPARENT_2767#6707, CODE_2765#6617 AS ADICAP_V3_2763_CODE_2765#6708, DICTIONARYCODE_2774#6618 AS ADICAP_V3_2763_DICTIONARYCODE_2774#6709, ENDDATE_2773#6619 AS ADICAP_V3_2763_ENDDATE_2773#6710, LIBELLEPARENT_2769#6620 AS ADICAP_V3_2763_LIBELLEPARENT_2769#6711, LIBELLE_2768#6621 AS ADICAP_V3_2763_LIBELLE_2768#6712, PARENT_2766#6622 AS ADICAP_V3_2763_PARENT_2766#6713, STARTDATE_2772#6623 AS ADICAP_V3_2763_STARTDATE_2772#6714, URI_2764#6624 AS ADICAP_V3_2763_URI_2764#6715]
         +- SubqueryAlias ADICAP_V3_2763113
            +- Relation[ANATOMYCODE_2770#6614,ANATOMYLABEL_2771#6615,CODEPARENT_2767#6616,CODE_2765#6617,DICTIONARYCODE_2774#6618,ENDDATE_2773#6619,LIBELLEPARENT_2769#6620,LIBELLE_2768#6621,PARENT_2766#6622,STARTDATE_2772#6623,URI_2764#6624] parquet

== Optimized Logical Plan ==
GlobalLimit 1500
+- LocalLimit 1500
   +- Project [URI_2764#6624 AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#6740, CODE_2765#6617 AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#6741, PARENT_2766#6622 AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#6742, CODEPARENT_2767#6616 AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#6743, LIBELLE_2768#6621 AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#6744, LIBELLEPARENT_2769#6620 AS COL_D472A873_1242_4F73_B703_84133E7F376C#6745, ANATOMYCODE_2770#6614 AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#6746, ANATOMYLABEL_2771#6615 AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#6747, STARTDATE_2772#6623 AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#6748, ENDDATE_2773#6619 AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#6749, DICTIONARYCODE_2774#6618 AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#6750]
      +- Relation[ANATOMYCODE_2770#6614,ANATOMYLABEL_2771#6615,CODEPARENT_2767#6616,CODE_2765#6617,DICTIONARYCODE_2774#6618,ENDDATE_2773#6619,LIBELLEPARENT_2769#6620,LIBELLE_2768#6621,PARENT_2766#6622,STARTDATE_2772#6623,URI_2764#6624] parquet

== Physical Plan ==
CollectLimit 1500
+- *(1) Project [URI_2764#6624 AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#6740, CODE_2765#6617 AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#6741, PARENT_2766#6622 AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#6742, CODEPARENT_2767#6616 AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#6743, LIBELLE_2768#6621 AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#6744, LIBELLEPARENT_2769#6620 AS COL_D472A873_1242_4F73_B703_84133E7F376C#6745, ANATOMYCODE_2770#6614 AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#6746, ANATOMYLABEL_2771#6615 AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#6747, STARTDATE_2772#6623 AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#6748, ENDDATE_2773#6619 AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#6749, DICTIONARYCODE_2774#6618 AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#6750]
   +- *(1) ColumnarToRow
      +- FileScan parquet [ANATOMYCODE_2770#6614,ANATOMYLABEL_2771#6615,CODEPARENT_2767#6616,CODE_2765#6617,DICTIONARYCODE_2774#6618,ENDDATE_2773#6619,LIBELLEPARENT_2769#6620,LIBELLE_2768#6621,PARENT_2766#6622,STARTDATE_2772#6623,URI_2764#6624] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/uet/ADICAP_V3_2763], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<ANATOMYCODE_2770:string,ANATOMYLABEL_2771:string,CODEPARENT_2767:string,CODE_2765:string,D...