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 #274246 AS COL_IPP_425461#274439, NOM_FAM#274247 AS COL_NOM_FAM_425462#274440, PRENOM#274248 AS COL_PRENOM_425463#274441, NOM_NAISSANCE#274249 AS COL_NOM_NAISSANCE_425464#274442, NATIONALITE#274250 AS COL_NATIONALITE_425465#274443, cast(SEXE#274251 as int) AS COL_SEXE_425466#274444, CIVILITE#274252 AS COL_CIVILITE_425467#274445, cast(DATE_NAIS#274253 as timestamp) AS COL_DATE_NAIS_425468#274446, FINESS_ETAB#274254 AS COL_FINESS_ETAB_425469#274447, cast(REFORMAT_FOR_DOUBLE(INSC#274255) as double) AS COL_INSC_425470#274448, CODE ETAB#274256 AS COL_CODE_ETAB_425471#274449, NOM ETAB#274257 AS COL_NOM_ETAB_425472#274450]
WholeStageCodegen (1)
FileScan csv [IPP #274246,NOM_FAM#274247,PRENOM#274248,NOM_NAISSANCE#274249,NATIONALITE#274250,SEXE#274251,CIVILITE#274252,DATE_NAIS#274253,FINESS_ETAB#274254,INSC#274255,CODE ETAB#274256,NOM ETAB#274257] 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 #274246, NOM_FAM#274247, PRENOM#274248, NOM_NAISSANCE#274249, NATIONALITE#274250, SEXE#274251, CIVILITE#274252, DATE_NAIS#274253, FINESS_ETAB#274254, INSC#274255, CODE ETAB#274256, NOM ETAB#274257]
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 #274246 AS COL_IPP_425461#274439, NOM_FAM#274247 AS COL_NOM_FAM_425462#274440, PRENOM#274248 AS COL_PRENOM_425463#274441, NOM_NAISSANCE#274249 AS COL_NOM_NAISSANCE_425464#274442, NATIONALITE#274250 AS COL_NATIONALITE_425465#274443, cast(SEXE#274251 as int) AS COL_SEXE_425466#274444, CIVILITE#274252 AS COL_CIVILITE_425467#274445, cast(DATE_NAIS#274253 as timestamp) AS COL_DATE_NAIS_425468#274446, FINESS_ETAB#274254 AS COL_FINESS_ETAB_425469#274447, cast(REFORMAT_FOR_DOUBLE(INSC#274255) as double) AS COL_INSC_425470#274448, CODE ETAB#274256 AS COL_CODE_ETAB_425471#274449, NOM ETAB#274257 AS COL_NOM_ETAB_425472#274450]
Input [12]: [IPP #274246, NOM_FAM#274247, PRENOM#274248, NOM_NAISSANCE#274249, NATIONALITE#274250, SEXE#274251, CIVILITE#274252, DATE_NAIS#274253, FINESS_ETAB#274254, INSC#274255, CODE ETAB#274256, NOM ETAB#274257]
(3) CollectLimit
Input [12]: [COL_IPP_425461#274439, COL_NOM_FAM_425462#274440, COL_PRENOM_425463#274441, COL_NOM_NAISSANCE_425464#274442, COL_NATIONALITE_425465#274443, COL_SEXE_425466#274444, COL_CIVILITE_425467#274445, COL_DATE_NAIS_425468#274446, COL_FINESS_ETAB_425469#274447, COL_INSC_425470#274448, COL_CODE_ETAB_425471#274449, COL_NOM_ETAB_425472#274450]
Arguments: 1500