== Parsed Logical Plan ==
CreateViewCommand `QUALITE_SYNTHES_38022116`, false, true, LocalTempView
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11440, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11441L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11442L, COL_70424811_2DDC_469F_8639_7777D23A61D6#11064 AS COL_70424811_2DDC_469F_8639_7777D23A61D6#11443, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11444L, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#11339 AS COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#11445, COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#11432]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L, COL_70424811_2DDC_469F_8639_7777D23A61D6#11064, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#11339, dec_operator(cast(DIFFERENCE as string), struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L)) AS COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#11432]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L, COL_70424811_2DDC_469F_8639_7777D23A61D6#11064, str_replace_regex(str_concat(struct(col1, dec_to_str(dec_round(dec_operator(cast(PRODUIT as string), struct(col1, dec_operator(cast(DIVISION as string), struct(COL_1AD867EF_74A9_4253_97E3_892B44C7C916, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L, COL_1FD79F2E_4E20_4432_8796_999C6B41C518, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L)), col2, cast(100 as double))), cast(2 as int))), col2, cast(% as string))), cast((?<![0-9])% as string), cast(Pas de traitement as string)) AS COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#11339]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L, str_concat(struct(col1, dec_to_str(dec_round(dec_operator(cast(PRODUIT as string), struct(col1, dec_operator(cast(DIVISION as string), struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1FD79F2E_4E20_4432_8796_999C6B41C518, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L)), col2, cast(100 as double))), cast(2 as int))), col2, cast(% as string))) AS COL_70424811_2DDC_469F_8639_7777D23A61D6#11064]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11034 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11037L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11038L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11039L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11034, coalesce(COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, cast(0 as bigint)) AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11037L, coalesce(COL_CF1B2EC2_6198_4115_B079_F51D532426DB#10996L, cast(0 as bigint)) AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11038L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#10991L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11039L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#10991L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#10996L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10906L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#10991L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10906L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10906L, Avant traitement qualité_NULL_1#10907, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#10837[0] AS Après traitement qualité_NULL_1#10844, __pivot_sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829` AS `sum(``COL_D08E9E92_1F45_417D_929C_3D370D7552B8``) AS ``COL_13D55021_C380_4F34_9553_27DE47738829```#10843[0] AS Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10906L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#10837[1] AS Avant traitement qualité_NULL_1#10907, __pivot_sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829` AS `sum(``COL_D08E9E92_1F45_417D_929C_3D370D7552B8``) AS ``COL_13D55021_C380_4F34_9553_27DE47738829```#10843[1] AS Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L]
+- Aggregate [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L], [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776, 1 AS `NULL_1`#10830, Après traitement qualité, Avant traitement qualité, 0, 0) AS __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#10837, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#10831L, Après traitement qualité, Avant traitement qualité, 0, 0) AS __pivot_sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829` AS `sum(``COL_D08E9E92_1F45_417D_929C_3D370D7552B8``) AS ``COL_13D55021_C380_4F34_9553_27DE47738829```#10843]
+- Aggregate [COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#10814, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776], [COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#10814 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776, 1 AS 1 AS `NULL_1`#10830, sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10769L) AS sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#10831L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10769L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776, str_join(struct(col1, str_transform_case(str_replace_extend(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768, struct(col1, cast( (Init) - Vide ou Null_SUM as string), col2, cast( (Final) - Vide ou Null_SUM as string), col3, cast( (Init) - Vide ou null_SUM as string)), struct(col1, cast( as string), col2, cast( as string), col3, cast( as string))), cast(UPPER as string)), col2, cast(non renseigné as string)), cast( - as string)) AS COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#10814]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10769L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L, str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768)), cast(INIT as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768)), cast(INIT as string)) END, cast(Avant traitement qualité as string), cast(Après traitement qualité as string)) AS COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10761 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10762L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10769L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10763L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10750 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10761, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10754L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10762L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10744L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10763L]
+- Project [COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10744L, COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10750, col1#10746L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10754L]
+- Project [COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10744L, col0#10745 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10750, col1#10746L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10724L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10744L, col0#10745, col1#10746L]
+- Generate stack(18, Adresse_GIE (Init) - Vide ou Null_SUM, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10706L, Code postal_GIE (Final) - Vide ou Null_SUM, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10707L, Code Postal_GIE (Init) - Vide ou Null_SUM, COL_67BC478B_6031_4C57_9DCE_401ABA863959#10708L, Commune_GIE (Init) - Vide ou Null_SUM, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10709L, Entité Juridique_GIE (Init) - Vide ou null_SUM, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10710L, Mail_GIE (Final) - Vide ou Null_SUM, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10711L, mail_GIE (Init) - Vide ou Null_SUM, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10712L, SIREN_GIE (Final) - Vide ou Null_SUM, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10713L, SIREN_GIE (Init) - Vide ou Null_SUM, COL_153C42A2_431C_44DE_92C1_40F644939BB5#10714L, SIRET_GIE (Final) - Vide ou Null_SUM, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10715L, SIRET_GIE (Init) - Vide ou Null_SUM, COL_9968307D_4589_4C17_884D_E5235BA04755#10716L, téléphone_GIE (Final) - Vide ou Null_SUM, ... 13 more fields), false, [col0#10745, col1#10746L]
+- Project [COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10578L AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10706L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10580L AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10707L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#10582L AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#10708L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10584L AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10709L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10586L AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10710L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10588L AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10711L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10590L AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10712L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10592L AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10713L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#10594L AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#10714L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10596L AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10715L, COL_9968307D_4589_4C17_884D_E5235BA04755#10598L AS COL_9968307D_4589_4C17_884D_E5235BA04755#10716L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10600L AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10717L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#10602L AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#10718L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10604L AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10719L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10606L AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10720L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10608L AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10721L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10610L AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10722L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10612L AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10723L, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10576L AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10724L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10576L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10578L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10580L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#10582L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10584L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10586L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10588L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10590L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10592L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#10594L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10596L, COL_9968307D_4589_4C17_884D_E5235BA04755#10598L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10600L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#10602L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10604L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10606L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10608L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10610L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10612L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10576L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10578L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10580L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#10582L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10584L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10586L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10588L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10590L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10592L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#10594L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10596L, COL_9968307D_4589_4C17_884D_E5235BA04755#10598L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10600L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#10602L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10604L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10606L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10608L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10610L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10612L]
+- Aggregate [1 AS NULL_1#10619, first(COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#10528L, true) AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10576L, sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#10509 as bigint)) AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10578L, sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#10514 as bigint)) AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10580L, sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#10515 as bigint)) AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#10582L, sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#10516 as bigint)) AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10584L, sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#10517 as bigint)) AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10586L, sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#10518 as bigint)) AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10588L, sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#10519 as bigint)) AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10590L, sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#10520 as bigint)) AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10592L, sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#10521 as bigint)) AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#10594L, sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#10522 as bigint)) AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10596L, sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#10523 as bigint)) AS COL_9968307D_4589_4C17_884D_E5235BA04755#10598L, sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#10524 as bigint)) AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10600L, sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#10525 as bigint)) AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#10602L, sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#10526 as bigint)) AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10604L, sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#10510 as bigint)) AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10606L, sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#10511 as bigint)) AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10608L, sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#10512 as bigint)) AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10610L, sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#10513 as bigint)) AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10612L]
+- Project [COL_56938DE4_4C31_41D9_801C_C0B0842C509A#10466 AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#10509, COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#10467 AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#10510, COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#10468 AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#10511, COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#10469 AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#10512, COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#10470 AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#10513, COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#10471 AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#10514, COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#10472 AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#10515, COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#10473 AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#10516, COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#10474 AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#10517, COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#10475 AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#10518, COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#10476 AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#10519, COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#10477 AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#10520, COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#10478 AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#10521, COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#10479 AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#10522, COL_3C783429_A484_4DEF_9A90_CFB70F06D809#10480 AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#10523, COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#10481 AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#10524, COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#10482 AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#10525, COL_013B4432_4745_457D_A136_EA9290A58319#10483 AS COL_013B4432_4745_457D_A136_EA9290A58319#10526, COL_925B308B_8FFC_4303_927E_8232D67AA1AB#10465 AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#10527, COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#10484L AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#10528L, COL_7B8D598B_1EE2_466A_A3A3_CBA6A5A3910C#10485]
+- Project [cast(EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#10300 as string) AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#10465, cast(EVALUATION_QUAL_37976_COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#10339 as int) AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#10466, cast(EVALUATION_QUAL_37976_COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#10342 as int) AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#10467, cast(EVALUATION_QUAL_37976_COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#10345 as int) AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#10468, cast(EVALUATION_QUAL_37976_COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#10341 as int) AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#10469, cast(EVALUATION_QUAL_37976_COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#10346 as int) AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#10470, cast(EVALUATION_QUAL_37976_COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#10329 as int) AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#10471, cast(EVALUATION_QUAL_37976_COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#10330 as int) AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#10472, cast(EVALUATION_QUAL_37976_COL_464A280A_485C_42DC_883D_1B8FCCF5258D#10328 as int) AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#10473, cast(EVALUATION_QUAL_37976_COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#10326 as int) AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#10474, cast(EVALUATION_QUAL_37976_COL_45927A2C_7B5E_46F0_B288_4E446278061F#10336 as int) AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#10475, cast(EVALUATION_QUAL_37976_COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#10335 as int) AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#10476, cast(EVALUATION_QUAL_37976_COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#10332 as int) AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#10477, cast(EVALUATION_QUAL_37976_COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#10331 as int) AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#10478, cast(EVALUATION_QUAL_37976_COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#10334 as int) AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#10479, cast(EVALUATION_QUAL_37976_COL_726D968C_42FA_4E31_BD79_225187FD2C06#10333 as int) AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#10480, cast(EVALUATION_QUAL_37976_COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#10337 as int) AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#10481, cast(EVALUATION_QUAL_37976_COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#10338 as int) AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#10482, cast(EVALUATION_QUAL_37976_COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#10327 as int) AS COL_013B4432_4745_457D_A136_EA9290A58319#10483, cast(EVALUATION_QUAL_37976_COL_4C315D79_D322_4165_A505_BACE77D2FFCE#10344L as bigint) AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#10484L, cast(EVALUATION_QUAL_37976_COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#10356 as array<string>) AS COL_7B8D598B_1EE2_466A_A3A3_CBA6A5A3910C#10485]
+- Project [COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#9855 AS EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#10300, COL_BE341768_3194_4DD8_99AF_6C95339F9D93#9856 AS EVALUATION_QUAL_37976_COL_BE341768_3194_4DD8_99AF_6C95339F9D93#10301, COL_1839416A_7E82_4851_9843_99CFBF41CD08#9857 AS EVALUATION_QUAL_37976_COL_1839416A_7E82_4851_9843_99CFBF41CD08#10302, COL_30D07025_5684_4705_A04C_1C678E65ED32#9858 AS EVALUATION_QUAL_37976_COL_30D07025_5684_4705_A04C_1C678E65ED32#10303, COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#9859 AS EVALUATION_QUAL_37976_COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#10304, COL_648D9173_ED6C_4044_8903_158C1196A3E2#9860 AS EVALUATION_QUAL_37976_COL_648D9173_ED6C_4044_8903_158C1196A3E2#10305, COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#9861 AS EVALUATION_QUAL_37976_COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#10306, COL_A5976546_E656_4E43_9B26_F4C3A85BA303#9862 AS EVALUATION_QUAL_37976_COL_A5976546_E656_4E43_9B26_F4C3A85BA303#10307, COL_903F51D5_1E51_488D_9761_67785F7AF263#9863 AS EVALUATION_QUAL_37976_COL_903F51D5_1E51_488D_9761_67785F7AF263#10308, COL_07DE422A_6DBA_4611_A969_1471FD804B90#9864 AS EVALUATION_QUAL_37976_COL_07DE422A_6DBA_4611_A969_1471FD804B90#10309, COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#9865 AS EVALUATION_QUAL_37976_COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#10310, COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#9866 AS EVALUATION_QUAL_37976_COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#10311, COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#9867 AS EVALUATION_QUAL_37976_COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#10312, COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#9868 AS EVALUATION_QUAL_37976_COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#10313, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#9869 AS EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#10314, COL_898D946E_34EC_4196_88F6_338B6B38B05F#9870 AS EVALUATION_QUAL_37976_COL_898D946E_34EC_4196_88F6_338B6B38B05F#10315, COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#9871 AS EVALUATION_QUAL_37976_COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#10316, COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#9872 AS EVALUATION_QUAL_37976_COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#10317, COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#9873 AS EVALUATION_QUAL_37976_COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#10318, COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#9874 AS EVALUATION_QUAL_37976_COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#10319, COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#9875 AS EVALUATION_QUAL_37976_COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#10320, COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#9876 AS EVALUATION_QUAL_37976_COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#10321, COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#9877 AS EVALUATION_QUAL_37976_COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#10322, COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#9878 AS EVALUATION_QUAL_37976_COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#10323, ... 37 more fields]
+- SubqueryAlias EVALUATION_QUAL_37976116
+- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#9855,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#9856,COL_1839416A_7E82_4851_9843_99CFBF41CD08#9857,COL_30D07025_5684_4705_A04C_1C678E65ED32#9858,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#9859,COL_648D9173_ED6C_4044_8903_158C1196A3E2#9860,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#9861,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#9862,COL_903F51D5_1E51_488D_9761_67785F7AF263#9863,COL_07DE422A_6DBA_4611_A969_1471FD804B90#9864,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#9865,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#9866,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#9867,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#9868,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#9869,COL_898D946E_34EC_4196_88F6_338B6B38B05F#9870,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#9871,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#9872,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#9873,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#9874,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#9875,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#9876,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#9877,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#9878,... 37 more fields] parquet
== Analyzed Logical Plan ==
CreateViewCommand `QUALITE_SYNTHES_38022116`, false, true, LocalTempView
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11440, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11441L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11442L, COL_70424811_2DDC_469F_8639_7777D23A61D6#11064 AS COL_70424811_2DDC_469F_8639_7777D23A61D6#11443, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11444L, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#11339 AS COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#11445, COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#11432]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L, COL_70424811_2DDC_469F_8639_7777D23A61D6#11064, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#11339, dec_operator(cast(DIFFERENCE as string), struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L)) AS COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#11432]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L, COL_70424811_2DDC_469F_8639_7777D23A61D6#11064, str_replace_regex(str_concat(struct(col1, dec_to_str(dec_round(dec_operator(cast(PRODUIT as string), struct(col1, dec_operator(cast(DIVISION as string), struct(COL_1AD867EF_74A9_4253_97E3_892B44C7C916, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L, COL_1FD79F2E_4E20_4432_8796_999C6B41C518, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L)), col2, cast(100 as double))), cast(2 as int))), col2, cast(% as string))), cast((?<![0-9])% as string), cast(Pas de traitement as string)) AS COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#11339]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L, str_concat(struct(col1, dec_to_str(dec_round(dec_operator(cast(PRODUIT as string), struct(col1, dec_operator(cast(DIVISION as string), struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1FD79F2E_4E20_4432_8796_999C6B41C518, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L)), col2, cast(100 as double))), cast(2 as int))), col2, cast(% as string))) AS COL_70424811_2DDC_469F_8639_7777D23A61D6#11064]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11034 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11037L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11038L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11039L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11034, coalesce(COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, cast(0 as bigint)) AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11037L, coalesce(COL_CF1B2EC2_6198_4115_B079_F51D532426DB#10996L, cast(0 as bigint)) AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11038L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#10991L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11039L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#10991L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#10996L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10906L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#10991L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10906L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10906L, Avant traitement qualité_NULL_1#10907, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#10837[0] AS Après traitement qualité_NULL_1#10844, __pivot_sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829` AS `sum(``COL_D08E9E92_1F45_417D_929C_3D370D7552B8``) AS ``COL_13D55021_C380_4F34_9553_27DE47738829```#10843[0] AS Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10906L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#10837[1] AS Avant traitement qualité_NULL_1#10907, __pivot_sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829` AS `sum(``COL_D08E9E92_1F45_417D_929C_3D370D7552B8``) AS ``COL_13D55021_C380_4F34_9553_27DE47738829```#10843[1] AS Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L]
+- Aggregate [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L], [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776, 1 AS `NULL_1`#10830, Après traitement qualité, Avant traitement qualité, 0, 0) AS __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#10837, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#10831L, Après traitement qualité, Avant traitement qualité, 0, 0) AS __pivot_sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829` AS `sum(``COL_D08E9E92_1F45_417D_929C_3D370D7552B8``) AS ``COL_13D55021_C380_4F34_9553_27DE47738829```#10843]
+- Aggregate [COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#10814, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776], [COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#10814 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776, 1 AS 1 AS `NULL_1`#10830, sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10769L) AS sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#10831L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10769L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776, str_join(struct(col1, str_transform_case(str_replace_extend(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768, struct(col1, cast( (Init) - Vide ou Null_SUM as string), col2, cast( (Final) - Vide ou Null_SUM as string), col3, cast( (Init) - Vide ou null_SUM as string)), struct(col1, cast( as string), col2, cast( as string), col3, cast( as string))), cast(UPPER as string)), col2, cast(non renseigné as string)), cast( - as string)) AS COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#10814]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10769L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L, str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768)), cast(INIT as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768)), cast(INIT as string)) END, cast(Avant traitement qualité as string), cast(Après traitement qualité as string)) AS COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10761 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10762L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10769L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10763L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10750 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10761, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10754L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10762L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10744L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10763L]
+- Project [COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10744L, COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10750, col1#10746L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10754L]
+- Project [COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10744L, col0#10745 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10750, col1#10746L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10724L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10744L, col0#10745, col1#10746L]
+- Generate stack(18, Adresse_GIE (Init) - Vide ou Null_SUM, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10706L, Code postal_GIE (Final) - Vide ou Null_SUM, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10707L, Code Postal_GIE (Init) - Vide ou Null_SUM, COL_67BC478B_6031_4C57_9DCE_401ABA863959#10708L, Commune_GIE (Init) - Vide ou Null_SUM, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10709L, Entité Juridique_GIE (Init) - Vide ou null_SUM, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10710L, Mail_GIE (Final) - Vide ou Null_SUM, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10711L, mail_GIE (Init) - Vide ou Null_SUM, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10712L, SIREN_GIE (Final) - Vide ou Null_SUM, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10713L, SIREN_GIE (Init) - Vide ou Null_SUM, COL_153C42A2_431C_44DE_92C1_40F644939BB5#10714L, SIRET_GIE (Final) - Vide ou Null_SUM, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10715L, SIRET_GIE (Init) - Vide ou Null_SUM, COL_9968307D_4589_4C17_884D_E5235BA04755#10716L, téléphone_GIE (Final) - Vide ou Null_SUM, ... 13 more fields), false, [col0#10745, col1#10746L]
+- Project [COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10578L AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10706L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10580L AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10707L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#10582L AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#10708L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10584L AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10709L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10586L AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10710L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10588L AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10711L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10590L AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10712L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10592L AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10713L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#10594L AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#10714L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10596L AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10715L, COL_9968307D_4589_4C17_884D_E5235BA04755#10598L AS COL_9968307D_4589_4C17_884D_E5235BA04755#10716L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10600L AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10717L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#10602L AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#10718L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10604L AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10719L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10606L AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10720L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10608L AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10721L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10610L AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10722L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10612L AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10723L, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10576L AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10724L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10576L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10578L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10580L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#10582L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10584L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10586L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10588L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10590L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10592L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#10594L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10596L, COL_9968307D_4589_4C17_884D_E5235BA04755#10598L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10600L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#10602L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10604L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10606L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10608L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10610L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10612L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10576L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10578L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10580L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#10582L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10584L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10586L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10588L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10590L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10592L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#10594L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10596L, COL_9968307D_4589_4C17_884D_E5235BA04755#10598L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10600L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#10602L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10604L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10606L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10608L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10610L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10612L]
+- Aggregate [1 AS NULL_1#10619, first(COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#10528L, true) AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10576L, sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#10509 as bigint)) AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10578L, sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#10514 as bigint)) AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10580L, sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#10515 as bigint)) AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#10582L, sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#10516 as bigint)) AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10584L, sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#10517 as bigint)) AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10586L, sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#10518 as bigint)) AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10588L, sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#10519 as bigint)) AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10590L, sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#10520 as bigint)) AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10592L, sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#10521 as bigint)) AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#10594L, sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#10522 as bigint)) AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10596L, sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#10523 as bigint)) AS COL_9968307D_4589_4C17_884D_E5235BA04755#10598L, sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#10524 as bigint)) AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10600L, sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#10525 as bigint)) AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#10602L, sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#10526 as bigint)) AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10604L, sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#10510 as bigint)) AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10606L, sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#10511 as bigint)) AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10608L, sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#10512 as bigint)) AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10610L, sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#10513 as bigint)) AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10612L]
+- Project [COL_56938DE4_4C31_41D9_801C_C0B0842C509A#10466 AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#10509, COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#10467 AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#10510, COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#10468 AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#10511, COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#10469 AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#10512, COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#10470 AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#10513, COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#10471 AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#10514, COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#10472 AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#10515, COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#10473 AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#10516, COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#10474 AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#10517, COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#10475 AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#10518, COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#10476 AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#10519, COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#10477 AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#10520, COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#10478 AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#10521, COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#10479 AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#10522, COL_3C783429_A484_4DEF_9A90_CFB70F06D809#10480 AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#10523, COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#10481 AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#10524, COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#10482 AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#10525, COL_013B4432_4745_457D_A136_EA9290A58319#10483 AS COL_013B4432_4745_457D_A136_EA9290A58319#10526, COL_925B308B_8FFC_4303_927E_8232D67AA1AB#10465 AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#10527, COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#10484L AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#10528L, COL_7B8D598B_1EE2_466A_A3A3_CBA6A5A3910C#10485]
+- Project [cast(EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#10300 as string) AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#10465, cast(EVALUATION_QUAL_37976_COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#10339 as int) AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#10466, cast(EVALUATION_QUAL_37976_COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#10342 as int) AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#10467, cast(EVALUATION_QUAL_37976_COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#10345 as int) AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#10468, cast(EVALUATION_QUAL_37976_COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#10341 as int) AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#10469, cast(EVALUATION_QUAL_37976_COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#10346 as int) AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#10470, cast(EVALUATION_QUAL_37976_COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#10329 as int) AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#10471, cast(EVALUATION_QUAL_37976_COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#10330 as int) AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#10472, cast(EVALUATION_QUAL_37976_COL_464A280A_485C_42DC_883D_1B8FCCF5258D#10328 as int) AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#10473, cast(EVALUATION_QUAL_37976_COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#10326 as int) AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#10474, cast(EVALUATION_QUAL_37976_COL_45927A2C_7B5E_46F0_B288_4E446278061F#10336 as int) AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#10475, cast(EVALUATION_QUAL_37976_COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#10335 as int) AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#10476, cast(EVALUATION_QUAL_37976_COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#10332 as int) AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#10477, cast(EVALUATION_QUAL_37976_COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#10331 as int) AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#10478, cast(EVALUATION_QUAL_37976_COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#10334 as int) AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#10479, cast(EVALUATION_QUAL_37976_COL_726D968C_42FA_4E31_BD79_225187FD2C06#10333 as int) AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#10480, cast(EVALUATION_QUAL_37976_COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#10337 as int) AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#10481, cast(EVALUATION_QUAL_37976_COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#10338 as int) AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#10482, cast(EVALUATION_QUAL_37976_COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#10327 as int) AS COL_013B4432_4745_457D_A136_EA9290A58319#10483, cast(EVALUATION_QUAL_37976_COL_4C315D79_D322_4165_A505_BACE77D2FFCE#10344L as bigint) AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#10484L, cast(EVALUATION_QUAL_37976_COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#10356 as array<string>) AS COL_7B8D598B_1EE2_466A_A3A3_CBA6A5A3910C#10485]
+- Project [COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#9855 AS EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#10300, COL_BE341768_3194_4DD8_99AF_6C95339F9D93#9856 AS EVALUATION_QUAL_37976_COL_BE341768_3194_4DD8_99AF_6C95339F9D93#10301, COL_1839416A_7E82_4851_9843_99CFBF41CD08#9857 AS EVALUATION_QUAL_37976_COL_1839416A_7E82_4851_9843_99CFBF41CD08#10302, COL_30D07025_5684_4705_A04C_1C678E65ED32#9858 AS EVALUATION_QUAL_37976_COL_30D07025_5684_4705_A04C_1C678E65ED32#10303, COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#9859 AS EVALUATION_QUAL_37976_COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#10304, COL_648D9173_ED6C_4044_8903_158C1196A3E2#9860 AS EVALUATION_QUAL_37976_COL_648D9173_ED6C_4044_8903_158C1196A3E2#10305, COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#9861 AS EVALUATION_QUAL_37976_COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#10306, COL_A5976546_E656_4E43_9B26_F4C3A85BA303#9862 AS EVALUATION_QUAL_37976_COL_A5976546_E656_4E43_9B26_F4C3A85BA303#10307, COL_903F51D5_1E51_488D_9761_67785F7AF263#9863 AS EVALUATION_QUAL_37976_COL_903F51D5_1E51_488D_9761_67785F7AF263#10308, COL_07DE422A_6DBA_4611_A969_1471FD804B90#9864 AS EVALUATION_QUAL_37976_COL_07DE422A_6DBA_4611_A969_1471FD804B90#10309, COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#9865 AS EVALUATION_QUAL_37976_COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#10310, COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#9866 AS EVALUATION_QUAL_37976_COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#10311, COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#9867 AS EVALUATION_QUAL_37976_COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#10312, COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#9868 AS EVALUATION_QUAL_37976_COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#10313, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#9869 AS EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#10314, COL_898D946E_34EC_4196_88F6_338B6B38B05F#9870 AS EVALUATION_QUAL_37976_COL_898D946E_34EC_4196_88F6_338B6B38B05F#10315, COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#9871 AS EVALUATION_QUAL_37976_COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#10316, COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#9872 AS EVALUATION_QUAL_37976_COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#10317, COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#9873 AS EVALUATION_QUAL_37976_COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#10318, COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#9874 AS EVALUATION_QUAL_37976_COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#10319, COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#9875 AS EVALUATION_QUAL_37976_COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#10320, COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#9876 AS EVALUATION_QUAL_37976_COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#10321, COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#9877 AS EVALUATION_QUAL_37976_COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#10322, COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#9878 AS EVALUATION_QUAL_37976_COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#10323, ... 37 more fields]
+- SubqueryAlias EVALUATION_QUAL_37976116
+- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#9855,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#9856,COL_1839416A_7E82_4851_9843_99CFBF41CD08#9857,COL_30D07025_5684_4705_A04C_1C678E65ED32#9858,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#9859,COL_648D9173_ED6C_4044_8903_158C1196A3E2#9860,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#9861,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#9862,COL_903F51D5_1E51_488D_9761_67785F7AF263#9863,COL_07DE422A_6DBA_4611_A969_1471FD804B90#9864,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#9865,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#9866,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#9867,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#9868,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#9869,COL_898D946E_34EC_4196_88F6_338B6B38B05F#9870,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#9871,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#9872,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#9873,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#9874,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#9875,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#9876,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#9877,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#9878,... 37 more fields] parquet
== Optimized Logical Plan ==
CreateViewCommand `QUALITE_SYNTHES_38022116`, false, true, LocalTempView
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11440, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11441L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11442L, COL_70424811_2DDC_469F_8639_7777D23A61D6#11064 AS COL_70424811_2DDC_469F_8639_7777D23A61D6#11443, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11444L, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#11339 AS COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#11445, COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#11432]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L, COL_70424811_2DDC_469F_8639_7777D23A61D6#11064, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#11339, dec_operator(cast(DIFFERENCE as string), struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L)) AS COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#11432]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L, COL_70424811_2DDC_469F_8639_7777D23A61D6#11064, str_replace_regex(str_concat(struct(col1, dec_to_str(dec_round(dec_operator(cast(PRODUIT as string), struct(col1, dec_operator(cast(DIVISION as string), struct(COL_1AD867EF_74A9_4253_97E3_892B44C7C916, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L, COL_1FD79F2E_4E20_4432_8796_999C6B41C518, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L)), col2, cast(100 as double))), cast(2 as int))), col2, cast(% as string))), cast((?<![0-9])% as string), cast(Pas de traitement as string)) AS COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#11339]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L, str_concat(struct(col1, dec_to_str(dec_round(dec_operator(cast(PRODUIT as string), struct(col1, dec_operator(cast(DIVISION as string), struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1FD79F2E_4E20_4432_8796_999C6B41C518, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L)), col2, cast(100 as double))), cast(2 as int))), col2, cast(% as string))) AS COL_70424811_2DDC_469F_8639_7777D23A61D6#11064]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11034 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11037L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11038L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11039L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11034, coalesce(COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, cast(0 as bigint)) AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11037L, coalesce(COL_CF1B2EC2_6198_4115_B079_F51D532426DB#10996L, cast(0 as bigint)) AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11038L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#10991L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11039L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#10991L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#10996L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10906L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#10991L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10906L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10906L, Avant traitement qualité_NULL_1#10907, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#10837[0] AS Après traitement qualité_NULL_1#10844, __pivot_sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829` AS `sum(``COL_D08E9E92_1F45_417D_929C_3D370D7552B8``) AS ``COL_13D55021_C380_4F34_9553_27DE47738829```#10843[0] AS Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10906L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#10837[1] AS Avant traitement qualité_NULL_1#10907, __pivot_sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829` AS `sum(``COL_D08E9E92_1F45_417D_929C_3D370D7552B8``) AS ``COL_13D55021_C380_4F34_9553_27DE47738829```#10843[1] AS Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L]
+- Aggregate [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L], [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776, 1 AS `NULL_1`#10830, Après traitement qualité, Avant traitement qualité, 0, 0) AS __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#10837, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#10831L, Après traitement qualité, Avant traitement qualité, 0, 0) AS __pivot_sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829` AS `sum(``COL_D08E9E92_1F45_417D_929C_3D370D7552B8``) AS ``COL_13D55021_C380_4F34_9553_27DE47738829```#10843]
+- Aggregate [COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#10814, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776], [COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#10814 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776, 1 AS 1 AS `NULL_1`#10830, sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10769L) AS sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#10831L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10769L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776, str_join(struct(col1, str_transform_case(str_replace_extend(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768, struct(col1, cast( (Init) - Vide ou Null_SUM as string), col2, cast( (Final) - Vide ou Null_SUM as string), col3, cast( (Init) - Vide ou null_SUM as string)), struct(col1, cast( as string), col2, cast( as string), col3, cast( as string))), cast(UPPER as string)), col2, cast(non renseigné as string)), cast( - as string)) AS COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#10814]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10769L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L, str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768)), cast(INIT as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768)), cast(INIT as string)) END, cast(Avant traitement qualité as string), cast(Après traitement qualité as string)) AS COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10761 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10762L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10769L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10763L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10750 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10761, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10754L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10762L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10744L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10763L]
+- Project [COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10744L, COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10750, col1#10746L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10754L]
+- Project [COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10744L, col0#10745 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10750, col1#10746L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10724L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10744L, col0#10745, col1#10746L]
+- Generate stack(18, Adresse_GIE (Init) - Vide ou Null_SUM, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10706L, Code postal_GIE (Final) - Vide ou Null_SUM, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10707L, Code Postal_GIE (Init) - Vide ou Null_SUM, COL_67BC478B_6031_4C57_9DCE_401ABA863959#10708L, Commune_GIE (Init) - Vide ou Null_SUM, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10709L, Entité Juridique_GIE (Init) - Vide ou null_SUM, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10710L, Mail_GIE (Final) - Vide ou Null_SUM, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10711L, mail_GIE (Init) - Vide ou Null_SUM, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10712L, SIREN_GIE (Final) - Vide ou Null_SUM, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10713L, SIREN_GIE (Init) - Vide ou Null_SUM, COL_153C42A2_431C_44DE_92C1_40F644939BB5#10714L, SIRET_GIE (Final) - Vide ou Null_SUM, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10715L, SIRET_GIE (Init) - Vide ou Null_SUM, COL_9968307D_4589_4C17_884D_E5235BA04755#10716L, téléphone_GIE (Final) - Vide ou Null_SUM, ... 13 more fields), false, [col0#10745, col1#10746L]
+- Project [COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10578L AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10706L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10580L AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10707L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#10582L AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#10708L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10584L AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10709L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10586L AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10710L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10588L AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10711L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10590L AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10712L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10592L AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10713L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#10594L AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#10714L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10596L AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10715L, COL_9968307D_4589_4C17_884D_E5235BA04755#10598L AS COL_9968307D_4589_4C17_884D_E5235BA04755#10716L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10600L AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10717L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#10602L AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#10718L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10604L AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10719L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10606L AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10720L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10608L AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10721L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10610L AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10722L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10612L AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10723L, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10576L AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10724L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10576L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10578L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10580L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#10582L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10584L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10586L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10588L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10590L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10592L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#10594L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10596L, COL_9968307D_4589_4C17_884D_E5235BA04755#10598L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10600L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#10602L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10604L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10606L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10608L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10610L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10612L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10576L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10578L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10580L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#10582L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10584L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10586L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10588L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10590L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10592L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#10594L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10596L, COL_9968307D_4589_4C17_884D_E5235BA04755#10598L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10600L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#10602L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10604L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10606L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10608L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10610L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10612L]
+- Aggregate [1 AS NULL_1#10619, first(COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#10528L, true) AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10576L, sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#10509 as bigint)) AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10578L, sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#10514 as bigint)) AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10580L, sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#10515 as bigint)) AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#10582L, sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#10516 as bigint)) AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10584L, sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#10517 as bigint)) AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10586L, sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#10518 as bigint)) AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10588L, sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#10519 as bigint)) AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10590L, sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#10520 as bigint)) AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10592L, sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#10521 as bigint)) AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#10594L, sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#10522 as bigint)) AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10596L, sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#10523 as bigint)) AS COL_9968307D_4589_4C17_884D_E5235BA04755#10598L, sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#10524 as bigint)) AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10600L, sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#10525 as bigint)) AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#10602L, sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#10526 as bigint)) AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10604L, sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#10510 as bigint)) AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10606L, sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#10511 as bigint)) AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10608L, sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#10512 as bigint)) AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10610L, sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#10513 as bigint)) AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10612L]
+- Project [COL_56938DE4_4C31_41D9_801C_C0B0842C509A#10466 AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#10509, COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#10467 AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#10510, COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#10468 AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#10511, COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#10469 AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#10512, COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#10470 AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#10513, COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#10471 AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#10514, COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#10472 AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#10515, COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#10473 AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#10516, COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#10474 AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#10517, COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#10475 AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#10518, COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#10476 AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#10519, COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#10477 AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#10520, COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#10478 AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#10521, COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#10479 AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#10522, COL_3C783429_A484_4DEF_9A90_CFB70F06D809#10480 AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#10523, COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#10481 AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#10524, COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#10482 AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#10525, COL_013B4432_4745_457D_A136_EA9290A58319#10483 AS COL_013B4432_4745_457D_A136_EA9290A58319#10526, COL_925B308B_8FFC_4303_927E_8232D67AA1AB#10465 AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#10527, COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#10484L AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#10528L, COL_7B8D598B_1EE2_466A_A3A3_CBA6A5A3910C#10485]
+- Project [cast(EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#10300 as string) AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#10465, cast(EVALUATION_QUAL_37976_COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#10339 as int) AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#10466, cast(EVALUATION_QUAL_37976_COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#10342 as int) AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#10467, cast(EVALUATION_QUAL_37976_COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#10345 as int) AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#10468, cast(EVALUATION_QUAL_37976_COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#10341 as int) AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#10469, cast(EVALUATION_QUAL_37976_COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#10346 as int) AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#10470, cast(EVALUATION_QUAL_37976_COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#10329 as int) AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#10471, cast(EVALUATION_QUAL_37976_COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#10330 as int) AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#10472, cast(EVALUATION_QUAL_37976_COL_464A280A_485C_42DC_883D_1B8FCCF5258D#10328 as int) AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#10473, cast(EVALUATION_QUAL_37976_COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#10326 as int) AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#10474, cast(EVALUATION_QUAL_37976_COL_45927A2C_7B5E_46F0_B288_4E446278061F#10336 as int) AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#10475, cast(EVALUATION_QUAL_37976_COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#10335 as int) AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#10476, cast(EVALUATION_QUAL_37976_COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#10332 as int) AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#10477, cast(EVALUATION_QUAL_37976_COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#10331 as int) AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#10478, cast(EVALUATION_QUAL_37976_COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#10334 as int) AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#10479, cast(EVALUATION_QUAL_37976_COL_726D968C_42FA_4E31_BD79_225187FD2C06#10333 as int) AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#10480, cast(EVALUATION_QUAL_37976_COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#10337 as int) AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#10481, cast(EVALUATION_QUAL_37976_COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#10338 as int) AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#10482, cast(EVALUATION_QUAL_37976_COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#10327 as int) AS COL_013B4432_4745_457D_A136_EA9290A58319#10483, cast(EVALUATION_QUAL_37976_COL_4C315D79_D322_4165_A505_BACE77D2FFCE#10344L as bigint) AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#10484L, cast(EVALUATION_QUAL_37976_COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#10356 as array<string>) AS COL_7B8D598B_1EE2_466A_A3A3_CBA6A5A3910C#10485]
+- Project [COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#9855 AS EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#10300, COL_BE341768_3194_4DD8_99AF_6C95339F9D93#9856 AS EVALUATION_QUAL_37976_COL_BE341768_3194_4DD8_99AF_6C95339F9D93#10301, COL_1839416A_7E82_4851_9843_99CFBF41CD08#9857 AS EVALUATION_QUAL_37976_COL_1839416A_7E82_4851_9843_99CFBF41CD08#10302, COL_30D07025_5684_4705_A04C_1C678E65ED32#9858 AS EVALUATION_QUAL_37976_COL_30D07025_5684_4705_A04C_1C678E65ED32#10303, COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#9859 AS EVALUATION_QUAL_37976_COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#10304, COL_648D9173_ED6C_4044_8903_158C1196A3E2#9860 AS EVALUATION_QUAL_37976_COL_648D9173_ED6C_4044_8903_158C1196A3E2#10305, COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#9861 AS EVALUATION_QUAL_37976_COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#10306, COL_A5976546_E656_4E43_9B26_F4C3A85BA303#9862 AS EVALUATION_QUAL_37976_COL_A5976546_E656_4E43_9B26_F4C3A85BA303#10307, COL_903F51D5_1E51_488D_9761_67785F7AF263#9863 AS EVALUATION_QUAL_37976_COL_903F51D5_1E51_488D_9761_67785F7AF263#10308, COL_07DE422A_6DBA_4611_A969_1471FD804B90#9864 AS EVALUATION_QUAL_37976_COL_07DE422A_6DBA_4611_A969_1471FD804B90#10309, COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#9865 AS EVALUATION_QUAL_37976_COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#10310, COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#9866 AS EVALUATION_QUAL_37976_COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#10311, COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#9867 AS EVALUATION_QUAL_37976_COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#10312, COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#9868 AS EVALUATION_QUAL_37976_COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#10313, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#9869 AS EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#10314, COL_898D946E_34EC_4196_88F6_338B6B38B05F#9870 AS EVALUATION_QUAL_37976_COL_898D946E_34EC_4196_88F6_338B6B38B05F#10315, COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#9871 AS EVALUATION_QUAL_37976_COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#10316, COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#9872 AS EVALUATION_QUAL_37976_COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#10317, COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#9873 AS EVALUATION_QUAL_37976_COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#10318, COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#9874 AS EVALUATION_QUAL_37976_COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#10319, COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#9875 AS EVALUATION_QUAL_37976_COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#10320, COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#9876 AS EVALUATION_QUAL_37976_COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#10321, COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#9877 AS EVALUATION_QUAL_37976_COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#10322, COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#9878 AS EVALUATION_QUAL_37976_COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#10323, ... 37 more fields]
+- SubqueryAlias EVALUATION_QUAL_37976116
+- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#9855,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#9856,COL_1839416A_7E82_4851_9843_99CFBF41CD08#9857,COL_30D07025_5684_4705_A04C_1C678E65ED32#9858,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#9859,COL_648D9173_ED6C_4044_8903_158C1196A3E2#9860,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#9861,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#9862,COL_903F51D5_1E51_488D_9761_67785F7AF263#9863,COL_07DE422A_6DBA_4611_A969_1471FD804B90#9864,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#9865,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#9866,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#9867,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#9868,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#9869,COL_898D946E_34EC_4196_88F6_338B6B38B05F#9870,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#9871,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#9872,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#9873,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#9874,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#9875,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#9876,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#9877,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#9878,... 37 more fields] parquet
== Physical Plan ==
Execute CreateViewCommand
+- CreateViewCommand `QUALITE_SYNTHES_38022116`, false, true, LocalTempView
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11440, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11441L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11442L, COL_70424811_2DDC_469F_8639_7777D23A61D6#11064 AS COL_70424811_2DDC_469F_8639_7777D23A61D6#11443, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11444L, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#11339 AS COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#11445, COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#11432]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L, COL_70424811_2DDC_469F_8639_7777D23A61D6#11064, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#11339, dec_operator(cast(DIFFERENCE as string), struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L)) AS COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#11432]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L, COL_70424811_2DDC_469F_8639_7777D23A61D6#11064, str_replace_regex(str_concat(struct(col1, dec_to_str(dec_round(dec_operator(cast(PRODUIT as string), struct(col1, dec_operator(cast(DIVISION as string), struct(COL_1AD867EF_74A9_4253_97E3_892B44C7C916, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L, COL_1FD79F2E_4E20_4432_8796_999C6B41C518, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L)), col2, cast(100 as double))), cast(2 as int))), col2, cast(% as string))), cast((?<![0-9])% as string), cast(Pas de traitement as string)) AS COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#11339]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L, str_concat(struct(col1, dec_to_str(dec_round(dec_operator(cast(PRODUIT as string), struct(col1, dec_operator(cast(DIVISION as string), struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1FD79F2E_4E20_4432_8796_999C6B41C518, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L)), col2, cast(100 as double))), cast(2 as int))), col2, cast(% as string))) AS COL_70424811_2DDC_469F_8639_7777D23A61D6#11064]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11034 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11050, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11037L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11051L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11038L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11052L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11039L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11053L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#11034, coalesce(COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, cast(0 as bigint)) AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#11037L, coalesce(COL_CF1B2EC2_6198_4115_B079_F51D532426DB#10996L, cast(0 as bigint)) AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#11038L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#10991L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#11039L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#10991L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#10996L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10906L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#10991L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10906L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10906L, Avant traitement qualité_NULL_1#10907, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#10837[0] AS Après traitement qualité_NULL_1#10844, __pivot_sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829` AS `sum(``COL_D08E9E92_1F45_417D_929C_3D370D7552B8``) AS ``COL_13D55021_C380_4F34_9553_27DE47738829```#10843[0] AS Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10906L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#10837[1] AS Avant traitement qualité_NULL_1#10907, __pivot_sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829` AS `sum(``COL_D08E9E92_1F45_417D_929C_3D370D7552B8``) AS ``COL_13D55021_C380_4F34_9553_27DE47738829```#10843[1] AS Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#10908L]
+- Aggregate [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L], [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776, 1 AS `NULL_1`#10830, Après traitement qualité, Avant traitement qualité, 0, 0) AS __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#10837, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#10831L, Après traitement qualité, Avant traitement qualité, 0, 0) AS __pivot_sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829` AS `sum(``COL_D08E9E92_1F45_417D_929C_3D370D7552B8``) AS ``COL_13D55021_C380_4F34_9553_27DE47738829```#10843]
+- Aggregate [COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#10814, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776], [COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#10814 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#10820, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#10821L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776, 1 AS 1 AS `NULL_1`#10830, sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10769L) AS sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#10831L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10769L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776, str_join(struct(col1, str_transform_case(str_replace_extend(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768, struct(col1, cast( (Init) - Vide ou Null_SUM as string), col2, cast( (Final) - Vide ou Null_SUM as string), col3, cast( (Init) - Vide ou null_SUM as string)), struct(col1, cast( as string), col2, cast( as string), col3, cast( as string))), cast(UPPER as string)), col2, cast(non renseigné as string)), cast( - as string)) AS COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#10814]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10769L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L, str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768)), cast(INIT as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768)), cast(INIT as string)) END, cast(Avant traitement qualité as string), cast(Après traitement qualité as string)) AS COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#10776]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10761 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10768, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10762L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10769L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10763L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10770L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10750 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10761, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10754L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10762L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10744L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10763L]
+- Project [COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10744L, COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10750, col1#10746L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#10754L]
+- Project [COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10744L, col0#10745 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#10750, col1#10746L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10724L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#10744L, col0#10745, col1#10746L]
+- Generate stack(18, Adresse_GIE (Init) - Vide ou Null_SUM, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10706L, Code postal_GIE (Final) - Vide ou Null_SUM, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10707L, Code Postal_GIE (Init) - Vide ou Null_SUM, COL_67BC478B_6031_4C57_9DCE_401ABA863959#10708L, Commune_GIE (Init) - Vide ou Null_SUM, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10709L, Entité Juridique_GIE (Init) - Vide ou null_SUM, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10710L, Mail_GIE (Final) - Vide ou Null_SUM, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10711L, mail_GIE (Init) - Vide ou Null_SUM, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10712L, SIREN_GIE (Final) - Vide ou Null_SUM, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10713L, SIREN_GIE (Init) - Vide ou Null_SUM, COL_153C42A2_431C_44DE_92C1_40F644939BB5#10714L, SIRET_GIE (Final) - Vide ou Null_SUM, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10715L, SIRET_GIE (Init) - Vide ou Null_SUM, COL_9968307D_4589_4C17_884D_E5235BA04755#10716L, téléphone_GIE (Final) - Vide ou Null_SUM, ... 13 more fields), false, [col0#10745, col1#10746L]
+- Project [COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10578L AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10706L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10580L AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10707L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#10582L AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#10708L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10584L AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10709L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10586L AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10710L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10588L AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10711L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10590L AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10712L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10592L AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10713L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#10594L AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#10714L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10596L AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10715L, COL_9968307D_4589_4C17_884D_E5235BA04755#10598L AS COL_9968307D_4589_4C17_884D_E5235BA04755#10716L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10600L AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10717L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#10602L AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#10718L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10604L AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10719L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10606L AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10720L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10608L AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10721L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10610L AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10722L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10612L AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10723L, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10576L AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10724L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10576L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10578L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10580L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#10582L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10584L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10586L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10588L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10590L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10592L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#10594L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10596L, COL_9968307D_4589_4C17_884D_E5235BA04755#10598L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10600L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#10602L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10604L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10606L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10608L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10610L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10612L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10576L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10578L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10580L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#10582L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10584L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10586L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10588L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10590L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10592L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#10594L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10596L, COL_9968307D_4589_4C17_884D_E5235BA04755#10598L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10600L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#10602L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10604L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10606L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10608L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10610L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10612L]
+- Aggregate [1 AS NULL_1#10619, first(COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#10528L, true) AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#10576L, sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#10509 as bigint)) AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#10578L, sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#10514 as bigint)) AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#10580L, sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#10515 as bigint)) AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#10582L, sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#10516 as bigint)) AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#10584L, sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#10517 as bigint)) AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#10586L, sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#10518 as bigint)) AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#10588L, sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#10519 as bigint)) AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#10590L, sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#10520 as bigint)) AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#10592L, sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#10521 as bigint)) AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#10594L, sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#10522 as bigint)) AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#10596L, sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#10523 as bigint)) AS COL_9968307D_4589_4C17_884D_E5235BA04755#10598L, sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#10524 as bigint)) AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#10600L, sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#10525 as bigint)) AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#10602L, sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#10526 as bigint)) AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#10604L, sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#10510 as bigint)) AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#10606L, sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#10511 as bigint)) AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#10608L, sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#10512 as bigint)) AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#10610L, sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#10513 as bigint)) AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#10612L]
+- Project [COL_56938DE4_4C31_41D9_801C_C0B0842C509A#10466 AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#10509, COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#10467 AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#10510, COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#10468 AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#10511, COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#10469 AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#10512, COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#10470 AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#10513, COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#10471 AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#10514, COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#10472 AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#10515, COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#10473 AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#10516, COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#10474 AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#10517, COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#10475 AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#10518, COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#10476 AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#10519, COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#10477 AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#10520, COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#10478 AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#10521, COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#10479 AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#10522, COL_3C783429_A484_4DEF_9A90_CFB70F06D809#10480 AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#10523, COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#10481 AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#10524, COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#10482 AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#10525, COL_013B4432_4745_457D_A136_EA9290A58319#10483 AS COL_013B4432_4745_457D_A136_EA9290A58319#10526, COL_925B308B_8FFC_4303_927E_8232D67AA1AB#10465 AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#10527, COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#10484L AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#10528L, COL_7B8D598B_1EE2_466A_A3A3_CBA6A5A3910C#10485]
+- Project [cast(EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#10300 as string) AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#10465, cast(EVALUATION_QUAL_37976_COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#10339 as int) AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#10466, cast(EVALUATION_QUAL_37976_COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#10342 as int) AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#10467, cast(EVALUATION_QUAL_37976_COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#10345 as int) AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#10468, cast(EVALUATION_QUAL_37976_COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#10341 as int) AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#10469, cast(EVALUATION_QUAL_37976_COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#10346 as int) AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#10470, cast(EVALUATION_QUAL_37976_COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#10329 as int) AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#10471, cast(EVALUATION_QUAL_37976_COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#10330 as int) AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#10472, cast(EVALUATION_QUAL_37976_COL_464A280A_485C_42DC_883D_1B8FCCF5258D#10328 as int) AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#10473, cast(EVALUATION_QUAL_37976_COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#10326 as int) AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#10474, cast(EVALUATION_QUAL_37976_COL_45927A2C_7B5E_46F0_B288_4E446278061F#10336 as int) AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#10475, cast(EVALUATION_QUAL_37976_COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#10335 as int) AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#10476, cast(EVALUATION_QUAL_37976_COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#10332 as int) AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#10477, cast(EVALUATION_QUAL_37976_COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#10331 as int) AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#10478, cast(EVALUATION_QUAL_37976_COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#10334 as int) AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#10479, cast(EVALUATION_QUAL_37976_COL_726D968C_42FA_4E31_BD79_225187FD2C06#10333 as int) AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#10480, cast(EVALUATION_QUAL_37976_COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#10337 as int) AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#10481, cast(EVALUATION_QUAL_37976_COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#10338 as int) AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#10482, cast(EVALUATION_QUAL_37976_COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#10327 as int) AS COL_013B4432_4745_457D_A136_EA9290A58319#10483, cast(EVALUATION_QUAL_37976_COL_4C315D79_D322_4165_A505_BACE77D2FFCE#10344L as bigint) AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#10484L, cast(EVALUATION_QUAL_37976_COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#10356 as array<string>) AS COL_7B8D598B_1EE2_466A_A3A3_CBA6A5A3910C#10485]
+- Project [COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#9855 AS EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#10300, COL_BE341768_3194_4DD8_99AF_6C95339F9D93#9856 AS EVALUATION_QUAL_37976_COL_BE341768_3194_4DD8_99AF_6C95339F9D93#10301, COL_1839416A_7E82_4851_9843_99CFBF41CD08#9857 AS EVALUATION_QUAL_37976_COL_1839416A_7E82_4851_9843_99CFBF41CD08#10302, COL_30D07025_5684_4705_A04C_1C678E65ED32#9858 AS EVALUATION_QUAL_37976_COL_30D07025_5684_4705_A04C_1C678E65ED32#10303, COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#9859 AS EVALUATION_QUAL_37976_COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#10304, COL_648D9173_ED6C_4044_8903_158C1196A3E2#9860 AS EVALUATION_QUAL_37976_COL_648D9173_ED6C_4044_8903_158C1196A3E2#10305, COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#9861 AS EVALUATION_QUAL_37976_COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#10306, COL_A5976546_E656_4E43_9B26_F4C3A85BA303#9862 AS EVALUATION_QUAL_37976_COL_A5976546_E656_4E43_9B26_F4C3A85BA303#10307, COL_903F51D5_1E51_488D_9761_67785F7AF263#9863 AS EVALUATION_QUAL_37976_COL_903F51D5_1E51_488D_9761_67785F7AF263#10308, COL_07DE422A_6DBA_4611_A969_1471FD804B90#9864 AS EVALUATION_QUAL_37976_COL_07DE422A_6DBA_4611_A969_1471FD804B90#10309, COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#9865 AS EVALUATION_QUAL_37976_COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#10310, COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#9866 AS EVALUATION_QUAL_37976_COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#10311, COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#9867 AS EVALUATION_QUAL_37976_COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#10312, COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#9868 AS EVALUATION_QUAL_37976_COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#10313, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#9869 AS EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#10314, COL_898D946E_34EC_4196_88F6_338B6B38B05F#9870 AS EVALUATION_QUAL_37976_COL_898D946E_34EC_4196_88F6_338B6B38B05F#10315, COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#9871 AS EVALUATION_QUAL_37976_COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#10316, COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#9872 AS EVALUATION_QUAL_37976_COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#10317, COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#9873 AS EVALUATION_QUAL_37976_COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#10318, COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#9874 AS EVALUATION_QUAL_37976_COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#10319, COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#9875 AS EVALUATION_QUAL_37976_COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#10320, COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#9876 AS EVALUATION_QUAL_37976_COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#10321, COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#9877 AS EVALUATION_QUAL_37976_COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#10322, COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#9878 AS EVALUATION_QUAL_37976_COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#10323, ... 37 more fields]
+- SubqueryAlias EVALUATION_QUAL_37976116
+- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#9855,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#9856,COL_1839416A_7E82_4851_9843_99CFBF41CD08#9857,COL_30D07025_5684_4705_A04C_1C678E65ED32#9858,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#9859,COL_648D9173_ED6C_4044_8903_158C1196A3E2#9860,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#9861,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#9862,COL_903F51D5_1E51_488D_9761_67785F7AF263#9863,COL_07DE422A_6DBA_4611_A969_1471FD804B90#9864,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#9865,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#9866,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#9867,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#9868,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#9869,COL_898D946E_34EC_4196_88F6_338B6B38B05F#9870,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#9871,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#9872,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#9873,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#9874,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#9875,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#9876,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#9877,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#9878,... 37 more fields] parquet