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: 1352.3 KiB"];
2->0;
3->2;
}
4
CollectLimit 1500
Project [IPP #292910 AS COL_CDBCF05D_281B_4705_B8DD_9921D7F5ADB5#293067, NOM_FAM#292911 AS COL_D785AC2F_1E1C_4290_B924_FC2DDDB90303#293068, PRENOM#292912 AS COL_E243CA10_46F3_48B9_BA89_AF32ECACAF4A#293069, NOM_NAISSANCE#292913 AS COL_F17ADE0E_1FCD_44CB_8E39_44B194291A2F#293070, NATIONALITE#292914 AS COL_12DD2D38_DC54_431D_B94D_305A958131F5#293071, cast(SEXE#292915 as int) AS COL_A2D22507_17FE_4B9D_A14A_AEBAF48F41CE#293072, CIVILITE#292916 AS COL_861974B8_07F6_4AB1_9E8F_3E4738B7E1EA#293073, cast(DATE_NAIS#292917 as timestamp) AS COL_1E5D96AD_B106_401C_B8A0_061F52A62110#293074, FINESS_ETAB#292918 AS COL_7DEA7417_B680_4350_A5E6_241EACF82475#293075, cast(REFORMAT_FOR_DOUBLE(INSC#292919) as double) AS COL_2E947770_B327_4622_8C56_C3D62B08D546#293076, CODE ETAB#292920 AS COL_2E30434E_A845_4DB6_968C_008FFEFAF47B#293077, NOM ETAB#292921 AS COL_31FF8084_5AC4_48D6_B6EE_184701CA7F3D#293078]
WholeStageCodegen (1)
FileScan csv [IPP #292910,NOM_FAM#292911,PRENOM#292912,NOM_NAISSANCE#292913,NATIONALITE#292914,SEXE#292915,CIVILITE#292916,DATE_NAIS#292917,FINESS_ETAB#292918,INSC#292919,CODE ETAB#292920,NOM ETAB#292921] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/A04A40C4_E816_454D_A2EF_8C6C991C4..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<IPP :string,NOM_FAM:string,PRENOM:string,NOM_NAISSANCE:string,NATIONALITE:string,SEXE:stri...
== Physical Plan ==
CollectLimit (3)
+- * Project (2)
+- Scan csv (1)
(1) Scan csv
Output [12]: [IPP #292910, NOM_FAM#292911, PRENOM#292912, NOM_NAISSANCE#292913, NATIONALITE#292914, SEXE#292915, CIVILITE#292916, DATE_NAIS#292917, FINESS_ETAB#292918, INSC#292919, CODE ETAB#292920, NOM ETAB#292921]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/A04A40C4_E816_454D_A2EF_8C6C991C44BC/current/PATIENT_ETAB_STI.csv]
ReadSchema: struct<IPP :string,NOM_FAM:string,PRENOM:string,NOM_NAISSANCE:string,NATIONALITE:string,SEXE:string,CIVILITE:string,DATE_NAIS:string,FINESS_ETAB:string,INSC:string,CODE ETAB:string,NOM ETAB:string>
(2) Project [codegen id : 1]
Output [12]: [IPP #292910 AS COL_CDBCF05D_281B_4705_B8DD_9921D7F5ADB5#293067, NOM_FAM#292911 AS COL_D785AC2F_1E1C_4290_B924_FC2DDDB90303#293068, PRENOM#292912 AS COL_E243CA10_46F3_48B9_BA89_AF32ECACAF4A#293069, NOM_NAISSANCE#292913 AS COL_F17ADE0E_1FCD_44CB_8E39_44B194291A2F#293070, NATIONALITE#292914 AS COL_12DD2D38_DC54_431D_B94D_305A958131F5#293071, cast(SEXE#292915 as int) AS COL_A2D22507_17FE_4B9D_A14A_AEBAF48F41CE#293072, CIVILITE#292916 AS COL_861974B8_07F6_4AB1_9E8F_3E4738B7E1EA#293073, cast(DATE_NAIS#292917 as timestamp) AS COL_1E5D96AD_B106_401C_B8A0_061F52A62110#293074, FINESS_ETAB#292918 AS COL_7DEA7417_B680_4350_A5E6_241EACF82475#293075, cast(REFORMAT_FOR_DOUBLE(INSC#292919) as double) AS COL_2E947770_B327_4622_8C56_C3D62B08D546#293076, CODE ETAB#292920 AS COL_2E30434E_A845_4DB6_968C_008FFEFAF47B#293077, NOM ETAB#292921 AS COL_31FF8084_5AC4_48D6_B6EE_184701CA7F3D#293078]
Input [12]: [IPP #292910, NOM_FAM#292911, PRENOM#292912, NOM_NAISSANCE#292913, NATIONALITE#292914, SEXE#292915, CIVILITE#292916, DATE_NAIS#292917, FINESS_ETAB#292918, INSC#292919, CODE ETAB#292920, NOM ETAB#292921]
(3) CollectLimit
Input [12]: [COL_CDBCF05D_281B_4705_B8DD_9921D7F5ADB5#293067, COL_D785AC2F_1E1C_4290_B924_FC2DDDB90303#293068, COL_E243CA10_46F3_48B9_BA89_AF32ECACAF4A#293069, COL_F17ADE0E_1FCD_44CB_8E39_44B194291A2F#293070, COL_12DD2D38_DC54_431D_B94D_305A958131F5#293071, COL_A2D22507_17FE_4B9D_A14A_AEBAF48F41CE#293072, COL_861974B8_07F6_4AB1_9E8F_3E4738B7E1EA#293073, COL_1E5D96AD_B106_401C_B8A0_061F52A62110#293074, COL_7DEA7417_B680_4350_A5E6_241EACF82475#293075, COL_2E947770_B327_4622_8C56_C3D62B08D546#293076, COL_2E30434E_A845_4DB6_968C_008FFEFAF47B#293077, COL_31FF8084_5AC4_48D6_B6EE_184701CA7F3D#293078]
Arguments: 1500