== Physical Plan ==
AdaptiveSparkPlan (17)
+- == Final Plan ==
TakeOrderedAndProject (10)
+- * HashAggregate (9)
+- AQEShuffleRead (8)
+- ShuffleQueryStage (7), Statistics(sizeInBytes=64.0 B, rowCount=2)
+- Exchange (6)
+- * HashAggregate (5)
+- * Project (4)
+- * Filter (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
+- == Initial Plan ==
TakeOrderedAndProject (16)
+- HashAggregate (15)
+- Exchange (14)
+- HashAggregate (13)
+- Project (12)
+- Filter (11)
+- Scan parquet (1)
(1) Scan parquet
Output [1]: [GENDER_3335#105239]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/PATIENT_3332]
PushedFilters: [IsNotNull(GENDER_3335)]
ReadSchema: struct<GENDER_3335:string>
(2) ColumnarToRow [codegen id : 1]
Input [1]: [GENDER_3335#105239]
(3) Filter [codegen id : 1]
Input [1]: [GENDER_3335#105239]
Condition : isnotnull(GENDER_3335#105239)
(4) Project [codegen id : 1]
Output [1]: [GENDER_3335#105239 AS COL_GENDER_3335#105286]
Input [1]: [GENDER_3335#105239]
(5) HashAggregate [codegen id : 1]
Input [1]: [COL_GENDER_3335#105286]
Keys [1]: [COL_GENDER_3335#105286]
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#105318L]
Results [2]: [COL_GENDER_3335#105286, count#105319L]
(6) Exchange
Input [2]: [COL_GENDER_3335#105286, count#105319L]
Arguments: hashpartitioning(COL_GENDER_3335#105286, 10), ENSURE_REQUIREMENTS, [plan_id=15943]
(7) ShuffleQueryStage
Output [2]: [COL_GENDER_3335#105286, count#105319L]
Arguments: 0
(8) AQEShuffleRead
Input [2]: [COL_GENDER_3335#105286, count#105319L]
Arguments: coalesced
(9) HashAggregate [codegen id : 2]
Input [2]: [COL_GENDER_3335#105286, count#105319L]
Keys [1]: [COL_GENDER_3335#105286]
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#105309L]
Results [2]: [COL_GENDER_3335#105286 AS COL_GENDER_33351#105300, count(1)#105309L AS COL_GENDER_33352#105311L]
(10) TakeOrderedAndProject
Input [2]: [COL_GENDER_33351#105300, COL_GENDER_33352#105311L]
Arguments: 10, [COL_GENDER_33352#105311L DESC NULLS LAST], [COL_GENDER_33351#105300, COL_GENDER_33352#105311L]
(11) Filter
Input [1]: [GENDER_3335#105239]
Condition : isnotnull(GENDER_3335#105239)
(12) Project
Output [1]: [GENDER_3335#105239 AS COL_GENDER_3335#105286]
Input [1]: [GENDER_3335#105239]
(13) HashAggregate
Input [1]: [COL_GENDER_3335#105286]
Keys [1]: [COL_GENDER_3335#105286]
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#105318L]
Results [2]: [COL_GENDER_3335#105286, count#105319L]
(14) Exchange
Input [2]: [COL_GENDER_3335#105286, count#105319L]
Arguments: hashpartitioning(COL_GENDER_3335#105286, 10), ENSURE_REQUIREMENTS, [plan_id=15920]
(15) HashAggregate
Input [2]: [COL_GENDER_3335#105286, count#105319L]
Keys [1]: [COL_GENDER_3335#105286]
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#105309L]
Results [2]: [COL_GENDER_3335#105286 AS COL_GENDER_33351#105300, count(1)#105309L AS COL_GENDER_33352#105311L]
(16) TakeOrderedAndProject
Input [2]: [COL_GENDER_33351#105300, COL_GENDER_33352#105311L]
Arguments: 10, [COL_GENDER_33352#105311L DESC NULLS LAST], [COL_GENDER_33351#105300, COL_GENDER_33352#105311L]
(17) AdaptiveSparkPlan
Output [2]: [COL_GENDER_33351#105300, COL_GENDER_33352#105311L]
Arguments: isFinalPlan=true