DC2 - Details for Query 134

Details for Query 134

Submitted Time: 2026/04/29 11:29:04
Duration: 0.2 s
Succeeded Jobs: 236 239 242

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))\n110 ms (3 ms, 10 ms, 61 ms (stage 378.0: task 1242))"; 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)) 100 ms (3 ms, 8 ms, 59 ms (stage 378.0: task 1242)) 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#29975 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30169, COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#29976 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30172, COL_B58638DB_F486_473C_B1E8_6919DBE69107#29977 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30175, COL_85E39150_E994_43ED_8974_DDE21A6F1942#29978 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30178, COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#29979 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30181, COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#29980 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30184, COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#29981 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30187, COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#29982 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30190, COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#29983 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30193, COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#29984L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30196L]

Filter (COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#29981 <=> Larvae)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#29975,COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#29976,COL_B58638DB_F486_473C_B1E8_6919DBE69107#29977,COL_85E39150_E994_43ED_8974_DDE21A6F1942#29978,COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#29979,COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#29980,COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#29981,COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#29982,COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#29983,COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#29984L] Batched: true, DataFilters: [(COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#29981 <=> 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#30431 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30495, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30432 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30496, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30433 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30497, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30434 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30498, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30435 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30499, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30436 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30500, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30437 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30501, COL_31DF125B_E873_427A_BF9B_8F071058184C#30438 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30502, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30439 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30503, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30440L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30504L]
         +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30367 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30431, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30368 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30432, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30369 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30433, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30370 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30434, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30371 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30435, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30372 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30436, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30373 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30437, COL_31DF125B_E873_427A_BF9B_8F071058184C#30374 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30438, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30375 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30439, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30376L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30440L]
            +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30327 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30367, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30328 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30368, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30329 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30369, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30330 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30370, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30331 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30371, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30332 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30372, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30333 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30373, COL_31DF125B_E873_427A_BF9B_8F071058184C#30334 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30374, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30335 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30375, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30336L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30376L]
               +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30264 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30327, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30268 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30328, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30270 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30329, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30272 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30330, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30274 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30331, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30276 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30332, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30278 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30333, COL_31DF125B_E873_427A_BF9B_8F071058184C#30280 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30334, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30281 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30335, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30282L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30336L]
                  +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30169 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30264, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30172 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30268, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30175 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30270, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30178 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30272, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30181 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30274, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30184 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30276, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30187 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30278, COL_31DF125B_E873_427A_BF9B_8F071058184C#30190 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30280, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30193 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30281, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30196L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30282L]
                     +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30169, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30172, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30175, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30178, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30181, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30184, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30187, COL_31DF125B_E873_427A_BF9B_8F071058184C#30190, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30193, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30196L]
                        +- Filter (COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30187 <=> cast(Larvae as string))
                           +- Project [cast(YNSECT_COHORTES_37616_COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#30071 as string) AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30169, cast(YNSECT_COHORTES_37616_COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#30072 as timestamp) AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30172, cast(YNSECT_COHORTES_37616_COL_B58638DB_F486_473C_B1E8_6919DBE69107#30074 as string) AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30175, cast(YNSECT_COHORTES_37616_COL_85E39150_E994_43ED_8974_DDE21A6F1942#30076 as double) AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30178, cast(YNSECT_COHORTES_37616_COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#30078 as double) AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30181, cast(YNSECT_COHORTES_37616_COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#30080 as string) AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30184, cast(YNSECT_COHORTES_37616_COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30082 as string) AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30187, cast(YNSECT_COHORTES_37616_COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#30084 as double) AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30190, cast(YNSECT_COHORTES_37616_COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#30086 as timestamp) AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30193, cast(YNSECT_COHORTES_37616_COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#30088L as bigint) AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30196L]
                              +- Project [COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#29975 AS YNSECT_COHORTES_37616_COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#30071, COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#29976 AS YNSECT_COHORTES_37616_COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#30072, COL_B58638DB_F486_473C_B1E8_6919DBE69107#29977 AS YNSECT_COHORTES_37616_COL_B58638DB_F486_473C_B1E8_6919DBE69107#30074, COL_85E39150_E994_43ED_8974_DDE21A6F1942#29978 AS YNSECT_COHORTES_37616_COL_85E39150_E994_43ED_8974_DDE21A6F1942#30076, COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#29979 AS YNSECT_COHORTES_37616_COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#30078, COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#29980 AS YNSECT_COHORTES_37616_COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#30080, COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#29981 AS YNSECT_COHORTES_37616_COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30082, COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#29982 AS YNSECT_COHORTES_37616_COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#30084, COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#29983 AS YNSECT_COHORTES_37616_COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#30086, COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#29984L AS YNSECT_COHORTES_37616_COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#30088L]
                                 +- SubqueryAlias YNSECT_COHORTES_37616118
                                    +- Relation[COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#29975,COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#29976,COL_B58638DB_F486_473C_B1E8_6919DBE69107#29977,COL_85E39150_E994_43ED_8974_DDE21A6F1942#29978,COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#29979,COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#29980,COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#29981,COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#29982,COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#29983,COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#29984L] 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#30431 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30495, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30432 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30496, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30433 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30497, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30434 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30498, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30435 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30499, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30436 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30500, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30437 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30501, COL_31DF125B_E873_427A_BF9B_8F071058184C#30438 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30502, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30439 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30503, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30440L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30504L]
         +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30367 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30431, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30368 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30432, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30369 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30433, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30370 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30434, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30371 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30435, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30372 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30436, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30373 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30437, COL_31DF125B_E873_427A_BF9B_8F071058184C#30374 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30438, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30375 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30439, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30376L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30440L]
            +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30327 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30367, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30328 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30368, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30329 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30369, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30330 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30370, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30331 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30371, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30332 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30372, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30333 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30373, COL_31DF125B_E873_427A_BF9B_8F071058184C#30334 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30374, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30335 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30375, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30336L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30376L]
               +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30264 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30327, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30268 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30328, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30270 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30329, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30272 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30330, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30274 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30331, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30276 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30332, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30278 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30333, COL_31DF125B_E873_427A_BF9B_8F071058184C#30280 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30334, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30281 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30335, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30282L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30336L]
                  +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30169 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30264, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30172 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30268, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30175 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30270, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30178 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30272, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30181 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30274, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30184 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30276, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30187 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30278, COL_31DF125B_E873_427A_BF9B_8F071058184C#30190 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30280, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30193 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30281, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30196L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30282L]
                     +- Project [COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30169, COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30172, COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30175, COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30178, COL_20457BD2_D838_436D_90F8_5396C7C2590C#30181, COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30184, COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30187, COL_31DF125B_E873_427A_BF9B_8F071058184C#30190, COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30193, COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30196L]
                        +- Filter (COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30187 <=> cast(Larvae as string))
                           +- Project [cast(YNSECT_COHORTES_37616_COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#30071 as string) AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30169, cast(YNSECT_COHORTES_37616_COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#30072 as timestamp) AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30172, cast(YNSECT_COHORTES_37616_COL_B58638DB_F486_473C_B1E8_6919DBE69107#30074 as string) AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30175, cast(YNSECT_COHORTES_37616_COL_85E39150_E994_43ED_8974_DDE21A6F1942#30076 as double) AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30178, cast(YNSECT_COHORTES_37616_COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#30078 as double) AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30181, cast(YNSECT_COHORTES_37616_COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#30080 as string) AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30184, cast(YNSECT_COHORTES_37616_COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30082 as string) AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30187, cast(YNSECT_COHORTES_37616_COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#30084 as double) AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30190, cast(YNSECT_COHORTES_37616_COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#30086 as timestamp) AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30193, cast(YNSECT_COHORTES_37616_COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#30088L as bigint) AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30196L]
                              +- Project [COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#29975 AS YNSECT_COHORTES_37616_COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#30071, COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#29976 AS YNSECT_COHORTES_37616_COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#30072, COL_B58638DB_F486_473C_B1E8_6919DBE69107#29977 AS YNSECT_COHORTES_37616_COL_B58638DB_F486_473C_B1E8_6919DBE69107#30074, COL_85E39150_E994_43ED_8974_DDE21A6F1942#29978 AS YNSECT_COHORTES_37616_COL_85E39150_E994_43ED_8974_DDE21A6F1942#30076, COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#29979 AS YNSECT_COHORTES_37616_COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#30078, COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#29980 AS YNSECT_COHORTES_37616_COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#30080, COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#29981 AS YNSECT_COHORTES_37616_COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#30082, COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#29982 AS YNSECT_COHORTES_37616_COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#30084, COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#29983 AS YNSECT_COHORTES_37616_COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#30086, COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#29984L AS YNSECT_COHORTES_37616_COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#30088L]
                                 +- SubqueryAlias YNSECT_COHORTES_37616118
                                    +- Relation[COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#29975,COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#29976,COL_B58638DB_F486_473C_B1E8_6919DBE69107#29977,COL_85E39150_E994_43ED_8974_DDE21A6F1942#29978,COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#29979,COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#29980,COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#29981,COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#29982,COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#29983,COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#29984L] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#29975 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30169, COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#29976 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30172, COL_B58638DB_F486_473C_B1E8_6919DBE69107#29977 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30175, COL_85E39150_E994_43ED_8974_DDE21A6F1942#29978 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30178, COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#29979 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30181, COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#29980 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30184, COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#29981 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30187, COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#29982 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30190, COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#29983 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30193, COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#29984L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30196L]
      +- Filter (COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#29981 <=> Larvae)
         +- Relation[COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#29975,COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#29976,COL_B58638DB_F486_473C_B1E8_6919DBE69107#29977,COL_85E39150_E994_43ED_8974_DDE21A6F1942#29978,COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#29979,COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#29980,COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#29981,COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#29982,COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#29983,COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#29984L] parquet

== Physical Plan ==
CollectLimit 500000
+- *(1) Project [COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#29975 AS COL_BD6A1B40_BE56_4DB6_B125_DD39FE3E176E#30169, COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#29976 AS COL_FD49B660_E10C_42BF_BE5A_BFDCFFB640AF#30172, COL_B58638DB_F486_473C_B1E8_6919DBE69107#29977 AS COL_F7CB58BC_033C_4A9A_9EB9_5582D4FFF7B6#30175, COL_85E39150_E994_43ED_8974_DDE21A6F1942#29978 AS COL_4ACA45A2_C2FC_4F14_B32E_7B6ABEA85A2D#30178, COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#29979 AS COL_20457BD2_D838_436D_90F8_5396C7C2590C#30181, COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#29980 AS COL_9F2513BD_B095_4017_B4DF_4E1F15676BBE#30184, COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#29981 AS COL_B708E9ED_78E1_435C_B50A_F42968D81F52#30187, COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#29982 AS COL_31DF125B_E873_427A_BF9B_8F071058184C#30190, COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#29983 AS COL_314076DC_4BF9_45BB_976B_D78B5B368A28#30193, COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#29984L AS COL_888B5014_64BB_4FAE_A429_1C7637B4F655#30196L]
   +- *(1) Filter (COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#29981 <=> Larvae)
      +- *(1) ColumnarToRow
         +- FileScan parquet [COL_101FAC00_6BC4_4407_8F5C_2CB25C8BC015#29975,COL_C25C02E6_F4C2_4E4A_87D5_0FAF275D41B4#29976,COL_B58638DB_F486_473C_B1E8_6919DBE69107#29977,COL_85E39150_E994_43ED_8974_DDE21A6F1942#29978,COL_17891EE2_99A2_4924_A859_B5A2E495CCDD#29979,COL_6A35B21A_CF9F_4C54_8FE3_C397613EA01B#29980,COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#29981,COL_76FA2B1A_DA88_4598_AF9C_436669FC83BC#29982,COL_76580C4E_7461_4CBD_B5B6_1160EB017A23#29983,COL_F3F25D10_D475_42DD_AC43_1C1EE0123CEC#29984L] Batched: true, DataFilters: [(COL_3F51BC74_5861_4104_986D_4D5F241D3DAD#29981 <=> 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...