== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Filter true
+- Project [COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30994 AS COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#31006, COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30995 AS COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#31007, COL_D7C13F10_82E7_4574_A512_6AC94400B894#30996 AS COL_D7C13F10_82E7_4574_A512_6AC94400B894#31008, COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30997 AS COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#31009, COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30998 AS COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#31010, COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30999 AS COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#31011]
+- Project [COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30982 AS COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30994, COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30983 AS COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30995, COL_D7C13F10_82E7_4574_A512_6AC94400B894#30984 AS COL_D7C13F10_82E7_4574_A512_6AC94400B894#30996, COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30985 AS COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30997, COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30986 AS COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30998, COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30987 AS COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30999]
+- Project [COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30970 AS COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30982, COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30971 AS COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30983, COL_D7C13F10_82E7_4574_A512_6AC94400B894#30972 AS COL_D7C13F10_82E7_4574_A512_6AC94400B894#30984, COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30973 AS COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30985, COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30974 AS COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30986, COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30975 AS COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30987]
+- Project [COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30952 AS COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30970, COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30953 AS COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30971, COL_D7C13F10_82E7_4574_A512_6AC94400B894#30954 AS COL_D7C13F10_82E7_4574_A512_6AC94400B894#30972, COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30955 AS COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30973, COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30956 AS COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30974, COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30957 AS COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30975]
+- Project [COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30926 AS COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30952, COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30927 AS COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30953, COL_D7C13F10_82E7_4574_A512_6AC94400B894#30928 AS COL_D7C13F10_82E7_4574_A512_6AC94400B894#30954, COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30929 AS COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30955, COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30930 AS COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30956, COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30931 AS COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30957]
+- Filter (COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30930 <=> cast(Larvae as string))
+- Project [COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30926, COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30927, COL_D7C13F10_82E7_4574_A512_6AC94400B894#30928, COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30929, COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30930, COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30931]
+- Filter (COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30930 <=> cast(Larvae as string))
+- Project [cast(GENEALOGIE_BACS_37595_COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30908 as string) AS COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30926, cast(GENEALOGIE_BACS_37595_COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30909 as string) AS COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30927, cast(GENEALOGIE_BACS_37595_COL_7DDC0C91_935D_421E_9979_6999F441DB11#30910 as timestamp) AS COL_D7C13F10_82E7_4574_A512_6AC94400B894#30928, cast(GENEALOGIE_BACS_37595_COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30911 as timestamp) AS COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30929, cast(GENEALOGIE_BACS_37595_COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30912 as string) AS COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30930, cast(GENEALOGIE_BACS_37595_COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30913 as array<string>) AS COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30931]
+- Project [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30890 AS GENEALOGIE_BACS_37595_COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30908, COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30891 AS GENEALOGIE_BACS_37595_COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30909, COL_7DDC0C91_935D_421E_9979_6999F441DB11#30892 AS GENEALOGIE_BACS_37595_COL_7DDC0C91_935D_421E_9979_6999F441DB11#30910, COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30893 AS GENEALOGIE_BACS_37595_COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30911, COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30894 AS GENEALOGIE_BACS_37595_COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30912, COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30895 AS GENEALOGIE_BACS_37595_COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30913]
+- SubqueryAlias GENEALOGIE_BACS_37595118
+- Relation[COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30890,COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30891,COL_7DDC0C91_935D_421E_9979_6999F441DB11#30892,COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30893,COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30894,COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30895] parquet
== Analyzed Logical Plan ==
COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E: string, COL_FC1663C8_1619_423A_A99B_56559C3FAB8C: string, COL_D7C13F10_82E7_4574_A512_6AC94400B894: timestamp, COL_785ADE38_6B5E_4689_836A_54CB349DD5DC: timestamp, COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D: string, COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1: array<string>
GlobalLimit 500000
+- LocalLimit 500000
+- Filter true
+- Project [COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30994 AS COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#31006, COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30995 AS COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#31007, COL_D7C13F10_82E7_4574_A512_6AC94400B894#30996 AS COL_D7C13F10_82E7_4574_A512_6AC94400B894#31008, COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30997 AS COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#31009, COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30998 AS COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#31010, COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30999 AS COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#31011]
+- Project [COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30982 AS COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30994, COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30983 AS COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30995, COL_D7C13F10_82E7_4574_A512_6AC94400B894#30984 AS COL_D7C13F10_82E7_4574_A512_6AC94400B894#30996, COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30985 AS COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30997, COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30986 AS COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30998, COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30987 AS COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30999]
+- Project [COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30970 AS COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30982, COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30971 AS COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30983, COL_D7C13F10_82E7_4574_A512_6AC94400B894#30972 AS COL_D7C13F10_82E7_4574_A512_6AC94400B894#30984, COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30973 AS COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30985, COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30974 AS COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30986, COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30975 AS COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30987]
+- Project [COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30952 AS COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30970, COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30953 AS COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30971, COL_D7C13F10_82E7_4574_A512_6AC94400B894#30954 AS COL_D7C13F10_82E7_4574_A512_6AC94400B894#30972, COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30955 AS COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30973, COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30956 AS COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30974, COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30957 AS COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30975]
+- Project [COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30926 AS COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30952, COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30927 AS COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30953, COL_D7C13F10_82E7_4574_A512_6AC94400B894#30928 AS COL_D7C13F10_82E7_4574_A512_6AC94400B894#30954, COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30929 AS COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30955, COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30930 AS COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30956, COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30931 AS COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30957]
+- Filter (COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30930 <=> cast(Larvae as string))
+- Project [COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30926, COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30927, COL_D7C13F10_82E7_4574_A512_6AC94400B894#30928, COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30929, COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30930, COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30931]
+- Filter (COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30930 <=> cast(Larvae as string))
+- Project [cast(GENEALOGIE_BACS_37595_COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30908 as string) AS COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30926, cast(GENEALOGIE_BACS_37595_COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30909 as string) AS COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30927, cast(GENEALOGIE_BACS_37595_COL_7DDC0C91_935D_421E_9979_6999F441DB11#30910 as timestamp) AS COL_D7C13F10_82E7_4574_A512_6AC94400B894#30928, cast(GENEALOGIE_BACS_37595_COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30911 as timestamp) AS COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30929, cast(GENEALOGIE_BACS_37595_COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30912 as string) AS COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30930, cast(GENEALOGIE_BACS_37595_COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30913 as array<string>) AS COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30931]
+- Project [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30890 AS GENEALOGIE_BACS_37595_COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30908, COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30891 AS GENEALOGIE_BACS_37595_COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30909, COL_7DDC0C91_935D_421E_9979_6999F441DB11#30892 AS GENEALOGIE_BACS_37595_COL_7DDC0C91_935D_421E_9979_6999F441DB11#30910, COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30893 AS GENEALOGIE_BACS_37595_COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30911, COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30894 AS GENEALOGIE_BACS_37595_COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30912, COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30895 AS GENEALOGIE_BACS_37595_COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30913]
+- SubqueryAlias GENEALOGIE_BACS_37595118
+- Relation[COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30890,COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30891,COL_7DDC0C91_935D_421E_9979_6999F441DB11#30892,COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30893,COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30894,COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30895] parquet
== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Project [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30890 AS COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30926, COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30891 AS COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30927, COL_7DDC0C91_935D_421E_9979_6999F441DB11#30892 AS COL_D7C13F10_82E7_4574_A512_6AC94400B894#30928, COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30893 AS COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30929, COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30894 AS COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30930, COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30895 AS COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30931]
+- Filter (COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30894 <=> Larvae)
+- Relation[COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30890,COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30891,COL_7DDC0C91_935D_421E_9979_6999F441DB11#30892,COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30893,COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30894,COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30895] parquet
== Physical Plan ==
CollectLimit 500000
+- *(1) Project [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30890 AS COL_BCE6B315_AC28_48DB_B4F7_897F4A36E69E#30926, COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30891 AS COL_FC1663C8_1619_423A_A99B_56559C3FAB8C#30927, COL_7DDC0C91_935D_421E_9979_6999F441DB11#30892 AS COL_D7C13F10_82E7_4574_A512_6AC94400B894#30928, COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30893 AS COL_785ADE38_6B5E_4689_836A_54CB349DD5DC#30929, COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30894 AS COL_80B45A0F_ACB7_4CB1_85B3_038439E3FA0D#30930, COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30895 AS COL_26F5BEAF_F9E5_4853_8B68_EAD4C95AACE1#30931]
+- *(1) Filter (COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30894 <=> Larvae)
+- FileScan parquet [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30890,COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30891,COL_7DDC0C91_935D_421E_9979_6999F441DB11#30892,COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30893,COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30894,COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30895] Batched: false, DataFilters: [(COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30894 <=> Larvae)], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/GENEALOGIE_BACS_37595], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_09AE520E_1F43_4D16_BD81_971EFC407F67,Larvae)], ReadSchema: struct<COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B:string,COL_00D4BAFE_C015_4657_A108_4EA72231DC63:s...