SP1 - Details for Query 347

Submitted Time: 2026/02/20 13:58:38
Duration: 0.8 s
Succeeded Jobs: 482 483

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label="Execute InsertIntoHadoopFsRelationCommand task commit time: 1 ms number of written files: 1 job commit time: 9 ms number of output rows: 5,068 number of dynamic part: 0 written output: 177.9 KiB"]; 2 [labelType="html" label=" WriteFiles "]; 3 [labelType="html" label="Exchange shuffle records written: 5,068 local merged chunks fetched: 0 shuffle write time: 2 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 5,068 local bytes read: 466.5 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 2028.6 KiB local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 466.5 KiB"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 266 ms"; 5 [labelType="html" label="Scan ExistingRDD number of output rows: 5,068"]; } 1->0; 2->1; 3->2; 5->3; }

AdaptiveSparkPlan isFinalPlan=true

Execute InsertIntoHadoopFsRelationCommand file:/data/output/export/parquet/e0c0d51d-9f21-4da1-ade6-0146295e65a4, false, Parquet, [path=file:///data/output/export/parquet/e0c0d51d-9f21-4da1-ade6-0146295e65a4], ErrorIfExists, [Produit_ID, Quantite, Code_promo, Prix_unitaire_facture, Montant_facture, Client_ID, Date, Annee_mois, Transaction_ID, Region-[Norm], Currency-[Norm], Date-[Norm], Campagne_ID, Jour-Semaine, Freebe, Premium, Categorie_Products_ref, Type_Products_ref, Prix_unitaire, Prix_revient, Client_premium, Client_region, GBP, USD, ... 9 more fields]

WriteFiles

Exchange SinglePartition, REPARTITION_BY_NUM, [plan_id=10324]

Scan ExistingRDD[Produit_ID#122517,Quantite#122518,Code_promo#122519,Prix_unitaire_facture#122520,Montant_facture#122521,Client_ID#122522,Date#122523,Annee_mois#122524,Transaction_ID#122525,Region-[Norm]#122526,Currency-[Norm]#122527,Date-[Norm]#122528,Campagne_ID#122529,Jour-Semaine#122530,Freebe#122531,Premium#122532,Categorie_Products_ref#122533,Type_Products_ref#122534,Prix_unitaire#122535,Prix_revient#122536,Client_premium#122537,Client_region#122538,GBP#122539,USD#122540,... 9 more fields]

WholeStageCodegen (1)

Details

== Physical Plan ==
AdaptiveSparkPlan (9)
+- == Final Plan ==
   Execute InsertIntoHadoopFsRelationCommand (5)
   +- WriteFiles (4)
      +- ShuffleQueryStage (3), Statistics(sizeInBytes=2028.6 KiB, rowCount=5.07E+3)
         +- Exchange (2)
            +- * Scan ExistingRDD (1)
+- == Initial Plan ==
   Execute InsertIntoHadoopFsRelationCommand (8)
   +- WriteFiles (7)
      +- Exchange (6)
         +- Scan ExistingRDD (1)


(1) Scan ExistingRDD [codegen id : 1]
Output [33]: [Produit_ID#122517, Quantite#122518, Code_promo#122519, Prix_unitaire_facture#122520, Montant_facture#122521, Client_ID#122522, Date#122523, Annee_mois#122524, Transaction_ID#122525, Region-[Norm]#122526, Currency-[Norm]#122527, Date-[Norm]#122528, Campagne_ID#122529, Jour-Semaine#122530, Freebe#122531, Premium#122532, Categorie_Products_ref#122533, Type_Products_ref#122534, Prix_unitaire#122535, Prix_revient#122536, Client_premium#122537, Client_region#122538, GBP#122539, USD#122540, JPY#122541, PrixUnitaireFacture-Euros#122542, MontantFacture-Euros#122543, Ecart-PrixUnitaireReference#122544, Ecart-PrixRevientReference#122545, Ecart-PrixFactureReferent#122546, Ecart-PrixFacturerevientReference#122547, Marge-Therorique#122548, Marge-Reelle#122549]
Arguments: [Produit_ID#122517, Quantite#122518, Code_promo#122519, Prix_unitaire_facture#122520, Montant_facture#122521, Client_ID#122522, Date#122523, Annee_mois#122524, Transaction_ID#122525, Region-[Norm]#122526, Currency-[Norm]#122527, Date-[Norm]#122528, Campagne_ID#122529, Jour-Semaine#122530, Freebe#122531, Premium#122532, Categorie_Products_ref#122533, Type_Products_ref#122534, Prix_unitaire#122535, Prix_revient#122536, Client_premium#122537, Client_region#122538, GBP#122539, USD#122540, ... 9 more fields], MapPartitionsRDD[1577] at createDataFrame at AbsExportExecutor.java:55, ExistingRDD, UnknownPartitioning(0)

(2) Exchange
Input [33]: [Produit_ID#122517, Quantite#122518, Code_promo#122519, Prix_unitaire_facture#122520, Montant_facture#122521, Client_ID#122522, Date#122523, Annee_mois#122524, Transaction_ID#122525, Region-[Norm]#122526, Currency-[Norm]#122527, Date-[Norm]#122528, Campagne_ID#122529, Jour-Semaine#122530, Freebe#122531, Premium#122532, Categorie_Products_ref#122533, Type_Products_ref#122534, Prix_unitaire#122535, Prix_revient#122536, Client_premium#122537, Client_region#122538, GBP#122539, USD#122540, JPY#122541, PrixUnitaireFacture-Euros#122542, MontantFacture-Euros#122543, Ecart-PrixUnitaireReference#122544, Ecart-PrixRevientReference#122545, Ecart-PrixFactureReferent#122546, Ecart-PrixFacturerevientReference#122547, Marge-Therorique#122548, Marge-Reelle#122549]
Arguments: SinglePartition, REPARTITION_BY_NUM, [plan_id=10324]

(3) ShuffleQueryStage
Output [33]: [Produit_ID#122517, Quantite#122518, Code_promo#122519, Prix_unitaire_facture#122520, Montant_facture#122521, Client_ID#122522, Date#122523, Annee_mois#122524, Transaction_ID#122525, Region-[Norm]#122526, Currency-[Norm]#122527, Date-[Norm]#122528, Campagne_ID#122529, Jour-Semaine#122530, Freebe#122531, Premium#122532, Categorie_Products_ref#122533, Type_Products_ref#122534, Prix_unitaire#122535, Prix_revient#122536, Client_premium#122537, Client_region#122538, GBP#122539, USD#122540, JPY#122541, PrixUnitaireFacture-Euros#122542, MontantFacture-Euros#122543, Ecart-PrixUnitaireReference#122544, Ecart-PrixRevientReference#122545, Ecart-PrixFactureReferent#122546, Ecart-PrixFacturerevientReference#122547, Marge-Therorique#122548, Marge-Reelle#122549]
Arguments: 0

(4) WriteFiles
Input [33]: [Produit_ID#122517, Quantite#122518, Code_promo#122519, Prix_unitaire_facture#122520, Montant_facture#122521, Client_ID#122522, Date#122523, Annee_mois#122524, Transaction_ID#122525, Region-[Norm]#122526, Currency-[Norm]#122527, Date-[Norm]#122528, Campagne_ID#122529, Jour-Semaine#122530, Freebe#122531, Premium#122532, Categorie_Products_ref#122533, Type_Products_ref#122534, Prix_unitaire#122535, Prix_revient#122536, Client_premium#122537, Client_region#122538, GBP#122539, USD#122540, JPY#122541, PrixUnitaireFacture-Euros#122542, MontantFacture-Euros#122543, Ecart-PrixUnitaireReference#122544, Ecart-PrixRevientReference#122545, Ecart-PrixFactureReferent#122546, Ecart-PrixFacturerevientReference#122547, Marge-Therorique#122548, Marge-Reelle#122549]

(5) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/export/parquet/e0c0d51d-9f21-4da1-ade6-0146295e65a4, false, Parquet, [path=file:///data/output/export/parquet/e0c0d51d-9f21-4da1-ade6-0146295e65a4], ErrorIfExists, [Produit_ID, Quantite, Code_promo, Prix_unitaire_facture, Montant_facture, Client_ID, Date, Annee_mois, Transaction_ID, Region-[Norm], Currency-[Norm], Date-[Norm], Campagne_ID, Jour-Semaine, Freebe, Premium, Categorie_Products_ref, Type_Products_ref, Prix_unitaire, Prix_revient, Client_premium, Client_region, GBP, USD, ... 9 more fields]

(6) Exchange
Input [33]: [Produit_ID#122517, Quantite#122518, Code_promo#122519, Prix_unitaire_facture#122520, Montant_facture#122521, Client_ID#122522, Date#122523, Annee_mois#122524, Transaction_ID#122525, Region-[Norm]#122526, Currency-[Norm]#122527, Date-[Norm]#122528, Campagne_ID#122529, Jour-Semaine#122530, Freebe#122531, Premium#122532, Categorie_Products_ref#122533, Type_Products_ref#122534, Prix_unitaire#122535, Prix_revient#122536, Client_premium#122537, Client_region#122538, GBP#122539, USD#122540, JPY#122541, PrixUnitaireFacture-Euros#122542, MontantFacture-Euros#122543, Ecart-PrixUnitaireReference#122544, Ecart-PrixRevientReference#122545, Ecart-PrixFactureReferent#122546, Ecart-PrixFacturerevientReference#122547, Marge-Therorique#122548, Marge-Reelle#122549]
Arguments: SinglePartition, REPARTITION_BY_NUM, [plan_id=10317]

(7) WriteFiles
Input [33]: [Produit_ID#122517, Quantite#122518, Code_promo#122519, Prix_unitaire_facture#122520, Montant_facture#122521, Client_ID#122522, Date#122523, Annee_mois#122524, Transaction_ID#122525, Region-[Norm]#122526, Currency-[Norm]#122527, Date-[Norm]#122528, Campagne_ID#122529, Jour-Semaine#122530, Freebe#122531, Premium#122532, Categorie_Products_ref#122533, Type_Products_ref#122534, Prix_unitaire#122535, Prix_revient#122536, Client_premium#122537, Client_region#122538, GBP#122539, USD#122540, JPY#122541, PrixUnitaireFacture-Euros#122542, MontantFacture-Euros#122543, Ecart-PrixUnitaireReference#122544, Ecart-PrixRevientReference#122545, Ecart-PrixFactureReferent#122546, Ecart-PrixFacturerevientReference#122547, Marge-Therorique#122548, Marge-Reelle#122549]

(8) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/export/parquet/e0c0d51d-9f21-4da1-ade6-0146295e65a4, false, Parquet, [path=file:///data/output/export/parquet/e0c0d51d-9f21-4da1-ade6-0146295e65a4], ErrorIfExists, [Produit_ID, Quantite, Code_promo, Prix_unitaire_facture, Montant_facture, Client_ID, Date, Annee_mois, Transaction_ID, Region-[Norm], Currency-[Norm], Date-[Norm], Campagne_ID, Jour-Semaine, Freebe, Premium, Categorie_Products_ref, Type_Products_ref, Prix_unitaire, Prix_revient, Client_premium, Client_region, GBP, USD, ... 9 more fields]

(9) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true

SQL / DataFrame Properties

Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet