== Physical Plan ==
AdaptiveSparkPlan (13)
+- == Final Plan ==
* HashAggregate (7)
+- ShuffleQueryStage (6), Statistics(sizeInBytes=16.0 B, rowCount=1)
+- Exchange (5)
+- * HashAggregate (4)
+- * Project (3)
+- * Filter (2)
+- Scan csv (1)
+- == Initial Plan ==
HashAggregate (12)
+- Exchange (11)
+- HashAggregate (10)
+- Project (9)
+- Filter (8)
+- Scan csv (1)
(1) Scan csv
Output [1]: [dep#117894]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/60C8936A_777F_482A_9DC6_7FCE72F859DB/current/covid_hospit4sur10.csv]
ReadSchema: struct<dep:string>
(2) Filter [codegen id : 1]
Input [1]: [dep#117894]
Condition : CASE WHEN isnull(Contains(str_remove_accent(upper(dep#117894)), ME)) THEN false ELSE Contains(str_remove_accent(upper(dep#117894)), ME) END
(3) Project [codegen id : 1]
Output: []
Input [1]: [dep#117894]
(4) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#117998L]
Results [1]: [count#117999L]
(5) Exchange
Input [1]: [count#117999L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=8540]
(6) ShuffleQueryStage
Output [1]: [count#117999L]
Arguments: 0
(7) HashAggregate [codegen id : 2]
Input [1]: [count#117999L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#117985L]
Results [1]: [count(1)#117985L AS COL_3d3a62ee-3d33-4422-96e3-743ce5206d77#117987L]
(8) Filter
Input [1]: [dep#117894]
Condition : CASE WHEN isnull(Contains(str_remove_accent(upper(dep#117894)), ME)) THEN false ELSE Contains(str_remove_accent(upper(dep#117894)), ME) END
(9) Project
Output: []
Input [1]: [dep#117894]
(10) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#117998L]
Results [1]: [count#117999L]
(11) Exchange
Input [1]: [count#117999L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=8526]
(12) HashAggregate
Input [1]: [count#117999L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#117985L]
Results [1]: [count(1)#117985L AS COL_3d3a62ee-3d33-4422-96e3-743ce5206d77#117987L]
(13) AdaptiveSparkPlan
Output [1]: [COL_3d3a62ee-3d33-4422-96e3-743ce5206d77#117987L]
Arguments: isFinalPlan=true