== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Filter true
+- Project [COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31259 AS COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31277, COL_DC30E845_E831_40BC_B870_36E0D3974400#31264 AS COL_DC30E845_E831_40BC_B870_36E0D3974400#31278, COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31267 AS COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31279, COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31268 AS COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31280, COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31269 AS COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31281, COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31270 AS COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31282]
+- Project [COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31247 AS COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31259, COL_DC30E845_E831_40BC_B870_36E0D3974400#31248 AS COL_DC30E845_E831_40BC_B870_36E0D3974400#31264, COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31249 AS COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31267, COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31250 AS COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31268, COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31251 AS COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31269, COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31252 AS COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31270]
+- Project [COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31211 AS COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31247, COL_DC30E845_E831_40BC_B870_36E0D3974400#31212 AS COL_DC30E845_E831_40BC_B870_36E0D3974400#31248, COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31213 AS COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31249, COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31214 AS COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31250, COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31215 AS COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31251, COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31216 AS COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31252]
+- Project [COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31181 AS COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31211, COL_DC30E845_E831_40BC_B870_36E0D3974400#31182 AS COL_DC30E845_E831_40BC_B870_36E0D3974400#31212, COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31183 AS COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31213, COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31184 AS COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31214, COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31185 AS COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31215, COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31186 AS COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31216]
+- Project [COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31121 AS COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31181, COL_DC30E845_E831_40BC_B870_36E0D3974400#31122 AS COL_DC30E845_E831_40BC_B870_36E0D3974400#31182, COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31123 AS COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31183, COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31124 AS COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31184, COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31125 AS COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31185, COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31126 AS COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31186]
+- Filter (COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31125 <=> cast(Pup as string))
+- Project [COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31121, COL_DC30E845_E831_40BC_B870_36E0D3974400#31122, COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31123, COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31124, COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31125, COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31126]
+- Filter (COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31125 <=> cast(Larvae as string))
+- Project [cast(GENEALOGIE_BACS_37595_COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#31067 as string) AS COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31121, cast(GENEALOGIE_BACS_37595_COL_00D4BAFE_C015_4657_A108_4EA72231DC63#31068 as string) AS COL_DC30E845_E831_40BC_B870_36E0D3974400#31122, cast(GENEALOGIE_BACS_37595_COL_7DDC0C91_935D_421E_9979_6999F441DB11#31069 as timestamp) AS COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31123, cast(GENEALOGIE_BACS_37595_COL_A0683C37_1AB9_4065_B896_9D5A04C22931#31070 as timestamp) AS COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31124, cast(GENEALOGIE_BACS_37595_COL_09AE520E_1F43_4D16_BD81_971EFC407F67#31071 as string) AS COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31125, cast(GENEALOGIE_BACS_37595_COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#31072 as array<string>) AS COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31126]
+- Project [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#31037 AS GENEALOGIE_BACS_37595_COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#31067, COL_00D4BAFE_C015_4657_A108_4EA72231DC63#31038 AS GENEALOGIE_BACS_37595_COL_00D4BAFE_C015_4657_A108_4EA72231DC63#31068, COL_7DDC0C91_935D_421E_9979_6999F441DB11#31039 AS GENEALOGIE_BACS_37595_COL_7DDC0C91_935D_421E_9979_6999F441DB11#31069, COL_A0683C37_1AB9_4065_B896_9D5A04C22931#31040 AS GENEALOGIE_BACS_37595_COL_A0683C37_1AB9_4065_B896_9D5A04C22931#31070, COL_09AE520E_1F43_4D16_BD81_971EFC407F67#31041 AS GENEALOGIE_BACS_37595_COL_09AE520E_1F43_4D16_BD81_971EFC407F67#31071, COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#31042 AS GENEALOGIE_BACS_37595_COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#31072]
+- SubqueryAlias GENEALOGIE_BACS_37595116
+- Relation[COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#31037,COL_00D4BAFE_C015_4657_A108_4EA72231DC63#31038,COL_7DDC0C91_935D_421E_9979_6999F441DB11#31039,COL_A0683C37_1AB9_4065_B896_9D5A04C22931#31040,COL_09AE520E_1F43_4D16_BD81_971EFC407F67#31041,COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#31042] parquet
== Analyzed Logical Plan ==
COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998: string, COL_DC30E845_E831_40BC_B870_36E0D3974400: string, COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C: timestamp, COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC: timestamp, COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355: string, COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35: array<string>
GlobalLimit 500000
+- LocalLimit 500000
+- Filter true
+- Project [COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31259 AS COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31277, COL_DC30E845_E831_40BC_B870_36E0D3974400#31264 AS COL_DC30E845_E831_40BC_B870_36E0D3974400#31278, COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31267 AS COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31279, COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31268 AS COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31280, COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31269 AS COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31281, COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31270 AS COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31282]
+- Project [COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31247 AS COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31259, COL_DC30E845_E831_40BC_B870_36E0D3974400#31248 AS COL_DC30E845_E831_40BC_B870_36E0D3974400#31264, COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31249 AS COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31267, COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31250 AS COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31268, COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31251 AS COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31269, COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31252 AS COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31270]
+- Project [COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31211 AS COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31247, COL_DC30E845_E831_40BC_B870_36E0D3974400#31212 AS COL_DC30E845_E831_40BC_B870_36E0D3974400#31248, COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31213 AS COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31249, COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31214 AS COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31250, COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31215 AS COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31251, COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31216 AS COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31252]
+- Project [COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31181 AS COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31211, COL_DC30E845_E831_40BC_B870_36E0D3974400#31182 AS COL_DC30E845_E831_40BC_B870_36E0D3974400#31212, COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31183 AS COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31213, COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31184 AS COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31214, COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31185 AS COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31215, COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31186 AS COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31216]
+- Project [COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31121 AS COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31181, COL_DC30E845_E831_40BC_B870_36E0D3974400#31122 AS COL_DC30E845_E831_40BC_B870_36E0D3974400#31182, COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31123 AS COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31183, COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31124 AS COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31184, COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31125 AS COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31185, COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31126 AS COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31186]
+- Filter (COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31125 <=> cast(Pup as string))
+- Project [COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31121, COL_DC30E845_E831_40BC_B870_36E0D3974400#31122, COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31123, COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31124, COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31125, COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31126]
+- Filter (COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31125 <=> cast(Larvae as string))
+- Project [cast(GENEALOGIE_BACS_37595_COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#31067 as string) AS COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31121, cast(GENEALOGIE_BACS_37595_COL_00D4BAFE_C015_4657_A108_4EA72231DC63#31068 as string) AS COL_DC30E845_E831_40BC_B870_36E0D3974400#31122, cast(GENEALOGIE_BACS_37595_COL_7DDC0C91_935D_421E_9979_6999F441DB11#31069 as timestamp) AS COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31123, cast(GENEALOGIE_BACS_37595_COL_A0683C37_1AB9_4065_B896_9D5A04C22931#31070 as timestamp) AS COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31124, cast(GENEALOGIE_BACS_37595_COL_09AE520E_1F43_4D16_BD81_971EFC407F67#31071 as string) AS COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31125, cast(GENEALOGIE_BACS_37595_COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#31072 as array<string>) AS COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31126]
+- Project [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#31037 AS GENEALOGIE_BACS_37595_COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#31067, COL_00D4BAFE_C015_4657_A108_4EA72231DC63#31038 AS GENEALOGIE_BACS_37595_COL_00D4BAFE_C015_4657_A108_4EA72231DC63#31068, COL_7DDC0C91_935D_421E_9979_6999F441DB11#31039 AS GENEALOGIE_BACS_37595_COL_7DDC0C91_935D_421E_9979_6999F441DB11#31069, COL_A0683C37_1AB9_4065_B896_9D5A04C22931#31040 AS GENEALOGIE_BACS_37595_COL_A0683C37_1AB9_4065_B896_9D5A04C22931#31070, COL_09AE520E_1F43_4D16_BD81_971EFC407F67#31041 AS GENEALOGIE_BACS_37595_COL_09AE520E_1F43_4D16_BD81_971EFC407F67#31071, COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#31042 AS GENEALOGIE_BACS_37595_COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#31072]
+- SubqueryAlias GENEALOGIE_BACS_37595116
+- Relation[COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#31037,COL_00D4BAFE_C015_4657_A108_4EA72231DC63#31038,COL_7DDC0C91_935D_421E_9979_6999F441DB11#31039,COL_A0683C37_1AB9_4065_B896_9D5A04C22931#31040,COL_09AE520E_1F43_4D16_BD81_971EFC407F67#31041,COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#31042] parquet
== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Project [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#31037 AS COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31121, COL_00D4BAFE_C015_4657_A108_4EA72231DC63#31038 AS COL_DC30E845_E831_40BC_B870_36E0D3974400#31122, COL_7DDC0C91_935D_421E_9979_6999F441DB11#31039 AS COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31123, COL_A0683C37_1AB9_4065_B896_9D5A04C22931#31040 AS COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31124, COL_09AE520E_1F43_4D16_BD81_971EFC407F67#31041 AS COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31125, COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#31042 AS COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31126]
+- Filter ((COL_09AE520E_1F43_4D16_BD81_971EFC407F67#31041 <=> Larvae) AND (COL_09AE520E_1F43_4D16_BD81_971EFC407F67#31041 <=> Pup))
+- Relation[COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#31037,COL_00D4BAFE_C015_4657_A108_4EA72231DC63#31038,COL_7DDC0C91_935D_421E_9979_6999F441DB11#31039,COL_A0683C37_1AB9_4065_B896_9D5A04C22931#31040,COL_09AE520E_1F43_4D16_BD81_971EFC407F67#31041,COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#31042] parquet
== Physical Plan ==
CollectLimit 500000
+- *(1) Project [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#31037 AS COL_0C104C6A_0291_4169_8A1B_38CFA5FB8998#31121, COL_00D4BAFE_C015_4657_A108_4EA72231DC63#31038 AS COL_DC30E845_E831_40BC_B870_36E0D3974400#31122, COL_7DDC0C91_935D_421E_9979_6999F441DB11#31039 AS COL_A6D4EA74_41B2_44C2_BD85_CCB199F9C13C#31123, COL_A0683C37_1AB9_4065_B896_9D5A04C22931#31040 AS COL_F40C32BE_7E6C_4B35_8B46_71A483C861AC#31124, COL_09AE520E_1F43_4D16_BD81_971EFC407F67#31041 AS COL_4C73D4BE_6A0F_4EB8_BB4B_0232C996E355#31125, COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#31042 AS COL_F71B570B_A726_4215_8F0B_9B9FE3F6FC35#31126]
+- *(1) Filter ((COL_09AE520E_1F43_4D16_BD81_971EFC407F67#31041 <=> Larvae) AND (COL_09AE520E_1F43_4D16_BD81_971EFC407F67#31041 <=> Pup))
+- FileScan parquet [COL_7032D65B_70B3_48B6_B1D2_8DD48C79CC2B#31037,COL_00D4BAFE_C015_4657_A108_4EA72231DC63#31038,COL_7DDC0C91_935D_421E_9979_6999F441DB11#31039,COL_A0683C37_1AB9_4065_B896_9D5A04C22931#31040,COL_09AE520E_1F43_4D16_BD81_971EFC407F67#31041,COL_6CD3DB5E_3364_4F3E_906E_88CD835121A3#31042] Batched: false, DataFilters: [(COL_09AE520E_1F43_4D16_BD81_971EFC407F67#31041 <=> 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...