SP1 - Details for Query 551

Submitted Time: 2026/06/25 16:36:15
Duration: 84 ms
Succeeded Jobs: 757

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

digraph G { 0 [labelType="html" label=" CollectLimit "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 23 ms"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="ColumnarToRow number of output rows: 1,455 number of input batches: 1"]; } 4 [labelType="html" label="Scan parquet number of files read: 1 scan time: 8 ms metadata time: 0 ms size of files read: 276.8 KiB number of output rows: 1,455"]; 2->0; 3->2; 4->3; }

CollectLimit 500000

Project [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#235053 AS COL_C9A4BCF0_FFDA_421D_B23C_22516A0A3E83#235789, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#235054 AS COL_FEC733BC_FE93_4B25_868A_D770927BEF0D#235790, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#235055 AS COL_B1DABA17_8111_40A9_942E_94DC87F6B80E#235791, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#235056 AS COL_EEB80BF1_1A65_4EBE_9A93_00647856484D#235792, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#235057 AS COL_184F9E78_32BC_44BD_8C93_E26CD008008B#235793, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#235058 AS COL_21C4878E_241C_4E78_B0C4_53090A811072#235794, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#235059 AS COL_6132364B_BB88_4A4F_8F24_27BF0BBAED38#235795, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#235060 AS COL_1EC66327_E6AF_4D33_9F35_6227C41B8F35#235796, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#235061 AS COL_32C382AA_7A11_4DBB_8F3E_B96C7A7C378A#235797, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#235062 AS COL_4804136E_3783_4E58_B864_A91873EBA2F6#235798, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#235063 AS COL_511D11C0_7D8B_4F91_A35E_9737D409EDF8#235799, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#235064 AS COL_7EA74981_A678_487B_B6F3_D6CB2AE9917B#235800, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#235065 AS COL_CE5B1457_37CB_4F32_B1C9_F7F3D7F4C211#235801, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#235066 AS COL_B6FB176C_92BE_4645_8704_DFB8B93FA23A#235802, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#235067 AS COL_5F082B45_C539_4231_A8D4_B200919E9817#235803, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#235068 AS COL_5934CBFA_D84D_4EB4_A2C3_CBCB789BA369#235804, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#235069 AS COL_C2EE1619_7320_4604_B623_6F8DE5AF3FC3#235805, COL_0DB61D05_5348_40DB_8F16_C7916849A669#235070 AS COL_609D9E39_F50B_41D9_A460_54592078005F#235806, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#235071 AS COL_4C20414D_7A5D_4382_BAA1_FD2B927D2A6A#235807, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#235072 AS COL_7C9A1F34_256F_4B72_91C7_B1A15F717525#235808, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#235073 AS COL_F4CE706B_FC79_43AE_B775_1BD30F3DDADF#235809, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#235074 AS COL_E945AA16_69AE_47A8_8B56_A9D8D3668F8D#235810, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#235075 AS COL_4B87B1A7_0F0E_4A8C_815C_C9F006F291F8#235811, COL_33CEA792_75B9_44A1_896B_B422BD28B923#235076 AS COL_5E44DBAB_DF27_4829_8AB9_DFECEA07D4C0#235812, ... 19 more fields]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#235053,COL_EC7474ED_A0A6_401C_BA97_20D63A467807#235054,COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#235055,COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#235056,COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#235057,COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#235058,COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#235059,COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#235060,COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#235061,COL_D4E1F01A_72C8_4621_905A_881FB0249F81#235062,COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#235063,COL_871E0000_AA32_4679_83B0_C8AA49007BCF#235064,COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#235065,COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#235066,COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#235067,COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#235068,COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#235069,COL_0DB61D05_5348_40DB_8F16_C7916849A669#235070,COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#235071,COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#235072,COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#235073,COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#235074,COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#235075,COL_33CEA792_75B9_44A1_896B_B422BD28B923#235076,... 19 more fields] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/MATCHING_ANALYS_405206], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_BA552F89_FE8A_4EC3_A09E_640A661C9019:string,COL_EC7474ED_A0A6_401C_BA97_20D63A467807:s...

Details

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


(1) Scan parquet 
Output [43]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#235053, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#235054, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#235055, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#235056, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#235057, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#235058, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#235059, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#235060, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#235061, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#235062, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#235063, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#235064, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#235065, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#235066, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#235067, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#235068, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#235069, COL_0DB61D05_5348_40DB_8F16_C7916849A669#235070, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#235071, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#235072, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#235073, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#235074, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#235075, COL_33CEA792_75B9_44A1_896B_B422BD28B923#235076, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#235077, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#235078, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#235079, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#235080, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#235081, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#235082, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#235083, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#235084, COL_924860D6_14C4_4F33_B84C_E428E89E2817#235085, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#235086, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#235087, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#235088, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#235089, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#235090, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#235091, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#235092, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#235093, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#235094, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#235095]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/MATCHING_ANALYS_405206]
ReadSchema: struct<COL_BA552F89_FE8A_4EC3_A09E_640A661C9019:string,COL_EC7474ED_A0A6_401C_BA97_20D63A467807:string,COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB:string,COL_8467C1BB_F0A2_44E6_88D6_8477052876CA:string,COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929:string,COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B:string,COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E:string,COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93:string,COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355:string,COL_D4E1F01A_72C8_4621_905A_881FB0249F81:string,COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED:string,COL_871E0000_AA32_4679_83B0_C8AA49007BCF:string,COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8:string,COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C:string,COL_9263F342_2220_4C7C_BA3D_B7B7386988B7:string,COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB:string,COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC:string,COL_0DB61D05_5348_40DB_8F16_C7916849A669:string,COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96:string,COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C:string,COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38:string,COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB:string,COL_BBEA900F_6FE8_40DA_B278_36CA822C312A:string,COL_33CEA792_75B9_44A1_896B_B422BD28B923:string,COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48:string,COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25:string,COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5:string,COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267:string,COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27:string,COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2:string,COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23:string,COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC:string,COL_924860D6_14C4_4F33_B84C_E428E89E2817:string,COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C:string,COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF:string,COL_730C7D9D_95B5_4388_983E_C4F260C553BD:string,COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D:string,COL_90791789_DD87_40BC_92F0_F5FB1BD5126F:string,COL_FB26292A_034B_4B72_8403_8A7AE83CFC56:string,COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E:string,COL_FC403537_BB94_4C83_AC18_B668C51A4E0A:string,COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142:string,COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4:string>

(2) ColumnarToRow [codegen id : 1]
Input [43]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#235053, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#235054, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#235055, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#235056, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#235057, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#235058, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#235059, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#235060, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#235061, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#235062, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#235063, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#235064, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#235065, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#235066, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#235067, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#235068, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#235069, COL_0DB61D05_5348_40DB_8F16_C7916849A669#235070, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#235071, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#235072, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#235073, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#235074, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#235075, COL_33CEA792_75B9_44A1_896B_B422BD28B923#235076, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#235077, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#235078, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#235079, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#235080, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#235081, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#235082, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#235083, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#235084, COL_924860D6_14C4_4F33_B84C_E428E89E2817#235085, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#235086, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#235087, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#235088, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#235089, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#235090, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#235091, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#235092, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#235093, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#235094, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#235095]

(3) Project [codegen id : 1]
Output [43]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#235053 AS COL_C9A4BCF0_FFDA_421D_B23C_22516A0A3E83#235789, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#235054 AS COL_FEC733BC_FE93_4B25_868A_D770927BEF0D#235790, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#235055 AS COL_B1DABA17_8111_40A9_942E_94DC87F6B80E#235791, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#235056 AS COL_EEB80BF1_1A65_4EBE_9A93_00647856484D#235792, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#235057 AS COL_184F9E78_32BC_44BD_8C93_E26CD008008B#235793, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#235058 AS COL_21C4878E_241C_4E78_B0C4_53090A811072#235794, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#235059 AS COL_6132364B_BB88_4A4F_8F24_27BF0BBAED38#235795, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#235060 AS COL_1EC66327_E6AF_4D33_9F35_6227C41B8F35#235796, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#235061 AS COL_32C382AA_7A11_4DBB_8F3E_B96C7A7C378A#235797, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#235062 AS COL_4804136E_3783_4E58_B864_A91873EBA2F6#235798, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#235063 AS COL_511D11C0_7D8B_4F91_A35E_9737D409EDF8#235799, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#235064 AS COL_7EA74981_A678_487B_B6F3_D6CB2AE9917B#235800, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#235065 AS COL_CE5B1457_37CB_4F32_B1C9_F7F3D7F4C211#235801, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#235066 AS COL_B6FB176C_92BE_4645_8704_DFB8B93FA23A#235802, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#235067 AS COL_5F082B45_C539_4231_A8D4_B200919E9817#235803, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#235068 AS COL_5934CBFA_D84D_4EB4_A2C3_CBCB789BA369#235804, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#235069 AS COL_C2EE1619_7320_4604_B623_6F8DE5AF3FC3#235805, COL_0DB61D05_5348_40DB_8F16_C7916849A669#235070 AS COL_609D9E39_F50B_41D9_A460_54592078005F#235806, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#235071 AS COL_4C20414D_7A5D_4382_BAA1_FD2B927D2A6A#235807, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#235072 AS COL_7C9A1F34_256F_4B72_91C7_B1A15F717525#235808, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#235073 AS COL_F4CE706B_FC79_43AE_B775_1BD30F3DDADF#235809, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#235074 AS COL_E945AA16_69AE_47A8_8B56_A9D8D3668F8D#235810, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#235075 AS COL_4B87B1A7_0F0E_4A8C_815C_C9F006F291F8#235811, COL_33CEA792_75B9_44A1_896B_B422BD28B923#235076 AS COL_5E44DBAB_DF27_4829_8AB9_DFECEA07D4C0#235812, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#235077 AS COL_0D0CAE86_65C2_4FAA_BD01_15FD4895BD9C#235813, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#235078 AS COL_59A89AD7_A254_4D91_B428_8495157C9209#235814, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#235079 AS COL_A668D5DE_02F8_4F57_954E_19823218892B#235815, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#235080 AS COL_96C087B0_69B7_4786_A8EB_EE0EF2BA93F1#235816, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#235081 AS COL_81EA42EA_0732_423B_BE4E_D4B43A6D017C#235817, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#235082 AS COL_BFFE08F7_B9F8_465C_B8ED_95915C453CDC#235818, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#235083 AS COL_C4B0B20A_2C5E_4548_959D_5699D8436AF0#235819, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#235084 AS COL_600708A7_F87E_4A5C_9B2E_0DA011430E77#235820, COL_924860D6_14C4_4F33_B84C_E428E89E2817#235085 AS COL_E53CDFA2_A8AB_414E_B236_967B4E251F0C#235821, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#235086 AS COL_CE00694B_35AF_4CCC_ABE8_F1EBE3A7F626#235822, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#235087 AS COL_21D6279A_F984_4FA4_A5C2_603DED589AAE#235823, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#235088 AS COL_5C0F1965_CE01_4DEC_8D5C_5355DDCAD5D7#235824, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#235089 AS COL_5B6DBAB2_5C5B_4134_AA76_DA869A07D7BC#235825, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#235090 AS COL_D13C7A4D_8C85_4F52_98A1_EF2127D8AB52#235826, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#235091 AS COL_4FD9A69B_25AE_4D93_A6E5_9D60D81EC9F5#235827, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#235092 AS COL_8FD9BB28_E1DF_45FB_BC81_70A76B33A1F1#235828, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#235093 AS COL_A3908EF6_1BE7_4A86_8815_D26C6B643464#235829, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#235094 AS COL_3C11391D_9D2A_4EFA_B62D_EF694334615F#235830, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#235095 AS COL_F5B2003F_943E_40FF_AEDC_4C2BB2062916#235831]
Input [43]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#235053, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#235054, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#235055, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#235056, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#235057, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#235058, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#235059, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#235060, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#235061, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#235062, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#235063, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#235064, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#235065, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#235066, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#235067, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#235068, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#235069, COL_0DB61D05_5348_40DB_8F16_C7916849A669#235070, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#235071, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#235072, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#235073, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#235074, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#235075, COL_33CEA792_75B9_44A1_896B_B422BD28B923#235076, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#235077, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#235078, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#235079, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#235080, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#235081, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#235082, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#235083, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#235084, COL_924860D6_14C4_4F33_B84C_E428E89E2817#235085, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#235086, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#235087, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#235088, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#235089, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#235090, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#235091, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#235092, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#235093, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#235094, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#235095]

(4) CollectLimit
Input [43]: [COL_C9A4BCF0_FFDA_421D_B23C_22516A0A3E83#235789, COL_FEC733BC_FE93_4B25_868A_D770927BEF0D#235790, COL_B1DABA17_8111_40A9_942E_94DC87F6B80E#235791, COL_EEB80BF1_1A65_4EBE_9A93_00647856484D#235792, COL_184F9E78_32BC_44BD_8C93_E26CD008008B#235793, COL_21C4878E_241C_4E78_B0C4_53090A811072#235794, COL_6132364B_BB88_4A4F_8F24_27BF0BBAED38#235795, COL_1EC66327_E6AF_4D33_9F35_6227C41B8F35#235796, COL_32C382AA_7A11_4DBB_8F3E_B96C7A7C378A#235797, COL_4804136E_3783_4E58_B864_A91873EBA2F6#235798, COL_511D11C0_7D8B_4F91_A35E_9737D409EDF8#235799, COL_7EA74981_A678_487B_B6F3_D6CB2AE9917B#235800, COL_CE5B1457_37CB_4F32_B1C9_F7F3D7F4C211#235801, COL_B6FB176C_92BE_4645_8704_DFB8B93FA23A#235802, COL_5F082B45_C539_4231_A8D4_B200919E9817#235803, COL_5934CBFA_D84D_4EB4_A2C3_CBCB789BA369#235804, COL_C2EE1619_7320_4604_B623_6F8DE5AF3FC3#235805, COL_609D9E39_F50B_41D9_A460_54592078005F#235806, COL_4C20414D_7A5D_4382_BAA1_FD2B927D2A6A#235807, COL_7C9A1F34_256F_4B72_91C7_B1A15F717525#235808, COL_F4CE706B_FC79_43AE_B775_1BD30F3DDADF#235809, COL_E945AA16_69AE_47A8_8B56_A9D8D3668F8D#235810, COL_4B87B1A7_0F0E_4A8C_815C_C9F006F291F8#235811, COL_5E44DBAB_DF27_4829_8AB9_DFECEA07D4C0#235812, COL_0D0CAE86_65C2_4FAA_BD01_15FD4895BD9C#235813, COL_59A89AD7_A254_4D91_B428_8495157C9209#235814, COL_A668D5DE_02F8_4F57_954E_19823218892B#235815, COL_96C087B0_69B7_4786_A8EB_EE0EF2BA93F1#235816, COL_81EA42EA_0732_423B_BE4E_D4B43A6D017C#235817, COL_BFFE08F7_B9F8_465C_B8ED_95915C453CDC#235818, COL_C4B0B20A_2C5E_4548_959D_5699D8436AF0#235819, COL_600708A7_F87E_4A5C_9B2E_0DA011430E77#235820, COL_E53CDFA2_A8AB_414E_B236_967B4E251F0C#235821, COL_CE00694B_35AF_4CCC_ABE8_F1EBE3A7F626#235822, COL_21D6279A_F984_4FA4_A5C2_603DED589AAE#235823, COL_5C0F1965_CE01_4DEC_8D5C_5355DDCAD5D7#235824, COL_5B6DBAB2_5C5B_4134_AA76_DA869A07D7BC#235825, COL_D13C7A4D_8C85_4F52_98A1_EF2127D8AB52#235826, COL_4FD9A69B_25AE_4D93_A6E5_9D60D81EC9F5#235827, COL_8FD9BB28_E1DF_45FB_BC81_70A76B33A1F1#235828, COL_A3908EF6_1BE7_4A86_8815_D26C6B643464#235829, COL_3C11391D_9D2A_4EFA_B62D_EF694334615F#235830, COL_F5B2003F_943E_40FF_AEDC_4C2BB2062916#235831]
Arguments: 500000

SQL / DataFrame Properties

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