Project [COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#23931 AS COL_FECEEE88_40B0_4DCF_A8C2_F6B16A1BB0FF#24162, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#23932 AS COL_F7142BC8_9EB9_4CD2_A907_8A483CCAC572#24163, COL_E1A32417_2E12_41F2_99C2_8F9E74E8C0D0#23959 AS COL_B4E89E69_2A0E_4AF8_A427_C03DC29AA3D1#24171]
Filter (COL_87B73D01_19C3_4258_8107_533C60810F9B#23929 <=> Usine de ponte)
== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Filter true
+- Project [COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24446 AS COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24546, COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24447 AS COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24547, COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24448 AS COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24548]
+- Project [COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24413 AS COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24446, COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24414 AS COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24447, COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24415 AS COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24448]
+- Project [COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24371 AS COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24413, COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24372 AS COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24414, COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24373 AS COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24415]
+- Project [COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24279 AS COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24371, COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24292 AS COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24372, COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24293 AS COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24373]
+- Project [COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24189 AS COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24279, round(COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24208, 2) AS COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24292, round(COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24210, 2) AS COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24293]
+- Sort [COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24189 ASC NULLS FIRST], true
+- Project [COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24189, COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24208, COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24210]
+- Aggregate [COL_B4E89E69_2A0E_4AF8_A427_C03DC29AA3D1#24171], [COL_B4E89E69_2A0E_4AF8_A427_C03DC29AA3D1#24171 AS COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24189, 1 AS NULL_1#24235, avg(COL_FECEEE88_40B0_4DCF_A8C2_F6B16A1BB0FF#24162) AS COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24208, avg(COL_F7142BC8_9EB9_4CD2_A907_8A483CCAC572#24163) AS COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24210]
+- Project [COL_499EC13B_2FE2_4AA3_8505_A532C6D3FF46#24121 AS COL_499EC13B_2FE2_4AA3_8505_A532C6D3FF46#24155, COL_512F8DDF_8973_4E08_8708_BC6B36AD68DD#24122 AS COL_512F8DDF_8973_4E08_8708_BC6B36AD68DD#24156, COL_AF3CDC09_4A3D_4B7F_9589_9E9432AC6D64#24123 AS COL_AF3CDC09_4A3D_4B7F_9589_9E9432AC6D64#24157, COL_8CA9410C_07C5_4B74_88AE_54723EE9428B#24124 AS COL_8CA9410C_07C5_4B74_88AE_54723EE9428B#24158, COL_BF6AD1A6_99CD_4160_BFD2_F09A72A8E236#24125 AS COL_BF6AD1A6_99CD_4160_BFD2_F09A72A8E236#24159, COL_A13BA407_4CE5_4974_B257_19EAD20D5213#24126 AS COL_A13BA407_4CE5_4974_B257_19EAD20D5213#24160, COL_83AC2845_92FB_4863_AFB3_39DE2851D0ED#24127 AS COL_83AC2845_92FB_4863_AFB3_39DE2851D0ED#24161, COL_FECEEE88_40B0_4DCF_A8C2_F6B16A1BB0FF#24128 AS COL_FECEEE88_40B0_4DCF_A8C2_F6B16A1BB0FF#24162, COL_F7142BC8_9EB9_4CD2_A907_8A483CCAC572#24129 AS COL_F7142BC8_9EB9_4CD2_A907_8A483CCAC572#24163, COL_EC03712A_2E82_4FC0_8385_F2B5D96C3E71#24130 AS COL_EC03712A_2E82_4FC0_8385_F2B5D96C3E71#24164, COL_1289F373_FF25_4487_9EE9_69B97F8F7E8C#24131 AS COL_1289F373_FF25_4487_9EE9_69B97F8F7E8C#24165, COL_9C14E0D7_2FBA_4353_97DE_0023051ED954#24132 AS COL_9C14E0D7_2FBA_4353_97DE_0023051ED954#24166, COL_1D51738B_5813_484E_9601_5F3B4C4606D7#24133 AS COL_1D51738B_5813_484E_9601_5F3B4C4606D7#24167, COL_0755F5E9_2A0B_4232_89D8_A65A9E2CA47B#24134 AS COL_0755F5E9_2A0B_4232_89D8_A65A9E2CA47B#24168, COL_74E4B274_D176_405D_853A_82B47F051C45#24135 AS COL_74E4B274_D176_405D_853A_82B47F051C45#24169, COL_9DF6B1CF_6AD6_411C_84D6_9B2218CCCD7E#24136 AS COL_9DF6B1CF_6AD6_411C_84D6_9B2218CCCD7E#24170, COL_B4E89E69_2A0E_4AF8_A427_C03DC29AA3D1#24137 AS COL_B4E89E69_2A0E_4AF8_A427_C03DC29AA3D1#24171]
+- Filter (COL_A13BA407_4CE5_4974_B257_19EAD20D5213#24126 <=> cast(Usine de ponte as string))
+- Project [cast(CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#24032 as timestamp) AS COL_499EC13B_2FE2_4AA3_8505_A532C6D3FF46#24121, cast(CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24033 as string) AS COL_512F8DDF_8973_4E08_8708_BC6B36AD68DD#24122, cast(CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24034 as string) AS COL_AF3CDC09_4A3D_4B7F_9589_9E9432AC6D64#24123, cast(CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24035 as string) AS COL_8CA9410C_07C5_4B74_88AE_54723EE9428B#24124, cast(CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#24036 as string) AS COL_BF6AD1A6_99CD_4160_BFD2_F09A72A8E236#24125, cast(CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#24037 as string) AS COL_A13BA407_4CE5_4974_B257_19EAD20D5213#24126, cast(CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24038 as string) AS COL_83AC2845_92FB_4863_AFB3_39DE2851D0ED#24127, cast(CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24039 as double) AS COL_FECEEE88_40B0_4DCF_A8C2_F6B16A1BB0FF#24128, cast(CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24040 as double) AS COL_F7142BC8_9EB9_4CD2_A907_8A483CCAC572#24129, cast(CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24041 as int) AS COL_EC03712A_2E82_4FC0_8385_F2B5D96C3E71#24130, cast(CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24042 as int) AS COL_1289F373_FF25_4487_9EE9_69B97F8F7E8C#24131, cast(CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#24043 as string) AS COL_9C14E0D7_2FBA_4353_97DE_0023051ED954#24132, cast(CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24044 as string) AS COL_1D51738B_5813_484E_9601_5F3B4C4606D7#24133, cast(CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#24045 as string) AS COL_0755F5E9_2A0B_4232_89D8_A65A9E2CA47B#24134, cast(CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#24046 as double) AS COL_74E4B274_D176_405D_853A_82B47F051C45#24135, cast(CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#24047 as double) AS COL_9DF6B1CF_6AD6_411C_84D6_9B2218CCCD7E#24136, cast(CONSOLIDATED_DA_37832_COL_E1A32417_2E12_41F2_99C2_8F9E74E8C0D0#24067 as string) AS COL_B4E89E69_2A0E_4AF8_A427_C03DC29AA3D1#24137]
+- Project [COL_8886263B_787F_402D_99DF_85269A2625C7#23924 AS CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#24032, COL_715DA55F_B685_4656_ACD7_0677A3328C5A#23925 AS CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24033, COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#23926 AS CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24034, COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#23927 AS CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24035, COL_B2A3110A_EA93_484C_99C3_654566F36027#23928 AS CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#24036, COL_87B73D01_19C3_4258_8107_533C60810F9B#23929 AS CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#24037, COL_F7878551_0607_4D5F_80D8_667ED2A491C5#23930 AS CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24038, COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#23931 AS CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24039, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#23932 AS CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24040, COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#23933 AS CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24041, COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#23934 AS CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24042, COL_CA314331_595A_479E_B554_2CF73BF8E065#23935 AS CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#24043, COL_05081AD0_57FC_451A_A0F0_02DA7463837B#23936 AS CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24044, COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#23937 AS CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#24045, COL_96EC1D60_6665_46D3_9518_324889EF63CF#23938 AS CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#24046, COL_8E10419E_226F_4098_A129_7AFAAA38B493#23939 AS CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#24047, COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#23940 AS CONSOLIDATED_DA_37832_COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#24048, COL_38186F06_5370_460A_8844_41809A1AAA16#23941 AS CONSOLIDATED_DA_37832_COL_38186F06_5370_460A_8844_41809A1AAA16#24049, COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#23942 AS CONSOLIDATED_DA_37832_COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#24050, COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#23943 AS CONSOLIDATED_DA_37832_COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#24051, COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#23944 AS CONSOLIDATED_DA_37832_COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#24052, COL_57F110A8_C27A_4968_805A_624B0B61FC56#23945 AS CONSOLIDATED_DA_37832_COL_57F110A8_C27A_4968_805A_624B0B61FC56#24053, COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#23946 AS CONSOLIDATED_DA_37832_COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#24054, COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#23947L AS CONSOLIDATED_DA_37832_COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#24055L, ... 12 more fields]
+- SubqueryAlias CONSOLIDATED_DA_37832116
+- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#23924,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#23925,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#23926,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#23927,COL_B2A3110A_EA93_484C_99C3_654566F36027#23928,COL_87B73D01_19C3_4258_8107_533C60810F9B#23929,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#23930,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#23931,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#23932,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#23933,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#23934,COL_CA314331_595A_479E_B554_2CF73BF8E065#23935,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#23936,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#23937,COL_96EC1D60_6665_46D3_9518_324889EF63CF#23938,COL_8E10419E_226F_4098_A129_7AFAAA38B493#23939,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#23940,COL_38186F06_5370_460A_8844_41809A1AAA16#23941,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#23942,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#23943,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#23944,COL_57F110A8_C27A_4968_805A_624B0B61FC56#23945,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#23946,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#23947L,... 12 more fields] parquet
== Analyzed Logical Plan ==
COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6: string, COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2: double, COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF: double
GlobalLimit 500000
+- LocalLimit 500000
+- Filter true
+- Project [COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24446 AS COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24546, COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24447 AS COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24547, COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24448 AS COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24548]
+- Project [COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24413 AS COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24446, COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24414 AS COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24447, COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24415 AS COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24448]
+- Project [COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24371 AS COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24413, COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24372 AS COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24414, COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24373 AS COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24415]
+- Project [COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24279 AS COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24371, COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24292 AS COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24372, COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24293 AS COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24373]
+- Project [COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24189 AS COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24279, round(COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24208, 2) AS COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24292, round(COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24210, 2) AS COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24293]
+- Sort [COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24189 ASC NULLS FIRST], true
+- Project [COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24189, COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24208, COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24210]
+- Aggregate [COL_B4E89E69_2A0E_4AF8_A427_C03DC29AA3D1#24171], [COL_B4E89E69_2A0E_4AF8_A427_C03DC29AA3D1#24171 AS COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24189, 1 AS NULL_1#24235, avg(COL_FECEEE88_40B0_4DCF_A8C2_F6B16A1BB0FF#24162) AS COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24208, avg(COL_F7142BC8_9EB9_4CD2_A907_8A483CCAC572#24163) AS COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24210]
+- Project [COL_499EC13B_2FE2_4AA3_8505_A532C6D3FF46#24121 AS COL_499EC13B_2FE2_4AA3_8505_A532C6D3FF46#24155, COL_512F8DDF_8973_4E08_8708_BC6B36AD68DD#24122 AS COL_512F8DDF_8973_4E08_8708_BC6B36AD68DD#24156, COL_AF3CDC09_4A3D_4B7F_9589_9E9432AC6D64#24123 AS COL_AF3CDC09_4A3D_4B7F_9589_9E9432AC6D64#24157, COL_8CA9410C_07C5_4B74_88AE_54723EE9428B#24124 AS COL_8CA9410C_07C5_4B74_88AE_54723EE9428B#24158, COL_BF6AD1A6_99CD_4160_BFD2_F09A72A8E236#24125 AS COL_BF6AD1A6_99CD_4160_BFD2_F09A72A8E236#24159, COL_A13BA407_4CE5_4974_B257_19EAD20D5213#24126 AS COL_A13BA407_4CE5_4974_B257_19EAD20D5213#24160, COL_83AC2845_92FB_4863_AFB3_39DE2851D0ED#24127 AS COL_83AC2845_92FB_4863_AFB3_39DE2851D0ED#24161, COL_FECEEE88_40B0_4DCF_A8C2_F6B16A1BB0FF#24128 AS COL_FECEEE88_40B0_4DCF_A8C2_F6B16A1BB0FF#24162, COL_F7142BC8_9EB9_4CD2_A907_8A483CCAC572#24129 AS COL_F7142BC8_9EB9_4CD2_A907_8A483CCAC572#24163, COL_EC03712A_2E82_4FC0_8385_F2B5D96C3E71#24130 AS COL_EC03712A_2E82_4FC0_8385_F2B5D96C3E71#24164, COL_1289F373_FF25_4487_9EE9_69B97F8F7E8C#24131 AS COL_1289F373_FF25_4487_9EE9_69B97F8F7E8C#24165, COL_9C14E0D7_2FBA_4353_97DE_0023051ED954#24132 AS COL_9C14E0D7_2FBA_4353_97DE_0023051ED954#24166, COL_1D51738B_5813_484E_9601_5F3B4C4606D7#24133 AS COL_1D51738B_5813_484E_9601_5F3B4C4606D7#24167, COL_0755F5E9_2A0B_4232_89D8_A65A9E2CA47B#24134 AS COL_0755F5E9_2A0B_4232_89D8_A65A9E2CA47B#24168, COL_74E4B274_D176_405D_853A_82B47F051C45#24135 AS COL_74E4B274_D176_405D_853A_82B47F051C45#24169, COL_9DF6B1CF_6AD6_411C_84D6_9B2218CCCD7E#24136 AS COL_9DF6B1CF_6AD6_411C_84D6_9B2218CCCD7E#24170, COL_B4E89E69_2A0E_4AF8_A427_C03DC29AA3D1#24137 AS COL_B4E89E69_2A0E_4AF8_A427_C03DC29AA3D1#24171]
+- Filter (COL_A13BA407_4CE5_4974_B257_19EAD20D5213#24126 <=> cast(Usine de ponte as string))
+- Project [cast(CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#24032 as timestamp) AS COL_499EC13B_2FE2_4AA3_8505_A532C6D3FF46#24121, cast(CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24033 as string) AS COL_512F8DDF_8973_4E08_8708_BC6B36AD68DD#24122, cast(CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24034 as string) AS COL_AF3CDC09_4A3D_4B7F_9589_9E9432AC6D64#24123, cast(CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24035 as string) AS COL_8CA9410C_07C5_4B74_88AE_54723EE9428B#24124, cast(CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#24036 as string) AS COL_BF6AD1A6_99CD_4160_BFD2_F09A72A8E236#24125, cast(CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#24037 as string) AS COL_A13BA407_4CE5_4974_B257_19EAD20D5213#24126, cast(CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24038 as string) AS COL_83AC2845_92FB_4863_AFB3_39DE2851D0ED#24127, cast(CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24039 as double) AS COL_FECEEE88_40B0_4DCF_A8C2_F6B16A1BB0FF#24128, cast(CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24040 as double) AS COL_F7142BC8_9EB9_4CD2_A907_8A483CCAC572#24129, cast(CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24041 as int) AS COL_EC03712A_2E82_4FC0_8385_F2B5D96C3E71#24130, cast(CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24042 as int) AS COL_1289F373_FF25_4487_9EE9_69B97F8F7E8C#24131, cast(CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#24043 as string) AS COL_9C14E0D7_2FBA_4353_97DE_0023051ED954#24132, cast(CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24044 as string) AS COL_1D51738B_5813_484E_9601_5F3B4C4606D7#24133, cast(CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#24045 as string) AS COL_0755F5E9_2A0B_4232_89D8_A65A9E2CA47B#24134, cast(CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#24046 as double) AS COL_74E4B274_D176_405D_853A_82B47F051C45#24135, cast(CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#24047 as double) AS COL_9DF6B1CF_6AD6_411C_84D6_9B2218CCCD7E#24136, cast(CONSOLIDATED_DA_37832_COL_E1A32417_2E12_41F2_99C2_8F9E74E8C0D0#24067 as string) AS COL_B4E89E69_2A0E_4AF8_A427_C03DC29AA3D1#24137]
+- Project [COL_8886263B_787F_402D_99DF_85269A2625C7#23924 AS CONSOLIDATED_DA_37832_COL_8886263B_787F_402D_99DF_85269A2625C7#24032, COL_715DA55F_B685_4656_ACD7_0677A3328C5A#23925 AS CONSOLIDATED_DA_37832_COL_715DA55F_B685_4656_ACD7_0677A3328C5A#24033, COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#23926 AS CONSOLIDATED_DA_37832_COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#24034, COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#23927 AS CONSOLIDATED_DA_37832_COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#24035, COL_B2A3110A_EA93_484C_99C3_654566F36027#23928 AS CONSOLIDATED_DA_37832_COL_B2A3110A_EA93_484C_99C3_654566F36027#24036, COL_87B73D01_19C3_4258_8107_533C60810F9B#23929 AS CONSOLIDATED_DA_37832_COL_87B73D01_19C3_4258_8107_533C60810F9B#24037, COL_F7878551_0607_4D5F_80D8_667ED2A491C5#23930 AS CONSOLIDATED_DA_37832_COL_F7878551_0607_4D5F_80D8_667ED2A491C5#24038, COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#23931 AS CONSOLIDATED_DA_37832_COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#24039, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#23932 AS CONSOLIDATED_DA_37832_COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#24040, COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#23933 AS CONSOLIDATED_DA_37832_COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#24041, COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#23934 AS CONSOLIDATED_DA_37832_COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#24042, COL_CA314331_595A_479E_B554_2CF73BF8E065#23935 AS CONSOLIDATED_DA_37832_COL_CA314331_595A_479E_B554_2CF73BF8E065#24043, COL_05081AD0_57FC_451A_A0F0_02DA7463837B#23936 AS CONSOLIDATED_DA_37832_COL_05081AD0_57FC_451A_A0F0_02DA7463837B#24044, COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#23937 AS CONSOLIDATED_DA_37832_COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#24045, COL_96EC1D60_6665_46D3_9518_324889EF63CF#23938 AS CONSOLIDATED_DA_37832_COL_96EC1D60_6665_46D3_9518_324889EF63CF#24046, COL_8E10419E_226F_4098_A129_7AFAAA38B493#23939 AS CONSOLIDATED_DA_37832_COL_8E10419E_226F_4098_A129_7AFAAA38B493#24047, COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#23940 AS CONSOLIDATED_DA_37832_COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#24048, COL_38186F06_5370_460A_8844_41809A1AAA16#23941 AS CONSOLIDATED_DA_37832_COL_38186F06_5370_460A_8844_41809A1AAA16#24049, COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#23942 AS CONSOLIDATED_DA_37832_COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#24050, COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#23943 AS CONSOLIDATED_DA_37832_COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#24051, COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#23944 AS CONSOLIDATED_DA_37832_COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#24052, COL_57F110A8_C27A_4968_805A_624B0B61FC56#23945 AS CONSOLIDATED_DA_37832_COL_57F110A8_C27A_4968_805A_624B0B61FC56#24053, COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#23946 AS CONSOLIDATED_DA_37832_COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#24054, COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#23947L AS CONSOLIDATED_DA_37832_COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#24055L, ... 12 more fields]
+- SubqueryAlias CONSOLIDATED_DA_37832116
+- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#23924,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#23925,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#23926,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#23927,COL_B2A3110A_EA93_484C_99C3_654566F36027#23928,COL_87B73D01_19C3_4258_8107_533C60810F9B#23929,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#23930,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#23931,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#23932,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#23933,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#23934,COL_CA314331_595A_479E_B554_2CF73BF8E065#23935,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#23936,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#23937,COL_96EC1D60_6665_46D3_9518_324889EF63CF#23938,COL_8E10419E_226F_4098_A129_7AFAAA38B493#23939,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#23940,COL_38186F06_5370_460A_8844_41809A1AAA16#23941,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#23942,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#23943,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#23944,COL_57F110A8_C27A_4968_805A_624B0B61FC56#23945,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#23946,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#23947L,... 12 more fields] parquet
== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Project [COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24189, round(COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24208, 2) AS COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24547, round(COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24210, 2) AS COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24548]
+- Sort [COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24189 ASC NULLS FIRST], true
+- Aggregate [COL_B4E89E69_2A0E_4AF8_A427_C03DC29AA3D1#24171], [COL_B4E89E69_2A0E_4AF8_A427_C03DC29AA3D1#24171 AS COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24189, avg(COL_FECEEE88_40B0_4DCF_A8C2_F6B16A1BB0FF#24162) AS COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24208, avg(COL_F7142BC8_9EB9_4CD2_A907_8A483CCAC572#24163) AS COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24210]
+- Project [COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#23931 AS COL_FECEEE88_40B0_4DCF_A8C2_F6B16A1BB0FF#24162, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#23932 AS COL_F7142BC8_9EB9_4CD2_A907_8A483CCAC572#24163, COL_E1A32417_2E12_41F2_99C2_8F9E74E8C0D0#23959 AS COL_B4E89E69_2A0E_4AF8_A427_C03DC29AA3D1#24171]
+- Filter (COL_87B73D01_19C3_4258_8107_533C60810F9B#23929 <=> Usine de ponte)
+- Relation[COL_8886263B_787F_402D_99DF_85269A2625C7#23924,COL_715DA55F_B685_4656_ACD7_0677A3328C5A#23925,COL_B7AF10A9_1A73_43AA_B078_6AB6B6CBD8F6#23926,COL_3445F5DA_65A9_4E08_BBCB_9DDF8BF616AE#23927,COL_B2A3110A_EA93_484C_99C3_654566F36027#23928,COL_87B73D01_19C3_4258_8107_533C60810F9B#23929,COL_F7878551_0607_4D5F_80D8_667ED2A491C5#23930,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#23931,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#23932,COL_9CA9D346_FD17_4B45_8682_F1B52407E9FB#23933,COL_8AED0ED3_AB8B_4D77_A014_521B3C8F2957#23934,COL_CA314331_595A_479E_B554_2CF73BF8E065#23935,COL_05081AD0_57FC_451A_A0F0_02DA7463837B#23936,COL_75EF94F9_DFFD_4312_8423_15BCA0E6366F#23937,COL_96EC1D60_6665_46D3_9518_324889EF63CF#23938,COL_8E10419E_226F_4098_A129_7AFAAA38B493#23939,COL_E36BF28A_A071_4942_9A87_6DE4DEC2DE52#23940,COL_38186F06_5370_460A_8844_41809A1AAA16#23941,COL_C52A546A_33A6_403C_BFC8_D5CF14FE4545#23942,COL_9E1F310A_A6D7_45F0_B3D8_9287793AE0CE#23943,COL_5A68E2C4_2B0D_4635_A8BB_5A93300D1724#23944,COL_57F110A8_C27A_4968_805A_624B0B61FC56#23945,COL_1C93F90E_A06D_4BFB_876F_2EF613D4801B#23946,COL_5E7B41EF_01E8_4D87_B45D_42855A7DE7F9#23947L,... 12 more fields] parquet
== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- TakeOrderedAndProject(limit=500000, orderBy=[COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24189 ASC NULLS FIRST], output=[COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24189,COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24547,COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24548])
+- *(2) HashAggregate(keys=[COL_B4E89E69_2A0E_4AF8_A427_C03DC29AA3D1#24171], functions=[avg(COL_FECEEE88_40B0_4DCF_A8C2_F6B16A1BB0FF#24162), avg(COL_F7142BC8_9EB9_4CD2_A907_8A483CCAC572#24163)], output=[COL_5A0139CA_5D45_4233_ADC1_3F2928DD6FC6#24189, COL_13733E5A_AC6F_4565_A1AB_2DAD579A0BC2#24208, COL_6F6ED4DD_CDB3_4A41_92E4_B373022886FF#24210])
+- CustomShuffleReader coalesced
+- ShuffleQueryStage 0
+- Exchange hashpartitioning(COL_B4E89E69_2A0E_4AF8_A427_C03DC29AA3D1#24171, 200), true, [id=#4627]
+- *(1) HashAggregate(keys=[COL_B4E89E69_2A0E_4AF8_A427_C03DC29AA3D1#24171], functions=[partial_avg(COL_FECEEE88_40B0_4DCF_A8C2_F6B16A1BB0FF#24162), partial_avg(COL_F7142BC8_9EB9_4CD2_A907_8A483CCAC572#24163)], output=[COL_B4E89E69_2A0E_4AF8_A427_C03DC29AA3D1#24171, sum#24784, count#24785L, sum#24786, count#24787L])
+- *(1) Project [COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#23931 AS COL_FECEEE88_40B0_4DCF_A8C2_F6B16A1BB0FF#24162, COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#23932 AS COL_F7142BC8_9EB9_4CD2_A907_8A483CCAC572#24163, COL_E1A32417_2E12_41F2_99C2_8F9E74E8C0D0#23959 AS COL_B4E89E69_2A0E_4AF8_A427_C03DC29AA3D1#24171]
+- *(1) Filter (COL_87B73D01_19C3_4258_8107_533C60810F9B#23929 <=> Usine de ponte)
+- *(1) ColumnarToRow
+- FileScan parquet [COL_87B73D01_19C3_4258_8107_533C60810F9B#23929,COL_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB#23931,COL_EEE3E075_652E_4DA4_BBBF_B9DAC72F2E18#23932,COL_E1A32417_2E12_41F2_99C2_8F9E74E8C0D0#23959] Batched: true, DataFilters: [(COL_87B73D01_19C3_4258_8107_533C60810F9B#23929 <=> 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_6A8610AB_FAE8_4EC0_9A07_72CB94FB4FDB:d...