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#56624 AS COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#59300, NO_RSS#56625 AS COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#59301, NO_ADMIN#56626 AS COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#59302, DATE_ENT#56627 AS COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#59303, DATE_SOR#56628 AS COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#59304, VALO#56629 AS COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#59305, GHS#56630 AS COL_CB09A89F_3D14_4584_B772_272D8BAC362D#59306, str_to_dec(MNT_MON#56766, ##,##) AS COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#59307, str_to_dec(MNT_DMI#56767, ##,##) AS COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#59308, str_to_dec(MNT_MED_APAC#56768, ##,##) AS COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#59309]
WholeStageCodegen (1)
FileScan csv [FINESS#56624,NO_RSS#56625,NO_ADMIN#56626,DATE_ENT#56627,DATE_SOR#56628,VALO#56629,GHS#56630,MNT_MON#56766,MNT_DMI#56767,MNT_MED_APAC#56768] 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#56624, NO_RSS#56625, NO_ADMIN#56626, DATE_ENT#56627, DATE_SOR#56628, VALO#56629, GHS#56630, MNT_MON#56766, MNT_DMI#56767, MNT_MED_APAC#56768]
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#56624 AS COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#59300, NO_RSS#56625 AS COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#59301, NO_ADMIN#56626 AS COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#59302, DATE_ENT#56627 AS COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#59303, DATE_SOR#56628 AS COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#59304, VALO#56629 AS COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#59305, GHS#56630 AS COL_CB09A89F_3D14_4584_B772_272D8BAC362D#59306, str_to_dec(MNT_MON#56766, ##,##) AS COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#59307, str_to_dec(MNT_DMI#56767, ##,##) AS COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#59308, str_to_dec(MNT_MED_APAC#56768, ##,##) AS COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#59309]
Input [10]: [FINESS#56624, NO_RSS#56625, NO_ADMIN#56626, DATE_ENT#56627, DATE_SOR#56628, VALO#56629, GHS#56630, MNT_MON#56766, MNT_DMI#56767, MNT_MED_APAC#56768]
(3) CollectLimit
Input [10]: [COL_439A37D8_DFEE_4DF0_A4A3_80E3EF97FAD9#59300, COL_B0421838_B608_4AA6_AA2E_38FAEED1F891#59301, COL_9CE78B38_05A8_4BDE_9330_F7DF8166291D#59302, COL_81F393A8_4EC5_4B1F_AD8B_579B7D0C9CFA#59303, COL_0D638A70_1AC1_4CB7_BD00_4DC21CBEBF81#59304, COL_95D7A479_6E49_47AA_A19D_1BC5654A70CB#59305, COL_CB09A89F_3D14_4584_B772_272D8BAC362D#59306, COL_1951BB46_DAA1_41AE_95E1_5D8AF0DDC5FE#59307, COL_DB68A28C_38CD_4B37_8BFB_36C0ED5BFF25#59308, COL_D704A1AD_7693_4EAC_8600_A0399BC2265F#59309]
Arguments: 1500