== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Filter true
+- Project [COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30527 AS COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30571, COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30528 AS COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30572, COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30529 AS COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30573, COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30530 AS COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30574, COL_8985D529_F1F7_4259_9961_16CE08C73C02#30531 AS COL_8985D529_F1F7_4259_9961_16CE08C73C02#30575, COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30532 AS COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30576, COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30533 AS COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30577, COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30534 AS COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30578, COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30535L AS COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30579L, COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30536 AS COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30580, COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30537 AS COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30581, COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30538L AS COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30582L]
+- Project [COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30463 AS COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30527, COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30464 AS COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30528, COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30465 AS COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30529, COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30466 AS COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30530, COL_8985D529_F1F7_4259_9961_16CE08C73C02#30467 AS COL_8985D529_F1F7_4259_9961_16CE08C73C02#30531, COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30468 AS COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30532, COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30469 AS COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30533, COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30470 AS COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30534, COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30471L AS COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30535L, COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30472 AS COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30536, COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30473 AS COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30537, COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30474L AS COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30538L]
+- Project [COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30399 AS COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30463, COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30400 AS COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30464, COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30401 AS COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30465, COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30402 AS COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30466, COL_8985D529_F1F7_4259_9961_16CE08C73C02#30403 AS COL_8985D529_F1F7_4259_9961_16CE08C73C02#30467, COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30404 AS COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30468, COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30405 AS COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30469, COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30406 AS COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30470, COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30407L AS COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30471L, COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30408 AS COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30472, COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30409 AS COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30473, COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30410L AS COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30474L]
+- Project [COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30295 AS COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30399, COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30296 AS COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30400, COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30297 AS COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30401, COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30298 AS COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30402, COL_8985D529_F1F7_4259_9961_16CE08C73C02#30299 AS COL_8985D529_F1F7_4259_9961_16CE08C73C02#30403, COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30300 AS COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30404, COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30301 AS COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30405, COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30302 AS COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30406, COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30303L AS COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30407L, COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30304 AS COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30408, COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30305 AS COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30409, COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30306L AS COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30410L]
+- Project [COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30231 AS COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30295, COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30232 AS COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30296, COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30233 AS COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30297, COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30234 AS COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30298, COL_8985D529_F1F7_4259_9961_16CE08C73C02#30235 AS COL_8985D529_F1F7_4259_9961_16CE08C73C02#30299, COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30236 AS COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30300, COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30237 AS COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30301, COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30238 AS COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30302, COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30239L AS COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30303L, COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30240 AS COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30304, COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30241 AS COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30305, COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30242L AS COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30306L]
+- Project [COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30167 AS COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30231, COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30171 AS COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30232, COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30174 AS COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30233, COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30177 AS COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30234, COL_8985D529_F1F7_4259_9961_16CE08C73C02#30180 AS COL_8985D529_F1F7_4259_9961_16CE08C73C02#30235, COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30183 AS COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30236, COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30186 AS COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30237, COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30189 AS COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30238, COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30192L AS COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30239L, COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30195 AS COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30240, COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30197 AS COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30241, COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30198L AS COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30242L]
+- Filter (COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30186 <=> cast(Larvae as string))
+- Project [cast(YNSECT_COHORTES_37602_COL_1994AEE4_C7F1_46DB_82C8_917372F1095C#30091 as string) AS COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30167, cast(YNSECT_COHORTES_37602_COL_5578CD92_21F3_4859_8B96_4D51AFF214B7#30092 as timestamp) AS COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30171, cast(YNSECT_COHORTES_37602_COL_B82385FE_79E0_4F00_AB06_09064EF10F56#30093 as string) AS COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30174, cast(YNSECT_COHORTES_37602_COL_A6636F5D_5C95_43E6_A62A_616CA48604B1#30094 as double) AS COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30177, cast(YNSECT_COHORTES_37602_COL_A35E709B_6B24_45A2_ADDE_759C8DC6AB5B#30095 as double) AS COL_8985D529_F1F7_4259_9961_16CE08C73C02#30180, cast(YNSECT_COHORTES_37602_COL_416E177A_B17E_4760_86A1_535383AE17C4#30096 as string) AS COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30183, cast(YNSECT_COHORTES_37602_COL_C818077B_0A65_4AD3_B2FD_DD213FE75D20#30097 as string) AS COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30186, cast(YNSECT_COHORTES_37602_COL_CC278B62_8D89_4CF3_9D81_3207632F8789#30098 as double) AS COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30189, cast(YNSECT_COHORTES_37602_COL_C4E4AA09_5787_4434_ACB9_073BD8189EB8#30099L as bigint) AS COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30192L, cast(YNSECT_COHORTES_37602_COL_BA278BC4_2019_4D4E_88A0_56C639AEBCE1#30100 as double) AS COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30195, cast(YNSECT_COHORTES_37602_COL_E4AB952E_6682_457D_9A9D_36C665C0CFB5#30102 as double) AS COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30197, cast(YNSECT_COHORTES_37602_COL_4A911470_331A_4FB4_8F36_B6DEC61D5785#30101L as bigint) AS COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30198L]
+- Project [COL_1994AEE4_C7F1_46DB_82C8_917372F1095C#29985 AS YNSECT_COHORTES_37602_COL_1994AEE4_C7F1_46DB_82C8_917372F1095C#30091, COL_5578CD92_21F3_4859_8B96_4D51AFF214B7#29986 AS YNSECT_COHORTES_37602_COL_5578CD92_21F3_4859_8B96_4D51AFF214B7#30092, COL_B82385FE_79E0_4F00_AB06_09064EF10F56#29987 AS YNSECT_COHORTES_37602_COL_B82385FE_79E0_4F00_AB06_09064EF10F56#30093, COL_A6636F5D_5C95_43E6_A62A_616CA48604B1#29988 AS YNSECT_COHORTES_37602_COL_A6636F5D_5C95_43E6_A62A_616CA48604B1#30094, COL_A35E709B_6B24_45A2_ADDE_759C8DC6AB5B#29989 AS YNSECT_COHORTES_37602_COL_A35E709B_6B24_45A2_ADDE_759C8DC6AB5B#30095, COL_416E177A_B17E_4760_86A1_535383AE17C4#29990 AS YNSECT_COHORTES_37602_COL_416E177A_B17E_4760_86A1_535383AE17C4#30096, COL_C818077B_0A65_4AD3_B2FD_DD213FE75D20#29991 AS YNSECT_COHORTES_37602_COL_C818077B_0A65_4AD3_B2FD_DD213FE75D20#30097, COL_CC278B62_8D89_4CF3_9D81_3207632F8789#29992 AS YNSECT_COHORTES_37602_COL_CC278B62_8D89_4CF3_9D81_3207632F8789#30098, COL_C4E4AA09_5787_4434_ACB9_073BD8189EB8#29993L AS YNSECT_COHORTES_37602_COL_C4E4AA09_5787_4434_ACB9_073BD8189EB8#30099L, COL_BA278BC4_2019_4D4E_88A0_56C639AEBCE1#29994 AS YNSECT_COHORTES_37602_COL_BA278BC4_2019_4D4E_88A0_56C639AEBCE1#30100, COL_4A911470_331A_4FB4_8F36_B6DEC61D5785#29995L AS YNSECT_COHORTES_37602_COL_4A911470_331A_4FB4_8F36_B6DEC61D5785#30101L, COL_E4AB952E_6682_457D_9A9D_36C665C0CFB5#29996 AS YNSECT_COHORTES_37602_COL_E4AB952E_6682_457D_9A9D_36C665C0CFB5#30102]
+- SubqueryAlias YNSECT_COHORTES_37602116
+- Relation[COL_1994AEE4_C7F1_46DB_82C8_917372F1095C#29985,COL_5578CD92_21F3_4859_8B96_4D51AFF214B7#29986,COL_B82385FE_79E0_4F00_AB06_09064EF10F56#29987,COL_A6636F5D_5C95_43E6_A62A_616CA48604B1#29988,COL_A35E709B_6B24_45A2_ADDE_759C8DC6AB5B#29989,COL_416E177A_B17E_4760_86A1_535383AE17C4#29990,COL_C818077B_0A65_4AD3_B2FD_DD213FE75D20#29991,COL_CC278B62_8D89_4CF3_9D81_3207632F8789#29992,COL_C4E4AA09_5787_4434_ACB9_073BD8189EB8#29993L,COL_BA278BC4_2019_4D4E_88A0_56C639AEBCE1#29994,COL_4A911470_331A_4FB4_8F36_B6DEC61D5785#29995L,COL_E4AB952E_6682_457D_9A9D_36C665C0CFB5#29996] parquet
== Analyzed Logical Plan ==
COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67: string, COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11: timestamp, COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965: string, COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D: double, COL_8985D529_F1F7_4259_9961_16CE08C73C02: double, COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13: string, COL_9D598458_FC98_40DB_B5BF_A43D3E34A768: string, COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA: double, COL_5CF37BBB_6435_4F99_8431_4E64E18C3106: bigint, COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04: double, COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F: double, COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF: bigint
GlobalLimit 500000
+- LocalLimit 500000
+- Filter true
+- Project [COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30527 AS COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30571, COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30528 AS COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30572, COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30529 AS COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30573, COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30530 AS COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30574, COL_8985D529_F1F7_4259_9961_16CE08C73C02#30531 AS COL_8985D529_F1F7_4259_9961_16CE08C73C02#30575, COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30532 AS COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30576, COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30533 AS COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30577, COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30534 AS COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30578, COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30535L AS COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30579L, COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30536 AS COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30580, COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30537 AS COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30581, COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30538L AS COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30582L]
+- Project [COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30463 AS COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30527, COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30464 AS COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30528, COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30465 AS COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30529, COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30466 AS COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30530, COL_8985D529_F1F7_4259_9961_16CE08C73C02#30467 AS COL_8985D529_F1F7_4259_9961_16CE08C73C02#30531, COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30468 AS COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30532, COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30469 AS COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30533, COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30470 AS COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30534, COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30471L AS COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30535L, COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30472 AS COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30536, COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30473 AS COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30537, COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30474L AS COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30538L]
+- Project [COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30399 AS COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30463, COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30400 AS COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30464, COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30401 AS COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30465, COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30402 AS COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30466, COL_8985D529_F1F7_4259_9961_16CE08C73C02#30403 AS COL_8985D529_F1F7_4259_9961_16CE08C73C02#30467, COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30404 AS COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30468, COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30405 AS COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30469, COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30406 AS COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30470, COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30407L AS COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30471L, COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30408 AS COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30472, COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30409 AS COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30473, COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30410L AS COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30474L]
+- Project [COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30295 AS COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30399, COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30296 AS COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30400, COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30297 AS COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30401, COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30298 AS COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30402, COL_8985D529_F1F7_4259_9961_16CE08C73C02#30299 AS COL_8985D529_F1F7_4259_9961_16CE08C73C02#30403, COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30300 AS COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30404, COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30301 AS COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30405, COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30302 AS COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30406, COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30303L AS COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30407L, COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30304 AS COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30408, COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30305 AS COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30409, COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30306L AS COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30410L]
+- Project [COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30231 AS COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30295, COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30232 AS COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30296, COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30233 AS COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30297, COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30234 AS COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30298, COL_8985D529_F1F7_4259_9961_16CE08C73C02#30235 AS COL_8985D529_F1F7_4259_9961_16CE08C73C02#30299, COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30236 AS COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30300, COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30237 AS COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30301, COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30238 AS COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30302, COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30239L AS COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30303L, COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30240 AS COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30304, COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30241 AS COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30305, COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30242L AS COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30306L]
+- Project [COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30167 AS COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30231, COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30171 AS COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30232, COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30174 AS COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30233, COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30177 AS COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30234, COL_8985D529_F1F7_4259_9961_16CE08C73C02#30180 AS COL_8985D529_F1F7_4259_9961_16CE08C73C02#30235, COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30183 AS COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30236, COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30186 AS COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30237, COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30189 AS COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30238, COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30192L AS COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30239L, COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30195 AS COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30240, COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30197 AS COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30241, COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30198L AS COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30242L]
+- Filter (COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30186 <=> cast(Larvae as string))
+- Project [cast(YNSECT_COHORTES_37602_COL_1994AEE4_C7F1_46DB_82C8_917372F1095C#30091 as string) AS COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30167, cast(YNSECT_COHORTES_37602_COL_5578CD92_21F3_4859_8B96_4D51AFF214B7#30092 as timestamp) AS COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30171, cast(YNSECT_COHORTES_37602_COL_B82385FE_79E0_4F00_AB06_09064EF10F56#30093 as string) AS COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30174, cast(YNSECT_COHORTES_37602_COL_A6636F5D_5C95_43E6_A62A_616CA48604B1#30094 as double) AS COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30177, cast(YNSECT_COHORTES_37602_COL_A35E709B_6B24_45A2_ADDE_759C8DC6AB5B#30095 as double) AS COL_8985D529_F1F7_4259_9961_16CE08C73C02#30180, cast(YNSECT_COHORTES_37602_COL_416E177A_B17E_4760_86A1_535383AE17C4#30096 as string) AS COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30183, cast(YNSECT_COHORTES_37602_COL_C818077B_0A65_4AD3_B2FD_DD213FE75D20#30097 as string) AS COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30186, cast(YNSECT_COHORTES_37602_COL_CC278B62_8D89_4CF3_9D81_3207632F8789#30098 as double) AS COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30189, cast(YNSECT_COHORTES_37602_COL_C4E4AA09_5787_4434_ACB9_073BD8189EB8#30099L as bigint) AS COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30192L, cast(YNSECT_COHORTES_37602_COL_BA278BC4_2019_4D4E_88A0_56C639AEBCE1#30100 as double) AS COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30195, cast(YNSECT_COHORTES_37602_COL_E4AB952E_6682_457D_9A9D_36C665C0CFB5#30102 as double) AS COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30197, cast(YNSECT_COHORTES_37602_COL_4A911470_331A_4FB4_8F36_B6DEC61D5785#30101L as bigint) AS COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30198L]
+- Project [COL_1994AEE4_C7F1_46DB_82C8_917372F1095C#29985 AS YNSECT_COHORTES_37602_COL_1994AEE4_C7F1_46DB_82C8_917372F1095C#30091, COL_5578CD92_21F3_4859_8B96_4D51AFF214B7#29986 AS YNSECT_COHORTES_37602_COL_5578CD92_21F3_4859_8B96_4D51AFF214B7#30092, COL_B82385FE_79E0_4F00_AB06_09064EF10F56#29987 AS YNSECT_COHORTES_37602_COL_B82385FE_79E0_4F00_AB06_09064EF10F56#30093, COL_A6636F5D_5C95_43E6_A62A_616CA48604B1#29988 AS YNSECT_COHORTES_37602_COL_A6636F5D_5C95_43E6_A62A_616CA48604B1#30094, COL_A35E709B_6B24_45A2_ADDE_759C8DC6AB5B#29989 AS YNSECT_COHORTES_37602_COL_A35E709B_6B24_45A2_ADDE_759C8DC6AB5B#30095, COL_416E177A_B17E_4760_86A1_535383AE17C4#29990 AS YNSECT_COHORTES_37602_COL_416E177A_B17E_4760_86A1_535383AE17C4#30096, COL_C818077B_0A65_4AD3_B2FD_DD213FE75D20#29991 AS YNSECT_COHORTES_37602_COL_C818077B_0A65_4AD3_B2FD_DD213FE75D20#30097, COL_CC278B62_8D89_4CF3_9D81_3207632F8789#29992 AS YNSECT_COHORTES_37602_COL_CC278B62_8D89_4CF3_9D81_3207632F8789#30098, COL_C4E4AA09_5787_4434_ACB9_073BD8189EB8#29993L AS YNSECT_COHORTES_37602_COL_C4E4AA09_5787_4434_ACB9_073BD8189EB8#30099L, COL_BA278BC4_2019_4D4E_88A0_56C639AEBCE1#29994 AS YNSECT_COHORTES_37602_COL_BA278BC4_2019_4D4E_88A0_56C639AEBCE1#30100, COL_4A911470_331A_4FB4_8F36_B6DEC61D5785#29995L AS YNSECT_COHORTES_37602_COL_4A911470_331A_4FB4_8F36_B6DEC61D5785#30101L, COL_E4AB952E_6682_457D_9A9D_36C665C0CFB5#29996 AS YNSECT_COHORTES_37602_COL_E4AB952E_6682_457D_9A9D_36C665C0CFB5#30102]
+- SubqueryAlias YNSECT_COHORTES_37602116
+- Relation[COL_1994AEE4_C7F1_46DB_82C8_917372F1095C#29985,COL_5578CD92_21F3_4859_8B96_4D51AFF214B7#29986,COL_B82385FE_79E0_4F00_AB06_09064EF10F56#29987,COL_A6636F5D_5C95_43E6_A62A_616CA48604B1#29988,COL_A35E709B_6B24_45A2_ADDE_759C8DC6AB5B#29989,COL_416E177A_B17E_4760_86A1_535383AE17C4#29990,COL_C818077B_0A65_4AD3_B2FD_DD213FE75D20#29991,COL_CC278B62_8D89_4CF3_9D81_3207632F8789#29992,COL_C4E4AA09_5787_4434_ACB9_073BD8189EB8#29993L,COL_BA278BC4_2019_4D4E_88A0_56C639AEBCE1#29994,COL_4A911470_331A_4FB4_8F36_B6DEC61D5785#29995L,COL_E4AB952E_6682_457D_9A9D_36C665C0CFB5#29996] parquet
== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Project [COL_1994AEE4_C7F1_46DB_82C8_917372F1095C#29985 AS COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30167, COL_5578CD92_21F3_4859_8B96_4D51AFF214B7#29986 AS COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30171, COL_B82385FE_79E0_4F00_AB06_09064EF10F56#29987 AS COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30174, COL_A6636F5D_5C95_43E6_A62A_616CA48604B1#29988 AS COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30177, COL_A35E709B_6B24_45A2_ADDE_759C8DC6AB5B#29989 AS COL_8985D529_F1F7_4259_9961_16CE08C73C02#30180, COL_416E177A_B17E_4760_86A1_535383AE17C4#29990 AS COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30183, COL_C818077B_0A65_4AD3_B2FD_DD213FE75D20#29991 AS COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30186, COL_CC278B62_8D89_4CF3_9D81_3207632F8789#29992 AS COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30189, COL_C4E4AA09_5787_4434_ACB9_073BD8189EB8#29993L AS COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30192L, COL_BA278BC4_2019_4D4E_88A0_56C639AEBCE1#29994 AS COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30195, COL_E4AB952E_6682_457D_9A9D_36C665C0CFB5#29996 AS COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30197, COL_4A911470_331A_4FB4_8F36_B6DEC61D5785#29995L AS COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30198L]
+- Filter (COL_C818077B_0A65_4AD3_B2FD_DD213FE75D20#29991 <=> Larvae)
+- Relation[COL_1994AEE4_C7F1_46DB_82C8_917372F1095C#29985,COL_5578CD92_21F3_4859_8B96_4D51AFF214B7#29986,COL_B82385FE_79E0_4F00_AB06_09064EF10F56#29987,COL_A6636F5D_5C95_43E6_A62A_616CA48604B1#29988,COL_A35E709B_6B24_45A2_ADDE_759C8DC6AB5B#29989,COL_416E177A_B17E_4760_86A1_535383AE17C4#29990,COL_C818077B_0A65_4AD3_B2FD_DD213FE75D20#29991,COL_CC278B62_8D89_4CF3_9D81_3207632F8789#29992,COL_C4E4AA09_5787_4434_ACB9_073BD8189EB8#29993L,COL_BA278BC4_2019_4D4E_88A0_56C639AEBCE1#29994,COL_4A911470_331A_4FB4_8F36_B6DEC61D5785#29995L,COL_E4AB952E_6682_457D_9A9D_36C665C0CFB5#29996] parquet
== Physical Plan ==
CollectLimit 500000
+- *(1) Project [COL_1994AEE4_C7F1_46DB_82C8_917372F1095C#29985 AS COL_871FC34C_BDDB_46B7_A8CC_FF6B73838A67#30167, COL_5578CD92_21F3_4859_8B96_4D51AFF214B7#29986 AS COL_E2E75630_AA10_4E14_AD9E_5EC763BDFA11#30171, COL_B82385FE_79E0_4F00_AB06_09064EF10F56#29987 AS COL_EB57E5E4_AA39_4D44_9583_C6CEE6FE9965#30174, COL_A6636F5D_5C95_43E6_A62A_616CA48604B1#29988 AS COL_F37755E6_8B15_4CFC_823F_6B6A2625FC2D#30177, COL_A35E709B_6B24_45A2_ADDE_759C8DC6AB5B#29989 AS COL_8985D529_F1F7_4259_9961_16CE08C73C02#30180, COL_416E177A_B17E_4760_86A1_535383AE17C4#29990 AS COL_71E2638A_3D9D_42FA_A373_CBC309F6CC13#30183, COL_C818077B_0A65_4AD3_B2FD_DD213FE75D20#29991 AS COL_9D598458_FC98_40DB_B5BF_A43D3E34A768#30186, COL_CC278B62_8D89_4CF3_9D81_3207632F8789#29992 AS COL_2EB08A16_E7E7_49C8_BE65_D3815F2B2BDA#30189, COL_C4E4AA09_5787_4434_ACB9_073BD8189EB8#29993L AS COL_5CF37BBB_6435_4F99_8431_4E64E18C3106#30192L, COL_BA278BC4_2019_4D4E_88A0_56C639AEBCE1#29994 AS COL_432AA0A4_27D0_4E5C_828A_95EE0BCFFC04#30195, COL_E4AB952E_6682_457D_9A9D_36C665C0CFB5#29996 AS COL_F9A714EB_9DDC_470A_933A_FB8F361EFE4F#30197, COL_4A911470_331A_4FB4_8F36_B6DEC61D5785#29995L AS COL_85A25F4C_2CB9_4CD7_8996_07157B0C09BF#30198L]
+- *(1) Filter (COL_C818077B_0A65_4AD3_B2FD_DD213FE75D20#29991 <=> Larvae)
+- *(1) ColumnarToRow
+- FileScan parquet [COL_1994AEE4_C7F1_46DB_82C8_917372F1095C#29985,COL_5578CD92_21F3_4859_8B96_4D51AFF214B7#29986,COL_B82385FE_79E0_4F00_AB06_09064EF10F56#29987,COL_A6636F5D_5C95_43E6_A62A_616CA48604B1#29988,COL_A35E709B_6B24_45A2_ADDE_759C8DC6AB5B#29989,COL_416E177A_B17E_4760_86A1_535383AE17C4#29990,COL_C818077B_0A65_4AD3_B2FD_DD213FE75D20#29991,COL_CC278B62_8D89_4CF3_9D81_3207632F8789#29992,COL_C4E4AA09_5787_4434_ACB9_073BD8189EB8#29993L,COL_BA278BC4_2019_4D4E_88A0_56C639AEBCE1#29994,COL_4A911470_331A_4FB4_8F36_B6DEC61D5785#29995L,COL_E4AB952E_6682_457D_9A9D_36C665C0CFB5#29996] Batched: true, DataFilters: [(COL_C818077B_0A65_4AD3_B2FD_DD213FE75D20#29991 <=> Larvae)], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/YNSECT_COHORTES_37602], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_C818077B_0A65_4AD3_B2FD_DD213FE75D20,Larvae)], ReadSchema: struct<COL_1994AEE4_C7F1_46DB_82C8_917372F1095C:string,COL_5578CD92_21F3_4859_8B96_4D51AFF214B7:t...