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#62086 AS COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#64762, NO_RSS#62087 AS COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#64763, NO_ADMIN#62088 AS COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#64764, DATE_ENT#62089 AS COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#64765, DATE_SOR#62090 AS COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#64766, VALO#62091 AS COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#64767, GHS#62092 AS COL_CB09A89F_3D14_4584_B772_272D8BAC362D#64768, str_to_dec(MNT_MON#62228, ##.##) AS COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#64769, str_to_dec(MNT_DMI#62229, ##.##) AS COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#64770, str_to_dec(MNT_MED_APAC#62230, ##.##) AS COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#64771]
WholeStageCodegen (1)
FileScan csv [FINESS#62086,NO_RSS#62087,NO_ADMIN#62088,DATE_ENT#62089,DATE_SOR#62090,VALO#62091,GHS#62092,MNT_MON#62228,MNT_DMI#62229,MNT_MED_APAC#62230] 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#62086, NO_RSS#62087, NO_ADMIN#62088, DATE_ENT#62089, DATE_SOR#62090, VALO#62091, GHS#62092, MNT_MON#62228, MNT_DMI#62229, MNT_MED_APAC#62230]
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#62086 AS COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#64762, NO_RSS#62087 AS COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#64763, NO_ADMIN#62088 AS COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#64764, DATE_ENT#62089 AS COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#64765, DATE_SOR#62090 AS COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#64766, VALO#62091 AS COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#64767, GHS#62092 AS COL_CB09A89F_3D14_4584_B772_272D8BAC362D#64768, str_to_dec(MNT_MON#62228, ##.##) AS COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#64769, str_to_dec(MNT_DMI#62229, ##.##) AS COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#64770, str_to_dec(MNT_MED_APAC#62230, ##.##) AS COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#64771]
Input [10]: [FINESS#62086, NO_RSS#62087, NO_ADMIN#62088, DATE_ENT#62089, DATE_SOR#62090, VALO#62091, GHS#62092, MNT_MON#62228, MNT_DMI#62229, MNT_MED_APAC#62230]
(3) CollectLimit
Input [10]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#64762, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#64763, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#64764, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#64765, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#64766, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#64767, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#64768, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#64769, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#64770, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#64771]
Arguments: 1500