digraph G {
0 [labelType="html" label="<b>Execute InsertIntoHadoopFsRelationCommand</b><br><br>task commit time: 1 ms<br>number of written files: 1<br>job commit time: 10 ms<br>number of output rows: 295<br>number of dynamic part: 0<br>written output: 16.7 KiB"];
1 [labelType="html" label="<br><b>WriteFiles</b><br><br>"];
subgraph cluster2 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 242 ms";
3 [labelType="html" label="<br><b>Project</b><br><br>"];
}
4 [labelType="html" label="<b>BatchScan excel file:/data/input/depot/excel/tmp/SYNTHESE_MO_202_237812/synth\u00E8se-MO-2025.xlsx</b><br><br>number of output rows: 295"];
1->0;
3->1;
4->3;
}
5
Execute InsertIntoHadoopFsRelationCommand file:/data/input/depot/excel/cache/SYNTHESE_MO_202_237812_bd57d77466024fccdf18ace5a6e64d03/synthèse-MO-2025.xlsx_6fa2b969a426becf7b2379293a107a75, false, Parquet, [path=file:///data/input/depot/excel/cache/SYNTHESE_MO_202_237812_bd57d77466024fccdf18ace5a6e64d03/synthèse-MO-2025.xlsx_6fa2b969a426becf7b2379293a107a75], ErrorIfExists, [num%C3%A9ro+suivi+DIM, date+envoi+DIM, IPP, N%C2%B0+SEJOUR, Type+de+prestation, UCD, produit, quantit%C3%A9s, prix+d%27achat%0Aunitaire+%28%E2%82%AC+ttc%29, tarif+de+responsabilit%C3%A9+%28%E2%82%AC+ttc%29, montant+d%C3%A9clar%C3%A9%0Atotal+%28%E2%82%AC+ttc%29, majoration+%28%E2%82%AC+ttc%29, montant+total+accord%C3%A9+%28%E2%82%AC+ttc%29, SERVICE, INDICATION, ADMIN., SYNTHESE_MO_202_237812HEADER_COL_DETAIL_DEPOT]
WriteFiles
Project [numéro suivi DIM#1692860 AS num%C3%A9ro+suivi+DIM#1692926, date envoi DIM#1692861 AS date+envoi+DIM#1692944, IPP#1692862, N° SEJOUR#1692863 AS N%C2%B0+SEJOUR#1692980, Type de prestation#1692864 AS Type+de+prestation#1692998, UCD#1692865, produit#1692866, quantités#1692867 AS quantit%C3%A9s#1693052, prix d'achat
unitaire (€ ttc)#1692868 AS prix+d%27achat%0Aunitaire+%28%E2%82%AC+ttc%29#1693070, tarif de responsabilité (€ ttc)#1692869 AS tarif+de+responsabilit%C3%A9+%28%E2%82%AC+ttc%29#1693088, montant déclaré
total (€ ttc)#1692870 AS montant+d%C3%A9clar%C3%A9%0Atotal+%28%E2%82%AC+ttc%29#1693106, majoration (€ ttc)#1692871 AS majoration+%28%E2%82%AC+ttc%29#1693124, montant total accordé (€ ttc)#1692872 AS montant+total+accord%C3%A9+%28%E2%82%AC+ttc%29#1693142, SERVICE#1692873, INDICATION#1692874, ADMIN.#1692875, file:/data/input/depot/excel/tmp/SYNTHESE_MO_202_237812/synthèse-MO-2025.xlsx AS SYNTHESE_MO_202_237812HEADER_COL_DETAIL_DEPOT#1693214]
WholeStageCodegen (1)
BatchScan excel file:/data/input/depot/excel/tmp/SYNTHESE_MO_202_237812/synthèse-MO-2025.xlsx[numéro suivi DIM#1692860, date envoi DIM#1692861, IPP#1692862, N° SEJOUR#1692863, Type de prestation#1692864, UCD#1692865, produit#1692866, quantités#1692867, prix d'achat
unitaire (€ ttc)#1692868, tarif de responsabilité (€ ttc)#1692869, montant déclaré
total (€ ttc)#1692870, majoration (€ ttc)#1692871, montant total accordé (€ ttc)#1692872, SERVICE#1692873, INDICATION#1692874, ADMIN.#1692875] ExcelScan DataFilters: [], Format: excel, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/tmp/SYNTHESE_MO_202_237812/synthèse-MO-20..., PartitionFilters: [], ReadSchema: struct<numéro suivi DIM:string,date envoi DIM:string,IPP:string,N° SEJOUR:string,Type de prestati..., PushedFilters: [] RuntimeFilters: []
== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand (4)
+- WriteFiles (3)
+- * Project (2)
+- BatchScan excel file:/data/input/depot/excel/tmp/SYNTHESE_MO_202_237812/synthèse-MO-2025.xlsx (1)
(1) BatchScan excel file:/data/input/depot/excel/tmp/SYNTHESE_MO_202_237812/synthèse-MO-2025.xlsx
Output [16]: [numéro suivi DIM#1692860, date envoi DIM#1692861, IPP#1692862, N° SEJOUR#1692863, Type de prestation#1692864, UCD#1692865, produit#1692866, quantités#1692867, prix d'achat
unitaire (€ ttc)#1692868, tarif de responsabilité (€ ttc)#1692869, montant déclaré
total (€ ttc)#1692870, majoration (€ ttc)#1692871, montant total accordé (€ ttc)#1692872, SERVICE#1692873, INDICATION#1692874, ADMIN.#1692875]
Format: excel
Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/tmp/SYNTHESE_MO_202_237812/synthèse-MO-2025.xlsx]
ReadSchema: struct<numéro suivi DIM:string,date envoi DIM:string,IPP:string,N° SEJOUR:string,Type de prestation:string,UCD:string,produit:string,quantités:string,prix d'achat
unitaire (€ ttc):string,tarif de responsabilité (€ ttc):string,montant déclaré
total (€ ttc):string,majoration (€ ttc):string,montant total accordé (€ ttc):string,SERVICE:string,INDICATION:string,ADMIN.:string>
(2) Project [codegen id : 1]
Output [17]: [numéro suivi DIM#1692860 AS num%C3%A9ro+suivi+DIM#1692926, date envoi DIM#1692861 AS date+envoi+DIM#1692944, IPP#1692862, N° SEJOUR#1692863 AS N%C2%B0+SEJOUR#1692980, Type de prestation#1692864 AS Type+de+prestation#1692998, UCD#1692865, produit#1692866, quantités#1692867 AS quantit%C3%A9s#1693052, prix d'achat
unitaire (€ ttc)#1692868 AS prix+d%27achat%0Aunitaire+%28%E2%82%AC+ttc%29#1693070, tarif de responsabilité (€ ttc)#1692869 AS tarif+de+responsabilit%C3%A9+%28%E2%82%AC+ttc%29#1693088, montant déclaré
total (€ ttc)#1692870 AS montant+d%C3%A9clar%C3%A9%0Atotal+%28%E2%82%AC+ttc%29#1693106, majoration (€ ttc)#1692871 AS majoration+%28%E2%82%AC+ttc%29#1693124, montant total accordé (€ ttc)#1692872 AS montant+total+accord%C3%A9+%28%E2%82%AC+ttc%29#1693142, SERVICE#1692873, INDICATION#1692874, ADMIN.#1692875, file:/data/input/depot/excel/tmp/SYNTHESE_MO_202_237812/synthèse-MO-2025.xlsx AS SYNTHESE_MO_202_237812HEADER_COL_DETAIL_DEPOT#1693214]
Input [16]: [numéro suivi DIM#1692860, date envoi DIM#1692861, IPP#1692862, N° SEJOUR#1692863, Type de prestation#1692864, UCD#1692865, produit#1692866, quantités#1692867, prix d'achat
unitaire (€ ttc)#1692868, tarif de responsabilité (€ ttc)#1692869, montant déclaré
total (€ ttc)#1692870, majoration (€ ttc)#1692871, montant total accordé (€ ttc)#1692872, SERVICE#1692873, INDICATION#1692874, ADMIN.#1692875]
(3) WriteFiles
Input [17]: [num%C3%A9ro+suivi+DIM#1692926, date+envoi+DIM#1692944, IPP#1692862, N%C2%B0+SEJOUR#1692980, Type+de+prestation#1692998, UCD#1692865, produit#1692866, quantit%C3%A9s#1693052, prix+d%27achat%0Aunitaire+%28%E2%82%AC+ttc%29#1693070, tarif+de+responsabilit%C3%A9+%28%E2%82%AC+ttc%29#1693088, montant+d%C3%A9clar%C3%A9%0Atotal+%28%E2%82%AC+ttc%29#1693106, majoration+%28%E2%82%AC+ttc%29#1693124, montant+total+accord%C3%A9+%28%E2%82%AC+ttc%29#1693142, SERVICE#1692873, INDICATION#1692874, ADMIN.#1692875, SYNTHESE_MO_202_237812HEADER_COL_DETAIL_DEPOT#1693214]
(4) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/input/depot/excel/cache/SYNTHESE_MO_202_237812_bd57d77466024fccdf18ace5a6e64d03/synthèse-MO-2025.xlsx_6fa2b969a426becf7b2379293a107a75, false, Parquet, [path=file:///data/input/depot/excel/cache/SYNTHESE_MO_202_237812_bd57d77466024fccdf18ace5a6e64d03/synthèse-MO-2025.xlsx_6fa2b969a426becf7b2379293a107a75], ErrorIfExists, [num%C3%A9ro+suivi+DIM, date+envoi+DIM, IPP, N%C2%B0+SEJOUR, Type+de+prestation, UCD, produit, quantit%C3%A9s, prix+d%27achat%0Aunitaire+%28%E2%82%AC+ttc%29, tarif+de+responsabilit%C3%A9+%28%E2%82%AC+ttc%29, montant+d%C3%A9clar%C3%A9%0Atotal+%28%E2%82%AC+ttc%29, majoration+%28%E2%82%AC+ttc%29, montant+total+accord%C3%A9+%28%E2%82%AC+ttc%29, SERVICE, INDICATION, ADMIN., SYNTHESE_MO_202_237812HEADER_COL_DETAIL_DEPOT]