SP1 - Details for Query 272

Submitted Time: 2026/02/20 08:08:58
Duration: 1 s
Succeeded Jobs: 389 391 395

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 (9 ms, 56 ms, 740 ms (stage 534.0: task 767))"; 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 (9 ms, 56 ms, 720 ms (stage 534.0: task 767)) 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#112778 AS COL_4E2F6DCD_755F_436B_A6D2_B62E29D38EAD#113528, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#112779 AS COL_B759B06F_EA1B_499D_A598_5008DBC83272#113529, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#112780 AS COL_90E0A81D_6EA1_4BE9_A698_51B3C872D1C6#113530, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#112781 AS COL_3109A72F_3A51_4901_846A_5E2101FD1DD9#113531, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#112782 AS COL_FD9702D1_C2BC_436B_9930_ACBCA7CAB3F5#113532, COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#112783 AS COL_87D0C45E_C323_4FA2_9095_E90865D3C8B4#113533, COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#112784 AS COL_1F3C5BA7_6A4A_46A9_AB6E_E6AB09562414#113534, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#112785 AS COL_FFDFAA98_DB8D_498C_9717_962EEFCF0BB3#113535, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#112786 AS COL_22941F2A_EE67_4B34_9C50_152189E04655#113536, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#112787 AS COL_F301E992_209D_40C5_9B37_0C5E5F1C355A#113537, COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#112788 AS COL_4EA2D8C1_4BA1_4AA8_A39A_2016C922D5F9#113538, COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#112789 AS COL_4EACFAB7_A3A4_47D9_8047_256D0643F4DC#113539, COL_502AB66E_6815_484C_823F_962B2CAB811A#112790 AS COL_5450E903_34DE_458E_81F6_40B9410DDA86#113540, COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#112791 AS COL_1E002AB6_5374_4035_9505_EFE020F02FA0#113541, COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#112792 AS COL_F9538688_667A_4775_8B0B_1F7BB072839A#113542, COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#112793 AS COL_94CB97DB_94EF_4F2E_BBB1_76FA2361F78B#113543, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#112794 AS COL_7AB609F7_8C71_4E92_A54A_C58B0F9280D0#113544, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#112795 AS COL_52C43B5C_550B_4BB4_B798_658B3539F08E#113545, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#112796 AS COL_44D2D66A_C50F_4A81_827E_73442AB7D314#113546, COL_00AA5519_7401_4EB3_89DC_851305135F18#112797 AS COL_37B3ABAC_1D72_4AFB_B0FA_8A3221B2CB37#113547, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#112798 AS COL_3973A4D6_3570_4EE4_A8A5_6E6CA78520FE#113548, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#112799 AS COL_625EC208_B143_4FBA_BF28_F1DB698CCE25#113549, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#112800 AS COL_0BA50281_C907_4445_A70B_47A230B2E77C#113550, COL_406265B0_4BD3_49B8_A338_51729B50709C#112801 AS COL_B58E4264_1752_4CE9_B798_E1B6020C9DFC#113551, ... 22 more fields]

Filter ((COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#112779 <=> ETB_LIN) AND (COL_04AF725C_66A0_4299_A535_7D820A79F925#112778 <=> I_0001119))

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_04AF725C_66A0_4299_A535_7D820A79F925#112778,COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#112779,COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#112780,COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#112781,COL_3CD2052B_33C5_4457_9C30_D79AE298A405#112782,COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#112783,COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#112784,COL_4FBE155F_08B2_4439_869C_ED16CA25E269#112785,COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#112786,COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#112787,COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#112788,COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#112789,COL_502AB66E_6815_484C_823F_962B2CAB811A#112790,COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#112791,COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#112792,COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#112793,COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#112794,COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#112795,COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#112796,COL_00AA5519_7401_4EB3_89DC_851305135F18#112797,COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#112798,COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#112799,COL_2430A18C_8A40_48E8_9D35_190F0F510C94#112800,COL_406265B0_4BD3_49B8_A338_51729B50709C#112801,... 22 more fields] Batched: true, DataFilters: [(COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#112779 <=> 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#112778, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#112779, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#112780, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#112781, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#112782, COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#112783, COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#112784, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#112785, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#112786, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#112787, COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#112788, COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#112789, COL_502AB66E_6815_484C_823F_962B2CAB811A#112790, COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#112791, COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#112792, COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#112793, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#112794, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#112795, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#112796, COL_00AA5519_7401_4EB3_89DC_851305135F18#112797, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#112798, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#112799, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#112800, COL_406265B0_4BD3_49B8_A338_51729B50709C#112801, COL_F5BE78DF_6F01_4E8F_B4B5_B5CA70A1A396#112802, COL_BD17594B_7240_401F_8602_574C180049C2#112803, COL_7BFE4DF5_15F1_4F75_B9A2_5CF7C2400C2B#112804, COL_9736E48D_3A9F_4F25_9D10_27534CD10454#112805, COL_92533CC3_4888_495A_9381_015E26FF9F56#112806, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#112807, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#112808, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#112809, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#112810, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#112811, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#112812L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#112813L, COL_3B383441_B23F_4759_A23F_2547EBED9035#112814, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#112815, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#112816, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#112817, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#112818, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#112819, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#112820, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#112821, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#112822, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#112823L]
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#112778, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#112779, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#112780, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#112781, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#112782, COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#112783, COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#112784, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#112785, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#112786, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#112787, COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#112788, COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#112789, COL_502AB66E_6815_484C_823F_962B2CAB811A#112790, COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#112791, COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#112792, COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#112793, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#112794, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#112795, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#112796, COL_00AA5519_7401_4EB3_89DC_851305135F18#112797, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#112798, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#112799, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#112800, COL_406265B0_4BD3_49B8_A338_51729B50709C#112801, COL_F5BE78DF_6F01_4E8F_B4B5_B5CA70A1A396#112802, COL_BD17594B_7240_401F_8602_574C180049C2#112803, COL_7BFE4DF5_15F1_4F75_B9A2_5CF7C2400C2B#112804, COL_9736E48D_3A9F_4F25_9D10_27534CD10454#112805, COL_92533CC3_4888_495A_9381_015E26FF9F56#112806, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#112807, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#112808, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#112809, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#112810, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#112811, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#112812L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#112813L, COL_3B383441_B23F_4759_A23F_2547EBED9035#112814, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#112815, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#112816, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#112817, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#112818, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#112819, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#112820, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#112821, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#112822, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#112823L]

(3) Filter [codegen id : 1]
Input [46]: [COL_04AF725C_66A0_4299_A535_7D820A79F925#112778, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#112779, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#112780, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#112781, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#112782, COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#112783, COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#112784, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#112785, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#112786, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#112787, COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#112788, COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#112789, COL_502AB66E_6815_484C_823F_962B2CAB811A#112790, COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#112791, COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#112792, COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#112793, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#112794, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#112795, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#112796, COL_00AA5519_7401_4EB3_89DC_851305135F18#112797, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#112798, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#112799, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#112800, COL_406265B0_4BD3_49B8_A338_51729B50709C#112801, COL_F5BE78DF_6F01_4E8F_B4B5_B5CA70A1A396#112802, COL_BD17594B_7240_401F_8602_574C180049C2#112803, COL_7BFE4DF5_15F1_4F75_B9A2_5CF7C2400C2B#112804, COL_9736E48D_3A9F_4F25_9D10_27534CD10454#112805, COL_92533CC3_4888_495A_9381_015E26FF9F56#112806, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#112807, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#112808, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#112809, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#112810, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#112811, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#112812L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#112813L, COL_3B383441_B23F_4759_A23F_2547EBED9035#112814, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#112815, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#112816, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#112817, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#112818, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#112819, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#112820, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#112821, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#112822, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#112823L]
Condition : ((COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#112779 <=> ETB_LIN) AND (COL_04AF725C_66A0_4299_A535_7D820A79F925#112778 <=> I_0001119))

(4) Project [codegen id : 1]
Output [46]: [COL_04AF725C_66A0_4299_A535_7D820A79F925#112778 AS COL_4E2F6DCD_755F_436B_A6D2_B62E29D38EAD#113528, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#112779 AS COL_B759B06F_EA1B_499D_A598_5008DBC83272#113529, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#112780 AS COL_90E0A81D_6EA1_4BE9_A698_51B3C872D1C6#113530, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#112781 AS COL_3109A72F_3A51_4901_846A_5E2101FD1DD9#113531, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#112782 AS COL_FD9702D1_C2BC_436B_9930_ACBCA7CAB3F5#113532, COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#112783 AS COL_87D0C45E_C323_4FA2_9095_E90865D3C8B4#113533, COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#112784 AS COL_1F3C5BA7_6A4A_46A9_AB6E_E6AB09562414#113534, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#112785 AS COL_FFDFAA98_DB8D_498C_9717_962EEFCF0BB3#113535, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#112786 AS COL_22941F2A_EE67_4B34_9C50_152189E04655#113536, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#112787 AS COL_F301E992_209D_40C5_9B37_0C5E5F1C355A#113537, COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#112788 AS COL_4EA2D8C1_4BA1_4AA8_A39A_2016C922D5F9#113538, COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#112789 AS COL_4EACFAB7_A3A4_47D9_8047_256D0643F4DC#113539, COL_502AB66E_6815_484C_823F_962B2CAB811A#112790 AS COL_5450E903_34DE_458E_81F6_40B9410DDA86#113540, COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#112791 AS COL_1E002AB6_5374_4035_9505_EFE020F02FA0#113541, COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#112792 AS COL_F9538688_667A_4775_8B0B_1F7BB072839A#113542, COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#112793 AS COL_94CB97DB_94EF_4F2E_BBB1_76FA2361F78B#113543, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#112794 AS COL_7AB609F7_8C71_4E92_A54A_C58B0F9280D0#113544, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#112795 AS COL_52C43B5C_550B_4BB4_B798_658B3539F08E#113545, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#112796 AS COL_44D2D66A_C50F_4A81_827E_73442AB7D314#113546, COL_00AA5519_7401_4EB3_89DC_851305135F18#112797 AS COL_37B3ABAC_1D72_4AFB_B0FA_8A3221B2CB37#113547, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#112798 AS COL_3973A4D6_3570_4EE4_A8A5_6E6CA78520FE#113548, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#112799 AS COL_625EC208_B143_4FBA_BF28_F1DB698CCE25#113549, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#112800 AS COL_0BA50281_C907_4445_A70B_47A230B2E77C#113550, COL_406265B0_4BD3_49B8_A338_51729B50709C#112801 AS COL_B58E4264_1752_4CE9_B798_E1B6020C9DFC#113551, COL_F5BE78DF_6F01_4E8F_B4B5_B5CA70A1A396#112802 AS COL_CA43801C_7EF0_4892_9F0B_24668CBBC5F7#113552, COL_BD17594B_7240_401F_8602_574C180049C2#112803 AS COL_207F09CA_1061_42B0_B075_3E139C5517DA#113553, COL_7BFE4DF5_15F1_4F75_B9A2_5CF7C2400C2B#112804 AS COL_467DCF13_28CF_4055_9499_20168C5BA017#113554, COL_9736E48D_3A9F_4F25_9D10_27534CD10454#112805 AS COL_5F8A250A_FDB8_4AA1_8CD5_296C53E447E2#113555, COL_92533CC3_4888_495A_9381_015E26FF9F56#112806 AS COL_109B07BE_5F53_4AA7_A48D_26D31EBB388C#113556, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#112807 AS COL_018E692D_8760_44D7_B0E7_DEF28A6467F8#113557, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#112808 AS COL_F766BD93_DC55_4F12_83BD_58803521CC78#113558, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#112809 AS COL_69E1663C_35E7_4821_89E9_A0E88981CBDC#113559, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#112810 AS COL_AF88F755_BCAF_4BEB_BF90_25CF414B2D5F#113560, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#112811 AS COL_38E65C11_A4F0_454B_B0B1_AA70A8D49DFD#113561, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#112812L AS COL_49D3EE03_A6C0_474E_94CF_F6A41D0F7DC3#113562L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#112813L AS COL_A2BEA8CB_E55A_41D6_B074_D1CA05F79E5F#113563L, COL_3B383441_B23F_4759_A23F_2547EBED9035#112814 AS COL_A15323C0_0B8D_4E83_B65E_B7ABAE556C05#113564, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#112815 AS COL_3C9CF95E_1F96_471C_AAAD_DF5708991DE4#113565, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#112816 AS COL_EC0005EE_6046_478E_9E52_FDF58BC73784#113566, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#112817 AS COL_20416395_6498_419E_8A84_566364662FCA#113567, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#112818 AS COL_83E6E209_5DF9_4C0D_82B9_C08AC52E1A4A#113568, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#112819 AS COL_72281EA0_9183_4D96_A3AA_E2E0A84C88CD#113569, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#112820 AS COL_8DC79DC2_DBAA_4D02_B0AC_2D1BB13F3EE7#113570, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#112821 AS COL_1DA176CC_520C_45C2_920E_B2BF638C4C9A#113571, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#112822 AS COL_A51EFB58_FAC9_42D6_9215_30BE3D76585C#113572, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#112823L AS COL_A519FCAD_03E8_4DAD_BDAA_0C9C6045157B#113573L]
Input [46]: [COL_04AF725C_66A0_4299_A535_7D820A79F925#112778, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#112779, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#112780, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#112781, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#112782, COL_49DA49E0_7469_4C3F_A05A_3FA643E894EA#112783, COL_D10143B3_53A3_4856_987D_3E4376BC7D0F#112784, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#112785, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#112786, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#112787, COL_C17C60DB_AEDB_478A_8DA1_BB4A2B356BB0#112788, COL_AC1B4616_1E9C_4831_8B34_258DFFDF4A0A#112789, COL_502AB66E_6815_484C_823F_962B2CAB811A#112790, COL_A74D03BD_6B7F_4E2A_A183_F640AEE1DF2E#112791, COL_0E52CF75_D6B3_4162_90EB_F3EB942D8974#112792, COL_5CA28AAD_255D_4160_9D91_D4947BA97BE9#112793, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#112794, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#112795, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#112796, COL_00AA5519_7401_4EB3_89DC_851305135F18#112797, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#112798, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#112799, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#112800, COL_406265B0_4BD3_49B8_A338_51729B50709C#112801, COL_F5BE78DF_6F01_4E8F_B4B5_B5CA70A1A396#112802, COL_BD17594B_7240_401F_8602_574C180049C2#112803, COL_7BFE4DF5_15F1_4F75_B9A2_5CF7C2400C2B#112804, COL_9736E48D_3A9F_4F25_9D10_27534CD10454#112805, COL_92533CC3_4888_495A_9381_015E26FF9F56#112806, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#112807, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#112808, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#112809, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#112810, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#112811, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#112812L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#112813L, COL_3B383441_B23F_4759_A23F_2547EBED9035#112814, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#112815, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#112816, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#112817, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#112818, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#112819, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#112820, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#112821, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#112822, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#112823L]

(5) CollectLimit
Input [46]: [COL_4E2F6DCD_755F_436B_A6D2_B62E29D38EAD#113528, COL_B759B06F_EA1B_499D_A598_5008DBC83272#113529, COL_90E0A81D_6EA1_4BE9_A698_51B3C872D1C6#113530, COL_3109A72F_3A51_4901_846A_5E2101FD1DD9#113531, COL_FD9702D1_C2BC_436B_9930_ACBCA7CAB3F5#113532, COL_87D0C45E_C323_4FA2_9095_E90865D3C8B4#113533, COL_1F3C5BA7_6A4A_46A9_AB6E_E6AB09562414#113534, COL_FFDFAA98_DB8D_498C_9717_962EEFCF0BB3#113535, COL_22941F2A_EE67_4B34_9C50_152189E04655#113536, COL_F301E992_209D_40C5_9B37_0C5E5F1C355A#113537, COL_4EA2D8C1_4BA1_4AA8_A39A_2016C922D5F9#113538, COL_4EACFAB7_A3A4_47D9_8047_256D0643F4DC#113539, COL_5450E903_34DE_458E_81F6_40B9410DDA86#113540, COL_1E002AB6_5374_4035_9505_EFE020F02FA0#113541, COL_F9538688_667A_4775_8B0B_1F7BB072839A#113542, COL_94CB97DB_94EF_4F2E_BBB1_76FA2361F78B#113543, COL_7AB609F7_8C71_4E92_A54A_C58B0F9280D0#113544, COL_52C43B5C_550B_4BB4_B798_658B3539F08E#113545, COL_44D2D66A_C50F_4A81_827E_73442AB7D314#113546, COL_37B3ABAC_1D72_4AFB_B0FA_8A3221B2CB37#113547, COL_3973A4D6_3570_4EE4_A8A5_6E6CA78520FE#113548, COL_625EC208_B143_4FBA_BF28_F1DB698CCE25#113549, COL_0BA50281_C907_4445_A70B_47A230B2E77C#113550, COL_B58E4264_1752_4CE9_B798_E1B6020C9DFC#113551, COL_CA43801C_7EF0_4892_9F0B_24668CBBC5F7#113552, COL_207F09CA_1061_42B0_B075_3E139C5517DA#113553, COL_467DCF13_28CF_4055_9499_20168C5BA017#113554, COL_5F8A250A_FDB8_4AA1_8CD5_296C53E447E2#113555, COL_109B07BE_5F53_4AA7_A48D_26D31EBB388C#113556, COL_018E692D_8760_44D7_B0E7_DEF28A6467F8#113557, COL_F766BD93_DC55_4F12_83BD_58803521CC78#113558, COL_69E1663C_35E7_4821_89E9_A0E88981CBDC#113559, COL_AF88F755_BCAF_4BEB_BF90_25CF414B2D5F#113560, COL_38E65C11_A4F0_454B_B0B1_AA70A8D49DFD#113561, COL_49D3EE03_A6C0_474E_94CF_F6A41D0F7DC3#113562L, COL_A2BEA8CB_E55A_41D6_B074_D1CA05F79E5F#113563L, COL_A15323C0_0B8D_4E83_B65E_B7ABAE556C05#113564, COL_3C9CF95E_1F96_471C_AAAD_DF5708991DE4#113565, COL_EC0005EE_6046_478E_9E52_FDF58BC73784#113566, COL_20416395_6498_419E_8A84_566364662FCA#113567, COL_83E6E209_5DF9_4C0D_82B9_C08AC52E1A4A#113568, COL_72281EA0_9183_4D96_A3AA_E2E0A84C88CD#113569, COL_8DC79DC2_DBAA_4D02_B0AC_2D1BB13F3EE7#113570, COL_1DA176CC_520C_45C2_920E_B2BF638C4C9A#113571, COL_A51EFB58_FAC9_42D6_9215_30BE3D76585C#113572, COL_A519FCAD_03E8_4DAD_BDAA_0C9C6045157B#113573L]
Arguments: 500000

SQL / DataFrame Properties

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