== 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(PATIENT_ID), "BIRTH_DATE", "GENDER", "PSEUDO", "INHOSPITAL_DEATH_DATE", "INHOSPITAL_DEATH_CODE", "DEATH_DATE", "EXTERNAL_DEATH_PROCESS_ID" FROM "DTM_622"."PATIENT") x) [numPartitions=1] (1)
+- == Initial Plan ==
HashAggregate (7)
+- Exchange (6)
+- HashAggregate (2)
+- Scan JDBCRelation((SELECT RAWTOHEX(PATIENT_ID), "BIRTH_DATE", "GENDER", "PSEUDO", "INHOSPITAL_DEATH_DATE", "INHOSPITAL_DEATH_CODE", "DEATH_DATE", "EXTERNAL_DEATH_PROCESS_ID" FROM "DTM_622"."PATIENT") x) [numPartitions=1] (1)
(1) Scan JDBCRelation((SELECT RAWTOHEX(PATIENT_ID), "BIRTH_DATE", "GENDER", "PSEUDO", "INHOSPITAL_DEATH_DATE", "INHOSPITAL_DEATH_CODE", "DEATH_DATE", "EXTERNAL_DEATH_PROCESS_ID" FROM "DTM_622"."PATIENT") 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#62226L]
Results [1]: [count#62227L]
(3) Exchange
Input [1]: [count#62227L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=9388]
(4) ShuffleQueryStage
Output [1]: [count#62227L]
Arguments: 0
(5) HashAggregate [codegen id : 2]
Input [1]: [count#62227L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#62223L]
Results [1]: [count(1)#62223L AS count#62224L]
(6) Exchange
Input [1]: [count#62227L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=9381]
(7) HashAggregate
Input [1]: [count#62227L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#62223L]
Results [1]: [count(1)#62223L AS count#62224L]
(8) AdaptiveSparkPlan
Output [1]: [count#62224L]
Arguments: isFinalPlan=true