== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Filter true
+- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27181 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27242, COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27182 AS COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27244]
+- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27177 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27181, COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27178 AS COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27182]
+- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27173 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27177, COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27174 AS COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27178]
+- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27169 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27173, COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27170 AS COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27174]
+- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26935 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27169, bigint_to_str(COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#26993L) AS COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27170]
+- Sort [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26935 ASC NULLS FIRST], true
+- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26935, COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#26993L]
+- Aggregate [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26900], [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26900 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26935, 1 AS NULL_1#27030, sum(cast(COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#26741 as bigint)) AS COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#26993L]
+- Project [COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#26732, COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#26733, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#26734, COL_523112AB_EB62_4F3A_87F1_C4786899F476#26735, COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#26736, COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#26737, COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#26738, COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#26739, COL_9F57D998_C889_4DCD_9247_5DCB9194B506#26740, COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#26741, COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26742, COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#26743, COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#26744, COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#26745, COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#26746, COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#26747, str_create(cast(Articles as string)) AS COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26900]
+- Project [COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#26732, COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#26733, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#26734, COL_523112AB_EB62_4F3A_87F1_C4786899F476#26735, COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#26736, COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#26737, COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#26738, COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#26739, COL_9F57D998_C889_4DCD_9247_5DCB9194B506#26740, COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#26741, COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26742, COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#26743, COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#26744, COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#26745, COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#26746, COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#26747]
+- Filter (COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#26737 <=> cast(Usine de ponte as string))
+- Project [cast(CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#26393 as timestamp) AS COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#26732, cast(CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#26394 as string) AS COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#26733, cast(CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#26396 as string) AS COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#26734, cast(CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#26398 as string) AS COL_523112AB_EB62_4F3A_87F1_C4786899F476#26735, cast(CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#26400 as string) AS COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#26736, cast(CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#26402 as string) AS COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#26737, cast(CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#26404 as string) AS COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#26738, cast(CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#26406 as double) AS COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#26739, cast(CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#26408 as double) AS COL_9F57D998_C889_4DCD_9247_5DCB9194B506#26740, cast(CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26410 as int) AS COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#26741, cast(CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26412 as int) AS COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26742, cast(CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#26414 as string) AS COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#26743, cast(CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#26416 as string) AS COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#26744, cast(CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#26418 as string) AS COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#26745, cast(CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#26420 as double) AS COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#26746, cast(CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#26421 as double) AS COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#26747]
+- Project [COL_8886263B_787F_402D_99DF_85269A2625C7#26176 AS CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#26393, COL_715DA55F_B685_4656_ACD7_0677A3328C5A#26177 AS CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#26394, COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#26178 AS CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#26396, COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#26179 AS CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#26398, COL_B2A3110A_EA93_484C_99C3_654566F36027#26180 AS CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#26400, COL_87B73D01_19C3_4258_8107_533C60810F9B#26181 AS CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#26402, COL_F7878551_0607_4D5F_80D8_667ED2A491C5#26182 AS CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#26404, COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#26183 AS CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#26406, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#26184 AS CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#26408, COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26185 AS CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26410, COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26186 AS CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26412, COL_CA314331_595A_479E_B554_2CF73BF8E065#26187 AS CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#26414, COL_05081AD0_57FC_451A_A0F0_02DA7463837B#26188 AS CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#26416, COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#26189 AS CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#26418, COL_96EC1D60_6665_46D3_9518_324889EF63CF#26190 AS CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#26420, COL_8E10419E_226F_4098_A129_7AFAAA38B493#26191 AS CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#26421, COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#26192 AS CONSOLIDATED_DA_37832_COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#26423, COL_38186F06_5370_460A_8844_41809A1AAA16#26193 AS CONSOLIDATED_DA_37832_COL_38186F06_5370_460A_8844_41809A1AAA16#26425, COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#26194 AS CONSOLIDATED_DA_37832_COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#26427, COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#26195 AS CONSOLIDATED_DA_37832_COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#26429, COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#26196 AS CONSOLIDATED_DA_37832_COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#26431, COL_57F110A8_C27A_4968_805A_624B0B61FC56#26197 AS CONSOLIDATED_DA_37832_COL_57F110A8_C27A_4968_805A_624B0B61FC56#26433, COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#26198 AS CONSOLIDATED_DA_37832_COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#26435, COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#26199L AS CONSOLIDATED_DA_37832_COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#26437L, ... 12 more fields]
+- SubqueryAlias CONSOLIDATED_DA_37832114
+- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#26176,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#26177,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#26178,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#26179,COL_B2A3110A_EA93_484C_99C3_654566F36027#26180,COL_87B73D01_19C3_4258_8107_533C60810F9B#26181,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#26182,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#26183,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#26184,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26185,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26186,COL_CA314331_595A_479E_B554_2CF73BF8E065#26187,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#26188,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#26189,COL_96EC1D60_6665_46D3_9518_324889EF63CF#26190,COL_8E10419E_226F_4098_A129_7AFAAA38B493#26191,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#26192,COL_38186F06_5370_460A_8844_41809A1AAA16#26193,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#26194,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#26195,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#26196,COL_57F110A8_C27A_4968_805A_624B0B61FC56#26197,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#26198,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#26199L,... 12 more fields] parquet
== Analyzed Logical Plan ==
COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51: string, COL_F9E9162A_1494_4591_93A9_8BABFC28DA74: string
GlobalLimit 500000
+- LocalLimit 500000
+- Filter true
+- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27181 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27242, COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27182 AS COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27244]
+- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27177 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27181, COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27178 AS COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27182]
+- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27173 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27177, COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27174 AS COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27178]
+- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27169 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27173, COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27170 AS COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27174]
+- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26935 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#27169, bigint_to_str(COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#26993L) AS COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27170]
+- Sort [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26935 ASC NULLS FIRST], true
+- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26935, COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#26993L]
+- Aggregate [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26900], [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26900 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26935, 1 AS NULL_1#27030, sum(cast(COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#26741 as bigint)) AS COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#26993L]
+- Project [COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#26732, COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#26733, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#26734, COL_523112AB_EB62_4F3A_87F1_C4786899F476#26735, COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#26736, COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#26737, COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#26738, COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#26739, COL_9F57D998_C889_4DCD_9247_5DCB9194B506#26740, COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#26741, COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26742, COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#26743, COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#26744, COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#26745, COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#26746, COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#26747, str_create(cast(Articles as string)) AS COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26900]
+- Project [COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#26732, COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#26733, COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#26734, COL_523112AB_EB62_4F3A_87F1_C4786899F476#26735, COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#26736, COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#26737, COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#26738, COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#26739, COL_9F57D998_C889_4DCD_9247_5DCB9194B506#26740, COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#26741, COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26742, COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#26743, COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#26744, COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#26745, COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#26746, COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#26747]
+- Filter (COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#26737 <=> cast(Usine de ponte as string))
+- Project [cast(CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#26393 as timestamp) AS COL_62DF33D3_8C47_4209_BD59_F88AC50997D2#26732, cast(CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#26394 as string) AS COL_A9F0A450_FDF7_41DF_9F4D_7B7572489E57#26733, cast(CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#26396 as string) AS COL_D413840B_1B60_4B74_8BA8_8F14EC86C85B#26734, cast(CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#26398 as string) AS COL_523112AB_EB62_4F3A_87F1_C4786899F476#26735, cast(CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#26400 as string) AS COL_6F455B19_F6F0_4D8A_BCE1_B975B4E4FEF9#26736, cast(CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#26402 as string) AS COL_7BBCADB0_74EC_4DD1_A6C4_07C87C387713#26737, cast(CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#26404 as string) AS COL_D57E3222_E7B9_4B70_B889_1FADCBF411E8#26738, cast(CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#26406 as double) AS COL_897E65A6_3A00_45E3_BF0A_F3CD3B1621A7#26739, cast(CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#26408 as double) AS COL_9F57D998_C889_4DCD_9247_5DCB9194B506#26740, cast(CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26410 as int) AS COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#26741, cast(CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26412 as int) AS COL_02C8E86D_3E80_49C9_BA1F_FBC42F396DB0#26742, cast(CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#26414 as string) AS COL_2C9BA905_008D_4A68_AE0E_4AFCAB7878B3#26743, cast(CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#26416 as string) AS COL_71B1C394_AD01_46DE_92CE_E303FB3F63C1#26744, cast(CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#26418 as string) AS COL_75A7E7AF_9C93_4566_970D_7FFB85F107F0#26745, cast(CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#26420 as double) AS COL_2FAAD820_C1DC_479B_BF14_90B2A210DF6A#26746, cast(CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#26421 as double) AS COL_6D002845_D685_4D8F_8C1F_3A805C0AD132#26747]
+- Project [COL_8886263B_787F_402D_99DF_85269A2625C7#26176 AS CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#26393, COL_715DA55F_B685_4656_ACD7_0677A3328C5A#26177 AS CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#26394, COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#26178 AS CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#26396, COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#26179 AS CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#26398, COL_B2A3110A_EA93_484C_99C3_654566F36027#26180 AS CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#26400, COL_87B73D01_19C3_4258_8107_533C60810F9B#26181 AS CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#26402, COL_F7878551_0607_4D5F_80D8_667ED2A491C5#26182 AS CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#26404, COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#26183 AS CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#26406, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#26184 AS CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#26408, COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26185 AS CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26410, COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26186 AS CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26412, COL_CA314331_595A_479E_B554_2CF73BF8E065#26187 AS CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#26414, COL_05081AD0_57FC_451A_A0F0_02DA7463837B#26188 AS CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#26416, COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#26189 AS CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#26418, COL_96EC1D60_6665_46D3_9518_324889EF63CF#26190 AS CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#26420, COL_8E10419E_226F_4098_A129_7AFAAA38B493#26191 AS CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#26421, COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#26192 AS CONSOLIDATED_DA_37832_COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#26423, COL_38186F06_5370_460A_8844_41809A1AAA16#26193 AS CONSOLIDATED_DA_37832_COL_38186F06_5370_460A_8844_41809A1AAA16#26425, COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#26194 AS CONSOLIDATED_DA_37832_COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#26427, COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#26195 AS CONSOLIDATED_DA_37832_COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#26429, COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#26196 AS CONSOLIDATED_DA_37832_COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#26431, COL_57F110A8_C27A_4968_805A_624B0B61FC56#26197 AS CONSOLIDATED_DA_37832_COL_57F110A8_C27A_4968_805A_624B0B61FC56#26433, COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#26198 AS CONSOLIDATED_DA_37832_COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#26435, COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#26199L AS CONSOLIDATED_DA_37832_COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#26437L, ... 12 more fields]
+- SubqueryAlias CONSOLIDATED_DA_37832114
+- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#26176,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#26177,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#26178,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#26179,COL_B2A3110A_EA93_484C_99C3_654566F36027#26180,COL_87B73D01_19C3_4258_8107_533C60810F9B#26181,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#26182,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#26183,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#26184,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26185,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26186,COL_CA314331_595A_479E_B554_2CF73BF8E065#26187,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#26188,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#26189,COL_96EC1D60_6665_46D3_9518_324889EF63CF#26190,COL_8E10419E_226F_4098_A129_7AFAAA38B493#26191,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#26192,COL_38186F06_5370_460A_8844_41809A1AAA16#26193,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#26194,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#26195,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#26196,COL_57F110A8_C27A_4968_805A_624B0B61FC56#26197,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#26198,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#26199L,... 12 more fields] parquet
== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Project [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26935, bigint_to_str(COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#26993L) AS COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27244]
+- Sort [COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26935 ASC NULLS FIRST], true
+- Aggregate [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26900], [COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26900 AS COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26935, sum(cast(COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#26741 as bigint)) AS COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#26993L]
+- Project [COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26185 AS COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#26741, str_create(Articles) AS COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26900]
+- Filter (COL_87B73D01_19C3_4258_8107_533C60810F9B#26181 <=> Usine de ponte)
+- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#26176,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#26177,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#26178,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#26179,COL_B2A3110A_EA93_484C_99C3_654566F36027#26180,COL_87B73D01_19C3_4258_8107_533C60810F9B#26181,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#26182,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#26183,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#26184,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26185,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#26186,COL_CA314331_595A_479E_B554_2CF73BF8E065#26187,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#26188,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#26189,COL_96EC1D60_6665_46D3_9518_324889EF63CF#26190,COL_8E10419E_226F_4098_A129_7AFAAA38B493#26191,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#26192,COL_38186F06_5370_460A_8844_41809A1AAA16#26193,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#26194,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#26195,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#26196,COL_57F110A8_C27A_4968_805A_624B0B61FC56#26197,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#26198,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#26199L,... 12 more fields] parquet
== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- TakeOrderedAndProject(limit=500000, orderBy=[COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26935 ASC NULLS FIRST], output=[COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26935,COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#27244])
+- *(2) HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26900], functions=[sum(cast(COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#26741 as bigint))], output=[COL_3EED5D50_DD9B_4553_AD29_995CB3CA8C51#26935, COL_F9E9162A_1494_4591_93A9_8BABFC28DA74#26993L])
+- CustomShuffleReader coalesced
+- ShuffleQueryStage 0
+- Exchange hashpartitioning(COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26900, 200), true, [id=#5328]
+- *(1) HashAggregate(keys=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26900], functions=[partial_sum(cast(COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#26741 as bigint))], output=[COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26900, sum#27409L])
+- *(1) Project [COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26185 AS COL_B4B4B67A_BAA8_4DC9_9951_D7AFA3D2A4F6#26741, str_create(Articles) AS COL_0D8A25D7_A284_4377_9B11_34FE6B527869#26900]
+- *(1) Filter (COL_87B73D01_19C3_4258_8107_533C60810F9B#26181 <=> Usine de ponte)
+- *(1) ColumnarToRow
+- FileScan parquet [COL_87B73D01_19C3_4258_8107_533C60810F9B#26181,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#26185] Batched: true, DataFilters: [(COL_87B73D01_19C3_4258_8107_533C60810F9B#26181 <=> Usine de ponte)], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/CONSOLIDATED_DA_37832], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_87B73D01_19C3_4258_8107_533C60810F9B,Usine de ponte)], ReadSchema: struct<COL_87B73D01_19C3_4258_8107_533C60810F9B:string,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB:int>