digraph G {
0 [labelType="html" label="<b>Execute InsertIntoHadoopFsRelationCommand</b><br><br>task commit time: 0 ms<br>number of written files: 1<br>job commit time: 6 ms<br>number of output rows: 209<br>number of dynamic part: 0<br>written output: 10.7 KiB"];
1 [labelType="html" label="<br><b>WriteFiles</b><br><br>"];
subgraph cluster2 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 299 ms";
3 [labelType="html" label="<br><b>Project</b><br><br>"];
}
4 [labelType="html" label="<b>BatchScan excel file:/data/input/depot/excel/tmp/SIC_SERVEUR_161426/SIC.xlsx</b><br><br>number of output rows: 209"];
1->0;
3->1;
4->3;
}
5
Execute InsertIntoHadoopFsRelationCommand file:/data/input/depot/excel/cache/SIC_SERVEUR_161426_7cd1e9ebf16383b20c9d2e7acf87fe19/SIC.xlsx_b48078a1cfbf8b575e36809c74ebf5bc, false, Parquet, [path=file:///data/input/depot/excel/cache/SIC_SERVEUR_161426_7cd1e9ebf16383b20c9d2e7acf87fe19/SIC.xlsx_b48078a1cfbf8b575e36809c74ebf5bc], ErrorIfExists, [CODE, LIBELLE, Code+REGROUPEMENT, Date_effet, Date_r%C3%A9vocation, Responsable+MAJ, Source, SIC_SERVEUR_161426HEADER_COL_DETAIL_DEPOT]
WriteFiles
Project [CODE#2314207, LIBELLE#2314208, Code REGROUPEMENT#2314209 AS Code+REGROUPEMENT#2314255, Date_effet#2314210, Date_révocation#2314211 AS Date_r%C3%A9vocation#2314273, Responsable MAJ#2314212 AS Responsable+MAJ#2314282, Source#2314213, file:/data/input/depot/excel/tmp/SIC_SERVEUR_161426/SIC.xlsx AS SIC_SERVEUR_161426HEADER_COL_DETAIL_DEPOT#2314300]
WholeStageCodegen (1)
BatchScan excel file:/data/input/depot/excel/tmp/SIC_SERVEUR_161426/SIC.xlsx[CODE#2314207, LIBELLE#2314208, Code REGROUPEMENT#2314209, Date_effet#2314210, Date_révocation#2314211, Responsable MAJ#2314212, Source#2314213] ExcelScan DataFilters: [], Format: excel, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/tmp/SIC_SERVEUR_161426/SIC.xlsx], PartitionFilters: [], ReadSchema: struct<CODE:string,LIBELLE:string,Code REGROUPEMENT:string,Date_effet:string,Date_révocation:stri..., PushedFilters: [] RuntimeFilters: []
== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand (4)
+- WriteFiles (3)
+- * Project (2)
+- BatchScan excel file:/data/input/depot/excel/tmp/SIC_SERVEUR_161426/SIC.xlsx (1)
(1) BatchScan excel file:/data/input/depot/excel/tmp/SIC_SERVEUR_161426/SIC.xlsx
Output [7]: [CODE#2314207, LIBELLE#2314208, Code REGROUPEMENT#2314209, Date_effet#2314210, Date_révocation#2314211, Responsable MAJ#2314212, Source#2314213]
Format: excel
Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/tmp/SIC_SERVEUR_161426/SIC.xlsx]
ReadSchema: struct<CODE:string,LIBELLE:string,Code REGROUPEMENT:string,Date_effet:string,Date_révocation:string,Responsable MAJ:string,Source:string>
(2) Project [codegen id : 1]
Output [8]: [CODE#2314207, LIBELLE#2314208, Code REGROUPEMENT#2314209 AS Code+REGROUPEMENT#2314255, Date_effet#2314210, Date_révocation#2314211 AS Date_r%C3%A9vocation#2314273, Responsable MAJ#2314212 AS Responsable+MAJ#2314282, Source#2314213, file:/data/input/depot/excel/tmp/SIC_SERVEUR_161426/SIC.xlsx AS SIC_SERVEUR_161426HEADER_COL_DETAIL_DEPOT#2314300]
Input [7]: [CODE#2314207, LIBELLE#2314208, Code REGROUPEMENT#2314209, Date_effet#2314210, Date_révocation#2314211, Responsable MAJ#2314212, Source#2314213]
(3) WriteFiles
Input [8]: [CODE#2314207, LIBELLE#2314208, Code+REGROUPEMENT#2314255, Date_effet#2314210, Date_r%C3%A9vocation#2314273, Responsable+MAJ#2314282, Source#2314213, SIC_SERVEUR_161426HEADER_COL_DETAIL_DEPOT#2314300]
(4) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/input/depot/excel/cache/SIC_SERVEUR_161426_7cd1e9ebf16383b20c9d2e7acf87fe19/SIC.xlsx_b48078a1cfbf8b575e36809c74ebf5bc, false, Parquet, [path=file:///data/input/depot/excel/cache/SIC_SERVEUR_161426_7cd1e9ebf16383b20c9d2e7acf87fe19/SIC.xlsx_b48078a1cfbf8b575e36809c74ebf5bc], ErrorIfExists, [CODE, LIBELLE, Code+REGROUPEMENT, Date_effet, Date_r%C3%A9vocation, Responsable+MAJ, Source, SIC_SERVEUR_161426HEADER_COL_DETAIL_DEPOT]