digraph G {
0 [labelType="html" label="<b>Execute InsertIntoHadoopFsRelationCommand</b><br><br>task commit time total (min, med, max (stageId: taskId))<br>10 ms (0 ms, 1 ms, 2 ms (stage 21046.0: task 27257))<br>number of written files: 12<br>job commit time: 18 ms<br>number of output rows: 1,201<br>number of dynamic part: 0<br>written output: 175.2 KiB"];
1 [labelType="html" label="<br><b>WriteFiles</b><br><br>"];
subgraph cluster2 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n2.1 s (133 ms, 179 ms, 184 ms (stage 21046.0: task 27266))";
3 [labelType="html" label="<br><b>Project</b><br><br>"];
4 [labelType="html" label="<b>Scan ExcelRelation(dev.mauch.spark.excel.CellRangeAddressDataLocator@4998bc0f,true,false,false,false,false,false,None,None,None,10,dev.mauch.spark.excel.DefaultWorkbookReader@26e3a578) </b><br><br>number of output rows: 1,201"];
}
1->0;
3->1;
4->3;
}
5
Execute InsertIntoHadoopFsRelationCommand file:/data/input/depot/excel/cache/SYNTHESE_DMI_20_237789_b7c9fcd90987f45e4002171a5d87dfdd/synthèse-DMI-2025.xls_41d136f5d26b76a99c371a1af7fc9e64, false, Parquet, [path=file:///data/input/depot/excel/cache/SYNTHESE_DMI_20_237789_b7c9fcd90987f45e4002171a5d87dfdd/synthèse-DMI-2025.xls_41d136f5d26b76a99c371a1af7fc9e64], ErrorIfExists, [N%C2%B0, IPP, N%C2%B0+s%C3%A9jour, initiales, date+pose, code+LPP, libell%C3%A9+LPP, quantit%C3%A9, prix+d%27achat+unitaire+%28%E2%82%AC+ttc%29, tarif+responsabilit%C3%A9+LPP+%28%E2%82%AC+ttc%29, d%C3%A9penses+d%C3%A9clar%C3%A9es+%28%E2%82%AC+ttc%29, d%C3%A9penses+au+tarif+LPP, majoration+%28%E2%82%AC+ttc%29, d%C3%A9penses+accord%C3%A9es+%28%E2%82%AC+ttc%29, _c14, _c15, Fournisseur%2C+Libell%C3%A9+DMI, commentaire, _c18, _c19, _c20, SYNTHESE_DMI_20_237789HEADER_COL_DETAIL_DEPOT]
WriteFiles
Project [N°#1690503 AS N%C2%B0#1690589, IPP#1690504, N° séjour#1690505 AS N%C2%B0+s%C3%A9jour#1690635, initiales#1690506, date pose#1690507 AS date+pose#1690681, code LPP#1690508 AS code+LPP#1690704, libellé LPP#1690509 AS libell%C3%A9+LPP#1690727, quantité#1690510 AS quantit%C3%A9#1690750, prix d'achat unitaire (€ ttc)#1690511 AS prix+d%27achat+unitaire+%28%E2%82%AC+ttc%29#1690773, tarif responsabilité LPP (€ ttc)#1690512 AS tarif+responsabilit%C3%A9+LPP+%28%E2%82%AC+ttc%29#1690796, dépenses déclarées (€ ttc)#1690513 AS d%C3%A9penses+d%C3%A9clar%C3%A9es+%28%E2%82%AC+ttc%29#1690819, dépenses au tarif LPP#1690514 AS d%C3%A9penses+au+tarif+LPP#1690842, majoration (€ ttc)#1690515 AS majoration+%28%E2%82%AC+ttc%29#1690865, dépenses accordées (€ ttc)#1690516 AS d%C3%A9penses+accord%C3%A9es+%28%E2%82%AC+ttc%29#1690888, _c14#1690517, _c15#1690518, Fournisseur, Libellé DMI#1690519 AS Fournisseur%2C+Libell%C3%A9+DMI#1690957, commentaire#1690520, _c18#1690521, _c19#1690522, _c20#1690523, file:/data/input/depot/excel/tmp/SYNTHESE_DMI_20_237789/synthèse-DMI-2025.xls AS SYNTHESE_DMI_20_237789HEADER_COL_DETAIL_DEPOT#1691072]
Scan ExcelRelation(dev.mauch.spark.excel.CellRangeAddressDataLocator@4998bc0f,true,false,false,false,false,false,None,None,None,10,dev.mauch.spark.excel.DefaultWorkbookReader@26e3a578) [N°#1690503,IPP#1690504,N° séjour#1690505,initiales#1690506,date pose#1690507,code LPP#1690508,libellé LPP#1690509,quantité#1690510,prix d'achat unitaire (€ ttc)#1690511,tarif responsabilité LPP (€ ttc)#1690512,dépenses déclarées (€ ttc)#1690513,dépenses au tarif LPP#1690514,majoration (€ ttc)#1690515,dépenses accordées (€ ttc)#1690516,_c14#1690517,_c15#1690518,Fournisseur, Libellé DMI#1690519,commentaire#1690520,_c18#1690521,_c19#1690522,_c20#1690523] PushedFilters: [], ReadSchema: struct<N°:string,IPP:string,N° séjour:string,initiales:string,date pose:string,code LPP:string,li...
WholeStageCodegen (1)
== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand (4)
+- WriteFiles (3)
+- * Project (2)
+- * Scan ExcelRelation(dev.mauch.spark.excel.CellRangeAddressDataLocator@4998bc0f,true,false,false,false,false,false,None,None,None,10,dev.mauch.spark.excel.DefaultWorkbookReader@26e3a578) (1)
(1) Scan ExcelRelation(dev.mauch.spark.excel.CellRangeAddressDataLocator@4998bc0f,true,false,false,false,false,false,None,None,None,10,dev.mauch.spark.excel.DefaultWorkbookReader@26e3a578) [codegen id : 1]
Output [21]: [N°#1690503, IPP#1690504, N° séjour#1690505, initiales#1690506, date pose#1690507, code LPP#1690508, libellé LPP#1690509, quantité#1690510, prix d'achat unitaire (€ ttc)#1690511, tarif responsabilité LPP (€ ttc)#1690512, dépenses déclarées (€ ttc)#1690513, dépenses au tarif LPP#1690514, majoration (€ ttc)#1690515, dépenses accordées (€ ttc)#1690516, _c14#1690517, _c15#1690518, Fournisseur, Libellé DMI#1690519, commentaire#1690520, _c18#1690521, _c19#1690522, _c20#1690523]
ReadSchema: struct<N°:string,IPP:string,N° séjour:string,initiales:string,date pose:string,code LPP:string,libellé LPP:string,quantité:string,prix d'achat unitaire (€ ttc):string,tarif responsabilité LPP (€ ttc):string,dépenses déclarées (€ ttc):string,dépenses au tarif LPP:string,majoration (€ ttc):string,dépenses accordées (€ ttc):string,_c14:string,_c15:string,Fournisseur, Libellé DMI:string,commentaire:string,_c18:string,_c19:string,_c20:string>
(2) Project [codegen id : 1]
Output [22]: [N°#1690503 AS N%C2%B0#1690589, IPP#1690504, N° séjour#1690505 AS N%C2%B0+s%C3%A9jour#1690635, initiales#1690506, date pose#1690507 AS date+pose#1690681, code LPP#1690508 AS code+LPP#1690704, libellé LPP#1690509 AS libell%C3%A9+LPP#1690727, quantité#1690510 AS quantit%C3%A9#1690750, prix d'achat unitaire (€ ttc)#1690511 AS prix+d%27achat+unitaire+%28%E2%82%AC+ttc%29#1690773, tarif responsabilité LPP (€ ttc)#1690512 AS tarif+responsabilit%C3%A9+LPP+%28%E2%82%AC+ttc%29#1690796, dépenses déclarées (€ ttc)#1690513 AS d%C3%A9penses+d%C3%A9clar%C3%A9es+%28%E2%82%AC+ttc%29#1690819, dépenses au tarif LPP#1690514 AS d%C3%A9penses+au+tarif+LPP#1690842, majoration (€ ttc)#1690515 AS majoration+%28%E2%82%AC+ttc%29#1690865, dépenses accordées (€ ttc)#1690516 AS d%C3%A9penses+accord%C3%A9es+%28%E2%82%AC+ttc%29#1690888, _c14#1690517, _c15#1690518, Fournisseur, Libellé DMI#1690519 AS Fournisseur%2C+Libell%C3%A9+DMI#1690957, commentaire#1690520, _c18#1690521, _c19#1690522, _c20#1690523, file:/data/input/depot/excel/tmp/SYNTHESE_DMI_20_237789/synthèse-DMI-2025.xls AS SYNTHESE_DMI_20_237789HEADER_COL_DETAIL_DEPOT#1691072]
Input [21]: [N°#1690503, IPP#1690504, N° séjour#1690505, initiales#1690506, date pose#1690507, code LPP#1690508, libellé LPP#1690509, quantité#1690510, prix d'achat unitaire (€ ttc)#1690511, tarif responsabilité LPP (€ ttc)#1690512, dépenses déclarées (€ ttc)#1690513, dépenses au tarif LPP#1690514, majoration (€ ttc)#1690515, dépenses accordées (€ ttc)#1690516, _c14#1690517, _c15#1690518, Fournisseur, Libellé DMI#1690519, commentaire#1690520, _c18#1690521, _c19#1690522, _c20#1690523]
(3) WriteFiles
Input [22]: [N%C2%B0#1690589, IPP#1690504, N%C2%B0+s%C3%A9jour#1690635, initiales#1690506, date+pose#1690681, code+LPP#1690704, libell%C3%A9+LPP#1690727, quantit%C3%A9#1690750, prix+d%27achat+unitaire+%28%E2%82%AC+ttc%29#1690773, tarif+responsabilit%C3%A9+LPP+%28%E2%82%AC+ttc%29#1690796, d%C3%A9penses+d%C3%A9clar%C3%A9es+%28%E2%82%AC+ttc%29#1690819, d%C3%A9penses+au+tarif+LPP#1690842, majoration+%28%E2%82%AC+ttc%29#1690865, d%C3%A9penses+accord%C3%A9es+%28%E2%82%AC+ttc%29#1690888, _c14#1690517, _c15#1690518, Fournisseur%2C+Libell%C3%A9+DMI#1690957, commentaire#1690520, _c18#1690521, _c19#1690522, _c20#1690523, SYNTHESE_DMI_20_237789HEADER_COL_DETAIL_DEPOT#1691072]
(4) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/input/depot/excel/cache/SYNTHESE_DMI_20_237789_b7c9fcd90987f45e4002171a5d87dfdd/synthèse-DMI-2025.xls_41d136f5d26b76a99c371a1af7fc9e64, false, Parquet, [path=file:///data/input/depot/excel/cache/SYNTHESE_DMI_20_237789_b7c9fcd90987f45e4002171a5d87dfdd/synthèse-DMI-2025.xls_41d136f5d26b76a99c371a1af7fc9e64], ErrorIfExists, [N%C2%B0, IPP, N%C2%B0+s%C3%A9jour, initiales, date+pose, code+LPP, libell%C3%A9+LPP, quantit%C3%A9, prix+d%27achat+unitaire+%28%E2%82%AC+ttc%29, tarif+responsabilit%C3%A9+LPP+%28%E2%82%AC+ttc%29, d%C3%A9penses+d%C3%A9clar%C3%A9es+%28%E2%82%AC+ttc%29, d%C3%A9penses+au+tarif+LPP, majoration+%28%E2%82%AC+ttc%29, d%C3%A9penses+accord%C3%A9es+%28%E2%82%AC+ttc%29, _c14, _c15, Fournisseur%2C+Libell%C3%A9+DMI, commentaire, _c18, _c19, _c20, SYNTHESE_DMI_20_237789HEADER_COL_DETAIL_DEPOT]