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 #294245 AS COL__IPP#294438, NOM_FAM#294246 AS COL__NOM_FAM#294439, PRENOM#294247 AS COL__PRENOM#294440, NOM_NAISSANCE#294248 AS COL__NOM_NAISSANCE#294441, NATIONALITE#294249 AS COL__NATIONALITE#294442, cast(SEXE#294250 as int) AS COL__SEXE#294443, CIVILITE#294251 AS COL__CIVILITE#294444, cast(DATE_NAIS#294252 as timestamp) AS COL__DATE_NAIS#294445, FINESS_ETAB#294253 AS COL__FINESS_ETAB#294446, cast(REFORMAT_FOR_DOUBLE(INSC#294254) as double) AS COL__INSC#294447, CODE ETAB#294255 AS COL__CODE_ETAB#294448, NOM ETAB#294256 AS COL__NOM_ETAB#294449]
WholeStageCodegen (1)
FileScan csv [IPP #294245,NOM_FAM#294246,PRENOM#294247,NOM_NAISSANCE#294248,NATIONALITE#294249,SEXE#294250,CIVILITE#294251,DATE_NAIS#294252,FINESS_ETAB#294253,INSC#294254,CODE ETAB#294255,NOM ETAB#294256] 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 #294245, NOM_FAM#294246, PRENOM#294247, NOM_NAISSANCE#294248, NATIONALITE#294249, SEXE#294250, CIVILITE#294251, DATE_NAIS#294252, FINESS_ETAB#294253, INSC#294254, CODE ETAB#294255, NOM ETAB#294256]
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 #294245 AS COL__IPP#294438, NOM_FAM#294246 AS COL__NOM_FAM#294439, PRENOM#294247 AS COL__PRENOM#294440, NOM_NAISSANCE#294248 AS COL__NOM_NAISSANCE#294441, NATIONALITE#294249 AS COL__NATIONALITE#294442, cast(SEXE#294250 as int) AS COL__SEXE#294443, CIVILITE#294251 AS COL__CIVILITE#294444, cast(DATE_NAIS#294252 as timestamp) AS COL__DATE_NAIS#294445, FINESS_ETAB#294253 AS COL__FINESS_ETAB#294446, cast(REFORMAT_FOR_DOUBLE(INSC#294254) as double) AS COL__INSC#294447, CODE ETAB#294255 AS COL__CODE_ETAB#294448, NOM ETAB#294256 AS COL__NOM_ETAB#294449]
Input [12]: [IPP #294245, NOM_FAM#294246, PRENOM#294247, NOM_NAISSANCE#294248, NATIONALITE#294249, SEXE#294250, CIVILITE#294251, DATE_NAIS#294252, FINESS_ETAB#294253, INSC#294254, CODE ETAB#294255, NOM ETAB#294256]
(3) CollectLimit
Input [12]: [COL__IPP#294438, COL__NOM_FAM#294439, COL__PRENOM#294440, COL__NOM_NAISSANCE#294441, COL__NATIONALITE#294442, COL__SEXE#294443, COL__CIVILITE#294444, COL__DATE_NAIS#294445, COL__FINESS_ETAB#294446, COL__INSC#294447, COL__CODE_ETAB#294448, COL__NOM_ETAB#294449]
Arguments: 1500