== Parsed Logical Plan ==
GlobalLimit 10
+- LocalLimit 10
+- Sort [COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F942#7047L DESC NULLS LAST], true
+- Project [COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F941#7033, COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F942#7047L]
+- Aggregate [COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7017], [COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7017 AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F941#7033, 1 AS NULL_1#7048, count(1) AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F942#7047L]
+- Filter isnotnull(COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7017)
+- Project [cast(ADICAP_V3_2763_URI_2764#6988 as string) AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7011, cast(ADICAP_V3_2763_CODE_2765#6981 as string) AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7012, cast(ADICAP_V3_2763_PARENT_2766#6986 as string) AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7013, cast(ADICAP_V3_2763_CODEPARENT_2767#6980 as string) AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7014, cast(ADICAP_V3_2763_LIBELLE_2768#6985 as string) AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7015, cast(ADICAP_V3_2763_LIBELLEPARENT_2769#6984 as string) AS COL_D472A873_1242_4F73_B703_84133E7F376C#7016, cast(ADICAP_V3_2763_ANATOMYCODE_2770#6978 as string) AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7017, cast(ADICAP_V3_2763_ANATOMYLABEL_2771#6979 as string) AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7018, cast(ADICAP_V3_2763_STARTDATE_2772#6987 as string) AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7019, cast(ADICAP_V3_2763_ENDDATE_2773#6983 as string) AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7020, cast(ADICAP_V3_2763_DICTIONARYCODE_2774#6982 as string) AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#7021]
+- Project [ANATOMYCODE_2770#6945 AS ADICAP_V3_2763_ANATOMYCODE_2770#6978, ANATOMYLABEL_2771#6946 AS ADICAP_V3_2763_ANATOMYLABEL_2771#6979, CODEPARENT_2767#6947 AS ADICAP_V3_2763_CODEPARENT_2767#6980, CODE_2765#6948 AS ADICAP_V3_2763_CODE_2765#6981, DICTIONARYCODE_2774#6949 AS ADICAP_V3_2763_DICTIONARYCODE_2774#6982, ENDDATE_2773#6950 AS ADICAP_V3_2763_ENDDATE_2773#6983, LIBELLEPARENT_2769#6951 AS ADICAP_V3_2763_LIBELLEPARENT_2769#6984, LIBELLE_2768#6952 AS ADICAP_V3_2763_LIBELLE_2768#6985, PARENT_2766#6953 AS ADICAP_V3_2763_PARENT_2766#6986, STARTDATE_2772#6954 AS ADICAP_V3_2763_STARTDATE_2772#6987, URI_2764#6955 AS ADICAP_V3_2763_URI_2764#6988]
+- SubqueryAlias ADICAP_V3_2763111
+- Relation[ANATOMYCODE_2770#6945,ANATOMYLABEL_2771#6946,CODEPARENT_2767#6947,CODE_2765#6948,DICTIONARYCODE_2774#6949,ENDDATE_2773#6950,LIBELLEPARENT_2769#6951,LIBELLE_2768#6952,PARENT_2766#6953,STARTDATE_2772#6954,URI_2764#6955] parquet
== Analyzed Logical Plan ==
COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F941: string, COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F942: bigint
GlobalLimit 10
+- LocalLimit 10
+- Sort [COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F942#7047L DESC NULLS LAST], true
+- Project [COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F941#7033, COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F942#7047L]
+- Aggregate [COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7017], [COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7017 AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F941#7033, 1 AS NULL_1#7048, count(1) AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F942#7047L]
+- Filter isnotnull(COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7017)
+- Project [cast(ADICAP_V3_2763_URI_2764#6988 as string) AS COL_3B2D7E37_2B76_43E5_B78F_6D4A006AD1DC#7011, cast(ADICAP_V3_2763_CODE_2765#6981 as string) AS COL_F5FF90C9_04E5_46B3_8805_3F1026104464#7012, cast(ADICAP_V3_2763_PARENT_2766#6986 as string) AS COL_A397999A_66EC_4CA1_8A3D_38331A08634E#7013, cast(ADICAP_V3_2763_CODEPARENT_2767#6980 as string) AS COL_62572762_1407_4D4C_905B_2FDF6DB67E90#7014, cast(ADICAP_V3_2763_LIBELLE_2768#6985 as string) AS COL_5CC9D481_5B00_49D6_9C55_3DABDD1B5B38#7015, cast(ADICAP_V3_2763_LIBELLEPARENT_2769#6984 as string) AS COL_D472A873_1242_4F73_B703_84133E7F376C#7016, cast(ADICAP_V3_2763_ANATOMYCODE_2770#6978 as string) AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7017, cast(ADICAP_V3_2763_ANATOMYLABEL_2771#6979 as string) AS COL_A7E2BC98_F636_45B9_8094_DA576E390BE8#7018, cast(ADICAP_V3_2763_STARTDATE_2772#6987 as string) AS COL_9C6F093E_2DD4_43E5_BC9D_163E1CEF0649#7019, cast(ADICAP_V3_2763_ENDDATE_2773#6983 as string) AS COL_7F9D0CBC_F068_4482_9330_68F4CD212FD8#7020, cast(ADICAP_V3_2763_DICTIONARYCODE_2774#6982 as string) AS COL_B752B85C_FAFD_434B_BEB1_25579727A129#7021]
+- Project [ANATOMYCODE_2770#6945 AS ADICAP_V3_2763_ANATOMYCODE_2770#6978, ANATOMYLABEL_2771#6946 AS ADICAP_V3_2763_ANATOMYLABEL_2771#6979, CODEPARENT_2767#6947 AS ADICAP_V3_2763_CODEPARENT_2767#6980, CODE_2765#6948 AS ADICAP_V3_2763_CODE_2765#6981, DICTIONARYCODE_2774#6949 AS ADICAP_V3_2763_DICTIONARYCODE_2774#6982, ENDDATE_2773#6950 AS ADICAP_V3_2763_ENDDATE_2773#6983, LIBELLEPARENT_2769#6951 AS ADICAP_V3_2763_LIBELLEPARENT_2769#6984, LIBELLE_2768#6952 AS ADICAP_V3_2763_LIBELLE_2768#6985, PARENT_2766#6953 AS ADICAP_V3_2763_PARENT_2766#6986, STARTDATE_2772#6954 AS ADICAP_V3_2763_STARTDATE_2772#6987, URI_2764#6955 AS ADICAP_V3_2763_URI_2764#6988]
+- SubqueryAlias ADICAP_V3_2763111
+- Relation[ANATOMYCODE_2770#6945,ANATOMYLABEL_2771#6946,CODEPARENT_2767#6947,CODE_2765#6948,DICTIONARYCODE_2774#6949,ENDDATE_2773#6950,LIBELLEPARENT_2769#6951,LIBELLE_2768#6952,PARENT_2766#6953,STARTDATE_2772#6954,URI_2764#6955] parquet
== Optimized Logical Plan ==
GlobalLimit 10
+- LocalLimit 10
+- Sort [COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F942#7047L DESC NULLS LAST], true
+- Aggregate [COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7017], [COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7017 AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F941#7033, count(1) AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F942#7047L]
+- Project [ANATOMYCODE_2770#6945 AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7017]
+- Filter isnotnull(ANATOMYCODE_2770#6945)
+- Relation[ANATOMYCODE_2770#6945,ANATOMYLABEL_2771#6946,CODEPARENT_2767#6947,CODE_2765#6948,DICTIONARYCODE_2774#6949,ENDDATE_2773#6950,LIBELLEPARENT_2769#6951,LIBELLE_2768#6952,PARENT_2766#6953,STARTDATE_2772#6954,URI_2764#6955] parquet
== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- TakeOrderedAndProject(limit=10, orderBy=[COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F942#7047L DESC NULLS LAST], output=[COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F941#7033,COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F942#7047L])
+- *(2) HashAggregate(keys=[COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7017], functions=[count(1)], output=[COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F941#7033, COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F942#7047L])
+- CustomShuffleReader coalesced
+- ShuffleQueryStage 0
+- Exchange hashpartitioning(COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7017, 200), true, [id=#864]
+- *(1) HashAggregate(keys=[COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7017], functions=[partial_count(1)], output=[COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7017, count#7055L])
+- *(1) Project [ANATOMYCODE_2770#6945 AS COL_5E7BFB0B_14E5_4DCB_BF08_4161F8AD8F94#7017]
+- *(1) Filter isnotnull(ANATOMYCODE_2770#6945)
+- *(1) ColumnarToRow
+- FileScan parquet [ANATOMYCODE_2770#6945] Batched: true, DataFilters: [isnotnull(ANATOMYCODE_2770#6945)], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/uet/ADICAP_V3_2763], PartitionFilters: [], PushedFilters: [IsNotNull(ANATOMYCODE_2770)], ReadSchema: struct<ANATOMYCODE_2770:string>
