== Physical Plan ==
AdaptiveSparkPlan (11)
+- == Final Plan ==
SortAggregate (6)
+- ShuffleQueryStage (5), Statistics(sizeInBytes=56.0 B, rowCount=1)
+- Exchange (4)
+- SortAggregate (3)
+- * Project (2)
+- Scan csv (1)
+- == Initial Plan ==
SortAggregate (10)
+- Exchange (9)
+- SortAggregate (8)
+- Project (7)
+- Scan csv (1)
(1) Scan csv
Output [1]: [_c0#17643]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/DMI_M12_2025_440461/DMI-M12-2025 - BIS.txt]
ReadSchema: struct<_c0:string>
(2) Project [codegen id : 1]
Output [1]: [str_extract_middle(_c0#17643, 10, 2) AS COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706]
Input [1]: [_c0#17643]
(3) SortAggregate
Input [1]: [COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706]
Keys: []
Functions [4]: [partial_count(1), partial_count(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706), partial_min(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706), partial_max(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706)]
Aggregate Attributes [4]: [count#17748L, count#17749L, min#17750, max#17751]
Results [4]: [count#17752L, count#17753L, min#17754, max#17755]
(4) Exchange
Input [4]: [count#17752L, count#17753L, min#17754, max#17755]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=3019]
(5) ShuffleQueryStage
Output [4]: [count#17752L, count#17753L, min#17754, max#17755]
Arguments: 0
(6) SortAggregate
Input [4]: [count#17752L, count#17753L, min#17754, max#17755]
Keys: []
Functions [4]: [count(1), count(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706), min(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706), max(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706)]
Aggregate Attributes [4]: [count(1)#17720L, count(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706)#17723L, min(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706)#17726, max(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706)#17728]
Results [4]: [count(1)#17720L AS COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F581#17722L, count(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706)#17723L AS COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F582#17725L, min(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706)#17726 AS COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F584#17727, max(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706)#17728 AS COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F585#17729]
(7) Project
Output [1]: [str_extract_middle(_c0#17643, 10, 2) AS COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706]
Input [1]: [_c0#17643]
(8) SortAggregate
Input [1]: [COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706]
Keys: []
Functions [4]: [partial_count(1), partial_count(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706), partial_min(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706), partial_max(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706)]
Aggregate Attributes [4]: [count#17748L, count#17749L, min#17750, max#17751]
Results [4]: [count#17752L, count#17753L, min#17754, max#17755]
(9) Exchange
Input [4]: [count#17752L, count#17753L, min#17754, max#17755]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=3007]
(10) SortAggregate
Input [4]: [count#17752L, count#17753L, min#17754, max#17755]
Keys: []
Functions [4]: [count(1), count(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706), min(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706), max(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706)]
Aggregate Attributes [4]: [count(1)#17720L, count(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706)#17723L, min(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706)#17726, max(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706)#17728]
Results [4]: [count(1)#17720L AS COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F581#17722L, count(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706)#17723L AS COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F582#17725L, min(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706)#17726 AS COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F584#17727, max(COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#17706)#17728 AS COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F585#17729]
(11) AdaptiveSparkPlan
Output [4]: [COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F581#17722L, COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F582#17725L, COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F584#17727, COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F585#17729]
Arguments: isFinalPlan=true