SP1 - Details for Query 605

Submitted Time: 2026/06/25 16:59:40
Duration: 0.1 s
Succeeded Jobs: 821

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: 28 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: 10 ms metadata time: 0 ms size of files read: 312.5 KiB number of output rows: 1,455"]; 2->0; 3->2; 4->3; }

CollectLimit 500000

Project [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#244738 AS COL_C0DEFCEC_8246_4648_B44C_9FF58C01DBFC#245673, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#244739 AS COL_894AA705_2C0D_4EE7_8FAF_450896A706EF#245674, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#244740 AS COL_85DB2F6D_94DF_4E41_B442_5B2A5AD8CDB2#245675, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#244741 AS COL_C84451E4_4ED1_4746_A4D9_F2E15C20E178#245676, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#244742 AS COL_D3B1EB2B_F16A_4C93_8E2A_D6D5DE8504A4#245677, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#244743 AS COL_2A3DDFD7_EF50_4814_9128_967194783431#245678, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#244744 AS COL_8EB7C7E4_1DA7_4C54_A4C6_6E666CF34DB0#245679, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#244745 AS COL_B57EE84C_56D0_41A5_8E12_925F8E0E110D#245680, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#244746 AS COL_76FE7CDA_1BC6_40A3_89CB_6C8BBF847A81#245681, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#244747 AS COL_9A659BA9_1E1E_4386_ABA4_64AFDAAF81DF#245682, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#244748 AS COL_6A10F26F_C13C_4C5A_A91D_68AB78C37DA4#245683, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#244749 AS COL_3AB7C43F_53F1_4346_AB3A_625ABD43963C#245684, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#244750 AS COL_AEA0EFC5_649F_4DB5_AA6F_AEED809FAECB#245685, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#244751 AS COL_332D60E5_EA29_4C4E_98D6_FAC946FC94EF#245686, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#244752 AS COL_2D2AE5AD_2970_4106_84B4_C6E788C430B1#245687, COL_98B2878A_418E_4331_B333_2493994BB807#244753 AS COL_97B7EB4A_333D_449A_930B_AF1116C13E8A#245688, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#244754 AS COL_344A0632_2789_4DAD_B265_44884048719B#245689, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#244755 AS COL_769D888E_7B74_4B24_A78E_E06E14897F36#245690, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#244756 AS COL_F580E0D3_58D7_41A8_BF6A_E132981A5DE7#245691, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#244757 AS COL_E5DCE762_733C_43C1_BA4C_FAC9FFA941AD#245692, COL_E722B691_2CA2_4160_A578_D9CD4920A842#244758 AS COL_7677E2E9_7220_4545_A53F_1A0DE4685903#245693, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#244759 AS COL_59C5FB5F_DE81_4539_948D_FAED838B7CF5#245694, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#244760 AS COL_542CCBED_52A0_4C49_8D1D_99D37894E229#245695, COL_D897344F_9AC3_429E_A95D_88390F445758#244761 AS COL_22091AA7_BC5A_434F_AA0C_2A5A97717F11#245696, ... 31 more fields]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#244738,COL_956F91E2_2027_457F_A229_B9CF20D9FF63#244739,COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#244740,COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#244741,COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#244742,COL_FB65F162_1AB6_4971_99DA_F8A943944A66#244743,COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#244744,COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#244745,COL_573E3A58_7401_4F3F_9EFA_058729D28B72#244746,COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#244747,COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#244748,COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#244749,COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#244750,COL_C42F735E_237B_4569_996D_76FF5A4A65DF#244751,COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#244752,COL_98B2878A_418E_4331_B333_2493994BB807#244753,COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#244754,COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#244755,COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#244756,COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#244757,COL_E722B691_2CA2_4160_A578_D9CD4920A842#244758,COL_D600764E_8D81_4891_BF21_ACC3F0938E57#244759,COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#244760,COL_D897344F_9AC3_429E_A95D_88390F445758#244761,... 31 more fields] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/2a0f06e8_dcf9_47f7_b482_92a6..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399:string,COL_956F91E2_2027_457F_A229_B9CF20D9FF63:s...

Details

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


(1) Scan parquet 
Output [55]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#244738, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#244739, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#244740, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#244741, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#244742, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#244743, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#244744, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#244745, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#244746, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#244747, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#244748, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#244749, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#244750, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#244751, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#244752, COL_98B2878A_418E_4331_B333_2493994BB807#244753, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#244754, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#244755, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#244756, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#244757, COL_E722B691_2CA2_4160_A578_D9CD4920A842#244758, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#244759, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#244760, COL_D897344F_9AC3_429E_A95D_88390F445758#244761, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#244762, COL_52167438_70F6_4E26_B5CD_17C5990F8948#244763, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#244764, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#244765, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#244766, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#244767, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#244768, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#244769, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#244770, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#244771, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#244772, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#244773, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#244774, COL_1FF33786_C88A_4789_B428_364FF98B1905#244775, COL_35375170_B542_49DE_AFA2_0A2D31967891#244776L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#244777, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#244778, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#244779, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#244780, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#244781, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#244782, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#244783, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#244784, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#244785, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#244786, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#244787, COL_8068E186_2734_4730_8D2C_A788B2226179#244788, COL_DA667933_29E5_49E1_8724_A537DCE9735F#244789, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#244790, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#244791, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#244792]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/2a0f06e8_dcf9_47f7_b482_92a6978dded9]
ReadSchema: struct<COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399:string,COL_956F91E2_2027_457F_A229_B9CF20D9FF63:string,COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3:string,COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3:string,COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C:string,COL_FB65F162_1AB6_4971_99DA_F8A943944A66:string,COL_04BFCB87_D14B_4364_A366_6B179BF9CD20:string,COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C:string,COL_573E3A58_7401_4F3F_9EFA_058729D28B72:string,COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF:string,COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159:string,COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9:string,COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084:string,COL_C42F735E_237B_4569_996D_76FF5A4A65DF:string,COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214:string,COL_98B2878A_418E_4331_B333_2493994BB807:string,COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C:string,COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF:string,COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE:string,COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63:string,COL_E722B691_2CA2_4160_A578_D9CD4920A842:string,COL_D600764E_8D81_4891_BF21_ACC3F0938E57:string,COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5:string,COL_D897344F_9AC3_429E_A95D_88390F445758:string,COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9:string,COL_52167438_70F6_4E26_B5CD_17C5990F8948:string,COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17:string,COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3:string,COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539:string,COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9:string,COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6:string,COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9:string,COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49:string,COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7:string,COL_D0A8A26A_A602_4462_BBB1_8286F0724054:string,COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30:string,COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3:string,COL_1FF33786_C88A_4789_B428_364FF98B1905:string,COL_35375170_B542_49DE_AFA2_0A2D31967891:bigint,COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF:double,COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9:double,COL_C0CA120C_6738_4CF5_B569_FD209A7B518A:double,COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3:double,COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE:double,COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF:double,COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD:double,COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9:double,COL_23424D2C_0B0A_403F_9061_1D8B148D6A67:double,COL_5CDC74F0_3D28_463C_9042_237BDAB52540:string,COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028:double,COL_8068E186_2734_4730_8D2C_A788B2226179:string,COL_DA667933_29E5_49E1_8724_A537DCE9735F:string,COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4:string,COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7:string,COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458:string>

(2) ColumnarToRow [codegen id : 1]
Input [55]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#244738, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#244739, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#244740, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#244741, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#244742, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#244743, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#244744, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#244745, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#244746, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#244747, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#244748, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#244749, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#244750, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#244751, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#244752, COL_98B2878A_418E_4331_B333_2493994BB807#244753, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#244754, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#244755, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#244756, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#244757, COL_E722B691_2CA2_4160_A578_D9CD4920A842#244758, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#244759, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#244760, COL_D897344F_9AC3_429E_A95D_88390F445758#244761, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#244762, COL_52167438_70F6_4E26_B5CD_17C5990F8948#244763, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#244764, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#244765, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#244766, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#244767, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#244768, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#244769, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#244770, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#244771, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#244772, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#244773, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#244774, COL_1FF33786_C88A_4789_B428_364FF98B1905#244775, COL_35375170_B542_49DE_AFA2_0A2D31967891#244776L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#244777, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#244778, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#244779, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#244780, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#244781, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#244782, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#244783, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#244784, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#244785, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#244786, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#244787, COL_8068E186_2734_4730_8D2C_A788B2226179#244788, COL_DA667933_29E5_49E1_8724_A537DCE9735F#244789, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#244790, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#244791, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#244792]

(3) Project [codegen id : 1]
Output [55]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#244738 AS COL_C0DEFCEC_8246_4648_B44C_9FF58C01DBFC#245673, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#244739 AS COL_894AA705_2C0D_4EE7_8FAF_450896A706EF#245674, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#244740 AS COL_85DB2F6D_94DF_4E41_B442_5B2A5AD8CDB2#245675, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#244741 AS COL_C84451E4_4ED1_4746_A4D9_F2E15C20E178#245676, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#244742 AS COL_D3B1EB2B_F16A_4C93_8E2A_D6D5DE8504A4#245677, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#244743 AS COL_2A3DDFD7_EF50_4814_9128_967194783431#245678, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#244744 AS COL_8EB7C7E4_1DA7_4C54_A4C6_6E666CF34DB0#245679, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#244745 AS COL_B57EE84C_56D0_41A5_8E12_925F8E0E110D#245680, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#244746 AS COL_76FE7CDA_1BC6_40A3_89CB_6C8BBF847A81#245681, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#244747 AS COL_9A659BA9_1E1E_4386_ABA4_64AFDAAF81DF#245682, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#244748 AS COL_6A10F26F_C13C_4C5A_A91D_68AB78C37DA4#245683, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#244749 AS COL_3AB7C43F_53F1_4346_AB3A_625ABD43963C#245684, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#244750 AS COL_AEA0EFC5_649F_4DB5_AA6F_AEED809FAECB#245685, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#244751 AS COL_332D60E5_EA29_4C4E_98D6_FAC946FC94EF#245686, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#244752 AS COL_2D2AE5AD_2970_4106_84B4_C6E788C430B1#245687, COL_98B2878A_418E_4331_B333_2493994BB807#244753 AS COL_97B7EB4A_333D_449A_930B_AF1116C13E8A#245688, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#244754 AS COL_344A0632_2789_4DAD_B265_44884048719B#245689, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#244755 AS COL_769D888E_7B74_4B24_A78E_E06E14897F36#245690, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#244756 AS COL_F580E0D3_58D7_41A8_BF6A_E132981A5DE7#245691, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#244757 AS COL_E5DCE762_733C_43C1_BA4C_FAC9FFA941AD#245692, COL_E722B691_2CA2_4160_A578_D9CD4920A842#244758 AS COL_7677E2E9_7220_4545_A53F_1A0DE4685903#245693, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#244759 AS COL_59C5FB5F_DE81_4539_948D_FAED838B7CF5#245694, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#244760 AS COL_542CCBED_52A0_4C49_8D1D_99D37894E229#245695, COL_D897344F_9AC3_429E_A95D_88390F445758#244761 AS COL_22091AA7_BC5A_434F_AA0C_2A5A97717F11#245696, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#244762 AS COL_7C4E42CF_655F_436B_B651_BC72104B0BEB#245697, COL_52167438_70F6_4E26_B5CD_17C5990F8948#244763 AS COL_65A9C5D9_54BB_4C8B_9F15_63A690A89203#245698, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#244764 AS COL_F3A26CD2_15AC_44E4_9308_8A4360F4C980#245699, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#244765 AS COL_C8A75012_A556_4F85_A6EA_3A4683E31227#245700, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#244766 AS COL_87A3E13D_ED43_431B_B663_15D779F058BA#245701, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#244767 AS COL_B88782FF_32F8_41BD_BEDC_C2FA126DECB6#245702, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#244768 AS COL_4D22709C_6B5C_4FF6_B22E_33486D607DDE#245703, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#244769 AS COL_5B3600F1_581D_407A_A3EC_DB89A4855F99#245704, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#244770 AS COL_ED09F390_1D14_44C4_BF94_D36A4BF99576#245705, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#244771 AS COL_610087CE_875C_412B_8170_539F84F8871C#245706, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#244772 AS COL_D824C0B6_53A2_41F1_AF1B_FBC3B6757B58#245707, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#244773 AS COL_163C05C0_0FA0_4DA8_98B9_984E609C6438#245708, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#244774 AS COL_19508A34_A09F_4A50_A5D1_C1ECBEF6ACCE#245709, COL_1FF33786_C88A_4789_B428_364FF98B1905#244775 AS COL_443A8073_F413_4BA4_9A4F_2B49D3AA2282#245710, COL_35375170_B542_49DE_AFA2_0A2D31967891#244776L AS COL_08EEDB43_7769_414D_A306_FD8F42D9BB9B#245711L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#244777 AS COL_6805DFEB_CE9E_4044_8B13_5BA1AF58C71E#245712, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#244778 AS COL_7C7C5950_2230_4394_AFB7_D00668F1FD7C#245713, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#244779 AS COL_F6FDA53F_7448_44EF_A007_A9F1EE63D561#245714, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#244780 AS COL_F098BDE5_38EA_4E38_A9D0_C88A77CC661A#245715, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#244781 AS COL_D28D069C_5259_41F7_B9E2_90A0613730D2#245716, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#244782 AS COL_11EC3721_860F_4CCB_BE2B_DD72A23B84AE#245717, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#244783 AS COL_140784F7_B038_4E75_B87A_383683008383#245718, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#244784 AS COL_EDE0D930_5EF0_49EC_A44D_DD72DED332DB#245719, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#244785 AS COL_3982AA6E_B867_4561_9C96_20E290C7F7B2#245720, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#244786 AS COL_F7D24BB2_021D_4738_8B2D_6B586273CDA0#245721, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#244787 AS COL_1CEDB10F_6563_42F6_8667_82694DF4450A#245722, COL_8068E186_2734_4730_8D2C_A788B2226179#244788 AS COL_ECC83B09_763C_4A0A_A30B_0EDFDAEA57CD#245723, COL_DA667933_29E5_49E1_8724_A537DCE9735F#244789 AS COL_3DFBA552_A542_4794_BC37_88CC5D6F89CE#245724, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#244790 AS COL_84EAB9BA_4929_4F06_A35A_75EBBDD474DF#245725, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#244791 AS COL_CEB027AF_6102_4A3C_AFB2_DE67E13DE7A8#245726, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#244792 AS COL_059CEED0_3B0A_45E5_8AB7_54AFCD242B8C#245727]
Input [55]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#244738, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#244739, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#244740, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#244741, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#244742, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#244743, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#244744, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#244745, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#244746, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#244747, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#244748, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#244749, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#244750, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#244751, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#244752, COL_98B2878A_418E_4331_B333_2493994BB807#244753, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#244754, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#244755, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#244756, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#244757, COL_E722B691_2CA2_4160_A578_D9CD4920A842#244758, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#244759, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#244760, COL_D897344F_9AC3_429E_A95D_88390F445758#244761, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#244762, COL_52167438_70F6_4E26_B5CD_17C5990F8948#244763, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#244764, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#244765, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#244766, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#244767, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#244768, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#244769, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#244770, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#244771, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#244772, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#244773, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#244774, COL_1FF33786_C88A_4789_B428_364FF98B1905#244775, COL_35375170_B542_49DE_AFA2_0A2D31967891#244776L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#244777, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#244778, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#244779, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#244780, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#244781, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#244782, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#244783, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#244784, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#244785, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#244786, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#244787, COL_8068E186_2734_4730_8D2C_A788B2226179#244788, COL_DA667933_29E5_49E1_8724_A537DCE9735F#244789, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#244790, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#244791, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#244792]

(4) CollectLimit
Input [55]: [COL_C0DEFCEC_8246_4648_B44C_9FF58C01DBFC#245673, COL_894AA705_2C0D_4EE7_8FAF_450896A706EF#245674, COL_85DB2F6D_94DF_4E41_B442_5B2A5AD8CDB2#245675, COL_C84451E4_4ED1_4746_A4D9_F2E15C20E178#245676, COL_D3B1EB2B_F16A_4C93_8E2A_D6D5DE8504A4#245677, COL_2A3DDFD7_EF50_4814_9128_967194783431#245678, COL_8EB7C7E4_1DA7_4C54_A4C6_6E666CF34DB0#245679, COL_B57EE84C_56D0_41A5_8E12_925F8E0E110D#245680, COL_76FE7CDA_1BC6_40A3_89CB_6C8BBF847A81#245681, COL_9A659BA9_1E1E_4386_ABA4_64AFDAAF81DF#245682, COL_6A10F26F_C13C_4C5A_A91D_68AB78C37DA4#245683, COL_3AB7C43F_53F1_4346_AB3A_625ABD43963C#245684, COL_AEA0EFC5_649F_4DB5_AA6F_AEED809FAECB#245685, COL_332D60E5_EA29_4C4E_98D6_FAC946FC94EF#245686, COL_2D2AE5AD_2970_4106_84B4_C6E788C430B1#245687, COL_97B7EB4A_333D_449A_930B_AF1116C13E8A#245688, COL_344A0632_2789_4DAD_B265_44884048719B#245689, COL_769D888E_7B74_4B24_A78E_E06E14897F36#245690, COL_F580E0D3_58D7_41A8_BF6A_E132981A5DE7#245691, COL_E5DCE762_733C_43C1_BA4C_FAC9FFA941AD#245692, COL_7677E2E9_7220_4545_A53F_1A0DE4685903#245693, COL_59C5FB5F_DE81_4539_948D_FAED838B7CF5#245694, COL_542CCBED_52A0_4C49_8D1D_99D37894E229#245695, COL_22091AA7_BC5A_434F_AA0C_2A5A97717F11#245696, COL_7C4E42CF_655F_436B_B651_BC72104B0BEB#245697, COL_65A9C5D9_54BB_4C8B_9F15_63A690A89203#245698, COL_F3A26CD2_15AC_44E4_9308_8A4360F4C980#245699, COL_C8A75012_A556_4F85_A6EA_3A4683E31227#245700, COL_87A3E13D_ED43_431B_B663_15D779F058BA#245701, COL_B88782FF_32F8_41BD_BEDC_C2FA126DECB6#245702, COL_4D22709C_6B5C_4FF6_B22E_33486D607DDE#245703, COL_5B3600F1_581D_407A_A3EC_DB89A4855F99#245704, COL_ED09F390_1D14_44C4_BF94_D36A4BF99576#245705, COL_610087CE_875C_412B_8170_539F84F8871C#245706, COL_D824C0B6_53A2_41F1_AF1B_FBC3B6757B58#245707, COL_163C05C0_0FA0_4DA8_98B9_984E609C6438#245708, COL_19508A34_A09F_4A50_A5D1_C1ECBEF6ACCE#245709, COL_443A8073_F413_4BA4_9A4F_2B49D3AA2282#245710, COL_08EEDB43_7769_414D_A306_FD8F42D9BB9B#245711L, COL_6805DFEB_CE9E_4044_8B13_5BA1AF58C71E#245712, COL_7C7C5950_2230_4394_AFB7_D00668F1FD7C#245713, COL_F6FDA53F_7448_44EF_A007_A9F1EE63D561#245714, COL_F098BDE5_38EA_4E38_A9D0_C88A77CC661A#245715, COL_D28D069C_5259_41F7_B9E2_90A0613730D2#245716, COL_11EC3721_860F_4CCB_BE2B_DD72A23B84AE#245717, COL_140784F7_B038_4E75_B87A_383683008383#245718, COL_EDE0D930_5EF0_49EC_A44D_DD72DED332DB#245719, COL_3982AA6E_B867_4561_9C96_20E290C7F7B2#245720, COL_F7D24BB2_021D_4738_8B2D_6B586273CDA0#245721, COL_1CEDB10F_6563_42F6_8667_82694DF4450A#245722, COL_ECC83B09_763C_4A0A_A30B_0EDFDAEA57CD#245723, COL_3DFBA552_A542_4794_BC37_88CC5D6F89CE#245724, COL_84EAB9BA_4929_4F06_A35A_75EBBDD474DF#245725, COL_CEB027AF_6102_4A3C_AFB2_DE67E13DE7A8#245726, COL_059CEED0_3B0A_45E5_8AB7_54AFCD242B8C#245727]
Arguments: 500000

SQL / DataFrame Properties

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