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 #291998 AS COL__IPP#292191, NOM_FAM#291999 AS COL__NOM_FAM#292192, PRENOM#292000 AS COL__PRENOM#292193, NOM_NAISSANCE#292001 AS COL__NOM_NAISSANCE#292194, NATIONALITE#292002 AS COL__NATIONALITE#292195, cast(SEXE#292003 as int) AS COL__SEXE#292196, CIVILITE#292004 AS COL__CIVILITE#292197, cast(DATE_NAIS#292005 as timestamp) AS COL__DATE_NAIS#292198, FINESS_ETAB#292006 AS COL__FINESS_ETAB#292199, cast(REFORMAT_FOR_DOUBLE(INSC#292007) as double) AS COL__INSC#292200, CODE ETAB#292008 AS COL__CODE_ETAB#292201, NOM ETAB#292009 AS COL__NOM_ETAB#292202]
WholeStageCodegen (1)
FileScan csv [IPP #291998,NOM_FAM#291999,PRENOM#292000,NOM_NAISSANCE#292001,NATIONALITE#292002,SEXE#292003,CIVILITE#292004,DATE_NAIS#292005,FINESS_ETAB#292006,INSC#292007,CODE ETAB#292008,NOM ETAB#292009] 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 #291998, NOM_FAM#291999, PRENOM#292000, NOM_NAISSANCE#292001, NATIONALITE#292002, SEXE#292003, CIVILITE#292004, DATE_NAIS#292005, FINESS_ETAB#292006, INSC#292007, CODE ETAB#292008, NOM ETAB#292009]
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 #291998 AS COL__IPP#292191, NOM_FAM#291999 AS COL__NOM_FAM#292192, PRENOM#292000 AS COL__PRENOM#292193, NOM_NAISSANCE#292001 AS COL__NOM_NAISSANCE#292194, NATIONALITE#292002 AS COL__NATIONALITE#292195, cast(SEXE#292003 as int) AS COL__SEXE#292196, CIVILITE#292004 AS COL__CIVILITE#292197, cast(DATE_NAIS#292005 as timestamp) AS COL__DATE_NAIS#292198, FINESS_ETAB#292006 AS COL__FINESS_ETAB#292199, cast(REFORMAT_FOR_DOUBLE(INSC#292007) as double) AS COL__INSC#292200, CODE ETAB#292008 AS COL__CODE_ETAB#292201, NOM ETAB#292009 AS COL__NOM_ETAB#292202]
Input [12]: [IPP #291998, NOM_FAM#291999, PRENOM#292000, NOM_NAISSANCE#292001, NATIONALITE#292002, SEXE#292003, CIVILITE#292004, DATE_NAIS#292005, FINESS_ETAB#292006, INSC#292007, CODE ETAB#292008, NOM ETAB#292009]
(3) CollectLimit
Input [12]: [COL__IPP#292191, COL__NOM_FAM#292192, COL__PRENOM#292193, COL__NOM_NAISSANCE#292194, COL__NATIONALITE#292195, COL__SEXE#292196, COL__CIVILITE#292197, COL__DATE_NAIS#292198, COL__FINESS_ETAB#292199, COL__INSC#292200, COL__CODE_ETAB#292201, COL__NOM_ETAB#292202]
Arguments: 1500