== Physical Plan ==
AdaptiveSparkPlan (8)
+- == Final Plan ==
* HashAggregate (5)
+- ShuffleQueryStage (4), Statistics(sizeInBytes=16.0 B, rowCount=1)
+- Exchange (3)
+- * HashAggregate (2)
+- * Scan JDBCRelation((SELECT RAWTOHEX(VISIT_UNIT_ID), RAWTOHEX(VISIT_ID), RAWTOHEX(PATIENT_ID), "UNIT", "ACTIVITY", "IN_DATE", "OUT_DATE" FROM "DTM_622"."VISIT_UNIT") x) [numPartitions=1] (1)
+- == Initial Plan ==
HashAggregate (7)
+- Exchange (6)
+- HashAggregate (2)
+- Scan JDBCRelation((SELECT RAWTOHEX(VISIT_UNIT_ID), RAWTOHEX(VISIT_ID), RAWTOHEX(PATIENT_ID), "UNIT", "ACTIVITY", "IN_DATE", "OUT_DATE" FROM "DTM_622"."VISIT_UNIT") x) [numPartitions=1] (1)
(1) Scan JDBCRelation((SELECT RAWTOHEX(VISIT_UNIT_ID), RAWTOHEX(VISIT_ID), RAWTOHEX(PATIENT_ID), "UNIT", "ACTIVITY", "IN_DATE", "OUT_DATE" FROM "DTM_622"."VISIT_UNIT") x) [numPartitions=1] [codegen id : 1]
Output: []
ReadSchema: struct<>
(2) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#53405L]
Results [1]: [count#53406L]
(3) Exchange
Input [1]: [count#53406L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=8171]
(4) ShuffleQueryStage
Output [1]: [count#53406L]
Arguments: 0
(5) HashAggregate [codegen id : 2]
Input [1]: [count#53406L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#53402L]
Results [1]: [count(1)#53402L AS count#53403L]
(6) Exchange
Input [1]: [count#53406L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=8164]
(7) HashAggregate
Input [1]: [count#53406L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#53402L]
Results [1]: [count(1)#53402L AS count#53403L]
(8) AdaptiveSparkPlan
Output [1]: [count#53403L]
Arguments: isFinalPlan=true