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 #293384 AS COL__IPP#293577, NOM_FAM#293385 AS COL__NOM_FAM#293578, PRENOM#293386 AS COL__PRENOM#293579, NOM_NAISSANCE#293387 AS COL__NOM_NAISSANCE#293580, NATIONALITE#293388 AS COL__NATIONALITE#293581, cast(SEXE#293389 as int) AS COL__SEXE#293582, CIVILITE#293390 AS COL__CIVILITE#293583, cast(DATE_NAIS#293391 as timestamp) AS COL__DATE_NAIS#293584, FINESS_ETAB#293392 AS COL__FINESS_ETAB#293585, cast(REFORMAT_FOR_DOUBLE(INSC#293393) as double) AS COL__INSC#293586, CODE ETAB#293394 AS COL__CODE_ETAB#293587, NOM ETAB#293395 AS COL__NOM_ETAB#293588]
WholeStageCodegen (1)
FileScan csv [IPP #293384,NOM_FAM#293385,PRENOM#293386,NOM_NAISSANCE#293387,NATIONALITE#293388,SEXE#293389,CIVILITE#293390,DATE_NAIS#293391,FINESS_ETAB#293392,INSC#293393,CODE ETAB#293394,NOM ETAB#293395] 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 #293384, NOM_FAM#293385, PRENOM#293386, NOM_NAISSANCE#293387, NATIONALITE#293388, SEXE#293389, CIVILITE#293390, DATE_NAIS#293391, FINESS_ETAB#293392, INSC#293393, CODE ETAB#293394, NOM ETAB#293395]
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 #293384 AS COL__IPP#293577, NOM_FAM#293385 AS COL__NOM_FAM#293578, PRENOM#293386 AS COL__PRENOM#293579, NOM_NAISSANCE#293387 AS COL__NOM_NAISSANCE#293580, NATIONALITE#293388 AS COL__NATIONALITE#293581, cast(SEXE#293389 as int) AS COL__SEXE#293582, CIVILITE#293390 AS COL__CIVILITE#293583, cast(DATE_NAIS#293391 as timestamp) AS COL__DATE_NAIS#293584, FINESS_ETAB#293392 AS COL__FINESS_ETAB#293585, cast(REFORMAT_FOR_DOUBLE(INSC#293393) as double) AS COL__INSC#293586, CODE ETAB#293394 AS COL__CODE_ETAB#293587, NOM ETAB#293395 AS COL__NOM_ETAB#293588]
Input [12]: [IPP #293384, NOM_FAM#293385, PRENOM#293386, NOM_NAISSANCE#293387, NATIONALITE#293388, SEXE#293389, CIVILITE#293390, DATE_NAIS#293391, FINESS_ETAB#293392, INSC#293393, CODE ETAB#293394, NOM ETAB#293395]
(3) CollectLimit
Input [12]: [COL__IPP#293577, COL__NOM_FAM#293578, COL__PRENOM#293579, COL__NOM_NAISSANCE#293580, COL__NATIONALITE#293581, COL__SEXE#293582, COL__CIVILITE#293583, COL__DATE_NAIS#293584, COL__FINESS_ETAB#293585, COL__INSC#293586, COL__CODE_ETAB#293587, COL__NOM_ETAB#293588]
Arguments: 1500