EVAL1_SPC2 - Details for Query 5

Details for Query 5

Submitted Time: 2025/09/15 13:12:46
Duration: 0.5 s
Succeeded Jobs: 5 6
Show the Stage ID and Task ID that corresponds to the max metric
Details
== Parsed Logical Plan ==
Aggregate [count(1) AS count#1065L]
+- Project [COL_URI_2764#998 AS COL_URI_2764#1031, COL_CODE_2765#999 AS COL_CODE_2765#1032, COL_PARENT_2766#1000 AS COL_PARENT_2766#1033, COL_CODEPARENT_2767#1001 AS COL_CODEPARENT_2767#1034, COL_LIBELLE_2768#1002 AS COL_LIBELLE_2768#1035, COL_LIBELLEPARENT_2769#1003 AS COL_LIBELLEPARENT_2769#1036, COL_ANATOMYCODE_2770#1004 AS COL_ANATOMYCODE_2770#1037, COL_ANATOMYLABEL_2771#1005 AS COL_ANATOMYLABEL_2771#1038, COL_STARTDATE_2772#1006 AS COL_STARTDATE_2772#1039, COL_ENDDATE_2773#1007 AS COL_ENDDATE_2773#1040, COL_DICTIONARYCODE_2774#1008 AS COL_DICTIONARYCODE_2774#1041]
   +- Filter true
      +- Project [COL_URI_2764#998, COL_CODE_2765#999, COL_PARENT_2766#1000, COL_CODEPARENT_2767#1001, COL_LIBELLE_2768#1002, COL_LIBELLEPARENT_2769#1003, COL_ANATOMYCODE_2770#1004, COL_ANATOMYLABEL_2771#1005, COL_STARTDATE_2772#1006, COL_ENDDATE_2773#1007, COL_DICTIONARYCODE_2774#1008]
         +- Project [cast(ADICAP_V3_2763_URI_2764#975 as string) AS COL_URI_2764#998, cast(ADICAP_V3_2763_CODE_2765#968 as string) AS COL_CODE_2765#999, cast(ADICAP_V3_2763_PARENT_2766#973 as string) AS COL_PARENT_2766#1000, cast(ADICAP_V3_2763_CODEPARENT_2767#967 as string) AS COL_CODEPARENT_2767#1001, cast(ADICAP_V3_2763_LIBELLE_2768#972 as string) AS COL_LIBELLE_2768#1002, cast(ADICAP_V3_2763_LIBELLEPARENT_2769#971 as string) AS COL_LIBELLEPARENT_2769#1003, cast(ADICAP_V3_2763_ANATOMYCODE_2770#965 as string) AS COL_ANATOMYCODE_2770#1004, cast(ADICAP_V3_2763_ANATOMYLABEL_2771#966 as string) AS COL_ANATOMYLABEL_2771#1005, cast(ADICAP_V3_2763_STARTDATE_2772#974 as string) AS COL_STARTDATE_2772#1006, cast(ADICAP_V3_2763_ENDDATE_2773#970 as string) AS COL_ENDDATE_2773#1007, cast(ADICAP_V3_2763_DICTIONARYCODE_2774#969 as string) AS COL_DICTIONARYCODE_2774#1008]
            +- Project [ANATOMYCODE_2770#921 AS ADICAP_V3_2763_ANATOMYCODE_2770#965, ANATOMYLABEL_2771#922 AS ADICAP_V3_2763_ANATOMYLABEL_2771#966, CODEPARENT_2767#923 AS ADICAP_V3_2763_CODEPARENT_2767#967, CODE_2765#924 AS ADICAP_V3_2763_CODE_2765#968, DICTIONARYCODE_2774#925 AS ADICAP_V3_2763_DICTIONARYCODE_2774#969, ENDDATE_2773#926 AS ADICAP_V3_2763_ENDDATE_2773#970, LIBELLEPARENT_2769#927 AS ADICAP_V3_2763_LIBELLEPARENT_2769#971, LIBELLE_2768#928 AS ADICAP_V3_2763_LIBELLE_2768#972, PARENT_2766#929 AS ADICAP_V3_2763_PARENT_2766#973, STARTDATE_2772#930 AS ADICAP_V3_2763_STARTDATE_2772#974, URI_2764#931 AS ADICAP_V3_2763_URI_2764#975]
               +- SubqueryAlias ADICAP_V3_2763111
                  +- Project [ANATOMYCODE_2770#921, ANATOMYLABEL_2771#922, CODEPARENT_2767#923, CODE_2765#924, DICTIONARYCODE_2774#925, ENDDATE_2773#926, LIBELLEPARENT_2769#927, LIBELLE_2768#928, PARENT_2766#929, STARTDATE_2772#930, URI_2764#931]
                     +- Project [anatomyCode#891 AS ANATOMYCODE_2770#921, anatomyLabel#892 AS ANATOMYLABEL_2771#922, codeParent#888 AS CODEPARENT_2767#923, code#886 AS CODE_2765#924, dictionaryCode#895 AS DICTIONARYCODE_2774#925, endDate#894 AS ENDDATE_2773#926, libelleParent#890 AS LIBELLEPARENT_2769#927, libelle#889 AS LIBELLE_2768#928, Parent#887 AS PARENT_2766#929, startDate#893 AS STARTDATE_2772#930, URI#885 AS URI_2764#931]
                        +- Project [URI#885, code#886, Parent#887, codeParent#888, libelle#889, libelleParent#890, anatomyCode#891, anatomyLabel#892, startDate#893, endDate#894, dictionaryCode#895, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#896]
                           +- Project [URI#729 AS URI#885, code#742 AS code#886, Parent#755 AS Parent#887, codeParent#768 AS codeParent#888, libelle#781 AS libelle#889, libelleParent#794 AS libelleParent#890, anatomyCode#807 AS anatomyCode#891, anatomyLabel#820 AS anatomyLabel#892, startDate#833 AS startDate#893, endDate#846 AS endDate#894, dictionaryCode#859 AS dictionaryCode#895, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#872 AS 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#896]
                              +- Project [URI#729, code#742, Parent#755, codeParent#768, libelle#781, libelleParent#794, anatomyCode#807, anatomyLabel#820, startDate#833, endDate#846, dictionaryCode#859, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716 AS 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#872]
                                 +- Project [URI#729, code#742, Parent#755, codeParent#768, libelle#781, libelleParent#794, anatomyCode#807, anatomyLabel#820, startDate#833, endDate#846, dictionaryCode#715 AS dictionaryCode#859, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                    +- Project [URI#729, code#742, Parent#755, codeParent#768, libelle#781, libelleParent#794, anatomyCode#807, anatomyLabel#820, startDate#833, endDate#714 AS endDate#846, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                       +- Project [URI#729, code#742, Parent#755, codeParent#768, libelle#781, libelleParent#794, anatomyCode#807, anatomyLabel#820, startDate#713 AS startDate#833, endDate#714, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                          +- Project [URI#729, code#742, Parent#755, codeParent#768, libelle#781, libelleParent#794, anatomyCode#807, anatomyLabel#712 AS anatomyLabel#820, startDate#713, endDate#714, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                             +- Project [URI#729, code#742, Parent#755, codeParent#768, libelle#781, libelleParent#794, anatomyCode#711 AS anatomyCode#807, anatomyLabel#712, startDate#713, endDate#714, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                                +- Project [URI#729, code#742, Parent#755, codeParent#768, libelle#781, libelleParent#710 AS libelleParent#794, anatomyCode#711, anatomyLabel#712, startDate#713, endDate#714, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                                   +- Project [URI#729, code#742, Parent#755, codeParent#768, libelle#709 AS libelle#781, libelleParent#710, anatomyCode#711, anatomyLabel#712, startDate#713, endDate#714, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                                      +- Project [URI#729, code#742, Parent#755, codeParent#708 AS codeParent#768, libelle#709, libelleParent#710, anatomyCode#711, anatomyLabel#712, startDate#713, endDate#714, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                                         +- Project [URI#729, code#742, Parent#707 AS Parent#755, codeParent#708, libelle#709, libelleParent#710, anatomyCode#711, anatomyLabel#712, startDate#713, endDate#714, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                                            +- Project [URI#729, code#706 AS code#742, Parent#707, codeParent#708, libelle#709, libelleParent#710, anatomyCode#711, anatomyLabel#712, startDate#713, endDate#714, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                                               +- Project [URI#705 AS URI#729, code#706, Parent#707, codeParent#708, libelle#709, libelleParent#710, anatomyCode#711, anatomyLabel#712, startDate#713, endDate#714, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                                                  +- Relation[URI#705,code#706,Parent#707,codeParent#708,libelle#709,libelleParent#710,anatomyCode#711,anatomyLabel#712,startDate#713,endDate#714,dictionaryCode#715,1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716] parquet

== Analyzed Logical Plan ==
count: bigint
Aggregate [count(1) AS count#1065L]
+- Project [COL_URI_2764#998 AS COL_URI_2764#1031, COL_CODE_2765#999 AS COL_CODE_2765#1032, COL_PARENT_2766#1000 AS COL_PARENT_2766#1033, COL_CODEPARENT_2767#1001 AS COL_CODEPARENT_2767#1034, COL_LIBELLE_2768#1002 AS COL_LIBELLE_2768#1035, COL_LIBELLEPARENT_2769#1003 AS COL_LIBELLEPARENT_2769#1036, COL_ANATOMYCODE_2770#1004 AS COL_ANATOMYCODE_2770#1037, COL_ANATOMYLABEL_2771#1005 AS COL_ANATOMYLABEL_2771#1038, COL_STARTDATE_2772#1006 AS COL_STARTDATE_2772#1039, COL_ENDDATE_2773#1007 AS COL_ENDDATE_2773#1040, COL_DICTIONARYCODE_2774#1008 AS COL_DICTIONARYCODE_2774#1041]
   +- Filter true
      +- Project [COL_URI_2764#998, COL_CODE_2765#999, COL_PARENT_2766#1000, COL_CODEPARENT_2767#1001, COL_LIBELLE_2768#1002, COL_LIBELLEPARENT_2769#1003, COL_ANATOMYCODE_2770#1004, COL_ANATOMYLABEL_2771#1005, COL_STARTDATE_2772#1006, COL_ENDDATE_2773#1007, COL_DICTIONARYCODE_2774#1008]
         +- Project [cast(ADICAP_V3_2763_URI_2764#975 as string) AS COL_URI_2764#998, cast(ADICAP_V3_2763_CODE_2765#968 as string) AS COL_CODE_2765#999, cast(ADICAP_V3_2763_PARENT_2766#973 as string) AS COL_PARENT_2766#1000, cast(ADICAP_V3_2763_CODEPARENT_2767#967 as string) AS COL_CODEPARENT_2767#1001, cast(ADICAP_V3_2763_LIBELLE_2768#972 as string) AS COL_LIBELLE_2768#1002, cast(ADICAP_V3_2763_LIBELLEPARENT_2769#971 as string) AS COL_LIBELLEPARENT_2769#1003, cast(ADICAP_V3_2763_ANATOMYCODE_2770#965 as string) AS COL_ANATOMYCODE_2770#1004, cast(ADICAP_V3_2763_ANATOMYLABEL_2771#966 as string) AS COL_ANATOMYLABEL_2771#1005, cast(ADICAP_V3_2763_STARTDATE_2772#974 as string) AS COL_STARTDATE_2772#1006, cast(ADICAP_V3_2763_ENDDATE_2773#970 as string) AS COL_ENDDATE_2773#1007, cast(ADICAP_V3_2763_DICTIONARYCODE_2774#969 as string) AS COL_DICTIONARYCODE_2774#1008]
            +- Project [ANATOMYCODE_2770#921 AS ADICAP_V3_2763_ANATOMYCODE_2770#965, ANATOMYLABEL_2771#922 AS ADICAP_V3_2763_ANATOMYLABEL_2771#966, CODEPARENT_2767#923 AS ADICAP_V3_2763_CODEPARENT_2767#967, CODE_2765#924 AS ADICAP_V3_2763_CODE_2765#968, DICTIONARYCODE_2774#925 AS ADICAP_V3_2763_DICTIONARYCODE_2774#969, ENDDATE_2773#926 AS ADICAP_V3_2763_ENDDATE_2773#970, LIBELLEPARENT_2769#927 AS ADICAP_V3_2763_LIBELLEPARENT_2769#971, LIBELLE_2768#928 AS ADICAP_V3_2763_LIBELLE_2768#972, PARENT_2766#929 AS ADICAP_V3_2763_PARENT_2766#973, STARTDATE_2772#930 AS ADICAP_V3_2763_STARTDATE_2772#974, URI_2764#931 AS ADICAP_V3_2763_URI_2764#975]
               +- SubqueryAlias ADICAP_V3_2763111
                  +- Project [ANATOMYCODE_2770#921, ANATOMYLABEL_2771#922, CODEPARENT_2767#923, CODE_2765#924, DICTIONARYCODE_2774#925, ENDDATE_2773#926, LIBELLEPARENT_2769#927, LIBELLE_2768#928, PARENT_2766#929, STARTDATE_2772#930, URI_2764#931]
                     +- Project [anatomyCode#891 AS ANATOMYCODE_2770#921, anatomyLabel#892 AS ANATOMYLABEL_2771#922, codeParent#888 AS CODEPARENT_2767#923, code#886 AS CODE_2765#924, dictionaryCode#895 AS DICTIONARYCODE_2774#925, endDate#894 AS ENDDATE_2773#926, libelleParent#890 AS LIBELLEPARENT_2769#927, libelle#889 AS LIBELLE_2768#928, Parent#887 AS PARENT_2766#929, startDate#893 AS STARTDATE_2772#930, URI#885 AS URI_2764#931]
                        +- Project [URI#885, code#886, Parent#887, codeParent#888, libelle#889, libelleParent#890, anatomyCode#891, anatomyLabel#892, startDate#893, endDate#894, dictionaryCode#895, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#896]
                           +- Project [URI#729 AS URI#885, code#742 AS code#886, Parent#755 AS Parent#887, codeParent#768 AS codeParent#888, libelle#781 AS libelle#889, libelleParent#794 AS libelleParent#890, anatomyCode#807 AS anatomyCode#891, anatomyLabel#820 AS anatomyLabel#892, startDate#833 AS startDate#893, endDate#846 AS endDate#894, dictionaryCode#859 AS dictionaryCode#895, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#872 AS 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#896]
                              +- Project [URI#729, code#742, Parent#755, codeParent#768, libelle#781, libelleParent#794, anatomyCode#807, anatomyLabel#820, startDate#833, endDate#846, dictionaryCode#859, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716 AS 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#872]
                                 +- Project [URI#729, code#742, Parent#755, codeParent#768, libelle#781, libelleParent#794, anatomyCode#807, anatomyLabel#820, startDate#833, endDate#846, dictionaryCode#715 AS dictionaryCode#859, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                    +- Project [URI#729, code#742, Parent#755, codeParent#768, libelle#781, libelleParent#794, anatomyCode#807, anatomyLabel#820, startDate#833, endDate#714 AS endDate#846, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                       +- Project [URI#729, code#742, Parent#755, codeParent#768, libelle#781, libelleParent#794, anatomyCode#807, anatomyLabel#820, startDate#713 AS startDate#833, endDate#714, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                          +- Project [URI#729, code#742, Parent#755, codeParent#768, libelle#781, libelleParent#794, anatomyCode#807, anatomyLabel#712 AS anatomyLabel#820, startDate#713, endDate#714, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                             +- Project [URI#729, code#742, Parent#755, codeParent#768, libelle#781, libelleParent#794, anatomyCode#711 AS anatomyCode#807, anatomyLabel#712, startDate#713, endDate#714, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                                +- Project [URI#729, code#742, Parent#755, codeParent#768, libelle#781, libelleParent#710 AS libelleParent#794, anatomyCode#711, anatomyLabel#712, startDate#713, endDate#714, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                                   +- Project [URI#729, code#742, Parent#755, codeParent#768, libelle#709 AS libelle#781, libelleParent#710, anatomyCode#711, anatomyLabel#712, startDate#713, endDate#714, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                                      +- Project [URI#729, code#742, Parent#755, codeParent#708 AS codeParent#768, libelle#709, libelleParent#710, anatomyCode#711, anatomyLabel#712, startDate#713, endDate#714, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                                         +- Project [URI#729, code#742, Parent#707 AS Parent#755, codeParent#708, libelle#709, libelleParent#710, anatomyCode#711, anatomyLabel#712, startDate#713, endDate#714, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                                            +- Project [URI#729, code#706 AS code#742, Parent#707, codeParent#708, libelle#709, libelleParent#710, anatomyCode#711, anatomyLabel#712, startDate#713, endDate#714, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                                               +- Project [URI#705 AS URI#729, code#706, Parent#707, codeParent#708, libelle#709, libelleParent#710, anatomyCode#711, anatomyLabel#712, startDate#713, endDate#714, dictionaryCode#715, 1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716]
                                                                  +- Relation[URI#705,code#706,Parent#707,codeParent#708,libelle#709,libelleParent#710,anatomyCode#711,anatomyLabel#712,startDate#713,endDate#714,dictionaryCode#715,1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716] parquet

== Optimized Logical Plan ==
Aggregate [count(1) AS count#1065L]
+- Project
   +- Relation[URI#705,code#706,Parent#707,codeParent#708,libelle#709,libelleParent#710,anatomyCode#711,anatomyLabel#712,startDate#713,endDate#714,dictionaryCode#715,1E141C3C_4381_4E6F_9D5B_20E374029A33HEADER_COL_DETAIL_DEPOT#716] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- *(2) HashAggregate(keys=[], functions=[count(1)], output=[count#1065L])
   +- ShuffleQueryStage 0
      +- Exchange SinglePartition, true, [id=#71]
         +- *(1) HashAggregate(keys=[], functions=[partial_count(1)], output=[count#1068L])
            +- *(1) ColumnarToRow
               +- FileScan parquet [] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/input/depot/excel/cache/1E141C3C_4381_4E6F_9D5B_20E374029A33_4b2e6d3..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<>