== Parsed Logical Plan ==
GlobalLimit 10
+- LocalLimit 10
+- Sort [COL_62572762_1407_4D4C_905B_2FDF6DB67E902#7321L DESC NULLS LAST], true
+- Project [COL_62572762_1407_4D4C_905B_2FDF6DB67E901#7307, COL_62572762_1407_4D4C_905B_2FDF6DB67E902#7321L]
+- Aggregate [COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7288], [COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7288 AS COL_62572762_1407_4D4C_905B_2FDF6DB67E901#7307, 1 AS NULL_1#7322, count(1) AS COL_62572762_1407_4D4C_905B_2FDF6DB67E902#7321L]
+- Filter isnotnull(COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7288)
+- Project [cast(ADICAP_V3_2763_URI_2764#7262 as string) AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7285, cast(ADICAP_V3_2763_CODE_2765#7255 as string) AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7286, cast(ADICAP_V3_2763_PARENT_2766#7260 as string) AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7287, cast(ADICAP_V3_2763_CODEPARENT_2767#7254 as string) AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7288, cast(ADICAP_V3_2763_LIBELLE_2768#7259 as string) AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7289, cast(ADICAP_V3_2763_LIBELLEPARENT_2769#7258 as string) AS COL_D472A873_1242_4F73_B703_84133E7F376C#7290, cast(ADICAP_V3_2763_ANATOMYCODE_2770#7252 as string) AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7291, cast(ADICAP_V3_2763_ANATOMYLABEL_2771#7253 as string) AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7292, cast(ADICAP_V3_2763_STARTDATE_2772#7261 as string) AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7293, cast(ADICAP_V3_2763_ENDDATE_2773#7257 as string) AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7294, cast(ADICAP_V3_2763_DICTIONARYCODE_2774#7256 as string) AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#7295]
+- Project [ANATOMYCODE_2770#7219 AS ADICAP_V3_2763_ANATOMYCODE_2770#7252, ANATOMYLABEL_2771#7220 AS ADICAP_V3_2763_ANATOMYLABEL_2771#7253, CODEPARENT_2767#7221 AS ADICAP_V3_2763_CODEPARENT_2767#7254, CODE_2765#7222 AS ADICAP_V3_2763_CODE_2765#7255, DICTIONARYCODE_2774#7223 AS ADICAP_V3_2763_DICTIONARYCODE_2774#7256, ENDDATE_2773#7224 AS ADICAP_V3_2763_ENDDATE_2773#7257, LIBELLEPARENT_2769#7225 AS ADICAP_V3_2763_LIBELLEPARENT_2769#7258, LIBELLE_2768#7226 AS ADICAP_V3_2763_LIBELLE_2768#7259, PARENT_2766#7227 AS ADICAP_V3_2763_PARENT_2766#7260, STARTDATE_2772#7228 AS ADICAP_V3_2763_STARTDATE_2772#7261, URI_2764#7229 AS ADICAP_V3_2763_URI_2764#7262]
+- SubqueryAlias ADICAP_V3_2763110
+- Relation[ANATOMYCODE_2770#7219,ANATOMYLABEL_2771#7220,CODEPARENT_2767#7221,CODE_2765#7222,DICTIONARYCODE_2774#7223,ENDDATE_2773#7224,LIBELLEPARENT_2769#7225,LIBELLE_2768#7226,PARENT_2766#7227,STARTDATE_2772#7228,URI_2764#7229] parquet
== Analyzed Logical Plan ==
COL_62572762_1407_4D4C_905B_2FDF6DB67E901: string, COL_62572762_1407_4D4C_905B_2FDF6DB67E902: bigint
GlobalLimit 10
+- LocalLimit 10
+- Sort [COL_62572762_1407_4D4C_905B_2FDF6DB67E902#7321L DESC NULLS LAST], true
+- Project [COL_62572762_1407_4D4C_905B_2FDF6DB67E901#7307, COL_62572762_1407_4D4C_905B_2FDF6DB67E902#7321L]
+- Aggregate [COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7288], [COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7288 AS COL_62572762_1407_4D4C_905B_2FDF6DB67E901#7307, 1 AS NULL_1#7322, count(1) AS COL_62572762_1407_4D4C_905B_2FDF6DB67E902#7321L]
+- Filter isnotnull(COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7288)
+- Project [cast(ADICAP_V3_2763_URI_2764#7262 as string) AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7285, cast(ADICAP_V3_2763_CODE_2765#7255 as string) AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7286, cast(ADICAP_V3_2763_PARENT_2766#7260 as string) AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7287, cast(ADICAP_V3_2763_CODEPARENT_2767#7254 as string) AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7288, cast(ADICAP_V3_2763_LIBELLE_2768#7259 as string) AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7289, cast(ADICAP_V3_2763_LIBELLEPARENT_2769#7258 as string) AS COL_D472A873_1242_4F73_B703_84133E7F376C#7290, cast(ADICAP_V3_2763_ANATOMYCODE_2770#7252 as string) AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7291, cast(ADICAP_V3_2763_ANATOMYLABEL_2771#7253 as string) AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7292, cast(ADICAP_V3_2763_STARTDATE_2772#7261 as string) AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7293, cast(ADICAP_V3_2763_ENDDATE_2773#7257 as string) AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7294, cast(ADICAP_V3_2763_DICTIONARYCODE_2774#7256 as string) AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#7295]
+- Project [ANATOMYCODE_2770#7219 AS ADICAP_V3_2763_ANATOMYCODE_2770#7252, ANATOMYLABEL_2771#7220 AS ADICAP_V3_2763_ANATOMYLABEL_2771#7253, CODEPARENT_2767#7221 AS ADICAP_V3_2763_CODEPARENT_2767#7254, CODE_2765#7222 AS ADICAP_V3_2763_CODE_2765#7255, DICTIONARYCODE_2774#7223 AS ADICAP_V3_2763_DICTIONARYCODE_2774#7256, ENDDATE_2773#7224 AS ADICAP_V3_2763_ENDDATE_2773#7257, LIBELLEPARENT_2769#7225 AS ADICAP_V3_2763_LIBELLEPARENT_2769#7258, LIBELLE_2768#7226 AS ADICAP_V3_2763_LIBELLE_2768#7259, PARENT_2766#7227 AS ADICAP_V3_2763_PARENT_2766#7260, STARTDATE_2772#7228 AS ADICAP_V3_2763_STARTDATE_2772#7261, URI_2764#7229 AS ADICAP_V3_2763_URI_2764#7262]
+- SubqueryAlias ADICAP_V3_2763110
+- Relation[ANATOMYCODE_2770#7219,ANATOMYLABEL_2771#7220,CODEPARENT_2767#7221,CODE_2765#7222,DICTIONARYCODE_2774#7223,ENDDATE_2773#7224,LIBELLEPARENT_2769#7225,LIBELLE_2768#7226,PARENT_2766#7227,STARTDATE_2772#7228,URI_2764#7229] parquet
== Optimized Logical Plan ==
GlobalLimit 10
+- LocalLimit 10
+- Sort [COL_62572762_1407_4D4C_905B_2FDF6DB67E902#7321L DESC NULLS LAST], true
+- Aggregate [COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7288], [COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7288 AS COL_62572762_1407_4D4C_905B_2FDF6DB67E901#7307, count(1) AS COL_62572762_1407_4D4C_905B_2FDF6DB67E902#7321L]
+- Project [CODEPARENT_2767#7221 AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7288]
+- Filter isnotnull(CODEPARENT_2767#7221)
+- Relation[ANATOMYCODE_2770#7219,ANATOMYLABEL_2771#7220,CODEPARENT_2767#7221,CODE_2765#7222,DICTIONARYCODE_2774#7223,ENDDATE_2773#7224,LIBELLEPARENT_2769#7225,LIBELLE_2768#7226,PARENT_2766#7227,STARTDATE_2772#7228,URI_2764#7229] parquet
== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- TakeOrderedAndProject(limit=10, orderBy=[COL_62572762_1407_4D4C_905B_2FDF6DB67E902#7321L DESC NULLS LAST], output=[COL_62572762_1407_4D4C_905B_2FDF6DB67E901#7307,COL_62572762_1407_4D4C_905B_2FDF6DB67E902#7321L])
+- *(2) HashAggregate(keys=[COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7288], functions=[count(1)], output=[COL_62572762_1407_4D4C_905B_2FDF6DB67E901#7307, COL_62572762_1407_4D4C_905B_2FDF6DB67E902#7321L])
+- CustomShuffleReader coalesced
+- ShuffleQueryStage 0
+- Exchange hashpartitioning(COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7288, 200), true, [id=#988]
+- *(1) HashAggregate(keys=[COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7288], functions=[partial_count(1)], output=[COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7288, count#7329L])
+- *(1) Project [CODEPARENT_2767#7221 AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7288]
+- *(1) Filter isnotnull(CODEPARENT_2767#7221)
+- *(1) ColumnarToRow
+- FileScan parquet [CODEPARENT_2767#7221] Batched: true, DataFilters: [isnotnull(CODEPARENT_2767#7221)], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/uet/ADICAP_V3_2763], PartitionFilters: [], PushedFilters: [IsNotNull(CODEPARENT_2767)], ReadSchema: struct<CODEPARENT_2767:string>
