== 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#48394]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/72E86347_B0DB_4D5A_8CD5_10164A935E7E/current/covid_hospit2sur10.csv]
ReadSchema: struct<dep:string>
(2) Filter [codegen id : 1]
Input [1]: [dep#48394]
Condition : CASE WHEN isnull(Contains(str_remove_accent(upper(dep#48394)), ME)) THEN false ELSE Contains(str_remove_accent(upper(dep#48394)), ME) END
(3) Project [codegen id : 1]
Output: []
Input [1]: [dep#48394]
(4) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#48705L]
Results [1]: [count#48706L]
(5) Exchange
Input [1]: [count#48706L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=8808]
(6) ShuffleQueryStage
Output [1]: [count#48706L]
Arguments: 0
(7) HashAggregate [codegen id : 2]
Input [1]: [count#48706L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#48646L]
Results [1]: [count(1)#48646L AS COL_465e98ec-c32c-45e5-9adc-0643036aae07#48648L]
(8) Filter
Input [1]: [dep#48394]
Condition : CASE WHEN isnull(Contains(str_remove_accent(upper(dep#48394)), ME)) THEN false ELSE Contains(str_remove_accent(upper(dep#48394)), ME) END
(9) Project
Output: []
Input [1]: [dep#48394]
(10) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#48705L]
Results [1]: [count#48706L]
(11) Exchange
Input [1]: [count#48706L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=8781]
(12) HashAggregate
Input [1]: [count#48706L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#48646L]
Results [1]: [count(1)#48646L AS COL_465e98ec-c32c-45e5-9adc-0643036aae07#48648L]
(13) AdaptiveSparkPlan
Output [1]: [COL_465e98ec-c32c-45e5-9adc-0643036aae07#48648L]
Arguments: isFinalPlan=true