== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Filter true
+- Project [COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30824 AS COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30848, COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30825 AS COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30849, COL_29528422_A642_4C28_9255_B43CAD8916FF#30826 AS COL_29528422_A642_4C28_9255_B43CAD8916FF#30850, COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30827 AS COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30851, COL_45B79445_6BED_4729_B592_A47BE201FED3#30828 AS COL_45B79445_6BED_4729_B592_A47BE201FED3#30852, COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30829 AS COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30853]
+- Project [COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30800 AS COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30824, COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30801 AS COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30825, COL_29528422_A642_4C28_9255_B43CAD8916FF#30802 AS COL_29528422_A642_4C28_9255_B43CAD8916FF#30826, COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30803 AS COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30827, COL_45B79445_6BED_4729_B592_A47BE201FED3#30804 AS COL_45B79445_6BED_4729_B592_A47BE201FED3#30828, COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30805 AS COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30829]
+- Project [COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30788 AS COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30800, COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30789 AS COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30801, COL_29528422_A642_4C28_9255_B43CAD8916FF#30790 AS COL_29528422_A642_4C28_9255_B43CAD8916FF#30802, COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30791 AS COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30803, COL_45B79445_6BED_4729_B592_A47BE201FED3#30792 AS COL_45B79445_6BED_4729_B592_A47BE201FED3#30804, COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30793 AS COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30805]
+- Project [COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30770 AS COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30788, COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30771 AS COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30789, COL_29528422_A642_4C28_9255_B43CAD8916FF#30772 AS COL_29528422_A642_4C28_9255_B43CAD8916FF#30790, COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30773 AS COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30791, COL_45B79445_6BED_4729_B592_A47BE201FED3#30774 AS COL_45B79445_6BED_4729_B592_A47BE201FED3#30792, COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30775 AS COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30793]
+- Project [COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30728 AS COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30770, COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30729 AS COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30771, COL_29528422_A642_4C28_9255_B43CAD8916FF#30730 AS COL_29528422_A642_4C28_9255_B43CAD8916FF#30772, COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30731 AS COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30773, COL_45B79445_6BED_4729_B592_A47BE201FED3#30732 AS COL_45B79445_6BED_4729_B592_A47BE201FED3#30774, COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30733 AS COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30775]
+- Filter (COL_45B79445_6BED_4729_B592_A47BE201FED3#30732 <=> cast(Small_larvae as string))
+- Project [COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30728, COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30729, COL_29528422_A642_4C28_9255_B43CAD8916FF#30730, COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30731, COL_45B79445_6BED_4729_B592_A47BE201FED3#30732, COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30733]
+- Filter (COL_45B79445_6BED_4729_B592_A47BE201FED3#30732 <=> cast(Larvae as string))
+- Project [cast(GENEALOGIE_BACS_37595_COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30692 as string) AS COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30728, cast(GENEALOGIE_BACS_37595_COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30693 as string) AS COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30729, cast(GENEALOGIE_BACS_37595_COL_7DDC0C91_935D_421E_9979_6999F441DB11#30694 as timestamp) AS COL_29528422_A642_4C28_9255_B43CAD8916FF#30730, cast(GENEALOGIE_BACS_37595_COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30695 as timestamp) AS COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30731, cast(GENEALOGIE_BACS_37595_COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30696 as string) AS COL_45B79445_6BED_4729_B592_A47BE201FED3#30732, cast(GENEALOGIE_BACS_37595_COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30697 as array<string>) AS COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30733]
+- Project [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30662 AS GENEALOGIE_BACS_37595_COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30692, COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30663 AS GENEALOGIE_BACS_37595_COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30693, COL_7DDC0C91_935D_421E_9979_6999F441DB11#30664 AS GENEALOGIE_BACS_37595_COL_7DDC0C91_935D_421E_9979_6999F441DB11#30694, COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30665 AS GENEALOGIE_BACS_37595_COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30695, COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30666 AS GENEALOGIE_BACS_37595_COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30696, COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30667 AS GENEALOGIE_BACS_37595_COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30697]
+- SubqueryAlias GENEALOGIE_BACS_37595115
+- Relation[COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30662,COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30663,COL_7DDC0C91_935D_421E_9979_6999F441DB11#30664,COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30665,COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30666,COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30667] parquet
== Analyzed Logical Plan ==
COL_AA144087_DB4E_4DAB_AD95_247FE3366D70: string, COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7: string, COL_29528422_A642_4C28_9255_B43CAD8916FF: timestamp, COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F: timestamp, COL_45B79445_6BED_4729_B592_A47BE201FED3: string, COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5: array<string>
GlobalLimit 500000
+- LocalLimit 500000
+- Filter true
+- Project [COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30824 AS COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30848, COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30825 AS COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30849, COL_29528422_A642_4C28_9255_B43CAD8916FF#30826 AS COL_29528422_A642_4C28_9255_B43CAD8916FF#30850, COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30827 AS COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30851, COL_45B79445_6BED_4729_B592_A47BE201FED3#30828 AS COL_45B79445_6BED_4729_B592_A47BE201FED3#30852, COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30829 AS COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30853]
+- Project [COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30800 AS COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30824, COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30801 AS COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30825, COL_29528422_A642_4C28_9255_B43CAD8916FF#30802 AS COL_29528422_A642_4C28_9255_B43CAD8916FF#30826, COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30803 AS COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30827, COL_45B79445_6BED_4729_B592_A47BE201FED3#30804 AS COL_45B79445_6BED_4729_B592_A47BE201FED3#30828, COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30805 AS COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30829]
+- Project [COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30788 AS COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30800, COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30789 AS COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30801, COL_29528422_A642_4C28_9255_B43CAD8916FF#30790 AS COL_29528422_A642_4C28_9255_B43CAD8916FF#30802, COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30791 AS COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30803, COL_45B79445_6BED_4729_B592_A47BE201FED3#30792 AS COL_45B79445_6BED_4729_B592_A47BE201FED3#30804, COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30793 AS COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30805]
+- Project [COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30770 AS COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30788, COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30771 AS COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30789, COL_29528422_A642_4C28_9255_B43CAD8916FF#30772 AS COL_29528422_A642_4C28_9255_B43CAD8916FF#30790, COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30773 AS COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30791, COL_45B79445_6BED_4729_B592_A47BE201FED3#30774 AS COL_45B79445_6BED_4729_B592_A47BE201FED3#30792, COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30775 AS COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30793]
+- Project [COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30728 AS COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30770, COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30729 AS COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30771, COL_29528422_A642_4C28_9255_B43CAD8916FF#30730 AS COL_29528422_A642_4C28_9255_B43CAD8916FF#30772, COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30731 AS COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30773, COL_45B79445_6BED_4729_B592_A47BE201FED3#30732 AS COL_45B79445_6BED_4729_B592_A47BE201FED3#30774, COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30733 AS COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30775]
+- Filter (COL_45B79445_6BED_4729_B592_A47BE201FED3#30732 <=> cast(Small_larvae as string))
+- Project [COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30728, COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30729, COL_29528422_A642_4C28_9255_B43CAD8916FF#30730, COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30731, COL_45B79445_6BED_4729_B592_A47BE201FED3#30732, COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30733]
+- Filter (COL_45B79445_6BED_4729_B592_A47BE201FED3#30732 <=> cast(Larvae as string))
+- Project [cast(GENEALOGIE_BACS_37595_COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30692 as string) AS COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30728, cast(GENEALOGIE_BACS_37595_COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30693 as string) AS COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30729, cast(GENEALOGIE_BACS_37595_COL_7DDC0C91_935D_421E_9979_6999F441DB11#30694 as timestamp) AS COL_29528422_A642_4C28_9255_B43CAD8916FF#30730, cast(GENEALOGIE_BACS_37595_COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30695 as timestamp) AS COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30731, cast(GENEALOGIE_BACS_37595_COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30696 as string) AS COL_45B79445_6BED_4729_B592_A47BE201FED3#30732, cast(GENEALOGIE_BACS_37595_COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30697 as array<string>) AS COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30733]
+- Project [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30662 AS GENEALOGIE_BACS_37595_COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30692, COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30663 AS GENEALOGIE_BACS_37595_COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30693, COL_7DDC0C91_935D_421E_9979_6999F441DB11#30664 AS GENEALOGIE_BACS_37595_COL_7DDC0C91_935D_421E_9979_6999F441DB11#30694, COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30665 AS GENEALOGIE_BACS_37595_COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30695, COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30666 AS GENEALOGIE_BACS_37595_COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30696, COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30667 AS GENEALOGIE_BACS_37595_COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30697]
+- SubqueryAlias GENEALOGIE_BACS_37595115
+- Relation[COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30662,COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30663,COL_7DDC0C91_935D_421E_9979_6999F441DB11#30664,COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30665,COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30666,COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30667] parquet
== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Project [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30662 AS COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30728, COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30663 AS COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30729, COL_7DDC0C91_935D_421E_9979_6999F441DB11#30664 AS COL_29528422_A642_4C28_9255_B43CAD8916FF#30730, COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30665 AS COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30731, COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30666 AS COL_45B79445_6BED_4729_B592_A47BE201FED3#30732, COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30667 AS COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30733]
+- Filter ((COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30666 <=> Larvae) AND (COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30666 <=> Small_larvae))
+- Relation[COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30662,COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30663,COL_7DDC0C91_935D_421E_9979_6999F441DB11#30664,COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30665,COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30666,COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30667] parquet
== Physical Plan ==
CollectLimit 500000
+- *(1) Project [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30662 AS COL_AA144087_DB4E_4DAB_AD95_247FE3366D70#30728, COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30663 AS COL_6D5A082C_9DD0_48C1_B4B7_ADBE9FDA7BF7#30729, COL_7DDC0C91_935D_421E_9979_6999F441DB11#30664 AS COL_29528422_A642_4C28_9255_B43CAD8916FF#30730, COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30665 AS COL_318D9CDF_AB80_4755_88DC_FDAA57059A4F#30731, COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30666 AS COL_45B79445_6BED_4729_B592_A47BE201FED3#30732, COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30667 AS COL_AD556D9D_0F51_4A32_B381_6B1C90C499C5#30733]
+- *(1) Filter ((COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30666 <=> Larvae) AND (COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30666 <=> Small_larvae))
+- FileScan parquet [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30662,COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30663,COL_7DDC0C91_935D_421E_9979_6999F441DB11#30664,COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30665,COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30666,COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30667] Batched: false, DataFilters: [(COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30666 <=> Larvae), (COL_09AE520E_1F43_4D16_BD81_971EFC..., Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/GENEALOGIE_BACS_37595], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_09AE520E_1F43_4D16_BD81_971EFC407F67,Larvae), EqualNullSafe(COL_09AE520E_1F43_..., ReadSchema: struct<COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B:string,COL_00D4BAFE_C015_4657_A108_4EA72231DC63:s...