== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Filter true
+- Project [COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30866 AS COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30878, COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30867 AS COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30879, COL_A5B24A63_BDBB_4393_803E_56C02146E662#30868 AS COL_A5B24A63_BDBB_4393_803E_56C02146E662#30880, COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30869 AS COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30881, COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30870 AS COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30882, COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30871 AS COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30883]
+- Project [COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30836 AS COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30866, COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30837 AS COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30867, COL_A5B24A63_BDBB_4393_803E_56C02146E662#30838 AS COL_A5B24A63_BDBB_4393_803E_56C02146E662#30868, COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30839 AS COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30869, COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30840 AS COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30870, COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30841 AS COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30871]
+- Project [COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30812 AS COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30836, COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30813 AS COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30837, COL_A5B24A63_BDBB_4393_803E_56C02146E662#30814 AS COL_A5B24A63_BDBB_4393_803E_56C02146E662#30838, COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30815 AS COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30839, COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30816 AS COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30840, COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30817 AS COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30841]
+- Project [COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30776 AS COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30812, COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30777 AS COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30813, COL_A5B24A63_BDBB_4393_803E_56C02146E662#30778 AS COL_A5B24A63_BDBB_4393_803E_56C02146E662#30814, COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30779 AS COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30815, COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30780 AS COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30816, COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30781 AS COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30817]
+- Project [COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30740 AS COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30776, COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30741 AS COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30777, COL_A5B24A63_BDBB_4393_803E_56C02146E662#30742 AS COL_A5B24A63_BDBB_4393_803E_56C02146E662#30778, COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30743 AS COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30779, COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30744 AS COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30780, COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30745 AS COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30781]
+- Filter (str_remove_accent(upper(COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30744)) <=> cast(ADULT as string))
+- Project [COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30740, COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30741, COL_A5B24A63_BDBB_4393_803E_56C02146E662#30742, COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30743, COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30744, COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30745]
+- Filter (COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30744 <=> cast(Larvae as string))
+- Project [cast(GENEALOGIE_BACS_37595_COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30704 as string) AS COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30740, cast(GENEALOGIE_BACS_37595_COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30705 as string) AS COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30741, cast(GENEALOGIE_BACS_37595_COL_7DDC0C91_935D_421E_9979_6999F441DB11#30706 as timestamp) AS COL_A5B24A63_BDBB_4393_803E_56C02146E662#30742, cast(GENEALOGIE_BACS_37595_COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30707 as timestamp) AS COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30743, cast(GENEALOGIE_BACS_37595_COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30708 as string) AS COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30744, cast(GENEALOGIE_BACS_37595_COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30709 as array<string>) AS COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30745]
+- Project [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30674 AS GENEALOGIE_BACS_37595_COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30704, COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30675 AS GENEALOGIE_BACS_37595_COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30705, COL_7DDC0C91_935D_421E_9979_6999F441DB11#30676 AS GENEALOGIE_BACS_37595_COL_7DDC0C91_935D_421E_9979_6999F441DB11#30706, COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30677 AS GENEALOGIE_BACS_37595_COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30707, COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30678 AS GENEALOGIE_BACS_37595_COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30708, COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30679 AS GENEALOGIE_BACS_37595_COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30709]
+- SubqueryAlias GENEALOGIE_BACS_37595114
+- Relation[COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30674,COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30675,COL_7DDC0C91_935D_421E_9979_6999F441DB11#30676,COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30677,COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30678,COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30679] parquet
== Analyzed Logical Plan ==
COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB: string, COL_196FB39A_956A_46F5_9166_6809D16D8AA6: string, COL_A5B24A63_BDBB_4393_803E_56C02146E662: timestamp, COL_1D0D6362_D659_4770_923A_81C94EB3C9D1: timestamp, COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C: string, COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3: array<string>
GlobalLimit 500000
+- LocalLimit 500000
+- Filter true
+- Project [COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30866 AS COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30878, COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30867 AS COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30879, COL_A5B24A63_BDBB_4393_803E_56C02146E662#30868 AS COL_A5B24A63_BDBB_4393_803E_56C02146E662#30880, COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30869 AS COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30881, COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30870 AS COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30882, COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30871 AS COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30883]
+- Project [COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30836 AS COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30866, COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30837 AS COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30867, COL_A5B24A63_BDBB_4393_803E_56C02146E662#30838 AS COL_A5B24A63_BDBB_4393_803E_56C02146E662#30868, COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30839 AS COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30869, COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30840 AS COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30870, COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30841 AS COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30871]
+- Project [COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30812 AS COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30836, COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30813 AS COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30837, COL_A5B24A63_BDBB_4393_803E_56C02146E662#30814 AS COL_A5B24A63_BDBB_4393_803E_56C02146E662#30838, COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30815 AS COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30839, COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30816 AS COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30840, COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30817 AS COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30841]
+- Project [COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30776 AS COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30812, COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30777 AS COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30813, COL_A5B24A63_BDBB_4393_803E_56C02146E662#30778 AS COL_A5B24A63_BDBB_4393_803E_56C02146E662#30814, COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30779 AS COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30815, COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30780 AS COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30816, COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30781 AS COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30817]
+- Project [COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30740 AS COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30776, COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30741 AS COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30777, COL_A5B24A63_BDBB_4393_803E_56C02146E662#30742 AS COL_A5B24A63_BDBB_4393_803E_56C02146E662#30778, COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30743 AS COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30779, COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30744 AS COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30780, COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30745 AS COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30781]
+- Filter (str_remove_accent(upper(COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30744)) <=> cast(ADULT as string))
+- Project [COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30740, COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30741, COL_A5B24A63_BDBB_4393_803E_56C02146E662#30742, COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30743, COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30744, COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30745]
+- Filter (COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30744 <=> cast(Larvae as string))
+- Project [cast(GENEALOGIE_BACS_37595_COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30704 as string) AS COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30740, cast(GENEALOGIE_BACS_37595_COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30705 as string) AS COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30741, cast(GENEALOGIE_BACS_37595_COL_7DDC0C91_935D_421E_9979_6999F441DB11#30706 as timestamp) AS COL_A5B24A63_BDBB_4393_803E_56C02146E662#30742, cast(GENEALOGIE_BACS_37595_COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30707 as timestamp) AS COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30743, cast(GENEALOGIE_BACS_37595_COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30708 as string) AS COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30744, cast(GENEALOGIE_BACS_37595_COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30709 as array<string>) AS COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30745]
+- Project [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30674 AS GENEALOGIE_BACS_37595_COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30704, COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30675 AS GENEALOGIE_BACS_37595_COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30705, COL_7DDC0C91_935D_421E_9979_6999F441DB11#30676 AS GENEALOGIE_BACS_37595_COL_7DDC0C91_935D_421E_9979_6999F441DB11#30706, COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30677 AS GENEALOGIE_BACS_37595_COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30707, COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30678 AS GENEALOGIE_BACS_37595_COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30708, COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30679 AS GENEALOGIE_BACS_37595_COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30709]
+- SubqueryAlias GENEALOGIE_BACS_37595114
+- Relation[COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30674,COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30675,COL_7DDC0C91_935D_421E_9979_6999F441DB11#30676,COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30677,COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30678,COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30679] parquet
== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Project [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30674 AS COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30740, COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30675 AS COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30741, COL_7DDC0C91_935D_421E_9979_6999F441DB11#30676 AS COL_A5B24A63_BDBB_4393_803E_56C02146E662#30742, COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30677 AS COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30743, COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30678 AS COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30744, COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30679 AS COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30745]
+- Filter ((COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30678 <=> Larvae) AND (str_remove_accent(LARVAE) <=> ADULT))
+- Relation[COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30674,COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30675,COL_7DDC0C91_935D_421E_9979_6999F441DB11#30676,COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30677,COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30678,COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30679] parquet
== Physical Plan ==
CollectLimit 500000
+- *(1) Project [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30674 AS COL_0C5D1E0B_67F0_4D31_8F95_76198203E5BB#30740, COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30675 AS COL_196FB39A_956A_46F5_9166_6809D16D8AA6#30741, COL_7DDC0C91_935D_421E_9979_6999F441DB11#30676 AS COL_A5B24A63_BDBB_4393_803E_56C02146E662#30742, COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30677 AS COL_1D0D6362_D659_4770_923A_81C94EB3C9D1#30743, COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30678 AS COL_8C8F5633_0F43_47E8_9F49_B6EFDCFE802C#30744, COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30679 AS COL_2D1C42E8_6144_40E8_A7AF_4C0BF9CE86C3#30745]
+- *(1) Filter ((COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30678 <=> Larvae) AND (str_remove_accent(LARVAE) <=> ADULT))
+- FileScan parquet [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#30674,COL_00D4BAFE_C015_4657_A108_4EA72231DC63#30675,COL_7DDC0C91_935D_421E_9979_6999F441DB11#30676,COL_A0683C37_1AB9_4065_B896_9D5A04C22931#30677,COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30678,COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#30679] Batched: false, DataFilters: [(COL_09AE520E_1F43_4D16_BD81_971EFC407F67#30678 <=> Larvae), (str_remove_accent(LARVAE) <=> ADULT)], 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...