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 #29792 AS COL_IPP_426409#29985, NOM_FAM#29793 AS COL_NOM_FAM_426410#29986, PRENOM#29794 AS COL_PRENOM_426411#29987, NOM_NAISSANCE#29795 AS COL_NOM_NAISSANCE_426412#29988, NATIONALITE#29796 AS COL_NATIONALITE_426413#29989, cast(SEXE#29797 as int) AS COL_SEXE_426414#29990, CIVILITE#29798 AS COL_CIVILITE_426415#29991, cast(DATE_NAIS#29799 as timestamp) AS COL_DATE_NAIS_426416#29992, FINESS_ETAB#29800 AS COL_FINESS_ETAB_426417#29993, cast(REFORMAT_FOR_DOUBLE(INSC#29801) as double) AS COL_INSC_426418#29994, CODE ETAB#29802 AS COL_CODE_ETAB_426419#29995, NOM ETAB#29803 AS COL_NOM_ETAB_426420#29996]
WholeStageCodegen (1)
FileScan csv [IPP #29792,NOM_FAM#29793,PRENOM#29794,NOM_NAISSANCE#29795,NATIONALITE#29796,SEXE#29797,CIVILITE#29798,DATE_NAIS#29799,FINESS_ETAB#29800,INSC#29801,CODE ETAB#29802,NOM ETAB#29803] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/AADAADF1_B478_478F_9645_5A73A40BB..., 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 #29792, NOM_FAM#29793, PRENOM#29794, NOM_NAISSANCE#29795, NATIONALITE#29796, SEXE#29797, CIVILITE#29798, DATE_NAIS#29799, FINESS_ETAB#29800, INSC#29801, CODE ETAB#29802, NOM ETAB#29803]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/AADAADF1_B478_478F_9645_5A73A40BB11C/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 #29792 AS COL_IPP_426409#29985, NOM_FAM#29793 AS COL_NOM_FAM_426410#29986, PRENOM#29794 AS COL_PRENOM_426411#29987, NOM_NAISSANCE#29795 AS COL_NOM_NAISSANCE_426412#29988, NATIONALITE#29796 AS COL_NATIONALITE_426413#29989, cast(SEXE#29797 as int) AS COL_SEXE_426414#29990, CIVILITE#29798 AS COL_CIVILITE_426415#29991, cast(DATE_NAIS#29799 as timestamp) AS COL_DATE_NAIS_426416#29992, FINESS_ETAB#29800 AS COL_FINESS_ETAB_426417#29993, cast(REFORMAT_FOR_DOUBLE(INSC#29801) as double) AS COL_INSC_426418#29994, CODE ETAB#29802 AS COL_CODE_ETAB_426419#29995, NOM ETAB#29803 AS COL_NOM_ETAB_426420#29996]
Input [12]: [IPP #29792, NOM_FAM#29793, PRENOM#29794, NOM_NAISSANCE#29795, NATIONALITE#29796, SEXE#29797, CIVILITE#29798, DATE_NAIS#29799, FINESS_ETAB#29800, INSC#29801, CODE ETAB#29802, NOM ETAB#29803]
(3) CollectLimit
Input [12]: [COL_IPP_426409#29985, COL_NOM_FAM_426410#29986, COL_PRENOM_426411#29987, COL_NOM_NAISSANCE_426412#29988, COL_NATIONALITE_426413#29989, COL_SEXE_426414#29990, COL_CIVILITE_426415#29991, COL_DATE_NAIS_426416#29992, COL_FINESS_ETAB_426417#29993, COL_INSC_426418#29994, COL_CODE_ETAB_426419#29995, COL_NOM_ETAB_426420#29996]
Arguments: 1500