SP1 - Details for Query 5654

Submitted Time: 2026/03/27 10:47:15
Duration: 0.1 s
Succeeded Jobs: 8671

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

digraph G { 0 [labelType="html" label=" TakeOrderedAndProject "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n89 ms (2 ms, 6 ms, 40 ms (stage 16559.0: task 22997))"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="Filter number of output rows: 2"]; 4 [labelType="html" label="ColumnarToRow number of output rows: 12,285 number of input batches: 3"]; } 5 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 59 ms (2 ms, 6 ms, 10 ms (stage 16559.0: task 22994)) metadata time: 0 ms size of files read: 1667.8 KiB number of output rows: 12,285"]; 2->0; 3->2; 4->3; 5->4; }

TakeOrderedAndProject(limit=500000, orderBy=[COL_56FCD270_1E4A_4F72_8B88_6B3B9B9D5BD8#1274462 ASC NULLS FIRST], output=[COL_360A143A_5A0F_43B9_AA32_428457B51C24#1274461,COL_56FCD270_1E4A_4F72_8B88_6B3B9B9D5BD8#1274462,COL_DC98DC92_5995_4B10_B357_1128145ABA89#1274463,COL_D5D06726_E0EE_4E72_94DE_29828C1855CE#1274464,COL_4C8A7311_1A7F_4F43_9EBD_F60D666E47CC#1274465,COL_31C17A2A_697C_4BC8_A97F_EE7B13F78835#1274466,COL_A5071495_2B41_4F40_B4D6_CD5BF5F3A621#1274467,COL_D537AE5E_0BBD_4C9F_A902_FA9D079BC1F2#1274468,COL_B2ED2D17_AFDB_4B80_98F4_6430CE1C43F8#1274469,COL_61371918_3FD1_4AF3_ABE2_3845DAF5C0AB#1274470,COL_92CA9333_140D_49BA_8B47_40C4ECBAD8B7#1274471,COL_0612B216_5C94_48F9_945D_17AF11C8131E#1274472,COL_E833C7D8_F587_48B6_9A74_E7A9097FDA42#1274473,COL_27245A36_2FCB_4287_84CD_486C8A70E56C#1274474,COL_C6BC0FB2_F938_451E_9D3C_970B1EC7CE17#1274475])

Project [COL_094C0B3B_F823_47CF_A413_74D35F42EAE1#1274324 AS COL_360A143A_5A0F_43B9_AA32_428457B51C24#1274461, COL_CBEF3811_E4EF_4F9E_9EEE_82122077EC0F#1274325 AS COL_56FCD270_1E4A_4F72_8B88_6B3B9B9D5BD8#1274462, COL_61D24032_1CF3_40CF_8813_66987B8FDCCE#1274326 AS COL_DC98DC92_5995_4B10_B357_1128145ABA89#1274463, COL_EC278560_7685_48E3_B44D_576F13F4A1D0#1274327 AS COL_D5D06726_E0EE_4E72_94DE_29828C1855CE#1274464, COL_E6BBE22F_4A1C_4467_891A_4C22C62E13C2#1274328 AS COL_4C8A7311_1A7F_4F43_9EBD_F60D666E47CC#1274465, COL_AC135CAA_4B4F_4D5B_8F77_7DB39EF3BCE9#1274329 AS COL_31C17A2A_697C_4BC8_A97F_EE7B13F78835#1274466, COL_3D4E5102_259C_4D72_862B_220B99C522C4#1274330 AS COL_A5071495_2B41_4F40_B4D6_CD5BF5F3A621#1274467, COL_AA8A7400_EB18_4287_AFFA_0B84FFCD3794#1274331 AS COL_D537AE5E_0BBD_4C9F_A902_FA9D079BC1F2#1274468, COL_E9659879_6635_4404_99A1_5AF775898BEB#1274332 AS COL_B2ED2D17_AFDB_4B80_98F4_6430CE1C43F8#1274469, COL_AEC78515_2EEF_495C_AB9E_8EFB42FD3D1D#1274333 AS COL_61371918_3FD1_4AF3_ABE2_3845DAF5C0AB#1274470, COL_6823F929_C987_422D_88A4_CD582DF84F63#1274334 AS COL_92CA9333_140D_49BA_8B47_40C4ECBAD8B7#1274471, COL_C74A4ECF_F14B_476C_A67D_B6041ED8D3A9#1274335 AS COL_0612B216_5C94_48F9_945D_17AF11C8131E#1274472, COL_1E7A663F_0C49_4DD3_957E_3413C84B2C41#1274336 AS COL_E833C7D8_F587_48B6_9A74_E7A9097FDA42#1274473, COL_02B6DADD_D184_43F9_AFD4_C4D49AA841DC#1274337 AS COL_27245A36_2FCB_4287_84CD_486C8A70E56C#1274474, COL_94135F59_2AF7_4A70_ABB8_623F5F4BE6D2#1274338 AS COL_C6BC0FB2_F938_451E_9D3C_970B1EC7CE17#1274475]

Filter (COL_094C0B3B_F823_47CF_A413_74D35F42EAE1#1274324 <=> 257194203)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_094C0B3B_F823_47CF_A413_74D35F42EAE1#1274324,COL_CBEF3811_E4EF_4F9E_9EEE_82122077EC0F#1274325,COL_61D24032_1CF3_40CF_8813_66987B8FDCCE#1274326,COL_EC278560_7685_48E3_B44D_576F13F4A1D0#1274327,COL_E6BBE22F_4A1C_4467_891A_4C22C62E13C2#1274328,COL_AC135CAA_4B4F_4D5B_8F77_7DB39EF3BCE9#1274329,COL_3D4E5102_259C_4D72_862B_220B99C522C4#1274330,COL_AA8A7400_EB18_4287_AFFA_0B84FFCD3794#1274331,COL_E9659879_6635_4404_99A1_5AF775898BEB#1274332,COL_AEC78515_2EEF_495C_AB9E_8EFB42FD3D1D#1274333,COL_6823F929_C987_422D_88A4_CD582DF84F63#1274334,COL_C74A4ECF_F14B_476C_A67D_B6041ED8D3A9#1274335,COL_1E7A663F_0C49_4DD3_957E_3413C84B2C41#1274336,COL_02B6DADD_D184_43F9_AFD4_C4D49AA841DC#1274337,COL_94135F59_2AF7_4A70_ABB8_623F5F4BE6D2#1274338] Batched: true, DataFilters: [(COL_094C0B3B_F823_47CF_A413_74D35F42EAE1#1274324 <=> 257194203)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/14_A_ACTES_PATI_203462], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_094C0B3B_F823_47CF_A413_74D35F42EAE1,257194203)], ReadSchema: struct<COL_094C0B3B_F823_47CF_A413_74D35F42EAE1:string,COL_CBEF3811_E4EF_4F9E_9EEE_82122077EC0F:s...

Details

== Physical Plan ==
TakeOrderedAndProject (5)
+- * Project (4)
   +- * Filter (3)
      +- * ColumnarToRow (2)
         +- Scan parquet  (1)


(1) Scan parquet 
Output [15]: [COL_094C0B3B_F823_47CF_A413_74D35F42EAE1#1274324, COL_CBEF3811_E4EF_4F9E_9EEE_82122077EC0F#1274325, COL_61D24032_1CF3_40CF_8813_66987B8FDCCE#1274326, COL_EC278560_7685_48E3_B44D_576F13F4A1D0#1274327, COL_E6BBE22F_4A1C_4467_891A_4C22C62E13C2#1274328, COL_AC135CAA_4B4F_4D5B_8F77_7DB39EF3BCE9#1274329, COL_3D4E5102_259C_4D72_862B_220B99C522C4#1274330, COL_AA8A7400_EB18_4287_AFFA_0B84FFCD3794#1274331, COL_E9659879_6635_4404_99A1_5AF775898BEB#1274332, COL_AEC78515_2EEF_495C_AB9E_8EFB42FD3D1D#1274333, COL_6823F929_C987_422D_88A4_CD582DF84F63#1274334, COL_C74A4ECF_F14B_476C_A67D_B6041ED8D3A9#1274335, COL_1E7A663F_0C49_4DD3_957E_3413C84B2C41#1274336, COL_02B6DADD_D184_43F9_AFD4_C4D49AA841DC#1274337, COL_94135F59_2AF7_4A70_ABB8_623F5F4BE6D2#1274338]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/14_A_ACTES_PATI_203462]
PushedFilters: [EqualNullSafe(COL_094C0B3B_F823_47CF_A413_74D35F42EAE1,257194203)]
ReadSchema: struct<COL_094C0B3B_F823_47CF_A413_74D35F42EAE1:string,COL_CBEF3811_E4EF_4F9E_9EEE_82122077EC0F:string,COL_61D24032_1CF3_40CF_8813_66987B8FDCCE:string,COL_EC278560_7685_48E3_B44D_576F13F4A1D0:string,COL_E6BBE22F_4A1C_4467_891A_4C22C62E13C2:string,COL_AC135CAA_4B4F_4D5B_8F77_7DB39EF3BCE9:string,COL_3D4E5102_259C_4D72_862B_220B99C522C4:string,COL_AA8A7400_EB18_4287_AFFA_0B84FFCD3794:string,COL_E9659879_6635_4404_99A1_5AF775898BEB:string,COL_AEC78515_2EEF_495C_AB9E_8EFB42FD3D1D:string,COL_6823F929_C987_422D_88A4_CD582DF84F63:string,COL_C74A4ECF_F14B_476C_A67D_B6041ED8D3A9:string,COL_1E7A663F_0C49_4DD3_957E_3413C84B2C41:string,COL_02B6DADD_D184_43F9_AFD4_C4D49AA841DC:string,COL_94135F59_2AF7_4A70_ABB8_623F5F4BE6D2:string>

(2) ColumnarToRow [codegen id : 1]
Input [15]: [COL_094C0B3B_F823_47CF_A413_74D35F42EAE1#1274324, COL_CBEF3811_E4EF_4F9E_9EEE_82122077EC0F#1274325, COL_61D24032_1CF3_40CF_8813_66987B8FDCCE#1274326, COL_EC278560_7685_48E3_B44D_576F13F4A1D0#1274327, COL_E6BBE22F_4A1C_4467_891A_4C22C62E13C2#1274328, COL_AC135CAA_4B4F_4D5B_8F77_7DB39EF3BCE9#1274329, COL_3D4E5102_259C_4D72_862B_220B99C522C4#1274330, COL_AA8A7400_EB18_4287_AFFA_0B84FFCD3794#1274331, COL_E9659879_6635_4404_99A1_5AF775898BEB#1274332, COL_AEC78515_2EEF_495C_AB9E_8EFB42FD3D1D#1274333, COL_6823F929_C987_422D_88A4_CD582DF84F63#1274334, COL_C74A4ECF_F14B_476C_A67D_B6041ED8D3A9#1274335, COL_1E7A663F_0C49_4DD3_957E_3413C84B2C41#1274336, COL_02B6DADD_D184_43F9_AFD4_C4D49AA841DC#1274337, COL_94135F59_2AF7_4A70_ABB8_623F5F4BE6D2#1274338]

(3) Filter [codegen id : 1]
Input [15]: [COL_094C0B3B_F823_47CF_A413_74D35F42EAE1#1274324, COL_CBEF3811_E4EF_4F9E_9EEE_82122077EC0F#1274325, COL_61D24032_1CF3_40CF_8813_66987B8FDCCE#1274326, COL_EC278560_7685_48E3_B44D_576F13F4A1D0#1274327, COL_E6BBE22F_4A1C_4467_891A_4C22C62E13C2#1274328, COL_AC135CAA_4B4F_4D5B_8F77_7DB39EF3BCE9#1274329, COL_3D4E5102_259C_4D72_862B_220B99C522C4#1274330, COL_AA8A7400_EB18_4287_AFFA_0B84FFCD3794#1274331, COL_E9659879_6635_4404_99A1_5AF775898BEB#1274332, COL_AEC78515_2EEF_495C_AB9E_8EFB42FD3D1D#1274333, COL_6823F929_C987_422D_88A4_CD582DF84F63#1274334, COL_C74A4ECF_F14B_476C_A67D_B6041ED8D3A9#1274335, COL_1E7A663F_0C49_4DD3_957E_3413C84B2C41#1274336, COL_02B6DADD_D184_43F9_AFD4_C4D49AA841DC#1274337, COL_94135F59_2AF7_4A70_ABB8_623F5F4BE6D2#1274338]
Condition : (COL_094C0B3B_F823_47CF_A413_74D35F42EAE1#1274324 <=> 257194203)

(4) Project [codegen id : 1]
Output [15]: [COL_094C0B3B_F823_47CF_A413_74D35F42EAE1#1274324 AS COL_360A143A_5A0F_43B9_AA32_428457B51C24#1274461, COL_CBEF3811_E4EF_4F9E_9EEE_82122077EC0F#1274325 AS COL_56FCD270_1E4A_4F72_8B88_6B3B9B9D5BD8#1274462, COL_61D24032_1CF3_40CF_8813_66987B8FDCCE#1274326 AS COL_DC98DC92_5995_4B10_B357_1128145ABA89#1274463, COL_EC278560_7685_48E3_B44D_576F13F4A1D0#1274327 AS COL_D5D06726_E0EE_4E72_94DE_29828C1855CE#1274464, COL_E6BBE22F_4A1C_4467_891A_4C22C62E13C2#1274328 AS COL_4C8A7311_1A7F_4F43_9EBD_F60D666E47CC#1274465, COL_AC135CAA_4B4F_4D5B_8F77_7DB39EF3BCE9#1274329 AS COL_31C17A2A_697C_4BC8_A97F_EE7B13F78835#1274466, COL_3D4E5102_259C_4D72_862B_220B99C522C4#1274330 AS COL_A5071495_2B41_4F40_B4D6_CD5BF5F3A621#1274467, COL_AA8A7400_EB18_4287_AFFA_0B84FFCD3794#1274331 AS COL_D537AE5E_0BBD_4C9F_A902_FA9D079BC1F2#1274468, COL_E9659879_6635_4404_99A1_5AF775898BEB#1274332 AS COL_B2ED2D17_AFDB_4B80_98F4_6430CE1C43F8#1274469, COL_AEC78515_2EEF_495C_AB9E_8EFB42FD3D1D#1274333 AS COL_61371918_3FD1_4AF3_ABE2_3845DAF5C0AB#1274470, COL_6823F929_C987_422D_88A4_CD582DF84F63#1274334 AS COL_92CA9333_140D_49BA_8B47_40C4ECBAD8B7#1274471, COL_C74A4ECF_F14B_476C_A67D_B6041ED8D3A9#1274335 AS COL_0612B216_5C94_48F9_945D_17AF11C8131E#1274472, COL_1E7A663F_0C49_4DD3_957E_3413C84B2C41#1274336 AS COL_E833C7D8_F587_48B6_9A74_E7A9097FDA42#1274473, COL_02B6DADD_D184_43F9_AFD4_C4D49AA841DC#1274337 AS COL_27245A36_2FCB_4287_84CD_486C8A70E56C#1274474, COL_94135F59_2AF7_4A70_ABB8_623F5F4BE6D2#1274338 AS COL_C6BC0FB2_F938_451E_9D3C_970B1EC7CE17#1274475]
Input [15]: [COL_094C0B3B_F823_47CF_A413_74D35F42EAE1#1274324, COL_CBEF3811_E4EF_4F9E_9EEE_82122077EC0F#1274325, COL_61D24032_1CF3_40CF_8813_66987B8FDCCE#1274326, COL_EC278560_7685_48E3_B44D_576F13F4A1D0#1274327, COL_E6BBE22F_4A1C_4467_891A_4C22C62E13C2#1274328, COL_AC135CAA_4B4F_4D5B_8F77_7DB39EF3BCE9#1274329, COL_3D4E5102_259C_4D72_862B_220B99C522C4#1274330, COL_AA8A7400_EB18_4287_AFFA_0B84FFCD3794#1274331, COL_E9659879_6635_4404_99A1_5AF775898BEB#1274332, COL_AEC78515_2EEF_495C_AB9E_8EFB42FD3D1D#1274333, COL_6823F929_C987_422D_88A4_CD582DF84F63#1274334, COL_C74A4ECF_F14B_476C_A67D_B6041ED8D3A9#1274335, COL_1E7A663F_0C49_4DD3_957E_3413C84B2C41#1274336, COL_02B6DADD_D184_43F9_AFD4_C4D49AA841DC#1274337, COL_94135F59_2AF7_4A70_ABB8_623F5F4BE6D2#1274338]

(5) TakeOrderedAndProject
Input [15]: [COL_360A143A_5A0F_43B9_AA32_428457B51C24#1274461, COL_56FCD270_1E4A_4F72_8B88_6B3B9B9D5BD8#1274462, COL_DC98DC92_5995_4B10_B357_1128145ABA89#1274463, COL_D5D06726_E0EE_4E72_94DE_29828C1855CE#1274464, COL_4C8A7311_1A7F_4F43_9EBD_F60D666E47CC#1274465, COL_31C17A2A_697C_4BC8_A97F_EE7B13F78835#1274466, COL_A5071495_2B41_4F40_B4D6_CD5BF5F3A621#1274467, COL_D537AE5E_0BBD_4C9F_A902_FA9D079BC1F2#1274468, COL_B2ED2D17_AFDB_4B80_98F4_6430CE1C43F8#1274469, COL_61371918_3FD1_4AF3_ABE2_3845DAF5C0AB#1274470, COL_92CA9333_140D_49BA_8B47_40C4ECBAD8B7#1274471, COL_0612B216_5C94_48F9_945D_17AF11C8131E#1274472, COL_E833C7D8_F587_48B6_9A74_E7A9097FDA42#1274473, COL_27245A36_2FCB_4287_84CD_486C8A70E56C#1274474, COL_C6BC0FB2_F938_451E_9D3C_970B1EC7CE17#1274475]
Arguments: 500000, [COL_56FCD270_1E4A_4F72_8B88_6B3B9B9D5BD8#1274462 ASC NULLS FIRST], [COL_360A143A_5A0F_43B9_AA32_428457B51C24#1274461, COL_56FCD270_1E4A_4F72_8B88_6B3B9B9D5BD8#1274462, COL_DC98DC92_5995_4B10_B357_1128145ABA89#1274463, COL_D5D06726_E0EE_4E72_94DE_29828C1855CE#1274464, COL_4C8A7311_1A7F_4F43_9EBD_F60D666E47CC#1274465, COL_31C17A2A_697C_4BC8_A97F_EE7B13F78835#1274466, COL_A5071495_2B41_4F40_B4D6_CD5BF5F3A621#1274467, COL_D537AE5E_0BBD_4C9F_A902_FA9D079BC1F2#1274468, COL_B2ED2D17_AFDB_4B80_98F4_6430CE1C43F8#1274469, COL_61371918_3FD1_4AF3_ABE2_3845DAF5C0AB#1274470, COL_92CA9333_140D_49BA_8B47_40C4ECBAD8B7#1274471, COL_0612B216_5C94_48F9_945D_17AF11C8131E#1274472, COL_E833C7D8_F587_48B6_9A74_E7A9097FDA42#1274473, COL_27245A36_2FCB_4287_84CD_486C8A70E56C#1274474, COL_C6BC0FB2_F938_451E_9D3C_970B1EC7CE17#1274475]

SQL / DataFrame Properties

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