SP1 - Details for Query 5292

Submitted Time: 2026/05/22 14:24:47
Duration: 2 s
Succeeded Jobs: 8293

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

digraph G { 0 [labelType="html" label="Execute InsertIntoHadoopFsRelationCommand task commit time total (min, med, max (stageId: taskId)) 3 ms (0 ms, 0 ms, 1 ms (stage 17016.0: task 23855)) number of written files: 10 job commit time: 10 ms number of output rows: 1,115,956 number of dynamic part: 0 written output: 14.1 MiB"]; 1 [labelType="html" label=" WriteFiles "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n13.7 s (6 ms, 1.4 s, 1.5 s (stage 17016.0: task 23861))"; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="ColumnarToRow number of output rows: 1,115,956 number of input batches: 277"]; } 5 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 349 ms (2 ms, 24 ms, 106 ms (stage 17016.0: task 23858)) metadata time: 0 ms size of files read: 86.2 MiB number of output rows: 1,115,956"]; 1->0; 3->1; 4->3; 5->4; }

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/14_A_ACTES_PATI_188142, false, Parquet, [path=file:///data/output/cache/parquet/datablock/14_A_ACTES_PATI_188142], Overwrite, [COL_094C0B3B_F823_47CF_A413_74D35F42EAE1, COL_CBEF3811_E4EF_4F9E_9EEE_82122077EC0F, COL_61D24032_1CF3_40CF_8813_66987B8FDCCE, COL_EC278560_7685_48E3_B44D_576F13F4A1D0, COL_E6BBE22F_4A1C_4467_891A_4C22C62E13C2, COL_AC135CAA_4B4F_4D5B_8F77_7DB39EF3BCE9, COL_3D4E5102_259C_4D72_862B_220B99C522C4, COL_AA8A7400_EB18_4287_AFFA_0B84FFCD3794, COL_E9659879_6635_4404_99A1_5AF775898BEB, COL_AEC78515_2EEF_495C_AB9E_8EFB42FD3D1D, COL_6823F929_C987_422D_88A4_CD582DF84F63, COL_C74A4ECF_F14B_476C_A67D_B6041ED8D3A9, COL_1E7A663F_0C49_4DD3_957E_3413C84B2C41, COL_02B6DADD_D184_43F9_AFD4_C4D49AA841DC, COL_94135F59_2AF7_4A70_ABB8_623F5F4BE6D2]

WriteFiles

Project [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1323562 AS COL_094C0B3B_F823_47CF_A413_74D35F42EAE1#1324258, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1323580 AS COL_CBEF3811_E4EF_4F9E_9EEE_82122077EC0F#1324259, COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#1323566 AS COL_61D24032_1CF3_40CF_8813_66987B8FDCCE#1324260, COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#1323565 AS COL_EC278560_7685_48E3_B44D_576F13F4A1D0#1324261, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#1323563 AS COL_E6BBE22F_4A1C_4467_891A_4C22C62E13C2#1324262, COL_C3324533_C0BB_4B8B_8370_DC4EE8F6BBC6#1323570 AS COL_AC135CAA_4B4F_4D5B_8F77_7DB39EF3BCE9#1324263, int_to_str(COL_D5EDAAE4_BF90_4134_AF8E_1039395D3356#1323568) AS COL_3D4E5102_259C_4D72_862B_220B99C522C4#1324264, COL_F94DAC07_127C_4495_A440_68EF585E7F25#1323571 AS COL_AA8A7400_EB18_4287_AFFA_0B84FFCD3794#1324265, COL_8C23F27C_A334_46F9_AD8F_4D2F98435644#1323573 AS COL_E9659879_6635_4404_99A1_5AF775898BEB#1324266, COL_5FE684A3_C173_4F6B_AD83_F16ADC313E77#1323572 AS COL_AEC78515_2EEF_495C_AB9E_8EFB42FD3D1D#1324267, COL_6CC6F978_0EE3_437E_8A71_6E7AB294A83A#1323579 AS COL_6823F929_C987_422D_88A4_CD582DF84F63#1324268, COL_A764821B_78E0_4C3B_A968_0BB28AD10628#1323578 AS COL_C74A4ECF_F14B_476C_A67D_B6041ED8D3A9#1324269, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1323599 AS COL_1E7A663F_0C49_4DD3_957E_3413C84B2C41#1324270, COL_98D04973_B000_492C_89FF_7BC686DEC49F#1323594 AS COL_02B6DADD_D184_43F9_AFD4_C4D49AA841DC#1324271, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1323581 AS COL_94135F59_2AF7_4A70_ABB8_623F5F4BE6D2#1324272]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1323562,COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#1323563,COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#1323565,COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#1323566,COL_D5EDAAE4_BF90_4134_AF8E_1039395D3356#1323568,COL_C3324533_C0BB_4B8B_8370_DC4EE8F6BBC6#1323570,COL_F94DAC07_127C_4495_A440_68EF585E7F25#1323571,COL_5FE684A3_C173_4F6B_AD83_F16ADC313E77#1323572,COL_8C23F27C_A334_46F9_AD8F_4D2F98435644#1323573,COL_A764821B_78E0_4C3B_A968_0BB28AD10628#1323578,COL_6CC6F978_0EE3_437E_8A71_6E7AB294A83A#1323579,COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1323580,COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1323581,COL_98D04973_B000_492C_89FF_7BC686DEC49F#1323594,COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1323599] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_188400], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62:s...

Details

== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand (5)
+- WriteFiles (4)
   +- * Project (3)
      +- * ColumnarToRow (2)
         +- Scan parquet  (1)


(1) Scan parquet 
Output [15]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1323562, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#1323563, COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#1323565, COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#1323566, COL_D5EDAAE4_BF90_4134_AF8E_1039395D3356#1323568, COL_C3324533_C0BB_4B8B_8370_DC4EE8F6BBC6#1323570, COL_F94DAC07_127C_4495_A440_68EF585E7F25#1323571, COL_5FE684A3_C173_4F6B_AD83_F16ADC313E77#1323572, COL_8C23F27C_A334_46F9_AD8F_4D2F98435644#1323573, COL_A764821B_78E0_4C3B_A968_0BB28AD10628#1323578, COL_6CC6F978_0EE3_437E_8A71_6E7AB294A83A#1323579, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1323580, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1323581, COL_98D04973_B000_492C_89FF_7BC686DEC49F#1323594, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1323599]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_188400]
ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62:string,COL_BE0A06CA_C165_46C5_AC16_64541F42FB67:string,COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1:string,COL_D5EDAAE4_BF90_4134_AF8E_1039395D3356:int,COL_C3324533_C0BB_4B8B_8370_DC4EE8F6BBC6:string,COL_F94DAC07_127C_4495_A440_68EF585E7F25:string,COL_5FE684A3_C173_4F6B_AD83_F16ADC313E77:string,COL_8C23F27C_A334_46F9_AD8F_4D2F98435644:string,COL_A764821B_78E0_4C3B_A968_0BB28AD10628:string,COL_6CC6F978_0EE3_437E_8A71_6E7AB294A83A:string,COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C:string,COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE:string,COL_98D04973_B000_492C_89FF_7BC686DEC49F:string,COL_60F0AF6F_D3F7_485E_B349_92A30BE52743:string>

(2) ColumnarToRow [codegen id : 1]
Input [15]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1323562, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#1323563, COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#1323565, COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#1323566, COL_D5EDAAE4_BF90_4134_AF8E_1039395D3356#1323568, COL_C3324533_C0BB_4B8B_8370_DC4EE8F6BBC6#1323570, COL_F94DAC07_127C_4495_A440_68EF585E7F25#1323571, COL_5FE684A3_C173_4F6B_AD83_F16ADC313E77#1323572, COL_8C23F27C_A334_46F9_AD8F_4D2F98435644#1323573, COL_A764821B_78E0_4C3B_A968_0BB28AD10628#1323578, COL_6CC6F978_0EE3_437E_8A71_6E7AB294A83A#1323579, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1323580, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1323581, COL_98D04973_B000_492C_89FF_7BC686DEC49F#1323594, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1323599]

(3) Project [codegen id : 1]
Output [15]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1323562 AS COL_094C0B3B_F823_47CF_A413_74D35F42EAE1#1324258, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1323580 AS COL_CBEF3811_E4EF_4F9E_9EEE_82122077EC0F#1324259, COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#1323566 AS COL_61D24032_1CF3_40CF_8813_66987B8FDCCE#1324260, COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#1323565 AS COL_EC278560_7685_48E3_B44D_576F13F4A1D0#1324261, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#1323563 AS COL_E6BBE22F_4A1C_4467_891A_4C22C62E13C2#1324262, COL_C3324533_C0BB_4B8B_8370_DC4EE8F6BBC6#1323570 AS COL_AC135CAA_4B4F_4D5B_8F77_7DB39EF3BCE9#1324263, int_to_str(COL_D5EDAAE4_BF90_4134_AF8E_1039395D3356#1323568) AS COL_3D4E5102_259C_4D72_862B_220B99C522C4#1324264, COL_F94DAC07_127C_4495_A440_68EF585E7F25#1323571 AS COL_AA8A7400_EB18_4287_AFFA_0B84FFCD3794#1324265, COL_8C23F27C_A334_46F9_AD8F_4D2F98435644#1323573 AS COL_E9659879_6635_4404_99A1_5AF775898BEB#1324266, COL_5FE684A3_C173_4F6B_AD83_F16ADC313E77#1323572 AS COL_AEC78515_2EEF_495C_AB9E_8EFB42FD3D1D#1324267, COL_6CC6F978_0EE3_437E_8A71_6E7AB294A83A#1323579 AS COL_6823F929_C987_422D_88A4_CD582DF84F63#1324268, COL_A764821B_78E0_4C3B_A968_0BB28AD10628#1323578 AS COL_C74A4ECF_F14B_476C_A67D_B6041ED8D3A9#1324269, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1323599 AS COL_1E7A663F_0C49_4DD3_957E_3413C84B2C41#1324270, COL_98D04973_B000_492C_89FF_7BC686DEC49F#1323594 AS COL_02B6DADD_D184_43F9_AFD4_C4D49AA841DC#1324271, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1323581 AS COL_94135F59_2AF7_4A70_ABB8_623F5F4BE6D2#1324272]
Input [15]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1323562, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#1323563, COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#1323565, COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#1323566, COL_D5EDAAE4_BF90_4134_AF8E_1039395D3356#1323568, COL_C3324533_C0BB_4B8B_8370_DC4EE8F6BBC6#1323570, COL_F94DAC07_127C_4495_A440_68EF585E7F25#1323571, COL_5FE684A3_C173_4F6B_AD83_F16ADC313E77#1323572, COL_8C23F27C_A334_46F9_AD8F_4D2F98435644#1323573, COL_A764821B_78E0_4C3B_A968_0BB28AD10628#1323578, COL_6CC6F978_0EE3_437E_8A71_6E7AB294A83A#1323579, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#1323580, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#1323581, COL_98D04973_B000_492C_89FF_7BC686DEC49F#1323594, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1323599]

(4) WriteFiles
Input [15]: [COL_094C0B3B_F823_47CF_A413_74D35F42EAE1#1324258, COL_CBEF3811_E4EF_4F9E_9EEE_82122077EC0F#1324259, COL_61D24032_1CF3_40CF_8813_66987B8FDCCE#1324260, COL_EC278560_7685_48E3_B44D_576F13F4A1D0#1324261, COL_E6BBE22F_4A1C_4467_891A_4C22C62E13C2#1324262, COL_AC135CAA_4B4F_4D5B_8F77_7DB39EF3BCE9#1324263, COL_3D4E5102_259C_4D72_862B_220B99C522C4#1324264, COL_AA8A7400_EB18_4287_AFFA_0B84FFCD3794#1324265, COL_E9659879_6635_4404_99A1_5AF775898BEB#1324266, COL_AEC78515_2EEF_495C_AB9E_8EFB42FD3D1D#1324267, COL_6823F929_C987_422D_88A4_CD582DF84F63#1324268, COL_C74A4ECF_F14B_476C_A67D_B6041ED8D3A9#1324269, COL_1E7A663F_0C49_4DD3_957E_3413C84B2C41#1324270, COL_02B6DADD_D184_43F9_AFD4_C4D49AA841DC#1324271, COL_94135F59_2AF7_4A70_ABB8_623F5F4BE6D2#1324272]

(5) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/14_A_ACTES_PATI_188142, false, Parquet, [path=file:///data/output/cache/parquet/datablock/14_A_ACTES_PATI_188142], Overwrite, [COL_094C0B3B_F823_47CF_A413_74D35F42EAE1, COL_CBEF3811_E4EF_4F9E_9EEE_82122077EC0F, COL_61D24032_1CF3_40CF_8813_66987B8FDCCE, COL_EC278560_7685_48E3_B44D_576F13F4A1D0, COL_E6BBE22F_4A1C_4467_891A_4C22C62E13C2, COL_AC135CAA_4B4F_4D5B_8F77_7DB39EF3BCE9, COL_3D4E5102_259C_4D72_862B_220B99C522C4, COL_AA8A7400_EB18_4287_AFFA_0B84FFCD3794, COL_E9659879_6635_4404_99A1_5AF775898BEB, COL_AEC78515_2EEF_495C_AB9E_8EFB42FD3D1D, COL_6823F929_C987_422D_88A4_CD582DF84F63, COL_C74A4ECF_F14B_476C_A67D_B6041ED8D3A9, COL_1E7A663F_0C49_4DD3_957E_3413C84B2C41, COL_02B6DADD_D184_43F9_AFD4_C4D49AA841DC, COL_94135F59_2AF7_4A70_ABB8_623F5F4BE6D2]

SQL / DataFrame Properties

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