digraph G {
0 [labelType="html" label="<b>Execute InsertIntoHadoopFsRelationCommand</b><br><br>task commit time: 7 ms<br>number of written files: 1<br>job commit time: 12 ms<br>number of output rows: 15,005<br>number of dynamic part: 1<br>written output: 256.4 KiB"];
1 [labelType="html" label="<br><b>WriteFiles</b><br><br>"];
subgraph cluster2 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 311 ms";
3 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 64.5 MiB<br>spill size: 0.0 B"];
4 [labelType="html" label="<br><b>Project</b><br><br>"];
}
5 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 15,005<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 1352.3 KiB"];
1->0;
3->1;
4->3;
5->4;
}
6
Execute InsertIntoHadoopFsRelationCommand file:/data/input/depot/csv/execution/123D0A81_3925_4EA5_89EA_BA846614BB79/extraction, false, [date_e2de7809f31f0bc995bbee0bc28094ce#28593], Parquet, [__partition_columns=["date_e2de7809f31f0bc995bbee0bc28094ce"], path=file:///data/input/depot/csv/execution/123D0A81_3925_4EA5_89EA_BA846614BB79/extraction], Append, [IPP+, NOM_FAM, PRENOM, NOM_NAISSANCE, NATIONALITE, SEXE, CIVILITE, DATE_NAIS, FINESS_ETAB, INSC, CODE+ETAB, NOM+ETAB, date_e2de7809f31f0bc995bbee0bc28094ce]
WriteFiles
Sort [date_e2de7809f31f0bc995bbee0bc28094ce#28593 ASC NULLS FIRST], false, 0
Project [IPP #28374 AS IPP+#28425, NOM_FAM#28375, PRENOM#28376, NOM_NAISSANCE#28377, NATIONALITE#28378, SEXE#28379, CIVILITE#28380, DATE_NAIS#28381, FINESS_ETAB#28382, INSC#28383, CODE ETAB#28384 AS CODE+ETAB#28565, NOM ETAB#28385 AS NOM+ETAB#28579, 2026-09-04 09:00:09.572047 AS date_e2de7809f31f0bc995bbee0bc28094ce#28593]
WholeStageCodegen (1)
FileScan csv [IPP #28374,NOM_FAM#28375,PRENOM#28376,NOM_NAISSANCE#28377,NATIONALITE#28378,SEXE#28379,CIVILITE#28380,DATE_NAIS#28381,FINESS_ETAB#28382,INSC#28383,CODE ETAB#28384,NOM ETAB#28385] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/123D0A81_3925_4EA5_89EA_BA846614B..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<IPP :string,NOM_FAM:string,PRENOM:string,NOM_NAISSANCE:string,NATIONALITE:string,SEXE:stri...
== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand (5)
+- WriteFiles (4)
+- * Sort (3)
+- * Project (2)
+- Scan csv (1)
(1) Scan csv
Output [12]: [IPP #28374, NOM_FAM#28375, PRENOM#28376, NOM_NAISSANCE#28377, NATIONALITE#28378, SEXE#28379, CIVILITE#28380, DATE_NAIS#28381, FINESS_ETAB#28382, INSC#28383, CODE ETAB#28384, NOM ETAB#28385]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/123D0A81_3925_4EA5_89EA_BA846614BB79/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 [13]: [IPP #28374 AS IPP+#28425, NOM_FAM#28375, PRENOM#28376, NOM_NAISSANCE#28377, NATIONALITE#28378, SEXE#28379, CIVILITE#28380, DATE_NAIS#28381, FINESS_ETAB#28382, INSC#28383, CODE ETAB#28384 AS CODE+ETAB#28565, NOM ETAB#28385 AS NOM+ETAB#28579, 2026-09-04 09:00:09.572047 AS date_e2de7809f31f0bc995bbee0bc28094ce#28593]
Input [12]: [IPP #28374, NOM_FAM#28375, PRENOM#28376, NOM_NAISSANCE#28377, NATIONALITE#28378, SEXE#28379, CIVILITE#28380, DATE_NAIS#28381, FINESS_ETAB#28382, INSC#28383, CODE ETAB#28384, NOM ETAB#28385]
(3) Sort [codegen id : 1]
Input [13]: [IPP+#28425, NOM_FAM#28375, PRENOM#28376, NOM_NAISSANCE#28377, NATIONALITE#28378, SEXE#28379, CIVILITE#28380, DATE_NAIS#28381, FINESS_ETAB#28382, INSC#28383, CODE+ETAB#28565, NOM+ETAB#28579, date_e2de7809f31f0bc995bbee0bc28094ce#28593]
Arguments: [date_e2de7809f31f0bc995bbee0bc28094ce#28593 ASC NULLS FIRST], false, 0
(4) WriteFiles
Input [13]: [IPP+#28425, NOM_FAM#28375, PRENOM#28376, NOM_NAISSANCE#28377, NATIONALITE#28378, SEXE#28379, CIVILITE#28380, DATE_NAIS#28381, FINESS_ETAB#28382, INSC#28383, CODE+ETAB#28565, NOM+ETAB#28579, date_e2de7809f31f0bc995bbee0bc28094ce#28593]
(5) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/input/depot/csv/execution/123D0A81_3925_4EA5_89EA_BA846614BB79/extraction, false, [date_e2de7809f31f0bc995bbee0bc28094ce#28593], Parquet, [__partition_columns=["date_e2de7809f31f0bc995bbee0bc28094ce"], path=file:///data/input/depot/csv/execution/123D0A81_3925_4EA5_89EA_BA846614BB79/extraction], Append, [IPP+, NOM_FAM, PRENOM, NOM_NAISSANCE, NATIONALITE, SEXE, CIVILITE, DATE_NAIS, FINESS_ETAB, INSC, CODE+ETAB, NOM+ETAB, date_e2de7809f31f0bc995bbee0bc28094ce]