digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 19 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<br><b>Project</b><br><br>"];
}
4 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 1,216<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 111.6 KiB"];
2->0;
3->2;
4->3;
}
5
CollectLimit 1500
Project [COL_734B3710_BBF1_4177_AB22_D313B0BFE2CC#90031, COL_0B951A66_FFE3_4A06_9739_F16358545321#90033, COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#90036, COL_C898C1FE_14C4_493A_878B_315EB757695B#90040, COL_D816DE78_7681_4E7B_98D4_661364CE2AD8#90045, COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#90051, COL_61C9B389_4942_4476_9A02_40C42C624B3B#90058, COL_BE37E53C_7DDB_452A_BEBB_A54D4645D1FE#90066, str_to_integer(COL_61C9B389_4942_4476_9A02_40C42C624B3B#90058) AS COL_6A7F96BB_1A29_487A_A8BD_A772FD0EF7A9#90104, round(str_to_dec(str_join(array(str_extract_middle(COL_734B3710_BBF1_4177_AB22_D313B0BFE2CC#90031, 83, 7), str_extract_middle(COL_734B3710_BBF1_4177_AB22_D313B0BFE2CC#90031, 90, 3)), .), ##.##), 2) AS COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#90105]
Project [_c0#90014 AS COL_734B3710_BBF1_4177_AB22_D313B0BFE2CC#90031, str_extract_middle(_c0#90014, 1, 9) AS COL_0B951A66_FFE3_4A06_9739_F16358545321#90033, str_extract_middle(_c0#90014, 10, 2) AS COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#90036, str_extract_middle(_c0#90014, 12, 20) AS COL_C898C1FE_14C4_493A_878B_315EB757695B#90040, str_extract_middle(_c0#90014, 42, 8) AS COL_D816DE78_7681_4E7B_98D4_661364CE2AD8#90045, str_extract_middle(_c0#90014, 58, 15) AS COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#90051, str_extract_middle(_c0#90014, 73, 10) AS COL_61C9B389_4942_4476_9A02_40C42C624B3B#90058, str_extract_middle(_c0#90014, 83, 10) AS COL_BE37E53C_7DDB_452A_BEBB_A54D4645D1FE#90066]
WholeStageCodegen (1)
FileScan csv [_c0#90014] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/DMI_M12_2025_440461/DMI-M12-2025 - BIS...., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<_c0:string>
== Physical Plan ==
CollectLimit (4)
+- * Project (3)
+- * Project (2)
+- Scan csv (1)
(1) Scan csv
Output [1]: [_c0#90014]
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 [8]: [_c0#90014 AS COL_734B3710_BBF1_4177_AB22_D313B0BFE2CC#90031, str_extract_middle(_c0#90014, 1, 9) AS COL_0B951A66_FFE3_4A06_9739_F16358545321#90033, str_extract_middle(_c0#90014, 10, 2) AS COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#90036, str_extract_middle(_c0#90014, 12, 20) AS COL_C898C1FE_14C4_493A_878B_315EB757695B#90040, str_extract_middle(_c0#90014, 42, 8) AS COL_D816DE78_7681_4E7B_98D4_661364CE2AD8#90045, str_extract_middle(_c0#90014, 58, 15) AS COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#90051, str_extract_middle(_c0#90014, 73, 10) AS COL_61C9B389_4942_4476_9A02_40C42C624B3B#90058, str_extract_middle(_c0#90014, 83, 10) AS COL_BE37E53C_7DDB_452A_BEBB_A54D4645D1FE#90066]
Input [1]: [_c0#90014]
(3) Project [codegen id : 1]
Output [10]: [COL_734B3710_BBF1_4177_AB22_D313B0BFE2CC#90031, COL_0B951A66_FFE3_4A06_9739_F16358545321#90033, COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#90036, COL_C898C1FE_14C4_493A_878B_315EB757695B#90040, COL_D816DE78_7681_4E7B_98D4_661364CE2AD8#90045, COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#90051, COL_61C9B389_4942_4476_9A02_40C42C624B3B#90058, COL_BE37E53C_7DDB_452A_BEBB_A54D4645D1FE#90066, str_to_integer(COL_61C9B389_4942_4476_9A02_40C42C624B3B#90058) AS COL_6A7F96BB_1A29_487A_A8BD_A772FD0EF7A9#90104, round(str_to_dec(str_join(array(str_extract_middle(COL_734B3710_BBF1_4177_AB22_D313B0BFE2CC#90031, 83, 7), str_extract_middle(COL_734B3710_BBF1_4177_AB22_D313B0BFE2CC#90031, 90, 3)), .), ##.##), 2) AS COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#90105]
Input [8]: [COL_734B3710_BBF1_4177_AB22_D313B0BFE2CC#90031, COL_0B951A66_FFE3_4A06_9739_F16358545321#90033, COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#90036, COL_C898C1FE_14C4_493A_878B_315EB757695B#90040, COL_D816DE78_7681_4E7B_98D4_661364CE2AD8#90045, COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#90051, COL_61C9B389_4942_4476_9A02_40C42C624B3B#90058, COL_BE37E53C_7DDB_452A_BEBB_A54D4645D1FE#90066]
(4) CollectLimit
Input [10]: [COL_734B3710_BBF1_4177_AB22_D313B0BFE2CC#90031, COL_0B951A66_FFE3_4A06_9739_F16358545321#90033, COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#90036, COL_C898C1FE_14C4_493A_878B_315EB757695B#90040, COL_D816DE78_7681_4E7B_98D4_661364CE2AD8#90045, COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#90051, COL_61C9B389_4942_4476_9A02_40C42C624B3B#90058, COL_BE37E53C_7DDB_452A_BEBB_A54D4645D1FE#90066, COL_6A7F96BB_1A29_487A_A8BD_A772FD0EF7A9#90104, COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#90105]
Arguments: 1500