SP1 - Details for Query 683

Submitted Time: 2026/02/24 09:29:01
Duration: 0.9 s
Succeeded Jobs: 875 877 880

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.2 s (30 ms, 69 ms, 436 ms (stage 1156.0: task 1612))"; 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.1 s (30 ms, 68 ms, 413 ms (stage 1156.0: task 1612)) 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#212225 AS COL_A1D0C03A_4339_4E25_8B49_C654DFC77678#212501, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#212226 AS COL_3A264EBB_8F54_48A5_BA5E_4F52D8EB017E#212502, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#212227 AS COL_85C62C30_9484_4BBD_B6A8_48DCB4DEA686#212503, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#212228 AS COL_0BD23BD3_2F2B_420F_AD50_254A62C8E387#212504, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#212229 AS COL_388F69D3_FB92_4B4B_A033_EB58D5AFE8F0#212505, COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#212230 AS COL_84798013_E9C8_4FEE_BD7A_063DAFC1D47C#212506, COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#212231 AS COL_375AD705_8359_4EC0_92F9_91879C626FFD#212507, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#212232 AS COL_BCBB4157_509A_4615_BA51_E4D11A7E05A7#212508, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#212233 AS COL_4E2831FC_BA5C_4919_B07D_79AD0C0A92DB#212509, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#212234 AS COL_20187F79_DCAF_4313_BF2C_0B58F913595A#212510, COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#212235 AS COL_1FA82290_8FE1_46F9_9412_21A22E5B69E6#212511, COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#212236 AS COL_2A166975_A259_46AA_9739_035611C808C0#212512, COL_502AB66E_6815_484C_823F_962B2CAB811A#212237 AS COL_7C4FC1CC_D3C2_4B00_9D8E_C673B6028796#212513, COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#212238 AS COL_0AB0EB1F_95D6_43C9_B4B8_28EBAB55D5D6#212514, COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#212239 AS COL_3D2211FE_0230_42BF_8CE8_B87D52DC4878#212515, COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#212240 AS COL_CAF87397_E2D5_4936_814A_140F8D7D2400#212516, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#212241 AS COL_3D01BEED_50F7_4EA4_9203_C9BD09B7A5C2#212517, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#212242 AS COL_0D8DD8BA_D918_405F_BE08_C3674BEB30F6#212518, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#212243 AS COL_B8F54F11_131C_4A6C_A567_B74C988484C0#212519, COL_00AA5519_7401_4EB3_89DC_851305135F18#212244 AS COL_D5359565_BB3B_4C06_9F46_437725E74A91#212520, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#212245 AS COL_25A572B6_F419_4C4E_943A_CB61E088A488#212521, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#212246 AS COL_3DFBD9B8_79D6_4A2E_A6A3_5AD433486495#212522, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#212247 AS COL_3540B4F4_5C71_4A65_B559_7DCE74FCDBFF#212523, COL_406265B0_4BD3_49B8_A338_51729B50709C#212248 AS COL_103A3FF7_989B_4A2D_AD8E_1F9ED6A31ADB#212524, ... 22 more fields]

Filter ((COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#212226 <=> ETB_LIN) AND (COL_04AF725C_66A0_4299_A535_7D820A79F925#212225 <=> I_0001119))

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_04AF725C_66A0_4299_A535_7D820A79F925#212225,COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#212226,COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#212227,COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#212228,COL_3CD2052B_33C5_4457_9C30_D79AE298A405#212229,COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#212230,COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#212231,COL_4FBE155F_08B2_4439_869C_ED16CA25E269#212232,COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#212233,COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#212234,COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#212235,COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#212236,COL_502AB66E_6815_484C_823F_962B2CAB811A#212237,COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#212238,COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#212239,COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#212240,COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#212241,COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#212242,COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#212243,COL_00AA5519_7401_4EB3_89DC_851305135F18#212244,COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#212245,COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#212246,COL_2430A18C_8A40_48E8_9D35_190F0F510C94#212247,COL_406265B0_4BD3_49B8_A338_51729B50709C#212248,... 22 more fields] Batched: true, DataFilters: [(COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#212226 <=> 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#212225, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#212226, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#212227, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#212228, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#212229, COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#212230, COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#212231, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#212232, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#212233, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#212234, COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#212235, COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#212236, COL_502AB66E_6815_484C_823F_962B2CAB811A#212237, COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#212238, COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#212239, COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#212240, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#212241, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#212242, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#212243, COL_00AA5519_7401_4EB3_89DC_851305135F18#212244, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#212245, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#212246, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#212247, COL_406265B0_4BD3_49B8_A338_51729B50709C#212248, COL_F5BE78DF_6F01_4E8F_B4B5_B5CA70A1A396#212249, COL_BD17594B_7240_401F_8602_574C180049C2#212250, COL_7BFE4DF5_15F1_4F75_B9A2_5CF7C2400C2B#212251, COL_9736E48D_3A9F_4F25_9D10_27534CD10454#212252, COL_92533CC3_4888_495A_9381_015E26FF9F56#212253, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#212254, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#212255, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#212256, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#212257, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#212258, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#212259L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#212260L, COL_3B383441_B23F_4759_A23F_2547EBED9035#212261, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#212262, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#212263, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#212264, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#212265, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#212266, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#212267, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#212268, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#212269, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#212270L]
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#212225, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#212226, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#212227, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#212228, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#212229, COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#212230, COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#212231, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#212232, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#212233, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#212234, COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#212235, COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#212236, COL_502AB66E_6815_484C_823F_962B2CAB811A#212237, COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#212238, COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#212239, COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#212240, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#212241, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#212242, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#212243, COL_00AA5519_7401_4EB3_89DC_851305135F18#212244, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#212245, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#212246, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#212247, COL_406265B0_4BD3_49B8_A338_51729B50709C#212248, COL_F5BE78DF_6F01_4E8F_B4B5_B5CA70A1A396#212249, COL_BD17594B_7240_401F_8602_574C180049C2#212250, COL_7BFE4DF5_15F1_4F75_B9A2_5CF7C2400C2B#212251, COL_9736E48D_3A9F_4F25_9D10_27534CD10454#212252, COL_92533CC3_4888_495A_9381_015E26FF9F56#212253, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#212254, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#212255, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#212256, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#212257, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#212258, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#212259L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#212260L, COL_3B383441_B23F_4759_A23F_2547EBED9035#212261, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#212262, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#212263, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#212264, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#212265, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#212266, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#212267, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#212268, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#212269, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#212270L]

(3) Filter [codegen id : 1]
Input [46]: [COL_04AF725C_66A0_4299_A535_7D820A79F925#212225, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#212226, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#212227, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#212228, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#212229, COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#212230, COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#212231, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#212232, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#212233, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#212234, COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#212235, COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#212236, COL_502AB66E_6815_484C_823F_962B2CAB811A#212237, COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#212238, COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#212239, COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#212240, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#212241, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#212242, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#212243, COL_00AA5519_7401_4EB3_89DC_851305135F18#212244, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#212245, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#212246, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#212247, COL_406265B0_4BD3_49B8_A338_51729B50709C#212248, COL_F5BE78DF_6F01_4E8F_B4B5_B5CA70A1A396#212249, COL_BD17594B_7240_401F_8602_574C180049C2#212250, COL_7BFE4DF5_15F1_4F75_B9A2_5CF7C2400C2B#212251, COL_9736E48D_3A9F_4F25_9D10_27534CD10454#212252, COL_92533CC3_4888_495A_9381_015E26FF9F56#212253, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#212254, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#212255, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#212256, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#212257, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#212258, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#212259L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#212260L, COL_3B383441_B23F_4759_A23F_2547EBED9035#212261, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#212262, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#212263, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#212264, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#212265, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#212266, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#212267, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#212268, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#212269, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#212270L]
Condition : ((COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#212226 <=> ETB_LIN) AND (COL_04AF725C_66A0_4299_A535_7D820A79F925#212225 <=> I_0001119))

(4) Project [codegen id : 1]
Output [46]: [COL_04AF725C_66A0_4299_A535_7D820A79F925#212225 AS COL_A1D0C03A_4339_4E25_8B49_C654DFC77678#212501, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#212226 AS COL_3A264EBB_8F54_48A5_BA5E_4F52D8EB017E#212502, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#212227 AS COL_85C62C30_9484_4BBD_B6A8_48DCB4DEA686#212503, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#212228 AS COL_0BD23BD3_2F2B_420F_AD50_254A62C8E387#212504, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#212229 AS COL_388F69D3_FB92_4B4B_A033_EB58D5AFE8F0#212505, COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#212230 AS COL_84798013_E9C8_4FEE_BD7A_063DAFC1D47C#212506, COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#212231 AS COL_375AD705_8359_4EC0_92F9_91879C626FFD#212507, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#212232 AS COL_BCBB4157_509A_4615_BA51_E4D11A7E05A7#212508, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#212233 AS COL_4E2831FC_BA5C_4919_B07D_79AD0C0A92DB#212509, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#212234 AS COL_20187F79_DCAF_4313_BF2C_0B58F913595A#212510, COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#212235 AS COL_1FA82290_8FE1_46F9_9412_21A22E5B69E6#212511, COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#212236 AS COL_2A166975_A259_46AA_9739_035611C808C0#212512, COL_502AB66E_6815_484C_823F_962B2CAB811A#212237 AS COL_7C4FC1CC_D3C2_4B00_9D8E_C673B6028796#212513, COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#212238 AS COL_0AB0EB1F_95D6_43C9_B4B8_28EBAB55D5D6#212514, COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#212239 AS COL_3D2211FE_0230_42BF_8CE8_B87D52DC4878#212515, COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#212240 AS COL_CAF87397_E2D5_4936_814A_140F8D7D2400#212516, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#212241 AS COL_3D01BEED_50F7_4EA4_9203_C9BD09B7A5C2#212517, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#212242 AS COL_0D8DD8BA_D918_405F_BE08_C3674BEB30F6#212518, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#212243 AS COL_B8F54F11_131C_4A6C_A567_B74C988484C0#212519, COL_00AA5519_7401_4EB3_89DC_851305135F18#212244 AS COL_D5359565_BB3B_4C06_9F46_437725E74A91#212520, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#212245 AS COL_25A572B6_F419_4C4E_943A_CB61E088A488#212521, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#212246 AS COL_3DFBD9B8_79D6_4A2E_A6A3_5AD433486495#212522, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#212247 AS COL_3540B4F4_5C71_4A65_B559_7DCE74FCDBFF#212523, COL_406265B0_4BD3_49B8_A338_51729B50709C#212248 AS COL_103A3FF7_989B_4A2D_AD8E_1F9ED6A31ADB#212524, COL_F5BE78DF_6F01_4E8F_B4B5_B5CA70A1A396#212249 AS COL_08D816B3_36AD_4123_BF7F_2AA16DA01C99#212525, COL_BD17594B_7240_401F_8602_574C180049C2#212250 AS COL_884EA5A4_CF83_49F2_AA82_38411966175F#212526, COL_7BFE4DF5_15F1_4F75_B9A2_5CF7C2400C2B#212251 AS COL_8862E33B_B501_4DBC_8194_85D8C9F849B4#212527, COL_9736E48D_3A9F_4F25_9D10_27534CD10454#212252 AS COL_6F258506_692C_48C2_8241_14A7DE2A6ECE#212528, COL_92533CC3_4888_495A_9381_015E26FF9F56#212253 AS COL_13B7735F_2B4A_40C6_9421_5D9FB5E1F94D#212529, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#212254 AS COL_66874688_7AF0_47ED_827F_52327DD29257#212530, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#212255 AS COL_1CCDF33E_9945_4885_BC84_330CD300BE3F#212531, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#212256 AS COL_83AB12EA_2FB4_4D75_814A_B63AFE996676#212532, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#212257 AS COL_94FE3BC9_34E1_4080_8C86_9090CCB4A565#212533, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#212258 AS COL_C6967E9E_FB7D_4B54_907E_1B3D2DEC1017#212534, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#212259L AS COL_DC8084C9_5A89_454E_9995_2C8F8906F245#212535L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#212260L AS COL_093A1653_9F0E_4D11_BA2B_F224601AD4FB#212536L, COL_3B383441_B23F_4759_A23F_2547EBED9035#212261 AS COL_0488006A_B1BA_4252_BCAD_1D70A2CB411A#212537, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#212262 AS COL_B1CB41ED_BF24_4E74_AA3B_6FE90EB28315#212538, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#212263 AS COL_D8415781_91FE_46A9_AEF7_171F11B8EF63#212539, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#212264 AS COL_DA5E0478_2E3E_4569_947F_6989CB4AABDF#212540, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#212265 AS COL_87BCEA6C_4187_46EC_917C_FB5409891FE2#212541, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#212266 AS COL_BB797946_B964_4ACD_B6CC_4DD48F06B208#212542, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#212267 AS COL_CCFFAD51_1822_4970_AB87_AB552494EF39#212543, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#212268 AS COL_4659222D_359F_48D0_9B2A_ED0D8FC0C42D#212544, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#212269 AS COL_B796E419_20C8_4626_8EFF_5623C6DB3E8E#212545, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#212270L AS COL_6A02C496_6818_49E7_801D_202F6C2FBCB7#212546L]
Input [46]: [COL_04AF725C_66A0_4299_A535_7D820A79F925#212225, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#212226, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#212227, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#212228, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#212229, COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#212230, COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#212231, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#212232, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#212233, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#212234, COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#212235, COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#212236, COL_502AB66E_6815_484C_823F_962B2CAB811A#212237, COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#212238, COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#212239, COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#212240, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#212241, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#212242, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#212243, COL_00AA5519_7401_4EB3_89DC_851305135F18#212244, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#212245, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#212246, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#212247, COL_406265B0_4BD3_49B8_A338_51729B50709C#212248, COL_F5BE78DF_6F01_4E8F_B4B5_B5CA70A1A396#212249, COL_BD17594B_7240_401F_8602_574C180049C2#212250, COL_7BFE4DF5_15F1_4F75_B9A2_5CF7C2400C2B#212251, COL_9736E48D_3A9F_4F25_9D10_27534CD10454#212252, COL_92533CC3_4888_495A_9381_015E26FF9F56#212253, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#212254, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#212255, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#212256, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#212257, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#212258, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#212259L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#212260L, COL_3B383441_B23F_4759_A23F_2547EBED9035#212261, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#212262, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#212263, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#212264, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#212265, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#212266, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#212267, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#212268, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#212269, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#212270L]

(5) CollectLimit
Input [46]: [COL_A1D0C03A_4339_4E25_8B49_C654DFC77678#212501, COL_3A264EBB_8F54_48A5_BA5E_4F52D8EB017E#212502, COL_85C62C30_9484_4BBD_B6A8_48DCB4DEA686#212503, COL_0BD23BD3_2F2B_420F_AD50_254A62C8E387#212504, COL_388F69D3_FB92_4B4B_A033_EB58D5AFE8F0#212505, COL_84798013_E9C8_4FEE_BD7A_063DAFC1D47C#212506, COL_375AD705_8359_4EC0_92F9_91879C626FFD#212507, COL_BCBB4157_509A_4615_BA51_E4D11A7E05A7#212508, COL_4E2831FC_BA5C_4919_B07D_79AD0C0A92DB#212509, COL_20187F79_DCAF_4313_BF2C_0B58F913595A#212510, COL_1FA82290_8FE1_46F9_9412_21A22E5B69E6#212511, COL_2A166975_A259_46AA_9739_035611C808C0#212512, COL_7C4FC1CC_D3C2_4B00_9D8E_C673B6028796#212513, COL_0AB0EB1F_95D6_43C9_B4B8_28EBAB55D5D6#212514, COL_3D2211FE_0230_42BF_8CE8_B87D52DC4878#212515, COL_CAF87397_E2D5_4936_814A_140F8D7D2400#212516, COL_3D01BEED_50F7_4EA4_9203_C9BD09B7A5C2#212517, COL_0D8DD8BA_D918_405F_BE08_C3674BEB30F6#212518, COL_B8F54F11_131C_4A6C_A567_B74C988484C0#212519, COL_D5359565_BB3B_4C06_9F46_437725E74A91#212520, COL_25A572B6_F419_4C4E_943A_CB61E088A488#212521, COL_3DFBD9B8_79D6_4A2E_A6A3_5AD433486495#212522, COL_3540B4F4_5C71_4A65_B559_7DCE74FCDBFF#212523, COL_103A3FF7_989B_4A2D_AD8E_1F9ED6A31ADB#212524, COL_08D816B3_36AD_4123_BF7F_2AA16DA01C99#212525, COL_884EA5A4_CF83_49F2_AA82_38411966175F#212526, COL_8862E33B_B501_4DBC_8194_85D8C9F849B4#212527, COL_6F258506_692C_48C2_8241_14A7DE2A6ECE#212528, COL_13B7735F_2B4A_40C6_9421_5D9FB5E1F94D#212529, COL_66874688_7AF0_47ED_827F_52327DD29257#212530, COL_1CCDF33E_9945_4885_BC84_330CD300BE3F#212531, COL_83AB12EA_2FB4_4D75_814A_B63AFE996676#212532, COL_94FE3BC9_34E1_4080_8C86_9090CCB4A565#212533, COL_C6967E9E_FB7D_4B54_907E_1B3D2DEC1017#212534, COL_DC8084C9_5A89_454E_9995_2C8F8906F245#212535L, COL_093A1653_9F0E_4D11_BA2B_F224601AD4FB#212536L, COL_0488006A_B1BA_4252_BCAD_1D70A2CB411A#212537, COL_B1CB41ED_BF24_4E74_AA3B_6FE90EB28315#212538, COL_D8415781_91FE_46A9_AEF7_171F11B8EF63#212539, COL_DA5E0478_2E3E_4569_947F_6989CB4AABDF#212540, COL_87BCEA6C_4187_46EC_917C_FB5409891FE2#212541, COL_BB797946_B964_4ACD_B6CC_4DD48F06B208#212542, COL_CCFFAD51_1822_4970_AB87_AB552494EF39#212543, COL_4659222D_359F_48D0_9B2A_ED0D8FC0C42D#212544, COL_B796E419_20C8_4626_8EFF_5623C6DB3E8E#212545, COL_6A02C496_6818_49E7_801D_202F6C2FBCB7#212546L]
Arguments: 500000

SQL / DataFrame Properties

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