digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 0 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
}
3 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 1,500<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 8.3 MiB"];
2->0;
3->2;
}
4
CollectLimit 1500
Project [FINESS#86459 AS COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#89135, NO_RSS#86460 AS COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#89136, NO_ADMIN#86461 AS COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#89137, DATE_ENT#86462 AS COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#89138, DATE_SOR#86463 AS COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#89139, VALO#86464 AS COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#89140, GHS#86465 AS COL_CB09A89F_3D14_4584_B772_272D8BAC362D#89141, str_to_dec(MNT_MON#86601, ##.##) AS COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#89142, str_to_dec(MNT_DMI#86602, ##.##) AS COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#89143, MNT_MED_APAC#86603 AS COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#89144]
WholeStageCodegen (1)
FileScan csv [FINESS#86459,NO_RSS#86460,NO_ADMIN#86461,DATE_ENT#86462,DATE_SOR#86463,VALO#86464,GHS#86465,MNT_MON#86601,MNT_DMI#86602,MNT_MED_APAC#86603] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/VISUALVALOSEJOU_440300/420780652.2025.1..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<FINESS:string,NO_RSS:string,NO_ADMIN:string,DATE_ENT:string,DATE_SOR:string,VALO:string,GH...
== Physical Plan ==
CollectLimit (3)
+- * Project (2)
+- Scan csv (1)
(1) Scan csv
Output [10]: [FINESS#86459, NO_RSS#86460, NO_ADMIN#86461, DATE_ENT#86462, DATE_SOR#86463, VALO#86464, GHS#86465, MNT_MON#86601, MNT_DMI#86602, MNT_MED_APAC#86603]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/VISUALVALOSEJOU_440300/420780652.2025.12.MCO.VisualValoSejours.csv]
ReadSchema: struct<FINESS:string,NO_RSS:string,NO_ADMIN:string,DATE_ENT:string,DATE_SOR:string,VALO:string,GHS:string,MNT_MON:string,MNT_DMI:string,MNT_MED_APAC:string>
(2) Project [codegen id : 1]
Output [10]: [FINESS#86459 AS COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#89135, NO_RSS#86460 AS COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#89136, NO_ADMIN#86461 AS COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#89137, DATE_ENT#86462 AS COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#89138, DATE_SOR#86463 AS COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#89139, VALO#86464 AS COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#89140, GHS#86465 AS COL_CB09A89F_3D14_4584_B772_272D8BAC362D#89141, str_to_dec(MNT_MON#86601, ##.##) AS COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#89142, str_to_dec(MNT_DMI#86602, ##.##) AS COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#89143, MNT_MED_APAC#86603 AS COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#89144]
Input [10]: [FINESS#86459, NO_RSS#86460, NO_ADMIN#86461, DATE_ENT#86462, DATE_SOR#86463, VALO#86464, GHS#86465, MNT_MON#86601, MNT_DMI#86602, MNT_MED_APAC#86603]
(3) CollectLimit
Input [10]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#89135, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#89136, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#89137, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#89138, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#89139, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#89140, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#89141, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#89142, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#89143, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#89144]
Arguments: 1500