digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 35 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#89766, COL_0B951A66_FFE3_4A06_9739_F16358545321#89768, COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#89771, COL_C898C1FE_14C4_493A_878B_315EB757695B#89775, COL_D816DE78_7681_4E7B_98D4_661364CE2AD8#89780, COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#89786, COL_61C9B389_4942_4476_9A02_40C42C624B3B#89793, COL_BE37E53C_7DDB_452A_BEBB_A54D4645D1FE#89801, str_to_integer(COL_61C9B389_4942_4476_9A02_40C42C624B3B#89793) AS COL_6A7F96BB_1A29_487A_A8BD_A772FD0EF7A9#89839, str_to_dec(str_join(array(str_extract_middle(COL_734B3710_BBF1_4177_AB22_D313B0BFE2CC#89766, 83, 7), str_extract_middle(COL_734B3710_BBF1_4177_AB22_D313B0BFE2CC#89766, 90, 3)), .), ##.##) AS COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#89840]
Project [_c0#89749 AS COL_734B3710_BBF1_4177_AB22_D313B0BFE2CC#89766, str_extract_middle(_c0#89749, 1, 9) AS COL_0B951A66_FFE3_4A06_9739_F16358545321#89768, str_extract_middle(_c0#89749, 10, 2) AS COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#89771, str_extract_middle(_c0#89749, 12, 20) AS COL_C898C1FE_14C4_493A_878B_315EB757695B#89775, str_extract_middle(_c0#89749, 42, 8) AS COL_D816DE78_7681_4E7B_98D4_661364CE2AD8#89780, str_extract_middle(_c0#89749, 58, 15) AS COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#89786, str_extract_middle(_c0#89749, 73, 10) AS COL_61C9B389_4942_4476_9A02_40C42C624B3B#89793, str_extract_middle(_c0#89749, 83, 10) AS COL_BE37E53C_7DDB_452A_BEBB_A54D4645D1FE#89801]
WholeStageCodegen (1)
FileScan csv [_c0#89749] 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#89749]
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#89749 AS COL_734B3710_BBF1_4177_AB22_D313B0BFE2CC#89766, str_extract_middle(_c0#89749, 1, 9) AS COL_0B951A66_FFE3_4A06_9739_F16358545321#89768, str_extract_middle(_c0#89749, 10, 2) AS COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#89771, str_extract_middle(_c0#89749, 12, 20) AS COL_C898C1FE_14C4_493A_878B_315EB757695B#89775, str_extract_middle(_c0#89749, 42, 8) AS COL_D816DE78_7681_4E7B_98D4_661364CE2AD8#89780, str_extract_middle(_c0#89749, 58, 15) AS COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#89786, str_extract_middle(_c0#89749, 73, 10) AS COL_61C9B389_4942_4476_9A02_40C42C624B3B#89793, str_extract_middle(_c0#89749, 83, 10) AS COL_BE37E53C_7DDB_452A_BEBB_A54D4645D1FE#89801]
Input [1]: [_c0#89749]
(3) Project [codegen id : 1]
Output [10]: [COL_734B3710_BBF1_4177_AB22_D313B0BFE2CC#89766, COL_0B951A66_FFE3_4A06_9739_F16358545321#89768, COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#89771, COL_C898C1FE_14C4_493A_878B_315EB757695B#89775, COL_D816DE78_7681_4E7B_98D4_661364CE2AD8#89780, COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#89786, COL_61C9B389_4942_4476_9A02_40C42C624B3B#89793, COL_BE37E53C_7DDB_452A_BEBB_A54D4645D1FE#89801, str_to_integer(COL_61C9B389_4942_4476_9A02_40C42C624B3B#89793) AS COL_6A7F96BB_1A29_487A_A8BD_A772FD0EF7A9#89839, str_to_dec(str_join(array(str_extract_middle(COL_734B3710_BBF1_4177_AB22_D313B0BFE2CC#89766, 83, 7), str_extract_middle(COL_734B3710_BBF1_4177_AB22_D313B0BFE2CC#89766, 90, 3)), .), ##.##) AS COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#89840]
Input [8]: [COL_734B3710_BBF1_4177_AB22_D313B0BFE2CC#89766, COL_0B951A66_FFE3_4A06_9739_F16358545321#89768, COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#89771, COL_C898C1FE_14C4_493A_878B_315EB757695B#89775, COL_D816DE78_7681_4E7B_98D4_661364CE2AD8#89780, COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#89786, COL_61C9B389_4942_4476_9A02_40C42C624B3B#89793, COL_BE37E53C_7DDB_452A_BEBB_A54D4645D1FE#89801]
(4) CollectLimit
Input [10]: [COL_734B3710_BBF1_4177_AB22_D313B0BFE2CC#89766, COL_0B951A66_FFE3_4A06_9739_F16358545321#89768, COL_5F7ED7D9_198B_43FF_AA77_F43BC93B4F58#89771, COL_C898C1FE_14C4_493A_878B_315EB757695B#89775, COL_D816DE78_7681_4E7B_98D4_661364CE2AD8#89780, COL_4F5EF121_C9BA_4BCB_BC00_75827CB8EDA5#89786, COL_61C9B389_4942_4476_9A02_40C42C624B3B#89793, COL_BE37E53C_7DDB_452A_BEBB_A54D4645D1FE#89801, COL_6A7F96BB_1A29_487A_A8BD_A772FD0EF7A9#89839, COL_50B93A8F_2FAC_42DA_862D_B1ADBEF5479D#89840]
Arguments: 1500