SP1 - Details for Query 270

Submitted Time: 2026/02/20 08:08:58
Duration: 1 s
Succeeded Jobs: 387 390 393

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.8 s (14 ms, 80 ms, 747 ms (stage 532.0: task 757))"; 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.7 s (14 ms, 80 ms, 724 ms (stage 532.0: task 757)) 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#111870 AS COL_F242539D_7E13_4CC3_A69A_EB410E76B19C#112409, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111871 AS COL_22B65E5F_908E_4090_AA5F_00EC8270189A#112410, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#111872 AS COL_1A7D535E_1655_4BE4_99C1_BF2C9558DAA1#112411, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#111873 AS COL_E6CAE2D4_4AB1_48EA_B627_D65F32FC4458#112412, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#111874 AS COL_0CF39CB9_0348_45D2_8955_8411D8A95B97#112413, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#111877 AS COL_E3426354_1491_432C_9D99_11BA2951E876#112414, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#111878 AS COL_95F62809_4D26_4CFE_ADF4_8EF647C18D2C#112415, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#111879 AS COL_70B29063_5E37_48E9_B0F5_3AA54E789232#112416, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#111886 AS COL_3CAF5785_9399_498C_9736_44B3C35499BF#112417, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#111887 AS COL_2CAD9536_92B2_4C39_A561_9FB07AE48B73#112418, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#111888 AS COL_0FBEDCAA_22ED_4838_BDAB_33E116D3193B#112419, COL_00AA5519_7401_4EB3_89DC_851305135F18#111889 AS COL_BECE3DF4_5C4E_4055_A88A_27AADF9B9EE3#112420, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#111890 AS COL_ECFFB9F1_C039_4B5C_AA53_F2CF22FE5087#112421, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#111891 AS COL_1152BB15_C176_46D6_A642_6561F8F9BB69#112422, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#111892 AS COL_FC9EB913_1069_4617_8BC3_E1B825927F86#112423, COL_92533CC3_4888_495A_9381_015E26FF9F56#111898 AS COL_6DAAB8A2_1581_4629_9753_BE2C9E44A4D8#112424, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#111899 AS COL_4C837F02_4F4B_4F84_AFB2_07ED885322B3#112425, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#111900 AS COL_CC4EC2C8_DB0C_44A4_83D4_F329776B6FAB#112426, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#111901 AS COL_BAD3682E_B05A_4437_86C5_5E1174AA3677#112427, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#111902 AS COL_CFA3D0AB_C972_47E2_B0B9_03A74D9090AF#112428, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#111903 AS COL_E1FDDF64_B643_49C4_A326_014CA552DBE5#112429, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#111904L AS COL_6359ED66_FE82_4430_B23E_4DD4DF0EAE2D#112430L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#111905L AS COL_2522DDA6_77A2_49A9_BCF4_A68B6F4BAB3A#112431L, COL_3B383441_B23F_4759_A23F_2547EBED9035#111906 AS COL_615A570E_6C62_458A_94C5_57A6A9F61C45#112432, ... 9 more fields]

Filter ((COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111871 <=> ETB_LIN) AND (COL_04AF725C_66A0_4299_A535_7D820A79F925#111870 <=> I_0001119))

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_04AF725C_66A0_4299_A535_7D820A79F925#111870,COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111871,COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#111872,COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#111873,COL_3CD2052B_33C5_4457_9C30_D79AE298A405#111874,COL_4FBE155F_08B2_4439_869C_ED16CA25E269#111877,COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#111878,COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#111879,COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#111886,COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#111887,COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#111888,COL_00AA5519_7401_4EB3_89DC_851305135F18#111889,COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#111890,COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#111891,COL_2430A18C_8A40_48E8_9D35_190F0F510C94#111892,COL_92533CC3_4888_495A_9381_015E26FF9F56#111898,COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#111899,COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#111900,COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#111901,COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#111902,COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#111903,COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#111904L,COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#111905L,COL_3B383441_B23F_4759_A23F_2547EBED9035#111906,... 9 more fields] Batched: true, DataFilters: [(COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111871 <=> 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 [33]: [COL_04AF725C_66A0_4299_A535_7D820A79F925#111870, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111871, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#111872, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#111873, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#111874, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#111877, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#111878, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#111879, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#111886, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#111887, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#111888, COL_00AA5519_7401_4EB3_89DC_851305135F18#111889, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#111890, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#111891, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#111892, COL_92533CC3_4888_495A_9381_015E26FF9F56#111898, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#111899, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#111900, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#111901, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#111902, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#111903, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#111904L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#111905L, COL_3B383441_B23F_4759_A23F_2547EBED9035#111906, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#111907, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#111908, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#111909, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#111910, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#111911, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#111912, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#111913, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#111914, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#111915L]
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_4FBE155F_08B2_4439_869C_ED16CA25E269:string,COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE:string,COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9: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_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 [33]: [COL_04AF725C_66A0_4299_A535_7D820A79F925#111870, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111871, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#111872, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#111873, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#111874, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#111877, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#111878, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#111879, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#111886, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#111887, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#111888, COL_00AA5519_7401_4EB3_89DC_851305135F18#111889, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#111890, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#111891, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#111892, COL_92533CC3_4888_495A_9381_015E26FF9F56#111898, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#111899, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#111900, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#111901, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#111902, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#111903, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#111904L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#111905L, COL_3B383441_B23F_4759_A23F_2547EBED9035#111906, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#111907, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#111908, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#111909, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#111910, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#111911, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#111912, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#111913, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#111914, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#111915L]

(3) Filter [codegen id : 1]
Input [33]: [COL_04AF725C_66A0_4299_A535_7D820A79F925#111870, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111871, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#111872, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#111873, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#111874, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#111877, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#111878, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#111879, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#111886, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#111887, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#111888, COL_00AA5519_7401_4EB3_89DC_851305135F18#111889, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#111890, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#111891, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#111892, COL_92533CC3_4888_495A_9381_015E26FF9F56#111898, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#111899, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#111900, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#111901, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#111902, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#111903, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#111904L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#111905L, COL_3B383441_B23F_4759_A23F_2547EBED9035#111906, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#111907, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#111908, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#111909, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#111910, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#111911, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#111912, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#111913, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#111914, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#111915L]
Condition : ((COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111871 <=> ETB_LIN) AND (COL_04AF725C_66A0_4299_A535_7D820A79F925#111870 <=> I_0001119))

(4) Project [codegen id : 1]
Output [33]: [COL_04AF725C_66A0_4299_A535_7D820A79F925#111870 AS COL_F242539D_7E13_4CC3_A69A_EB410E76B19C#112409, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111871 AS COL_22B65E5F_908E_4090_AA5F_00EC8270189A#112410, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#111872 AS COL_1A7D535E_1655_4BE4_99C1_BF2C9558DAA1#112411, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#111873 AS COL_E6CAE2D4_4AB1_48EA_B627_D65F32FC4458#112412, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#111874 AS COL_0CF39CB9_0348_45D2_8955_8411D8A95B97#112413, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#111877 AS COL_E3426354_1491_432C_9D99_11BA2951E876#112414, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#111878 AS COL_95F62809_4D26_4CFE_ADF4_8EF647C18D2C#112415, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#111879 AS COL_70B29063_5E37_48E9_B0F5_3AA54E789232#112416, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#111886 AS COL_3CAF5785_9399_498C_9736_44B3C35499BF#112417, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#111887 AS COL_2CAD9536_92B2_4C39_A561_9FB07AE48B73#112418, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#111888 AS COL_0FBEDCAA_22ED_4838_BDAB_33E116D3193B#112419, COL_00AA5519_7401_4EB3_89DC_851305135F18#111889 AS COL_BECE3DF4_5C4E_4055_A88A_27AADF9B9EE3#112420, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#111890 AS COL_ECFFB9F1_C039_4B5C_AA53_F2CF22FE5087#112421, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#111891 AS COL_1152BB15_C176_46D6_A642_6561F8F9BB69#112422, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#111892 AS COL_FC9EB913_1069_4617_8BC3_E1B825927F86#112423, COL_92533CC3_4888_495A_9381_015E26FF9F56#111898 AS COL_6DAAB8A2_1581_4629_9753_BE2C9E44A4D8#112424, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#111899 AS COL_4C837F02_4F4B_4F84_AFB2_07ED885322B3#112425, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#111900 AS COL_CC4EC2C8_DB0C_44A4_83D4_F329776B6FAB#112426, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#111901 AS COL_BAD3682E_B05A_4437_86C5_5E1174AA3677#112427, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#111902 AS COL_CFA3D0AB_C972_47E2_B0B9_03A74D9090AF#112428, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#111903 AS COL_E1FDDF64_B643_49C4_A326_014CA552DBE5#112429, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#111904L AS COL_6359ED66_FE82_4430_B23E_4DD4DF0EAE2D#112430L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#111905L AS COL_2522DDA6_77A2_49A9_BCF4_A68B6F4BAB3A#112431L, COL_3B383441_B23F_4759_A23F_2547EBED9035#111906 AS COL_615A570E_6C62_458A_94C5_57A6A9F61C45#112432, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#111907 AS COL_BEC4A9AF_A3D3_451A_9AC6_64A1CEC2E690#112433, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#111908 AS COL_D0383959_F5E3_4612_A556_EB11E938ECE4#112434, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#111909 AS COL_113E74AF_12E3_44C3_A223_495FAC6E5762#112435, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#111910 AS COL_6632065C_6835_464D_A0A1_C31A716D4AAE#112436, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#111911 AS COL_21994721_BF49_4518_8C07_B86B07B0A1E9#112437, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#111912 AS COL_F085AE8C_5F7C_43DF_8F71_F1C7C478BF70#112438, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#111913 AS COL_E3E917B3_0DA1_45F4_B330_266C4A427BD3#112439, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#111914 AS COL_26029938_ED70_4E28_AA27_7CB6835C1AAF#112440, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#111915L AS COL_14E1D092_FD4F_490F_815C_21F26927887E#112441L]
Input [33]: [COL_04AF725C_66A0_4299_A535_7D820A79F925#111870, COL_81492BFD_C38C_4C09_8A5D_1EE53F619CB4#111871, COL_8CAF0B1F_914D_45B3_919A_E87F9882A9B9#111872, COL_5DBB07B2_DD4E_4DF8_A772_64564BC20B53#111873, COL_3CD2052B_33C5_4457_9C30_D79AE298A405#111874, COL_4FBE155F_08B2_4439_869C_ED16CA25E269#111877, COL_FE7AEAA4_23AE_49C1_82AC_4A9ADE3181CE#111878, COL_8953E1CC_CB11_4CCC_87D4_F7518DBE39D9#111879, COL_A94FC4EF_7A86_4CB2_8339_FCBD9C034DB7#111886, COL_F2C204FA_15DA_4EEC_96F8_CEC8C043BD71#111887, COL_4DCCDFEC_02BB_494A_B5F3_24EC9B392DBD#111888, COL_00AA5519_7401_4EB3_89DC_851305135F18#111889, COL_4C35D883_B8E8_461B_BBDC_8AF1C39800F5#111890, COL_CE6E64EE_1EBF_4DEC_96A1_9C0E9C1ED2A9#111891, COL_2430A18C_8A40_48E8_9D35_190F0F510C94#111892, COL_92533CC3_4888_495A_9381_015E26FF9F56#111898, COL_56A8ACFE_FC0F_47F5_AB2A_E577600B59DC#111899, COL_017A72D2_5F08_48ED_95FF_E5EF56F416D0#111900, COL_B57A41FE_1A75_4C02_8A7B_6ABFDF1FB1CE#111901, COL_B2956BB5_EDD0_4033_AF0A_1E48E4A36D77#111902, COL_0CD7A69B_FDF6_4D6A_9E55_45EF06841D1E#111903, COL_14B75E71_444A_4E9B_866D_3A07E6F5DEC1#111904L, COL_AF45FDD2_5F18_420E_8BD7_889B0C6BA906#111905L, COL_3B383441_B23F_4759_A23F_2547EBED9035#111906, COL_6A743F41_E8CE_491E_99CE_9BBC63F78493#111907, COL_AE1B08C1_973A_46F1_8A58_27DB81CAEE5E#111908, COL_767CA1C1_2BB5_4051_821B_C868BAE49582#111909, COL_EDA1F9AA_CEC0_4D27_890E_A05FEA3DBF9D#111910, COL_77E26D7D_BFEE_4DD4_8490_4869D9F4B59A#111911, COL_B5CFDCE1_2A69_4503_991B_E02A359A2A1B#111912, COL_B62D9177_DD65_4B22_AF90_C55B90BD1EB7#111913, COL_AEB3ECFC_916F_4772_89B2_213CF25BDB83#111914, COL_0DE4EE46_9B97_42A3_BE3B_9E757765A4D1#111915L]

(5) CollectLimit
Input [33]: [COL_F242539D_7E13_4CC3_A69A_EB410E76B19C#112409, COL_22B65E5F_908E_4090_AA5F_00EC8270189A#112410, COL_1A7D535E_1655_4BE4_99C1_BF2C9558DAA1#112411, COL_E6CAE2D4_4AB1_48EA_B627_D65F32FC4458#112412, COL_0CF39CB9_0348_45D2_8955_8411D8A95B97#112413, COL_E3426354_1491_432C_9D99_11BA2951E876#112414, COL_95F62809_4D26_4CFE_ADF4_8EF647C18D2C#112415, COL_70B29063_5E37_48E9_B0F5_3AA54E789232#112416, COL_3CAF5785_9399_498C_9736_44B3C35499BF#112417, COL_2CAD9536_92B2_4C39_A561_9FB07AE48B73#112418, COL_0FBEDCAA_22ED_4838_BDAB_33E116D3193B#112419, COL_BECE3DF4_5C4E_4055_A88A_27AADF9B9EE3#112420, COL_ECFFB9F1_C039_4B5C_AA53_F2CF22FE5087#112421, COL_1152BB15_C176_46D6_A642_6561F8F9BB69#112422, COL_FC9EB913_1069_4617_8BC3_E1B825927F86#112423, COL_6DAAB8A2_1581_4629_9753_BE2C9E44A4D8#112424, COL_4C837F02_4F4B_4F84_AFB2_07ED885322B3#112425, COL_CC4EC2C8_DB0C_44A4_83D4_F329776B6FAB#112426, COL_BAD3682E_B05A_4437_86C5_5E1174AA3677#112427, COL_CFA3D0AB_C972_47E2_B0B9_03A74D9090AF#112428, COL_E1FDDF64_B643_49C4_A326_014CA552DBE5#112429, COL_6359ED66_FE82_4430_B23E_4DD4DF0EAE2D#112430L, COL_2522DDA6_77A2_49A9_BCF4_A68B6F4BAB3A#112431L, COL_615A570E_6C62_458A_94C5_57A6A9F61C45#112432, COL_BEC4A9AF_A3D3_451A_9AC6_64A1CEC2E690#112433, COL_D0383959_F5E3_4612_A556_EB11E938ECE4#112434, COL_113E74AF_12E3_44C3_A223_495FAC6E5762#112435, COL_6632065C_6835_464D_A0A1_C31A716D4AAE#112436, COL_21994721_BF49_4518_8C07_B86B07B0A1E9#112437, COL_F085AE8C_5F7C_43DF_8F71_F1C7C478BF70#112438, COL_E3E917B3_0DA1_45F4_B330_266C4A427BD3#112439, COL_26029938_ED70_4E28_AA27_7CB6835C1AAF#112440, COL_14E1D092_FD4F_490F_815C_21F26927887E#112441L]
Arguments: 500000

SQL / DataFrame Properties

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