DC2 - Details for Query 135

Details for Query 135

Submitted Time: 2026/04/29 11:29:04
Duration: 0.2 s
Succeeded Jobs: 235 238 241

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))\n106 ms (4 ms, 14 ms, 25 ms (stage 377.0: task 1236))"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="Filter number of output rows: 3,438"]; 4 [labelType="html" label="ColumnarToRow number of output rows: 6,026 number of input batches: 13"]; } 5 [labelType="html" label="Scan parquet number of files read: 13 scan time total (min, med, max (stageId: taskId)) 94 ms (4 ms, 12 ms, 23 ms (stage 377.0: task 1236)) metadata time: 0 ms size of files read: 236.1 KiB number of output rows: 6,026"]; 2->0; 3->2; 4->3; 5->4; }

CollectLimit 500000

Project [COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#30019 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30168, COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#30020 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30170, COL_B58638DB_F486_473C_B1E8_6919DBE69107#30021 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30173, COL_85E39150_E994_43ED_8974_DDE21A6F1942#30022 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30176, COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#30023 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30179, COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#30024 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30182, COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30025 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30185, COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#30026 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30188, COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#30027 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30191, COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#30028L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30194L]

Filter (COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30025 <=> Larvae)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#30019,COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#30020,COL_B58638DB_F486_473C_B1E8_6919DBE69107#30021,COL_85E39150_E994_43ED_8974_DDE21A6F1942#30022,COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#30023,COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#30024,COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30025,COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#30026,COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#30027,COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#30028L] Batched: true, DataFilters: [(COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30025 <=> Larvae)], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/YNSECT_COHORTES_37616], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_3F51BC74_5861_4104_986D_4D5F241D3DAD,Larvae)], ReadSchema: struct<COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015:string,COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4:t...

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Filter true
      +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30441 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30505, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30442 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30506, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30443 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30507, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30444 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30508, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30445 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30509, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30446 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30510, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30447 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30511, COL_31DF125B_E873_427A_BF9B_8F071058184C#30448 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30512, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30449 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30513, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30450L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30514L]
         +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30377 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30441, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30378 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30442, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30379 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30443, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30380 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30444, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30381 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30445, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30382 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30446, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30383 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30447, COL_31DF125B_E873_427A_BF9B_8F071058184C#30384 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30448, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30385 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30449, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30386L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30450L]
            +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30337 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30377, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30338 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30378, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30339 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30379, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30340 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30380, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30341 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30381, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30342 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30382, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30343 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30383, COL_31DF125B_E873_427A_BF9B_8F071058184C#30344 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30384, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30345 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30385, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30346L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30386L]
               +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30263 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30337, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30265 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30338, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30266 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30339, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30267 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30340, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30269 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30341, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30271 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30342, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30273 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30343, COL_31DF125B_E873_427A_BF9B_8F071058184C#30275 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30344, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30277 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30345, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30279L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30346L]
                  +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30168 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30263, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30170 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30265, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30173 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30266, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30176 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30267, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30179 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30269, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30182 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30271, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30185 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30273, COL_31DF125B_E873_427A_BF9B_8F071058184C#30188 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30275, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30191 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30277, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30194L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30279L]
                     +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30168, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30170, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30173, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30176, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30179, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30182, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30185, COL_31DF125B_E873_427A_BF9B_8F071058184C#30188, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30191, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30194L]
                        +- Filter (COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30185 <=> cast(Larvae as string))
                           +- Project [cast(YNSECT_COHORTES_37616_COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#30073 as string) AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30168, cast(YNSECT_COHORTES_37616_COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#30075 as timestamp) AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30170, cast(YNSECT_COHORTES_37616_COL_B58638DB_F486_473C_B1E8_6919DBE69107#30077 as string) AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30173, cast(YNSECT_COHORTES_37616_COL_85E39150_E994_43ED_8974_DDE21A6F1942#30079 as double) AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30176, cast(YNSECT_COHORTES_37616_COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#30081 as double) AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30179, cast(YNSECT_COHORTES_37616_COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#30083 as string) AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30182, cast(YNSECT_COHORTES_37616_COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30085 as string) AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30185, cast(YNSECT_COHORTES_37616_COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#30087 as double) AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30188, cast(YNSECT_COHORTES_37616_COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#30089 as timestamp) AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30191, cast(YNSECT_COHORTES_37616_COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#30090L as bigint) AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30194L]
                              +- Project [COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#30019 AS YNSECT_COHORTES_37616_COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#30073, COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#30020 AS YNSECT_COHORTES_37616_COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#30075, COL_B58638DB_F486_473C_B1E8_6919DBE69107#30021 AS YNSECT_COHORTES_37616_COL_B58638DB_F486_473C_B1E8_6919DBE69107#30077, COL_85E39150_E994_43ED_8974_DDE21A6F1942#30022 AS YNSECT_COHORTES_37616_COL_85E39150_E994_43ED_8974_DDE21A6F1942#30079, COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#30023 AS YNSECT_COHORTES_37616_COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#30081, COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#30024 AS YNSECT_COHORTES_37616_COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#30083, COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30025 AS YNSECT_COHORTES_37616_COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30085, COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#30026 AS YNSECT_COHORTES_37616_COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#30087, COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#30027 AS YNSECT_COHORTES_37616_COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#30089, COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#30028L AS YNSECT_COHORTES_37616_COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#30090L]
                                 +- SubqueryAlias YNSECT_COHORTES_37616117
                                    +- Relation[COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#30019,COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#30020,COL_B58638DB_F486_473C_B1E8_6919DBE69107#30021,COL_85E39150_E994_43ED_8974_DDE21A6F1942#30022,COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#30023,COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#30024,COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30025,COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#30026,COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#30027,COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#30028L] parquet

== Analyzed Logical Plan ==
COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E: string, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF: timestamp, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6: string, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D: double, COL_20457BD2_D838_436D_90F8_5396C7C2590C: double, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE: string, COL_B708E9ED_78E1_435C_B50A_F42968D81F52: string, COL_31DF125B_E873_427A_BF9B_8F071058184C: double, COL_314076DC_4BF9_45BB_976B_D78B5B368A28: timestamp, COL_888B5014_64BB_4FAE_A429_1C7637B4F655: bigint
GlobalLimit 500000
+- LocalLimit 500000
   +- Filter true
      +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30441 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30505, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30442 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30506, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30443 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30507, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30444 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30508, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30445 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30509, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30446 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30510, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30447 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30511, COL_31DF125B_E873_427A_BF9B_8F071058184C#30448 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30512, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30449 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30513, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30450L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30514L]
         +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30377 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30441, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30378 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30442, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30379 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30443, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30380 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30444, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30381 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30445, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30382 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30446, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30383 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30447, COL_31DF125B_E873_427A_BF9B_8F071058184C#30384 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30448, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30385 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30449, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30386L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30450L]
            +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30337 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30377, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30338 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30378, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30339 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30379, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30340 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30380, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30341 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30381, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30342 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30382, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30343 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30383, COL_31DF125B_E873_427A_BF9B_8F071058184C#30344 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30384, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30345 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30385, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30346L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30386L]
               +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30263 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30337, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30265 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30338, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30266 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30339, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30267 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30340, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30269 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30341, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30271 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30342, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30273 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30343, COL_31DF125B_E873_427A_BF9B_8F071058184C#30275 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30344, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30277 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30345, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30279L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30346L]
                  +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30168 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30263, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30170 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30265, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30173 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30266, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30176 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30267, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30179 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30269, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30182 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30271, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30185 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30273, COL_31DF125B_E873_427A_BF9B_8F071058184C#30188 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30275, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30191 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30277, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30194L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30279L]
                     +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30168, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30170, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30173, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30176, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30179, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30182, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30185, COL_31DF125B_E873_427A_BF9B_8F071058184C#30188, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30191, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30194L]
                        +- Filter (COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30185 <=> cast(Larvae as string))
                           +- Project [cast(YNSECT_COHORTES_37616_COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#30073 as string) AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30168, cast(YNSECT_COHORTES_37616_COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#30075 as timestamp) AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30170, cast(YNSECT_COHORTES_37616_COL_B58638DB_F486_473C_B1E8_6919DBE69107#30077 as string) AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30173, cast(YNSECT_COHORTES_37616_COL_85E39150_E994_43ED_8974_DDE21A6F1942#30079 as double) AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30176, cast(YNSECT_COHORTES_37616_COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#30081 as double) AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30179, cast(YNSECT_COHORTES_37616_COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#30083 as string) AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30182, cast(YNSECT_COHORTES_37616_COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30085 as string) AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30185, cast(YNSECT_COHORTES_37616_COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#30087 as double) AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30188, cast(YNSECT_COHORTES_37616_COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#30089 as timestamp) AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30191, cast(YNSECT_COHORTES_37616_COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#30090L as bigint) AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30194L]
                              +- Project [COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#30019 AS YNSECT_COHORTES_37616_COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#30073, COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#30020 AS YNSECT_COHORTES_37616_COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#30075, COL_B58638DB_F486_473C_B1E8_6919DBE69107#30021 AS YNSECT_COHORTES_37616_COL_B58638DB_F486_473C_B1E8_6919DBE69107#30077, COL_85E39150_E994_43ED_8974_DDE21A6F1942#30022 AS YNSECT_COHORTES_37616_COL_85E39150_E994_43ED_8974_DDE21A6F1942#30079, COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#30023 AS YNSECT_COHORTES_37616_COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#30081, COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#30024 AS YNSECT_COHORTES_37616_COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#30083, COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30025 AS YNSECT_COHORTES_37616_COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30085, COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#30026 AS YNSECT_COHORTES_37616_COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#30087, COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#30027 AS YNSECT_COHORTES_37616_COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#30089, COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#30028L AS YNSECT_COHORTES_37616_COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#30090L]
                                 +- SubqueryAlias YNSECT_COHORTES_37616117
                                    +- Relation[COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#30019,COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#30020,COL_B58638DB_F486_473C_B1E8_6919DBE69107#30021,COL_85E39150_E994_43ED_8974_DDE21A6F1942#30022,COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#30023,COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#30024,COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30025,COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#30026,COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#30027,COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#30028L] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#30019 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30168, COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#30020 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30170, COL_B58638DB_F486_473C_B1E8_6919DBE69107#30021 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30173, COL_85E39150_E994_43ED_8974_DDE21A6F1942#30022 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30176, COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#30023 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30179, COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#30024 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30182, COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30025 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30185, COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#30026 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30188, COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#30027 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30191, COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#30028L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30194L]
      +- Filter (COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30025 <=> Larvae)
         +- Relation[COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#30019,COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#30020,COL_B58638DB_F486_473C_B1E8_6919DBE69107#30021,COL_85E39150_E994_43ED_8974_DDE21A6F1942#30022,COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#30023,COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#30024,COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30025,COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#30026,COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#30027,COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#30028L] parquet

== Physical Plan ==
CollectLimit 500000
+- *(1) Project [COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#30019 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30168, COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#30020 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30170, COL_B58638DB_F486_473C_B1E8_6919DBE69107#30021 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30173, COL_85E39150_E994_43ED_8974_DDE21A6F1942#30022 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30176, COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#30023 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30179, COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#30024 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30182, COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30025 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30185, COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#30026 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30188, COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#30027 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30191, COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#30028L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30194L]
   +- *(1) Filter (COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30025 <=> Larvae)
      +- *(1) ColumnarToRow
         +- FileScan parquet [COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#30019,COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#30020,COL_B58638DB_F486_473C_B1E8_6919DBE69107#30021,COL_85E39150_E994_43ED_8974_DDE21A6F1942#30022,COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#30023,COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#30024,COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30025,COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#30026,COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#30027,COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#30028L] Batched: true, DataFilters: [(COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30025 <=> Larvae)], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/YNSECT_COHORTES_37616], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_3F51BC74_5861_4104_986D_4D5F241D3DAD,Larvae)], ReadSchema: struct<COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015:string,COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4:t...