DC2 - Details for Query 90

Details for Query 90

Submitted Time: 2026/04/29 06:30:32
Duration: 0.2 s
Succeeded Jobs: 150 151 152

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))\n246 ms (9 ms, 17 ms, 35 ms (stage 238.0: task 707))"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="Filter number of output rows: 3,432"]; 4 [labelType="html" label="ColumnarToRow number of output rows: 3,432 number of input batches: 12"]; } 5 [labelType="html" label="Scan parquet number of files read: 45 scan time total (min, med, max (stageId: taskId)) 233 ms (8 ms, 17 ms, 31 ms (stage 238.0: task 707)) metadata time: 0 ms size of files read: 266.6 KiB number of output rows: 3,432"]; 2->0; 3->2; 4->3; 5->4; }

CollectLimit 500000

Project [COL_655080F4_5ECA_4FED_A763_9B0E34490248#23471 AS COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23519, COL_66297348_CC53_497B_98E0_10E6C236F7F7#23472 AS COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23520, COL_9EABBDD7_7BED_42F0_A922_637712817B51#23473 AS COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23521, COL_2ABDA2E0_4DEB_4FF7_9D92_E45932B42790#23474 AS COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23522, COL_4A9C1E84_0C29_4139_9683_BE1B0436163E#23475 AS COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23523, COL_4552271C_6064_4B80_A4FC_FD60EF37390D#23476 AS COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23524, COL_B53B5B70_7533_4624_8936_77BFAF29A1A8#23477 AS COL_222F41D1_267E_4321_B361_E29B83590B2D#23525, COL_10B8E04C_35BE_4465_A856_7581B7F9319D#23478 AS COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23526]

Filter (COL_B53B5B70_7533_4624_8936_77BFAF29A1A8#23477 <=> Larvae)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_655080F4_5ECA_4FED_A763_9B0E34490248#23471,COL_66297348_CC53_497B_98E0_10E6C236F7F7#23472,COL_9EABBDD7_7BED_42F0_A922_637712817B51#23473,COL_2ABDA2E0_4DEB_4FF7_9D92_E45932B42790#23474,COL_4A9C1E84_0C29_4139_9683_BE1B0436163E#23475,COL_4552271C_6064_4B80_A4FC_FD60EF37390D#23476,COL_B53B5B70_7533_4624_8936_77BFAF29A1A8#23477,COL_10B8E04C_35BE_4465_A856_7581B7F9319D#23478] Batched: true, DataFilters: [(COL_B53B5B70_7533_4624_8936_77BFAF29A1A8#23477 <=> Larvae)], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/YNSECT_ALL_TRAY_37627], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_B53B5B70_7533_4624_8936_77BFAF29A1A8,Larvae)], ReadSchema: struct<COL_655080F4_5ECA_4FED_A763_9B0E34490248:string,COL_66297348_CC53_497B_98E0_10E6C236F7F7:t...

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Filter true
      +- Project [COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23671 AS COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23703, COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23672 AS COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23704, COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23673 AS COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23705, COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23674 AS COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23706, COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23675 AS COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23707, COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23676 AS COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23708, COL_222F41D1_267E_4321_B361_E29B83590B2D#23677 AS COL_222F41D1_267E_4321_B361_E29B83590B2D#23709, COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23678 AS COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23710]
         +- Project [COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23647 AS COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23671, COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23648 AS COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23672, COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23649 AS COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23673, COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23650 AS COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23674, COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23651 AS COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23675, COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23652 AS COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23676, COL_222F41D1_267E_4321_B361_E29B83590B2D#23653 AS COL_222F41D1_267E_4321_B361_E29B83590B2D#23677, COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23654 AS COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23678]
            +- Project [COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23615 AS COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23647, COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23616 AS COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23648, COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23617 AS COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23649, COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23618 AS COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23650, COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23619 AS COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23651, COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23620 AS COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23652, COL_222F41D1_267E_4321_B361_E29B83590B2D#23621 AS COL_222F41D1_267E_4321_B361_E29B83590B2D#23653, COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23622 AS COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23654]
               +- Project [COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23575 AS COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23615, COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23576 AS COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23616, COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23577 AS COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23617, COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23578 AS COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23618, COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23579 AS COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23619, COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23580 AS COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23620, COL_222F41D1_267E_4321_B361_E29B83590B2D#23581 AS COL_222F41D1_267E_4321_B361_E29B83590B2D#23621, COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23582 AS COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23622]
                  +- Project [COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23519 AS COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23575, COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23520 AS COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23576, COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23521 AS COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23577, COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23522 AS COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23578, COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23523 AS COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23579, COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23524 AS COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23580, COL_222F41D1_267E_4321_B361_E29B83590B2D#23525 AS COL_222F41D1_267E_4321_B361_E29B83590B2D#23581, COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23526 AS COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23582]
                     +- Project [COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23519, COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23520, COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23521, COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23522, COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23523, COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23524, COL_222F41D1_267E_4321_B361_E29B83590B2D#23525, COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23526]
                        +- Filter (COL_222F41D1_267E_4321_B361_E29B83590B2D#23525 <=> cast(Larvae as string))
                           +- Project [cast(YNSECT_ALL_TRAY_37627_COL_655080F4_5ECA_4FED_A763_9B0E34490248#23495 as string) AS COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23519, cast(YNSECT_ALL_TRAY_37627_COL_66297348_CC53_497B_98E0_10E6C236F7F7#23496 as timestamp) AS COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23520, cast(YNSECT_ALL_TRAY_37627_COL_9EABBDD7_7BED_42F0_A922_637712817B51#23497 as string) AS COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23521, cast(YNSECT_ALL_TRAY_37627_COL_2ABDA2E0_4DEB_4FF7_9D92_E45932B42790#23498 as double) AS COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23522, cast(YNSECT_ALL_TRAY_37627_COL_4A9C1E84_0C29_4139_9683_BE1B0436163E#23499 as double) AS COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23523, cast(YNSECT_ALL_TRAY_37627_COL_4552271C_6064_4B80_A4FC_FD60EF37390D#23500 as string) AS COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23524, cast(YNSECT_ALL_TRAY_37627_COL_B53B5B70_7533_4624_8936_77BFAF29A1A8#23501 as string) AS COL_222F41D1_267E_4321_B361_E29B83590B2D#23525, cast(YNSECT_ALL_TRAY_37627_COL_10B8E04C_35BE_4465_A856_7581B7F9319D#23502 as double) AS COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23526]
                              +- Project [COL_655080F4_5ECA_4FED_A763_9B0E34490248#23471 AS YNSECT_ALL_TRAY_37627_COL_655080F4_5ECA_4FED_A763_9B0E34490248#23495, COL_66297348_CC53_497B_98E0_10E6C236F7F7#23472 AS YNSECT_ALL_TRAY_37627_COL_66297348_CC53_497B_98E0_10E6C236F7F7#23496, COL_9EABBDD7_7BED_42F0_A922_637712817B51#23473 AS YNSECT_ALL_TRAY_37627_COL_9EABBDD7_7BED_42F0_A922_637712817B51#23497, COL_2ABDA2E0_4DEB_4FF7_9D92_E45932B42790#23474 AS YNSECT_ALL_TRAY_37627_COL_2ABDA2E0_4DEB_4FF7_9D92_E45932B42790#23498, COL_4A9C1E84_0C29_4139_9683_BE1B0436163E#23475 AS YNSECT_ALL_TRAY_37627_COL_4A9C1E84_0C29_4139_9683_BE1B0436163E#23499, COL_4552271C_6064_4B80_A4FC_FD60EF37390D#23476 AS YNSECT_ALL_TRAY_37627_COL_4552271C_6064_4B80_A4FC_FD60EF37390D#23500, COL_B53B5B70_7533_4624_8936_77BFAF29A1A8#23477 AS YNSECT_ALL_TRAY_37627_COL_B53B5B70_7533_4624_8936_77BFAF29A1A8#23501, COL_10B8E04C_35BE_4465_A856_7581B7F9319D#23478 AS YNSECT_ALL_TRAY_37627_COL_10B8E04C_35BE_4465_A856_7581B7F9319D#23502]
                                 +- SubqueryAlias YNSECT_ALL_TRAY_37627117
                                    +- Relation[COL_655080F4_5ECA_4FED_A763_9B0E34490248#23471,COL_66297348_CC53_497B_98E0_10E6C236F7F7#23472,COL_9EABBDD7_7BED_42F0_A922_637712817B51#23473,COL_2ABDA2E0_4DEB_4FF7_9D92_E45932B42790#23474,COL_4A9C1E84_0C29_4139_9683_BE1B0436163E#23475,COL_4552271C_6064_4B80_A4FC_FD60EF37390D#23476,COL_B53B5B70_7533_4624_8936_77BFAF29A1A8#23477,COL_10B8E04C_35BE_4465_A856_7581B7F9319D#23478] parquet

== Analyzed Logical Plan ==
COL_EB6BB67D_2489_48F9_9FA2_95341781F073: string, COL_D00CE058_37C2_4427_BBB8_CEE939636E01: timestamp, COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4: string, COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C: double, COL_CBD9EA88_6B17_4541_877D_1E22EDD09765: double, COL_6CFE2B33_647D_44A3_BA4A_811A300A479F: string, COL_222F41D1_267E_4321_B361_E29B83590B2D: string, COL_47956557_2FFB_4455_BDCE_2AEC22D1E501: double
GlobalLimit 500000
+- LocalLimit 500000
   +- Filter true
      +- Project [COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23671 AS COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23703, COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23672 AS COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23704, COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23673 AS COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23705, COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23674 AS COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23706, COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23675 AS COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23707, COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23676 AS COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23708, COL_222F41D1_267E_4321_B361_E29B83590B2D#23677 AS COL_222F41D1_267E_4321_B361_E29B83590B2D#23709, COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23678 AS COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23710]
         +- Project [COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23647 AS COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23671, COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23648 AS COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23672, COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23649 AS COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23673, COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23650 AS COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23674, COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23651 AS COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23675, COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23652 AS COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23676, COL_222F41D1_267E_4321_B361_E29B83590B2D#23653 AS COL_222F41D1_267E_4321_B361_E29B83590B2D#23677, COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23654 AS COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23678]
            +- Project [COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23615 AS COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23647, COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23616 AS COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23648, COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23617 AS COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23649, COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23618 AS COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23650, COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23619 AS COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23651, COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23620 AS COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23652, COL_222F41D1_267E_4321_B361_E29B83590B2D#23621 AS COL_222F41D1_267E_4321_B361_E29B83590B2D#23653, COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23622 AS COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23654]
               +- Project [COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23575 AS COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23615, COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23576 AS COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23616, COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23577 AS COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23617, COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23578 AS COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23618, COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23579 AS COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23619, COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23580 AS COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23620, COL_222F41D1_267E_4321_B361_E29B83590B2D#23581 AS COL_222F41D1_267E_4321_B361_E29B83590B2D#23621, COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23582 AS COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23622]
                  +- Project [COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23519 AS COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23575, COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23520 AS COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23576, COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23521 AS COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23577, COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23522 AS COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23578, COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23523 AS COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23579, COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23524 AS COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23580, COL_222F41D1_267E_4321_B361_E29B83590B2D#23525 AS COL_222F41D1_267E_4321_B361_E29B83590B2D#23581, COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23526 AS COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23582]
                     +- Project [COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23519, COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23520, COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23521, COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23522, COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23523, COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23524, COL_222F41D1_267E_4321_B361_E29B83590B2D#23525, COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23526]
                        +- Filter (COL_222F41D1_267E_4321_B361_E29B83590B2D#23525 <=> cast(Larvae as string))
                           +- Project [cast(YNSECT_ALL_TRAY_37627_COL_655080F4_5ECA_4FED_A763_9B0E34490248#23495 as string) AS COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23519, cast(YNSECT_ALL_TRAY_37627_COL_66297348_CC53_497B_98E0_10E6C236F7F7#23496 as timestamp) AS COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23520, cast(YNSECT_ALL_TRAY_37627_COL_9EABBDD7_7BED_42F0_A922_637712817B51#23497 as string) AS COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23521, cast(YNSECT_ALL_TRAY_37627_COL_2ABDA2E0_4DEB_4FF7_9D92_E45932B42790#23498 as double) AS COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23522, cast(YNSECT_ALL_TRAY_37627_COL_4A9C1E84_0C29_4139_9683_BE1B0436163E#23499 as double) AS COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23523, cast(YNSECT_ALL_TRAY_37627_COL_4552271C_6064_4B80_A4FC_FD60EF37390D#23500 as string) AS COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23524, cast(YNSECT_ALL_TRAY_37627_COL_B53B5B70_7533_4624_8936_77BFAF29A1A8#23501 as string) AS COL_222F41D1_267E_4321_B361_E29B83590B2D#23525, cast(YNSECT_ALL_TRAY_37627_COL_10B8E04C_35BE_4465_A856_7581B7F9319D#23502 as double) AS COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23526]
                              +- Project [COL_655080F4_5ECA_4FED_A763_9B0E34490248#23471 AS YNSECT_ALL_TRAY_37627_COL_655080F4_5ECA_4FED_A763_9B0E34490248#23495, COL_66297348_CC53_497B_98E0_10E6C236F7F7#23472 AS YNSECT_ALL_TRAY_37627_COL_66297348_CC53_497B_98E0_10E6C236F7F7#23496, COL_9EABBDD7_7BED_42F0_A922_637712817B51#23473 AS YNSECT_ALL_TRAY_37627_COL_9EABBDD7_7BED_42F0_A922_637712817B51#23497, COL_2ABDA2E0_4DEB_4FF7_9D92_E45932B42790#23474 AS YNSECT_ALL_TRAY_37627_COL_2ABDA2E0_4DEB_4FF7_9D92_E45932B42790#23498, COL_4A9C1E84_0C29_4139_9683_BE1B0436163E#23475 AS YNSECT_ALL_TRAY_37627_COL_4A9C1E84_0C29_4139_9683_BE1B0436163E#23499, COL_4552271C_6064_4B80_A4FC_FD60EF37390D#23476 AS YNSECT_ALL_TRAY_37627_COL_4552271C_6064_4B80_A4FC_FD60EF37390D#23500, COL_B53B5B70_7533_4624_8936_77BFAF29A1A8#23477 AS YNSECT_ALL_TRAY_37627_COL_B53B5B70_7533_4624_8936_77BFAF29A1A8#23501, COL_10B8E04C_35BE_4465_A856_7581B7F9319D#23478 AS YNSECT_ALL_TRAY_37627_COL_10B8E04C_35BE_4465_A856_7581B7F9319D#23502]
                                 +- SubqueryAlias YNSECT_ALL_TRAY_37627117
                                    +- Relation[COL_655080F4_5ECA_4FED_A763_9B0E34490248#23471,COL_66297348_CC53_497B_98E0_10E6C236F7F7#23472,COL_9EABBDD7_7BED_42F0_A922_637712817B51#23473,COL_2ABDA2E0_4DEB_4FF7_9D92_E45932B42790#23474,COL_4A9C1E84_0C29_4139_9683_BE1B0436163E#23475,COL_4552271C_6064_4B80_A4FC_FD60EF37390D#23476,COL_B53B5B70_7533_4624_8936_77BFAF29A1A8#23477,COL_10B8E04C_35BE_4465_A856_7581B7F9319D#23478] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_655080F4_5ECA_4FED_A763_9B0E34490248#23471 AS COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23519, COL_66297348_CC53_497B_98E0_10E6C236F7F7#23472 AS COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23520, COL_9EABBDD7_7BED_42F0_A922_637712817B51#23473 AS COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23521, COL_2ABDA2E0_4DEB_4FF7_9D92_E45932B42790#23474 AS COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23522, COL_4A9C1E84_0C29_4139_9683_BE1B0436163E#23475 AS COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23523, COL_4552271C_6064_4B80_A4FC_FD60EF37390D#23476 AS COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23524, COL_B53B5B70_7533_4624_8936_77BFAF29A1A8#23477 AS COL_222F41D1_267E_4321_B361_E29B83590B2D#23525, COL_10B8E04C_35BE_4465_A856_7581B7F9319D#23478 AS COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23526]
      +- Filter (COL_B53B5B70_7533_4624_8936_77BFAF29A1A8#23477 <=> Larvae)
         +- Relation[COL_655080F4_5ECA_4FED_A763_9B0E34490248#23471,COL_66297348_CC53_497B_98E0_10E6C236F7F7#23472,COL_9EABBDD7_7BED_42F0_A922_637712817B51#23473,COL_2ABDA2E0_4DEB_4FF7_9D92_E45932B42790#23474,COL_4A9C1E84_0C29_4139_9683_BE1B0436163E#23475,COL_4552271C_6064_4B80_A4FC_FD60EF37390D#23476,COL_B53B5B70_7533_4624_8936_77BFAF29A1A8#23477,COL_10B8E04C_35BE_4465_A856_7581B7F9319D#23478] parquet

== Physical Plan ==
CollectLimit 500000
+- *(1) Project [COL_655080F4_5ECA_4FED_A763_9B0E34490248#23471 AS COL_EB6BB67D_2489_48F9_9FA2_95341781F073#23519, COL_66297348_CC53_497B_98E0_10E6C236F7F7#23472 AS COL_D00CE058_37C2_4427_BBB8_CEE939636E01#23520, COL_9EABBDD7_7BED_42F0_A922_637712817B51#23473 AS COL_A22E4E7D_AA8D_4A53_A9C6_80C134C798D4#23521, COL_2ABDA2E0_4DEB_4FF7_9D92_E45932B42790#23474 AS COL_5C2DA607_F3FB_44A2_9ECD_84241F84A86C#23522, COL_4A9C1E84_0C29_4139_9683_BE1B0436163E#23475 AS COL_CBD9EA88_6B17_4541_877D_1E22EDD09765#23523, COL_4552271C_6064_4B80_A4FC_FD60EF37390D#23476 AS COL_6CFE2B33_647D_44A3_BA4A_811A300A479F#23524, COL_B53B5B70_7533_4624_8936_77BFAF29A1A8#23477 AS COL_222F41D1_267E_4321_B361_E29B83590B2D#23525, COL_10B8E04C_35BE_4465_A856_7581B7F9319D#23478 AS COL_47956557_2FFB_4455_BDCE_2AEC22D1E501#23526]
   +- *(1) Filter (COL_B53B5B70_7533_4624_8936_77BFAF29A1A8#23477 <=> Larvae)
      +- *(1) ColumnarToRow
         +- FileScan parquet [COL_655080F4_5ECA_4FED_A763_9B0E34490248#23471,COL_66297348_CC53_497B_98E0_10E6C236F7F7#23472,COL_9EABBDD7_7BED_42F0_A922_637712817B51#23473,COL_2ABDA2E0_4DEB_4FF7_9D92_E45932B42790#23474,COL_4A9C1E84_0C29_4139_9683_BE1B0436163E#23475,COL_4552271C_6064_4B80_A4FC_FD60EF37390D#23476,COL_B53B5B70_7533_4624_8936_77BFAF29A1A8#23477,COL_10B8E04C_35BE_4465_A856_7581B7F9319D#23478] Batched: true, DataFilters: [(COL_B53B5B70_7533_4624_8936_77BFAF29A1A8#23477 <=> Larvae)], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/YNSECT_ALL_TRAY_37627], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_B53B5B70_7533_4624_8936_77BFAF29A1A8,Larvae)], ReadSchema: struct<COL_655080F4_5ECA_4FED_A763_9B0E34490248:string,COL_66297348_CC53_497B_98E0_10E6C236F7F7:t...