SP1 - Details for Query 271

Submitted Time: 2026/02/20 08:08:58
Duration: 1 s
Succeeded Jobs: 388 392 394

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: total (min, med, max (stageId: taskId))\n1.7 s (11 ms, 65 ms, 764 ms (stage 533.0: task 762))"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="Filter number of output rows: 7"]; 4 [labelType="html" label="ColumnarToRow number of output rows: 120,000 number of input batches: 30"]; } 5 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 1.6 s (11 ms, 65 ms, 736 ms (stage 533.0: task 762)) metadata time: 0 ms size of files read: 30.1 MiB number of output rows: 120,000"]; 2->0; 3->2; 4->3; 5->4; }

CollectLimit 500000

Project [COL_04AF725C_66A0_4299_A535_7D820A79F925#111824 AS COL_A1D0C03A_4339_4E25_8B49_C654DFC77678#112363, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111825 AS COL_3A264EBB_8F54_48A5_BA5E_4F52D8EB017E#112364, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#111826 AS COL_85C62C30_9484_4BBD_B6A8_48DCB4DEA686#112365, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#111827 AS COL_0BD23BD3_2F2B_420F_AD50_254A62C8E387#112366, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#111828 AS COL_388F69D3_FB92_4B4B_A033_EB58D5AFE8F0#112367, COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#111829 AS COL_84798013_E9C8_4FEE_BD7A_063DAFC1D47C#112368, COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#111830 AS COL_375AD705_8359_4EC0_92F9_91879C626FFD#112369, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#111831 AS COL_BCBB4157_509A_4615_BA51_E4D11A7E05A7#112370, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#111832 AS COL_4E2831FC_BA5C_4919_B07D_79AD0C0A92DB#112371, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#111833 AS COL_20187F79_DCAF_4313_BF2C_0B58F913595A#112372, COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#111834 AS COL_1FA82290_8FE1_46F9_9412_21A22E5B69E6#112373, COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#111835 AS COL_2A166975_A259_46AA_9739_035611C808C0#112374, COL_502AB66E_6815_484C_823F_962B2CAB811A#111836 AS COL_7C4FC1CC_D3C2_4B00_9D8E_C673B6028796#112375, COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#111837 AS COL_0AB0EB1F_95D6_43C9_B4B8_28EBAB55D5D6#112376, COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#111838 AS COL_3D2211FE_0230_42BF_8CE8_B87D52DC4878#112377, COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#111839 AS COL_CAF87397_E2D5_4936_814A_140F8D7D2400#112378, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#111840 AS COL_3D01BEED_50F7_4EA4_9203_C9BD09B7A5C2#112379, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#111841 AS COL_0D8DD8BA_D918_405F_BE08_C3674BEB30F6#112380, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#111842 AS COL_B8F54F11_131C_4A6C_A567_B74C988484C0#112381, COL_00AA5519_7401_4EB3_89DC_851305135F18#111843 AS COL_D5359565_BB3B_4C06_9F46_437725E74A91#112382, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#111844 AS COL_25A572B6_F419_4C4E_943A_CB61E088A488#112383, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#111845 AS COL_3DFBD9B8_79D6_4A2E_A6A3_5AD433486495#112384, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#111846 AS COL_3540B4F4_5C71_4A65_B559_7DCE74FCDBFF#112385, COL_406265B0_4BD3_49B8_A338_51729B50709C#111847 AS COL_103A3FF7_989B_4A2D_AD8E_1F9ED6A31ADB#112386, ... 22 more fields]

Filter ((COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111825 <=> ETB_LIN) AND (COL_04AF725C_66A0_4299_A535_7D820A79F925#111824 <=> I_0001119))

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_04AF725C_66A0_4299_A535_7D820A79F925#111824,COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111825,COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#111826,COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#111827,COL_3CD2052B_33C5_4457_9C30_D79AE298A405#111828,COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#111829,COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#111830,COL_4FBE155F_08B2_4439_869C_ED16CA25E269#111831,COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#111832,COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#111833,COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#111834,COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#111835,COL_502AB66E_6815_484C_823F_962B2CAB811A#111836,COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#111837,COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#111838,COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#111839,COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#111840,COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#111841,COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#111842,COL_00AA5519_7401_4EB3_89DC_851305135F18#111843,COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#111844,COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#111845,COL_2430A18C_8A40_48E8_9D35_190F0F510C94#111846,COL_406265B0_4BD3_49B8_A338_51729B50709C#111847,... 22 more fields] Batched: true, DataFilters: [(COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111825 <=> ETB_LIN), (COL_04AF725C_66A0_4299_A535_7D82..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/BIOLOGIE_ETUDE__19988], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4,ETB_LIN), EqualNullSafe(COL_04AF725C_66A0..., ReadSchema: struct<COL_04AF725C_66A0_4299_A535_7D820A79F925:string,COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4:s...

Details

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


(1) Scan parquet 
Output [46]: [COL_04AF725C_66A0_4299_A535_7D820A79F925#111824, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111825, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#111826, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#111827, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#111828, COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#111829, COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#111830, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#111831, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#111832, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#111833, COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#111834, COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#111835, COL_502AB66E_6815_484C_823F_962B2CAB811A#111836, COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#111837, COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#111838, COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#111839, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#111840, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#111841, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#111842, COL_00AA5519_7401_4EB3_89DC_851305135F18#111843, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#111844, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#111845, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#111846, COL_406265B0_4BD3_49B8_A338_51729B50709C#111847, COL_F5BE78DF_6F01_4E8F_B4B5_B5CA70A1A396#111848, COL_BD17594B_7240_401F_8602_574C180049C2#111849, COL_7BFE4DF5_15F1_4F75_B9A2_5CF7C2400C2B#111850, COL_9736E48D_3A9F_4F25_9D10_27534CD10454#111851, COL_92533CC3_4888_495A_9381_015E26FF9F56#111852, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#111853, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#111854, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#111855, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#111856, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#111857, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#111858L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#111859L, COL_3B383441_B23F_4759_A23F_2547EBED9035#111860, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#111861, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#111862, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#111863, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#111864, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#111865, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#111866, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#111867, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#111868, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#111869L]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/BIOLOGIE_ETUDE__19988]
PushedFilters: [EqualNullSafe(COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4,ETB_LIN), EqualNullSafe(COL_04AF725C_66A0_4299_A535_7D820A79F925,I_0001119)]
ReadSchema: struct<COL_04AF725C_66A0_4299_A535_7D820A79F925:string,COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4:string,COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9:string,COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53:string,COL_3CD2052B_33C5_4457_9C30_D79AE298A405:string,COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA:double,COL_D10143B3_53A3_4856_987D_3E4376BC7D0F:string,COL_4FBE155F_08B2_4439_869C_ED16CA25E269:string,COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE:string,COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9:string,COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0:string,COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A:string,COL_502AB66E_6815_484C_823F_962B2CAB811A:string,COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E:double,COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974:double,COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9:string,COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7:string,COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71:string,COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD:string,COL_00AA5519_7401_4EB3_89DC_851305135F18:string,COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5:int,COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9:timestamp,COL_2430A18C_8A40_48E8_9D35_190F0F510C94:string,COL_406265B0_4BD3_49B8_A338_51729B50709C:string,COL_F5BE78DF_6F01_4E8F_B4B5_B5CA70A1A396:int,COL_BD17594B_7240_401F_8602_574C180049C2:string,COL_7BFE4DF5_15F1_4F75_B9A2_5CF7C2400C2B:double,COL_9736E48D_3A9F_4F25_9D10_27534CD10454:double,COL_92533CC3_4888_495A_9381_015E26FF9F56:string,COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC:string,COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0:timestamp,COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE:double,COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77:double,COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E:timestamp,COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1:bigint,COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906:bigint,COL_3B383441_B23F_4759_A23F_2547EBED9035:double,COL_6A743F41_E8CE_491E_99CE_9BBC63F78493:double,COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E:double,COL_767CA1C1_2BB5_4051_821B_C868BAE49582:double,COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D:double,COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A:double,COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B:double,COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7:int,COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83:string,COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1:bigint>

(2) ColumnarToRow [codegen id : 1]
Input [46]: [COL_04AF725C_66A0_4299_A535_7D820A79F925#111824, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111825, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#111826, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#111827, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#111828, COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#111829, COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#111830, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#111831, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#111832, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#111833, COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#111834, COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#111835, COL_502AB66E_6815_484C_823F_962B2CAB811A#111836, COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#111837, COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#111838, COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#111839, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#111840, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#111841, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#111842, COL_00AA5519_7401_4EB3_89DC_851305135F18#111843, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#111844, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#111845, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#111846, COL_406265B0_4BD3_49B8_A338_51729B50709C#111847, COL_F5BE78DF_6F01_4E8F_B4B5_B5CA70A1A396#111848, COL_BD17594B_7240_401F_8602_574C180049C2#111849, COL_7BFE4DF5_15F1_4F75_B9A2_5CF7C2400C2B#111850, COL_9736E48D_3A9F_4F25_9D10_27534CD10454#111851, COL_92533CC3_4888_495A_9381_015E26FF9F56#111852, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#111853, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#111854, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#111855, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#111856, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#111857, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#111858L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#111859L, COL_3B383441_B23F_4759_A23F_2547EBED9035#111860, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#111861, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#111862, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#111863, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#111864, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#111865, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#111866, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#111867, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#111868, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#111869L]

(3) Filter [codegen id : 1]
Input [46]: [COL_04AF725C_66A0_4299_A535_7D820A79F925#111824, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111825, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#111826, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#111827, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#111828, COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#111829, COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#111830, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#111831, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#111832, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#111833, COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#111834, COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#111835, COL_502AB66E_6815_484C_823F_962B2CAB811A#111836, COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#111837, COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#111838, COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#111839, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#111840, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#111841, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#111842, COL_00AA5519_7401_4EB3_89DC_851305135F18#111843, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#111844, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#111845, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#111846, COL_406265B0_4BD3_49B8_A338_51729B50709C#111847, COL_F5BE78DF_6F01_4E8F_B4B5_B5CA70A1A396#111848, COL_BD17594B_7240_401F_8602_574C180049C2#111849, COL_7BFE4DF5_15F1_4F75_B9A2_5CF7C2400C2B#111850, COL_9736E48D_3A9F_4F25_9D10_27534CD10454#111851, COL_92533CC3_4888_495A_9381_015E26FF9F56#111852, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#111853, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#111854, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#111855, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#111856, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#111857, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#111858L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#111859L, COL_3B383441_B23F_4759_A23F_2547EBED9035#111860, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#111861, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#111862, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#111863, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#111864, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#111865, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#111866, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#111867, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#111868, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#111869L]
Condition : ((COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111825 <=> ETB_LIN) AND (COL_04AF725C_66A0_4299_A535_7D820A79F925#111824 <=> I_0001119))

(4) Project [codegen id : 1]
Output [46]: [COL_04AF725C_66A0_4299_A535_7D820A79F925#111824 AS COL_A1D0C03A_4339_4E25_8B49_C654DFC77678#112363, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111825 AS COL_3A264EBB_8F54_48A5_BA5E_4F52D8EB017E#112364, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#111826 AS COL_85C62C30_9484_4BBD_B6A8_48DCB4DEA686#112365, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#111827 AS COL_0BD23BD3_2F2B_420F_AD50_254A62C8E387#112366, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#111828 AS COL_388F69D3_FB92_4B4B_A033_EB58D5AFE8F0#112367, COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#111829 AS COL_84798013_E9C8_4FEE_BD7A_063DAFC1D47C#112368, COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#111830 AS COL_375AD705_8359_4EC0_92F9_91879C626FFD#112369, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#111831 AS COL_BCBB4157_509A_4615_BA51_E4D11A7E05A7#112370, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#111832 AS COL_4E2831FC_BA5C_4919_B07D_79AD0C0A92DB#112371, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#111833 AS COL_20187F79_DCAF_4313_BF2C_0B58F913595A#112372, COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#111834 AS COL_1FA82290_8FE1_46F9_9412_21A22E5B69E6#112373, COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#111835 AS COL_2A166975_A259_46AA_9739_035611C808C0#112374, COL_502AB66E_6815_484C_823F_962B2CAB811A#111836 AS COL_7C4FC1CC_D3C2_4B00_9D8E_C673B6028796#112375, COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#111837 AS COL_0AB0EB1F_95D6_43C9_B4B8_28EBAB55D5D6#112376, COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#111838 AS COL_3D2211FE_0230_42BF_8CE8_B87D52DC4878#112377, COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#111839 AS COL_CAF87397_E2D5_4936_814A_140F8D7D2400#112378, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#111840 AS COL_3D01BEED_50F7_4EA4_9203_C9BD09B7A5C2#112379, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#111841 AS COL_0D8DD8BA_D918_405F_BE08_C3674BEB30F6#112380, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#111842 AS COL_B8F54F11_131C_4A6C_A567_B74C988484C0#112381, COL_00AA5519_7401_4EB3_89DC_851305135F18#111843 AS COL_D5359565_BB3B_4C06_9F46_437725E74A91#112382, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#111844 AS COL_25A572B6_F419_4C4E_943A_CB61E088A488#112383, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#111845 AS COL_3DFBD9B8_79D6_4A2E_A6A3_5AD433486495#112384, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#111846 AS COL_3540B4F4_5C71_4A65_B559_7DCE74FCDBFF#112385, COL_406265B0_4BD3_49B8_A338_51729B50709C#111847 AS COL_103A3FF7_989B_4A2D_AD8E_1F9ED6A31ADB#112386, COL_F5BE78DF_6F01_4E8F_B4B5_B5CA70A1A396#111848 AS COL_08D816B3_36AD_4123_BF7F_2AA16DA01C99#112387, COL_BD17594B_7240_401F_8602_574C180049C2#111849 AS COL_884EA5A4_CF83_49F2_AA82_38411966175F#112388, COL_7BFE4DF5_15F1_4F75_B9A2_5CF7C2400C2B#111850 AS COL_8862E33B_B501_4DBC_8194_85D8C9F849B4#112389, COL_9736E48D_3A9F_4F25_9D10_27534CD10454#111851 AS COL_6F258506_692C_48C2_8241_14A7DE2A6ECE#112390, COL_92533CC3_4888_495A_9381_015E26FF9F56#111852 AS COL_13B7735F_2B4A_40C6_9421_5D9FB5E1F94D#112391, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#111853 AS COL_66874688_7AF0_47ED_827F_52327DD29257#112392, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#111854 AS COL_1CCDF33E_9945_4885_BC84_330CD300BE3F#112393, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#111855 AS COL_83AB12EA_2FB4_4D75_814A_B63AFE996676#112394, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#111856 AS COL_94FE3BC9_34E1_4080_8C86_9090CCB4A565#112395, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#111857 AS COL_C6967E9E_FB7D_4B54_907E_1B3D2DEC1017#112396, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#111858L AS COL_DC8084C9_5A89_454E_9995_2C8F8906F245#112397L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#111859L AS COL_093A1653_9F0E_4D11_BA2B_F224601AD4FB#112398L, COL_3B383441_B23F_4759_A23F_2547EBED9035#111860 AS COL_0488006A_B1BA_4252_BCAD_1D70A2CB411A#112399, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#111861 AS COL_B1CB41ED_BF24_4E74_AA3B_6FE90EB28315#112400, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#111862 AS COL_D8415781_91FE_46A9_AEF7_171F11B8EF63#112401, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#111863 AS COL_DA5E0478_2E3E_4569_947F_6989CB4AABDF#112402, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#111864 AS COL_87BCEA6C_4187_46EC_917C_FB5409891FE2#112403, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#111865 AS COL_BB797946_B964_4ACD_B6CC_4DD48F06B208#112404, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#111866 AS COL_CCFFAD51_1822_4970_AB87_AB552494EF39#112405, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#111867 AS COL_4659222D_359F_48D0_9B2A_ED0D8FC0C42D#112406, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#111868 AS COL_B796E419_20C8_4626_8EFF_5623C6DB3E8E#112407, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#111869L AS COL_6A02C496_6818_49E7_801D_202F6C2FBCB7#112408L]
Input [46]: [COL_04AF725C_66A0_4299_A535_7D820A79F925#111824, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111825, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#111826, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#111827, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#111828, COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#111829, COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#111830, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#111831, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#111832, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#111833, COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#111834, COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#111835, COL_502AB66E_6815_484C_823F_962B2CAB811A#111836, COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#111837, COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#111838, COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#111839, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#111840, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#111841, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#111842, COL_00AA5519_7401_4EB3_89DC_851305135F18#111843, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#111844, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#111845, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#111846, COL_406265B0_4BD3_49B8_A338_51729B50709C#111847, COL_F5BE78DF_6F01_4E8F_B4B5_B5CA70A1A396#111848, COL_BD17594B_7240_401F_8602_574C180049C2#111849, COL_7BFE4DF5_15F1_4F75_B9A2_5CF7C2400C2B#111850, COL_9736E48D_3A9F_4F25_9D10_27534CD10454#111851, COL_92533CC3_4888_495A_9381_015E26FF9F56#111852, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#111853, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#111854, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#111855, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#111856, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#111857, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#111858L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#111859L, COL_3B383441_B23F_4759_A23F_2547EBED9035#111860, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#111861, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#111862, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#111863, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#111864, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#111865, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#111866, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#111867, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#111868, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#111869L]

(5) CollectLimit
Input [46]: [COL_A1D0C03A_4339_4E25_8B49_C654DFC77678#112363, COL_3A264EBB_8F54_48A5_BA5E_4F52D8EB017E#112364, COL_85C62C30_9484_4BBD_B6A8_48DCB4DEA686#112365, COL_0BD23BD3_2F2B_420F_AD50_254A62C8E387#112366, COL_388F69D3_FB92_4B4B_A033_EB58D5AFE8F0#112367, COL_84798013_E9C8_4FEE_BD7A_063DAFC1D47C#112368, COL_375AD705_8359_4EC0_92F9_91879C626FFD#112369, COL_BCBB4157_509A_4615_BA51_E4D11A7E05A7#112370, COL_4E2831FC_BA5C_4919_B07D_79AD0C0A92DB#112371, COL_20187F79_DCAF_4313_BF2C_0B58F913595A#112372, COL_1FA82290_8FE1_46F9_9412_21A22E5B69E6#112373, COL_2A166975_A259_46AA_9739_035611C808C0#112374, COL_7C4FC1CC_D3C2_4B00_9D8E_C673B6028796#112375, COL_0AB0EB1F_95D6_43C9_B4B8_28EBAB55D5D6#112376, COL_3D2211FE_0230_42BF_8CE8_B87D52DC4878#112377, COL_CAF87397_E2D5_4936_814A_140F8D7D2400#112378, COL_3D01BEED_50F7_4EA4_9203_C9BD09B7A5C2#112379, COL_0D8DD8BA_D918_405F_BE08_C3674BEB30F6#112380, COL_B8F54F11_131C_4A6C_A567_B74C988484C0#112381, COL_D5359565_BB3B_4C06_9F46_437725E74A91#112382, COL_25A572B6_F419_4C4E_943A_CB61E088A488#112383, COL_3DFBD9B8_79D6_4A2E_A6A3_5AD433486495#112384, COL_3540B4F4_5C71_4A65_B559_7DCE74FCDBFF#112385, COL_103A3FF7_989B_4A2D_AD8E_1F9ED6A31ADB#112386, COL_08D816B3_36AD_4123_BF7F_2AA16DA01C99#112387, COL_884EA5A4_CF83_49F2_AA82_38411966175F#112388, COL_8862E33B_B501_4DBC_8194_85D8C9F849B4#112389, COL_6F258506_692C_48C2_8241_14A7DE2A6ECE#112390, COL_13B7735F_2B4A_40C6_9421_5D9FB5E1F94D#112391, COL_66874688_7AF0_47ED_827F_52327DD29257#112392, COL_1CCDF33E_9945_4885_BC84_330CD300BE3F#112393, COL_83AB12EA_2FB4_4D75_814A_B63AFE996676#112394, COL_94FE3BC9_34E1_4080_8C86_9090CCB4A565#112395, COL_C6967E9E_FB7D_4B54_907E_1B3D2DEC1017#112396, COL_DC8084C9_5A89_454E_9995_2C8F8906F245#112397L, COL_093A1653_9F0E_4D11_BA2B_F224601AD4FB#112398L, COL_0488006A_B1BA_4252_BCAD_1D70A2CB411A#112399, COL_B1CB41ED_BF24_4E74_AA3B_6FE90EB28315#112400, COL_D8415781_91FE_46A9_AEF7_171F11B8EF63#112401, COL_DA5E0478_2E3E_4569_947F_6989CB4AABDF#112402, COL_87BCEA6C_4187_46EC_917C_FB5409891FE2#112403, COL_BB797946_B964_4ACD_B6CC_4DD48F06B208#112404, COL_CCFFAD51_1822_4970_AB87_AB552494EF39#112405, COL_4659222D_359F_48D0_9B2A_ED0D8FC0C42D#112406, COL_B796E419_20C8_4626_8EFF_5623C6DB3E8E#112407, COL_6A02C496_6818_49E7_801D_202F6C2FBCB7#112408L]
Arguments: 500000

SQL / DataFrame Properties

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