hdh-spark-job - Details for Query 1197

Submitted Time: 2026/10/23 13:05:05
Duration: 0.4 s
Succeeded Jobs: 1198 1199

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: 6 ms number of output rows: 1 number of dynamic part: 0 written output: 3.8 KiB"]; 2 [labelType="html" label=" WriteFiles "]; 3 [labelType="html" label="Exchange shuffle records written: 1 local merged chunks fetched: 0 shuffle write time: 0 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: 1 local bytes read: 1337.0 B 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: 2.9 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: 1337.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 216 ms"; 5 [labelType="html" label="Scan ExistingRDD number of output rows: 1"]; } 1->0; 2->1; 3->2; 5->3; }

AdaptiveSparkPlan isFinalPlan=true

Execute InsertIntoHadoopFsRelationCommand file:/data/output/export/parquet/a73b8620-b1a5-44fd-a8bc-f3c1324c2d67, false, Parquet, [path=file:///data/output/export/parquet/a73b8620-b1a5-44fd-a8bc-f3c1324c2d67], ErrorIfExists, [code_insee, departement_code, departement_nom, epci_code, epci_nom, nom, region_code, region_nom, Les-Indices]

WriteFiles

Exchange SinglePartition, REPARTITION_BY_NUM, [plan_id=28985]

Scan ExistingRDD[code_insee#474636,departement_code#474637,departement_nom#474638,epci_code#474639,epci_nom#474640,nom#474641,region_code#474642,region_nom#474643,Les-Indices#474644]

WholeStageCodegen (1)

Details

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


(1) Scan ExistingRDD [codegen id : 1]
Output [9]: [code_insee#474636, departement_code#474637, departement_nom#474638, epci_code#474639, epci_nom#474640, nom#474641, region_code#474642, region_nom#474643, Les-Indices#474644]
Arguments: [code_insee#474636, departement_code#474637, departement_nom#474638, epci_code#474639, epci_nom#474640, nom#474641, region_code#474642, region_nom#474643, Les-Indices#474644], MapPartitionsRDD[4977] at createDataFrame at AbsExportExecutor.java:55, ExistingRDD, UnknownPartitioning(0)

(2) Exchange
Input [9]: [code_insee#474636, departement_code#474637, departement_nom#474638, epci_code#474639, epci_nom#474640, nom#474641, region_code#474642, region_nom#474643, Les-Indices#474644]
Arguments: SinglePartition, REPARTITION_BY_NUM, [plan_id=28985]

(3) ShuffleQueryStage
Output [9]: [code_insee#474636, departement_code#474637, departement_nom#474638, epci_code#474639, epci_nom#474640, nom#474641, region_code#474642, region_nom#474643, Les-Indices#474644]
Arguments: 0

(4) WriteFiles
Input [9]: [code_insee#474636, departement_code#474637, departement_nom#474638, epci_code#474639, epci_nom#474640, nom#474641, region_code#474642, region_nom#474643, Les-Indices#474644]

(5) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/export/parquet/a73b8620-b1a5-44fd-a8bc-f3c1324c2d67, false, Parquet, [path=file:///data/output/export/parquet/a73b8620-b1a5-44fd-a8bc-f3c1324c2d67], ErrorIfExists, [code_insee, departement_code, departement_nom, epci_code, epci_nom, nom, region_code, region_nom, Les-Indices]

(6) Exchange
Input [9]: [code_insee#474636, departement_code#474637, departement_nom#474638, epci_code#474639, epci_nom#474640, nom#474641, region_code#474642, region_nom#474643, Les-Indices#474644]
Arguments: SinglePartition, REPARTITION_BY_NUM, [plan_id=28978]

(7) WriteFiles
Input [9]: [code_insee#474636, departement_code#474637, departement_nom#474638, epci_code#474639, epci_nom#474640, nom#474641, region_code#474642, region_nom#474643, Les-Indices#474644]

(8) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/export/parquet/a73b8620-b1a5-44fd-a8bc-f3c1324c2d67, false, Parquet, [path=file:///data/output/export/parquet/a73b8620-b1a5-44fd-a8bc-f3c1324c2d67], ErrorIfExists, [code_insee, departement_code, departement_nom, epci_code, epci_nom, nom, region_code, region_nom, Les-Indices]

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

SQL / DataFrame Properties

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