== Parsed Logical Plan ==
CreateViewCommand `QUALITE_SYNTHES_38022117`, false, true, LocalTempView
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29364, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29365L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29366L, COL_70424811_2DDC_469F_8639_7777D23A61D6#29291 AS COL_70424811_2DDC_469F_8639_7777D23A61D6#29367, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29368L, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#29349 AS COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#29369, COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#29356]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L, COL_70424811_2DDC_469F_8639_7777D23A61D6#29291, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#29349, dec_operator(cast(DIFFERENCE as string), struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L)) AS COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#29356]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L, COL_70424811_2DDC_469F_8639_7777D23A61D6#29291, 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#29286L, COL_1FD79F2E_4E20_4432_8796_999C6B41C518, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L)), 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#29349]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L, 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#29285L, COL_1FD79F2E_4E20_4432_8796_999C6B41C518, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L)), col2, cast(100 as double))), cast(2 as int))), col2, cast(% as string))) AS COL_70424811_2DDC_469F_8639_7777D23A61D6#29291]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29275 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29276L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29277L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29278L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29275, coalesce(COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, cast(0 as bigint)) AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29276L, coalesce(COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29270L, cast(0 as bigint)) AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29277L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29265L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29278L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29265L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29270L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29193L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29265L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29193L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29193L, Avant traitement qualité_NULL_1#29194, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#29185[0] AS Après traitement qualité_NULL_1#29192, __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```#29191[0] AS Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29193L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#29185[1] AS Avant traitement qualité_NULL_1#29194, __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```#29191[1] AS Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L]
+- Aggregate [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L], [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077, 1 AS `NULL_1`#29170, Après traitement qualité, Avant traitement qualité, 0, 0) AS __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#29185, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#29171L, 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```#29191]
+- Aggregate [COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#29114, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077], [COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#29114 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077, 1 AS 1 AS `NULL_1`#29170, sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29056L) AS sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#29171L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29056L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077, str_join(struct(col1, str_transform_case(str_replace_extend(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055, 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#29114]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29056L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L, str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055)), cast(INIT as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055)), 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#29077]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29049 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29050L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29056L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29051L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29038 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29049, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29042L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29050L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#28958L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29051L]
+- Project [COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#28958L, COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29038, col1#28968L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29042L]
+- Project [COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#28958L, col0#28967 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29038, col1#28968L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28850L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#28958L, col0#28967, col1#28968L]
+- Generate stack(18, Adresse_GIE (Init) - Vide ou Null_SUM, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28832L, Code postal_GIE (Final) - Vide ou Null_SUM, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28833L, Code Postal_GIE (Init) - Vide ou Null_SUM, COL_67BC478B_6031_4C57_9DCE_401ABA863959#28834L, Commune_GIE (Init) - Vide ou Null_SUM, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28835L, Entité Juridique_GIE (Init) - Vide ou null_SUM, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28836L, Mail_GIE (Final) - Vide ou Null_SUM, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28837L, mail_GIE (Init) - Vide ou Null_SUM, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28838L, SIREN_GIE (Final) - Vide ou Null_SUM, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28839L, SIREN_GIE (Init) - Vide ou Null_SUM, COL_153C42A2_431C_44DE_92C1_40F644939BB5#28840L, SIRET_GIE (Final) - Vide ou Null_SUM, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28841L, SIRET_GIE (Init) - Vide ou Null_SUM, COL_9968307D_4589_4C17_884D_E5235BA04755#28842L, téléphone_GIE (Final) - Vide ou Null_SUM, ... 13 more fields), false, [col0#28967, col1#28968L]
+- Project [COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28704L AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28832L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28706L AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28833L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#28708L AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#28834L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28710L AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28835L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28712L AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28836L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28714L AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28837L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28716L AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28838L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28718L AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28839L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#28720L AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#28840L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28722L AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28841L, COL_9968307D_4589_4C17_884D_E5235BA04755#28724L AS COL_9968307D_4589_4C17_884D_E5235BA04755#28842L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28726L AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28843L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#28728L AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#28844L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28730L AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28845L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28732L AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28846L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28734L AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28847L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28736L AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28848L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28738L AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28849L, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28702L AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28850L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28702L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28704L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28706L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#28708L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28710L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28712L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28714L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28716L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28718L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#28720L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28722L, COL_9968307D_4589_4C17_884D_E5235BA04755#28724L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28726L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#28728L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28730L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28732L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28734L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28736L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28738L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28702L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28704L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28706L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#28708L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28710L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28712L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28714L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28716L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28718L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#28720L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28722L, COL_9968307D_4589_4C17_884D_E5235BA04755#28724L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28726L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#28728L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28730L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28732L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28734L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28736L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28738L]
+- Aggregate [1 AS NULL_1#28751, first(COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#28646L, true) AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28702L, sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#28627 as bigint)) AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28704L, sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#28632 as bigint)) AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28706L, sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#28633 as bigint)) AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#28708L, sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#28634 as bigint)) AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28710L, sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#28635 as bigint)) AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28712L, sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#28636 as bigint)) AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28714L, sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#28637 as bigint)) AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28716L, sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#28638 as bigint)) AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28718L, sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#28639 as bigint)) AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#28720L, sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#28640 as bigint)) AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28722L, sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#28641 as bigint)) AS COL_9968307D_4589_4C17_884D_E5235BA04755#28724L, sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#28642 as bigint)) AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28726L, sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#28643 as bigint)) AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#28728L, sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#28644 as bigint)) AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28730L, sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#28628 as bigint)) AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28732L, sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#28629 as bigint)) AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28734L, sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#28630 as bigint)) AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28736L, sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#28631 as bigint)) AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28738L]
+- Project [COL_56938DE4_4C31_41D9_801C_C0B0842C509A#28572 AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#28627, COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#28573 AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#28628, COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#28574 AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#28629, COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#28575 AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#28630, COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#28576 AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#28631, COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#28577 AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#28632, COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#28578 AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#28633, COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#28579 AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#28634, COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#28580 AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#28635, COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#28581 AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#28636, COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#28582 AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#28637, COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#28583 AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#28638, COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#28584 AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#28639, COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#28585 AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#28640, COL_3C783429_A484_4DEF_9A90_CFB70F06D809#28586 AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#28641, COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#28587 AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#28642, COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#28588 AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#28643, COL_013B4432_4745_457D_A136_EA9290A58319#28589 AS COL_013B4432_4745_457D_A136_EA9290A58319#28644, COL_925B308B_8FFC_4303_927E_8232D67AA1AB#28571 AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#28645, COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#28590L AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#28646L, COL_7B8D598B_1EE2_466A_A3A3_CBA6A5A3910C#28591]
+- Project [cast(EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#28412 as string) AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#28571, cast(EVALUATION_QUAL_37976_COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#28451 as int) AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#28572, cast(EVALUATION_QUAL_37976_COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#28454 as int) AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#28573, cast(EVALUATION_QUAL_37976_COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#28457 as int) AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#28574, cast(EVALUATION_QUAL_37976_COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#28453 as int) AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#28575, cast(EVALUATION_QUAL_37976_COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#28458 as int) AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#28576, cast(EVALUATION_QUAL_37976_COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#28441 as int) AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#28577, cast(EVALUATION_QUAL_37976_COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#28442 as int) AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#28578, cast(EVALUATION_QUAL_37976_COL_464A280A_485C_42DC_883D_1B8FCCF5258D#28440 as int) AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#28579, cast(EVALUATION_QUAL_37976_COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#28438 as int) AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#28580, cast(EVALUATION_QUAL_37976_COL_45927A2C_7B5E_46F0_B288_4E446278061F#28448 as int) AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#28581, cast(EVALUATION_QUAL_37976_COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#28447 as int) AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#28582, cast(EVALUATION_QUAL_37976_COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#28444 as int) AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#28583, cast(EVALUATION_QUAL_37976_COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#28443 as int) AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#28584, cast(EVALUATION_QUAL_37976_COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#28446 as int) AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#28585, cast(EVALUATION_QUAL_37976_COL_726D968C_42FA_4E31_BD79_225187FD2C06#28445 as int) AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#28586, cast(EVALUATION_QUAL_37976_COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#28449 as int) AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#28587, cast(EVALUATION_QUAL_37976_COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#28450 as int) AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#28588, cast(EVALUATION_QUAL_37976_COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#28439 as int) AS COL_013B4432_4745_457D_A136_EA9290A58319#28589, cast(EVALUATION_QUAL_37976_COL_4C315D79_D322_4165_A505_BACE77D2FFCE#28456L as bigint) AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#28590L, cast(EVALUATION_QUAL_37976_COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#28468 as array<string>) AS COL_7B8D598B_1EE2_466A_A3A3_CBA6A5A3910C#28591]
+- Project [COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#28129 AS EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#28412, COL_BE341768_3194_4DD8_99AF_6C95339F9D93#28130 AS EVALUATION_QUAL_37976_COL_BE341768_3194_4DD8_99AF_6C95339F9D93#28413, COL_1839416A_7E82_4851_9843_99CFBF41CD08#28131 AS EVALUATION_QUAL_37976_COL_1839416A_7E82_4851_9843_99CFBF41CD08#28414, COL_30D07025_5684_4705_A04C_1C678E65ED32#28132 AS EVALUATION_QUAL_37976_COL_30D07025_5684_4705_A04C_1C678E65ED32#28415, COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#28133 AS EVALUATION_QUAL_37976_COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#28416, COL_648D9173_ED6C_4044_8903_158C1196A3E2#28134 AS EVALUATION_QUAL_37976_COL_648D9173_ED6C_4044_8903_158C1196A3E2#28417, COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#28135 AS EVALUATION_QUAL_37976_COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#28418, COL_A5976546_E656_4E43_9B26_F4C3A85BA303#28136 AS EVALUATION_QUAL_37976_COL_A5976546_E656_4E43_9B26_F4C3A85BA303#28419, COL_903F51D5_1E51_488D_9761_67785F7AF263#28137 AS EVALUATION_QUAL_37976_COL_903F51D5_1E51_488D_9761_67785F7AF263#28420, COL_07DE422A_6DBA_4611_A969_1471FD804B90#28138 AS EVALUATION_QUAL_37976_COL_07DE422A_6DBA_4611_A969_1471FD804B90#28421, COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#28139 AS EVALUATION_QUAL_37976_COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#28422, COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#28140 AS EVALUATION_QUAL_37976_COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#28423, COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#28141 AS EVALUATION_QUAL_37976_COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#28424, COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#28142 AS EVALUATION_QUAL_37976_COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#28425, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#28143 AS EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#28426, COL_898D946E_34EC_4196_88F6_338B6B38B05F#28144 AS EVALUATION_QUAL_37976_COL_898D946E_34EC_4196_88F6_338B6B38B05F#28427, COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#28145 AS EVALUATION_QUAL_37976_COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#28428, COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#28146 AS EVALUATION_QUAL_37976_COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#28429, COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#28147 AS EVALUATION_QUAL_37976_COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#28430, COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#28148 AS EVALUATION_QUAL_37976_COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#28431, COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#28149 AS EVALUATION_QUAL_37976_COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#28432, COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#28150 AS EVALUATION_QUAL_37976_COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#28433, COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#28151 AS EVALUATION_QUAL_37976_COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#28434, COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#28152 AS EVALUATION_QUAL_37976_COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#28435, ... 37 more fields]
+- SubqueryAlias EVALUATION_QUAL_37976117
+- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#28129,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#28130,COL_1839416A_7E82_4851_9843_99CFBF41CD08#28131,COL_30D07025_5684_4705_A04C_1C678E65ED32#28132,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#28133,COL_648D9173_ED6C_4044_8903_158C1196A3E2#28134,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#28135,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#28136,COL_903F51D5_1E51_488D_9761_67785F7AF263#28137,COL_07DE422A_6DBA_4611_A969_1471FD804B90#28138,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#28139,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#28140,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#28141,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#28142,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#28143,COL_898D946E_34EC_4196_88F6_338B6B38B05F#28144,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#28145,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#28146,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#28147,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#28148,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#28149,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#28150,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#28151,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#28152,... 37 more fields] parquet
== Analyzed Logical Plan ==
CreateViewCommand `QUALITE_SYNTHES_38022117`, false, true, LocalTempView
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29364, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29365L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29366L, COL_70424811_2DDC_469F_8639_7777D23A61D6#29291 AS COL_70424811_2DDC_469F_8639_7777D23A61D6#29367, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29368L, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#29349 AS COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#29369, COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#29356]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L, COL_70424811_2DDC_469F_8639_7777D23A61D6#29291, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#29349, dec_operator(cast(DIFFERENCE as string), struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L)) AS COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#29356]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L, COL_70424811_2DDC_469F_8639_7777D23A61D6#29291, 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#29286L, COL_1FD79F2E_4E20_4432_8796_999C6B41C518, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L)), 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#29349]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L, 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#29285L, COL_1FD79F2E_4E20_4432_8796_999C6B41C518, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L)), col2, cast(100 as double))), cast(2 as int))), col2, cast(% as string))) AS COL_70424811_2DDC_469F_8639_7777D23A61D6#29291]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29275 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29276L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29277L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29278L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29275, coalesce(COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, cast(0 as bigint)) AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29276L, coalesce(COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29270L, cast(0 as bigint)) AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29277L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29265L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29278L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29265L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29270L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29193L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29265L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29193L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29193L, Avant traitement qualité_NULL_1#29194, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#29185[0] AS Après traitement qualité_NULL_1#29192, __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```#29191[0] AS Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29193L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#29185[1] AS Avant traitement qualité_NULL_1#29194, __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```#29191[1] AS Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L]
+- Aggregate [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L], [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077, 1 AS `NULL_1`#29170, Après traitement qualité, Avant traitement qualité, 0, 0) AS __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#29185, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#29171L, 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```#29191]
+- Aggregate [COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#29114, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077], [COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#29114 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077, 1 AS 1 AS `NULL_1`#29170, sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29056L) AS sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#29171L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29056L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077, str_join(struct(col1, str_transform_case(str_replace_extend(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055, 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#29114]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29056L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L, str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055)), cast(INIT as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055)), 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#29077]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29049 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29050L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29056L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29051L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29038 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29049, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29042L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29050L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#28958L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29051L]
+- Project [COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#28958L, COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29038, col1#28968L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29042L]
+- Project [COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#28958L, col0#28967 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29038, col1#28968L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28850L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#28958L, col0#28967, col1#28968L]
+- Generate stack(18, Adresse_GIE (Init) - Vide ou Null_SUM, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28832L, Code postal_GIE (Final) - Vide ou Null_SUM, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28833L, Code Postal_GIE (Init) - Vide ou Null_SUM, COL_67BC478B_6031_4C57_9DCE_401ABA863959#28834L, Commune_GIE (Init) - Vide ou Null_SUM, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28835L, Entité Juridique_GIE (Init) - Vide ou null_SUM, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28836L, Mail_GIE (Final) - Vide ou Null_SUM, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28837L, mail_GIE (Init) - Vide ou Null_SUM, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28838L, SIREN_GIE (Final) - Vide ou Null_SUM, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28839L, SIREN_GIE (Init) - Vide ou Null_SUM, COL_153C42A2_431C_44DE_92C1_40F644939BB5#28840L, SIRET_GIE (Final) - Vide ou Null_SUM, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28841L, SIRET_GIE (Init) - Vide ou Null_SUM, COL_9968307D_4589_4C17_884D_E5235BA04755#28842L, téléphone_GIE (Final) - Vide ou Null_SUM, ... 13 more fields), false, [col0#28967, col1#28968L]
+- Project [COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28704L AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28832L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28706L AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28833L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#28708L AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#28834L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28710L AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28835L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28712L AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28836L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28714L AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28837L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28716L AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28838L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28718L AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28839L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#28720L AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#28840L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28722L AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28841L, COL_9968307D_4589_4C17_884D_E5235BA04755#28724L AS COL_9968307D_4589_4C17_884D_E5235BA04755#28842L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28726L AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28843L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#28728L AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#28844L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28730L AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28845L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28732L AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28846L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28734L AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28847L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28736L AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28848L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28738L AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28849L, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28702L AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28850L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28702L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28704L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28706L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#28708L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28710L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28712L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28714L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28716L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28718L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#28720L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28722L, COL_9968307D_4589_4C17_884D_E5235BA04755#28724L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28726L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#28728L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28730L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28732L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28734L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28736L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28738L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28702L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28704L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28706L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#28708L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28710L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28712L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28714L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28716L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28718L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#28720L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28722L, COL_9968307D_4589_4C17_884D_E5235BA04755#28724L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28726L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#28728L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28730L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28732L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28734L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28736L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28738L]
+- Aggregate [1 AS NULL_1#28751, first(COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#28646L, true) AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28702L, sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#28627 as bigint)) AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28704L, sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#28632 as bigint)) AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28706L, sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#28633 as bigint)) AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#28708L, sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#28634 as bigint)) AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28710L, sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#28635 as bigint)) AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28712L, sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#28636 as bigint)) AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28714L, sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#28637 as bigint)) AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28716L, sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#28638 as bigint)) AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28718L, sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#28639 as bigint)) AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#28720L, sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#28640 as bigint)) AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28722L, sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#28641 as bigint)) AS COL_9968307D_4589_4C17_884D_E5235BA04755#28724L, sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#28642 as bigint)) AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28726L, sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#28643 as bigint)) AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#28728L, sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#28644 as bigint)) AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28730L, sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#28628 as bigint)) AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28732L, sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#28629 as bigint)) AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28734L, sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#28630 as bigint)) AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28736L, sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#28631 as bigint)) AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28738L]
+- Project [COL_56938DE4_4C31_41D9_801C_C0B0842C509A#28572 AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#28627, COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#28573 AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#28628, COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#28574 AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#28629, COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#28575 AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#28630, COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#28576 AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#28631, COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#28577 AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#28632, COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#28578 AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#28633, COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#28579 AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#28634, COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#28580 AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#28635, COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#28581 AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#28636, COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#28582 AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#28637, COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#28583 AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#28638, COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#28584 AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#28639, COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#28585 AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#28640, COL_3C783429_A484_4DEF_9A90_CFB70F06D809#28586 AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#28641, COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#28587 AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#28642, COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#28588 AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#28643, COL_013B4432_4745_457D_A136_EA9290A58319#28589 AS COL_013B4432_4745_457D_A136_EA9290A58319#28644, COL_925B308B_8FFC_4303_927E_8232D67AA1AB#28571 AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#28645, COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#28590L AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#28646L, COL_7B8D598B_1EE2_466A_A3A3_CBA6A5A3910C#28591]
+- Project [cast(EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#28412 as string) AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#28571, cast(EVALUATION_QUAL_37976_COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#28451 as int) AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#28572, cast(EVALUATION_QUAL_37976_COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#28454 as int) AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#28573, cast(EVALUATION_QUAL_37976_COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#28457 as int) AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#28574, cast(EVALUATION_QUAL_37976_COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#28453 as int) AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#28575, cast(EVALUATION_QUAL_37976_COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#28458 as int) AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#28576, cast(EVALUATION_QUAL_37976_COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#28441 as int) AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#28577, cast(EVALUATION_QUAL_37976_COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#28442 as int) AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#28578, cast(EVALUATION_QUAL_37976_COL_464A280A_485C_42DC_883D_1B8FCCF5258D#28440 as int) AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#28579, cast(EVALUATION_QUAL_37976_COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#28438 as int) AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#28580, cast(EVALUATION_QUAL_37976_COL_45927A2C_7B5E_46F0_B288_4E446278061F#28448 as int) AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#28581, cast(EVALUATION_QUAL_37976_COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#28447 as int) AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#28582, cast(EVALUATION_QUAL_37976_COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#28444 as int) AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#28583, cast(EVALUATION_QUAL_37976_COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#28443 as int) AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#28584, cast(EVALUATION_QUAL_37976_COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#28446 as int) AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#28585, cast(EVALUATION_QUAL_37976_COL_726D968C_42FA_4E31_BD79_225187FD2C06#28445 as int) AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#28586, cast(EVALUATION_QUAL_37976_COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#28449 as int) AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#28587, cast(EVALUATION_QUAL_37976_COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#28450 as int) AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#28588, cast(EVALUATION_QUAL_37976_COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#28439 as int) AS COL_013B4432_4745_457D_A136_EA9290A58319#28589, cast(EVALUATION_QUAL_37976_COL_4C315D79_D322_4165_A505_BACE77D2FFCE#28456L as bigint) AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#28590L, cast(EVALUATION_QUAL_37976_COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#28468 as array<string>) AS COL_7B8D598B_1EE2_466A_A3A3_CBA6A5A3910C#28591]
+- Project [COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#28129 AS EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#28412, COL_BE341768_3194_4DD8_99AF_6C95339F9D93#28130 AS EVALUATION_QUAL_37976_COL_BE341768_3194_4DD8_99AF_6C95339F9D93#28413, COL_1839416A_7E82_4851_9843_99CFBF41CD08#28131 AS EVALUATION_QUAL_37976_COL_1839416A_7E82_4851_9843_99CFBF41CD08#28414, COL_30D07025_5684_4705_A04C_1C678E65ED32#28132 AS EVALUATION_QUAL_37976_COL_30D07025_5684_4705_A04C_1C678E65ED32#28415, COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#28133 AS EVALUATION_QUAL_37976_COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#28416, COL_648D9173_ED6C_4044_8903_158C1196A3E2#28134 AS EVALUATION_QUAL_37976_COL_648D9173_ED6C_4044_8903_158C1196A3E2#28417, COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#28135 AS EVALUATION_QUAL_37976_COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#28418, COL_A5976546_E656_4E43_9B26_F4C3A85BA303#28136 AS EVALUATION_QUAL_37976_COL_A5976546_E656_4E43_9B26_F4C3A85BA303#28419, COL_903F51D5_1E51_488D_9761_67785F7AF263#28137 AS EVALUATION_QUAL_37976_COL_903F51D5_1E51_488D_9761_67785F7AF263#28420, COL_07DE422A_6DBA_4611_A969_1471FD804B90#28138 AS EVALUATION_QUAL_37976_COL_07DE422A_6DBA_4611_A969_1471FD804B90#28421, COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#28139 AS EVALUATION_QUAL_37976_COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#28422, COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#28140 AS EVALUATION_QUAL_37976_COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#28423, COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#28141 AS EVALUATION_QUAL_37976_COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#28424, COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#28142 AS EVALUATION_QUAL_37976_COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#28425, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#28143 AS EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#28426, COL_898D946E_34EC_4196_88F6_338B6B38B05F#28144 AS EVALUATION_QUAL_37976_COL_898D946E_34EC_4196_88F6_338B6B38B05F#28427, COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#28145 AS EVALUATION_QUAL_37976_COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#28428, COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#28146 AS EVALUATION_QUAL_37976_COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#28429, COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#28147 AS EVALUATION_QUAL_37976_COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#28430, COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#28148 AS EVALUATION_QUAL_37976_COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#28431, COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#28149 AS EVALUATION_QUAL_37976_COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#28432, COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#28150 AS EVALUATION_QUAL_37976_COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#28433, COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#28151 AS EVALUATION_QUAL_37976_COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#28434, COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#28152 AS EVALUATION_QUAL_37976_COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#28435, ... 37 more fields]
+- SubqueryAlias EVALUATION_QUAL_37976117
+- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#28129,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#28130,COL_1839416A_7E82_4851_9843_99CFBF41CD08#28131,COL_30D07025_5684_4705_A04C_1C678E65ED32#28132,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#28133,COL_648D9173_ED6C_4044_8903_158C1196A3E2#28134,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#28135,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#28136,COL_903F51D5_1E51_488D_9761_67785F7AF263#28137,COL_07DE422A_6DBA_4611_A969_1471FD804B90#28138,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#28139,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#28140,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#28141,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#28142,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#28143,COL_898D946E_34EC_4196_88F6_338B6B38B05F#28144,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#28145,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#28146,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#28147,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#28148,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#28149,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#28150,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#28151,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#28152,... 37 more fields] parquet
== Optimized Logical Plan ==
CreateViewCommand `QUALITE_SYNTHES_38022117`, false, true, LocalTempView
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29364, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29365L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29366L, COL_70424811_2DDC_469F_8639_7777D23A61D6#29291 AS COL_70424811_2DDC_469F_8639_7777D23A61D6#29367, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29368L, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#29349 AS COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#29369, COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#29356]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L, COL_70424811_2DDC_469F_8639_7777D23A61D6#29291, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#29349, dec_operator(cast(DIFFERENCE as string), struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L)) AS COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#29356]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L, COL_70424811_2DDC_469F_8639_7777D23A61D6#29291, 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#29286L, COL_1FD79F2E_4E20_4432_8796_999C6B41C518, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L)), 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#29349]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L, 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#29285L, COL_1FD79F2E_4E20_4432_8796_999C6B41C518, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L)), col2, cast(100 as double))), cast(2 as int))), col2, cast(% as string))) AS COL_70424811_2DDC_469F_8639_7777D23A61D6#29291]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29275 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29276L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29277L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29278L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29275, coalesce(COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, cast(0 as bigint)) AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29276L, coalesce(COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29270L, cast(0 as bigint)) AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29277L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29265L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29278L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29265L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29270L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29193L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29265L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29193L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29193L, Avant traitement qualité_NULL_1#29194, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#29185[0] AS Après traitement qualité_NULL_1#29192, __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```#29191[0] AS Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29193L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#29185[1] AS Avant traitement qualité_NULL_1#29194, __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```#29191[1] AS Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L]
+- Aggregate [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L], [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077, 1 AS `NULL_1`#29170, Après traitement qualité, Avant traitement qualité, 0, 0) AS __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#29185, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#29171L, 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```#29191]
+- Aggregate [COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#29114, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077], [COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#29114 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077, 1 AS 1 AS `NULL_1`#29170, sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29056L) AS sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#29171L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29056L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077, str_join(struct(col1, str_transform_case(str_replace_extend(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055, 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#29114]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29056L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L, str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055)), cast(INIT as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055)), 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#29077]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29049 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29050L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29056L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29051L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29038 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29049, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29042L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29050L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#28958L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29051L]
+- Project [COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#28958L, COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29038, col1#28968L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29042L]
+- Project [COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#28958L, col0#28967 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29038, col1#28968L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28850L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#28958L, col0#28967, col1#28968L]
+- Generate stack(18, Adresse_GIE (Init) - Vide ou Null_SUM, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28832L, Code postal_GIE (Final) - Vide ou Null_SUM, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28833L, Code Postal_GIE (Init) - Vide ou Null_SUM, COL_67BC478B_6031_4C57_9DCE_401ABA863959#28834L, Commune_GIE (Init) - Vide ou Null_SUM, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28835L, Entité Juridique_GIE (Init) - Vide ou null_SUM, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28836L, Mail_GIE (Final) - Vide ou Null_SUM, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28837L, mail_GIE (Init) - Vide ou Null_SUM, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28838L, SIREN_GIE (Final) - Vide ou Null_SUM, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28839L, SIREN_GIE (Init) - Vide ou Null_SUM, COL_153C42A2_431C_44DE_92C1_40F644939BB5#28840L, SIRET_GIE (Final) - Vide ou Null_SUM, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28841L, SIRET_GIE (Init) - Vide ou Null_SUM, COL_9968307D_4589_4C17_884D_E5235BA04755#28842L, téléphone_GIE (Final) - Vide ou Null_SUM, ... 13 more fields), false, [col0#28967, col1#28968L]
+- Project [COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28704L AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28832L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28706L AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28833L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#28708L AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#28834L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28710L AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28835L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28712L AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28836L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28714L AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28837L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28716L AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28838L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28718L AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28839L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#28720L AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#28840L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28722L AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28841L, COL_9968307D_4589_4C17_884D_E5235BA04755#28724L AS COL_9968307D_4589_4C17_884D_E5235BA04755#28842L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28726L AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28843L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#28728L AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#28844L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28730L AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28845L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28732L AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28846L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28734L AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28847L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28736L AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28848L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28738L AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28849L, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28702L AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28850L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28702L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28704L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28706L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#28708L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28710L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28712L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28714L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28716L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28718L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#28720L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28722L, COL_9968307D_4589_4C17_884D_E5235BA04755#28724L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28726L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#28728L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28730L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28732L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28734L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28736L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28738L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28702L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28704L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28706L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#28708L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28710L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28712L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28714L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28716L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28718L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#28720L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28722L, COL_9968307D_4589_4C17_884D_E5235BA04755#28724L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28726L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#28728L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28730L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28732L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28734L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28736L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28738L]
+- Aggregate [1 AS NULL_1#28751, first(COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#28646L, true) AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28702L, sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#28627 as bigint)) AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28704L, sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#28632 as bigint)) AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28706L, sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#28633 as bigint)) AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#28708L, sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#28634 as bigint)) AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28710L, sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#28635 as bigint)) AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28712L, sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#28636 as bigint)) AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28714L, sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#28637 as bigint)) AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28716L, sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#28638 as bigint)) AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28718L, sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#28639 as bigint)) AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#28720L, sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#28640 as bigint)) AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28722L, sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#28641 as bigint)) AS COL_9968307D_4589_4C17_884D_E5235BA04755#28724L, sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#28642 as bigint)) AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28726L, sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#28643 as bigint)) AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#28728L, sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#28644 as bigint)) AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28730L, sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#28628 as bigint)) AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28732L, sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#28629 as bigint)) AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28734L, sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#28630 as bigint)) AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28736L, sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#28631 as bigint)) AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28738L]
+- Project [COL_56938DE4_4C31_41D9_801C_C0B0842C509A#28572 AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#28627, COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#28573 AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#28628, COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#28574 AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#28629, COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#28575 AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#28630, COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#28576 AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#28631, COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#28577 AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#28632, COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#28578 AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#28633, COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#28579 AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#28634, COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#28580 AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#28635, COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#28581 AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#28636, COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#28582 AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#28637, COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#28583 AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#28638, COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#28584 AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#28639, COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#28585 AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#28640, COL_3C783429_A484_4DEF_9A90_CFB70F06D809#28586 AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#28641, COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#28587 AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#28642, COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#28588 AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#28643, COL_013B4432_4745_457D_A136_EA9290A58319#28589 AS COL_013B4432_4745_457D_A136_EA9290A58319#28644, COL_925B308B_8FFC_4303_927E_8232D67AA1AB#28571 AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#28645, COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#28590L AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#28646L, COL_7B8D598B_1EE2_466A_A3A3_CBA6A5A3910C#28591]
+- Project [cast(EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#28412 as string) AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#28571, cast(EVALUATION_QUAL_37976_COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#28451 as int) AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#28572, cast(EVALUATION_QUAL_37976_COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#28454 as int) AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#28573, cast(EVALUATION_QUAL_37976_COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#28457 as int) AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#28574, cast(EVALUATION_QUAL_37976_COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#28453 as int) AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#28575, cast(EVALUATION_QUAL_37976_COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#28458 as int) AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#28576, cast(EVALUATION_QUAL_37976_COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#28441 as int) AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#28577, cast(EVALUATION_QUAL_37976_COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#28442 as int) AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#28578, cast(EVALUATION_QUAL_37976_COL_464A280A_485C_42DC_883D_1B8FCCF5258D#28440 as int) AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#28579, cast(EVALUATION_QUAL_37976_COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#28438 as int) AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#28580, cast(EVALUATION_QUAL_37976_COL_45927A2C_7B5E_46F0_B288_4E446278061F#28448 as int) AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#28581, cast(EVALUATION_QUAL_37976_COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#28447 as int) AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#28582, cast(EVALUATION_QUAL_37976_COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#28444 as int) AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#28583, cast(EVALUATION_QUAL_37976_COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#28443 as int) AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#28584, cast(EVALUATION_QUAL_37976_COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#28446 as int) AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#28585, cast(EVALUATION_QUAL_37976_COL_726D968C_42FA_4E31_BD79_225187FD2C06#28445 as int) AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#28586, cast(EVALUATION_QUAL_37976_COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#28449 as int) AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#28587, cast(EVALUATION_QUAL_37976_COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#28450 as int) AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#28588, cast(EVALUATION_QUAL_37976_COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#28439 as int) AS COL_013B4432_4745_457D_A136_EA9290A58319#28589, cast(EVALUATION_QUAL_37976_COL_4C315D79_D322_4165_A505_BACE77D2FFCE#28456L as bigint) AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#28590L, cast(EVALUATION_QUAL_37976_COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#28468 as array<string>) AS COL_7B8D598B_1EE2_466A_A3A3_CBA6A5A3910C#28591]
+- Project [COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#28129 AS EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#28412, COL_BE341768_3194_4DD8_99AF_6C95339F9D93#28130 AS EVALUATION_QUAL_37976_COL_BE341768_3194_4DD8_99AF_6C95339F9D93#28413, COL_1839416A_7E82_4851_9843_99CFBF41CD08#28131 AS EVALUATION_QUAL_37976_COL_1839416A_7E82_4851_9843_99CFBF41CD08#28414, COL_30D07025_5684_4705_A04C_1C678E65ED32#28132 AS EVALUATION_QUAL_37976_COL_30D07025_5684_4705_A04C_1C678E65ED32#28415, COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#28133 AS EVALUATION_QUAL_37976_COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#28416, COL_648D9173_ED6C_4044_8903_158C1196A3E2#28134 AS EVALUATION_QUAL_37976_COL_648D9173_ED6C_4044_8903_158C1196A3E2#28417, COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#28135 AS EVALUATION_QUAL_37976_COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#28418, COL_A5976546_E656_4E43_9B26_F4C3A85BA303#28136 AS EVALUATION_QUAL_37976_COL_A5976546_E656_4E43_9B26_F4C3A85BA303#28419, COL_903F51D5_1E51_488D_9761_67785F7AF263#28137 AS EVALUATION_QUAL_37976_COL_903F51D5_1E51_488D_9761_67785F7AF263#28420, COL_07DE422A_6DBA_4611_A969_1471FD804B90#28138 AS EVALUATION_QUAL_37976_COL_07DE422A_6DBA_4611_A969_1471FD804B90#28421, COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#28139 AS EVALUATION_QUAL_37976_COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#28422, COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#28140 AS EVALUATION_QUAL_37976_COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#28423, COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#28141 AS EVALUATION_QUAL_37976_COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#28424, COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#28142 AS EVALUATION_QUAL_37976_COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#28425, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#28143 AS EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#28426, COL_898D946E_34EC_4196_88F6_338B6B38B05F#28144 AS EVALUATION_QUAL_37976_COL_898D946E_34EC_4196_88F6_338B6B38B05F#28427, COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#28145 AS EVALUATION_QUAL_37976_COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#28428, COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#28146 AS EVALUATION_QUAL_37976_COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#28429, COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#28147 AS EVALUATION_QUAL_37976_COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#28430, COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#28148 AS EVALUATION_QUAL_37976_COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#28431, COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#28149 AS EVALUATION_QUAL_37976_COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#28432, COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#28150 AS EVALUATION_QUAL_37976_COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#28433, COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#28151 AS EVALUATION_QUAL_37976_COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#28434, COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#28152 AS EVALUATION_QUAL_37976_COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#28435, ... 37 more fields]
+- SubqueryAlias EVALUATION_QUAL_37976117
+- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#28129,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#28130,COL_1839416A_7E82_4851_9843_99CFBF41CD08#28131,COL_30D07025_5684_4705_A04C_1C678E65ED32#28132,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#28133,COL_648D9173_ED6C_4044_8903_158C1196A3E2#28134,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#28135,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#28136,COL_903F51D5_1E51_488D_9761_67785F7AF263#28137,COL_07DE422A_6DBA_4611_A969_1471FD804B90#28138,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#28139,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#28140,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#28141,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#28142,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#28143,COL_898D946E_34EC_4196_88F6_338B6B38B05F#28144,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#28145,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#28146,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#28147,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#28148,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#28149,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#28150,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#28151,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#28152,... 37 more fields] parquet
== Physical Plan ==
Execute CreateViewCommand
+- CreateViewCommand `QUALITE_SYNTHES_38022117`, false, true, LocalTempView
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29364, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29365L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29366L, COL_70424811_2DDC_469F_8639_7777D23A61D6#29291 AS COL_70424811_2DDC_469F_8639_7777D23A61D6#29367, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29368L, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#29349 AS COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#29369, COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#29356]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L, COL_70424811_2DDC_469F_8639_7777D23A61D6#29291, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#29349, dec_operator(cast(DIFFERENCE as string), struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L)) AS COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#29356]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L, COL_70424811_2DDC_469F_8639_7777D23A61D6#29291, 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#29286L, COL_1FD79F2E_4E20_4432_8796_999C6B41C518, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L)), 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#29349]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L, 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#29285L, COL_1FD79F2E_4E20_4432_8796_999C6B41C518, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L)), col2, cast(100 as double))), cast(2 as int))), col2, cast(% as string))) AS COL_70424811_2DDC_469F_8639_7777D23A61D6#29291]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29275 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29283, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29276L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29284L, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29277L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29285L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29278L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29286L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29275, coalesce(COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, cast(0 as bigint)) AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29276L, coalesce(COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29270L, cast(0 as bigint)) AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29277L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29265L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29278L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29265L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#29270L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29193L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#29265L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29193L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29193L, Avant traitement qualité_NULL_1#29194, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#29185[0] AS Après traitement qualité_NULL_1#29192, __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```#29191[0] AS Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29193L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#29185[1] AS Avant traitement qualité_NULL_1#29194, __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```#29191[1] AS Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#29195L]
+- Aggregate [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L], [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077, 1 AS `NULL_1`#29170, Après traitement qualité, Avant traitement qualité, 0, 0) AS __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#29185, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#29171L, 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```#29191]
+- Aggregate [COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#29114, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077], [COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#29114 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#29160, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L AS COL_1FD79F2E_4E20_4432_8796_999C6B41C518#29161L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077, 1 AS 1 AS `NULL_1`#29170, sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29056L) AS sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#29171L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29056L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#29077, str_join(struct(col1, str_transform_case(str_replace_extend(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055, 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#29114]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29056L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L, str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055)), cast(INIT as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055)), 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#29077]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29049 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29055, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29050L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29056L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29051L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29057L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29038 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29049, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29042L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29050L, COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#28958L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#29051L]
+- Project [COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#28958L, COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29038, col1#28968L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#29042L]
+- Project [COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#28958L, col0#28967 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#29038, col1#28968L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28850L AS COL_E9ED5F5E_DF3A_46FA_AB38_DCEBCD57C67F#28958L, col0#28967, col1#28968L]
+- Generate stack(18, Adresse_GIE (Init) - Vide ou Null_SUM, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28832L, Code postal_GIE (Final) - Vide ou Null_SUM, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28833L, Code Postal_GIE (Init) - Vide ou Null_SUM, COL_67BC478B_6031_4C57_9DCE_401ABA863959#28834L, Commune_GIE (Init) - Vide ou Null_SUM, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28835L, Entité Juridique_GIE (Init) - Vide ou null_SUM, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28836L, Mail_GIE (Final) - Vide ou Null_SUM, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28837L, mail_GIE (Init) - Vide ou Null_SUM, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28838L, SIREN_GIE (Final) - Vide ou Null_SUM, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28839L, SIREN_GIE (Init) - Vide ou Null_SUM, COL_153C42A2_431C_44DE_92C1_40F644939BB5#28840L, SIRET_GIE (Final) - Vide ou Null_SUM, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28841L, SIRET_GIE (Init) - Vide ou Null_SUM, COL_9968307D_4589_4C17_884D_E5235BA04755#28842L, téléphone_GIE (Final) - Vide ou Null_SUM, ... 13 more fields), false, [col0#28967, col1#28968L]
+- Project [COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28704L AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28832L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28706L AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28833L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#28708L AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#28834L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28710L AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28835L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28712L AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28836L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28714L AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28837L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28716L AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28838L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28718L AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28839L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#28720L AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#28840L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28722L AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28841L, COL_9968307D_4589_4C17_884D_E5235BA04755#28724L AS COL_9968307D_4589_4C17_884D_E5235BA04755#28842L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28726L AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28843L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#28728L AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#28844L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28730L AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28845L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28732L AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28846L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28734L AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28847L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28736L AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28848L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28738L AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28849L, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28702L AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28850L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28702L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28704L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28706L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#28708L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28710L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28712L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28714L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28716L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28718L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#28720L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28722L, COL_9968307D_4589_4C17_884D_E5235BA04755#28724L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28726L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#28728L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28730L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28732L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28734L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28736L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28738L]
+- Project [COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28702L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28704L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28706L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#28708L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28710L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28712L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28714L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28716L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28718L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#28720L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28722L, COL_9968307D_4589_4C17_884D_E5235BA04755#28724L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28726L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#28728L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28730L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28732L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28734L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28736L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28738L]
+- Aggregate [1 AS NULL_1#28751, first(COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#28646L, true) AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#28702L, sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#28627 as bigint)) AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#28704L, sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#28632 as bigint)) AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#28706L, sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#28633 as bigint)) AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#28708L, sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#28634 as bigint)) AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#28710L, sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#28635 as bigint)) AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#28712L, sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#28636 as bigint)) AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#28714L, sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#28637 as bigint)) AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#28716L, sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#28638 as bigint)) AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#28718L, sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#28639 as bigint)) AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#28720L, sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#28640 as bigint)) AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#28722L, sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#28641 as bigint)) AS COL_9968307D_4589_4C17_884D_E5235BA04755#28724L, sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#28642 as bigint)) AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#28726L, sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#28643 as bigint)) AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#28728L, sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#28644 as bigint)) AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#28730L, sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#28628 as bigint)) AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#28732L, sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#28629 as bigint)) AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#28734L, sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#28630 as bigint)) AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#28736L, sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#28631 as bigint)) AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#28738L]
+- Project [COL_56938DE4_4C31_41D9_801C_C0B0842C509A#28572 AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#28627, COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#28573 AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#28628, COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#28574 AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#28629, COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#28575 AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#28630, COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#28576 AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#28631, COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#28577 AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#28632, COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#28578 AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#28633, COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#28579 AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#28634, COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#28580 AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#28635, COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#28581 AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#28636, COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#28582 AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#28637, COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#28583 AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#28638, COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#28584 AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#28639, COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#28585 AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#28640, COL_3C783429_A484_4DEF_9A90_CFB70F06D809#28586 AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#28641, COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#28587 AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#28642, COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#28588 AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#28643, COL_013B4432_4745_457D_A136_EA9290A58319#28589 AS COL_013B4432_4745_457D_A136_EA9290A58319#28644, COL_925B308B_8FFC_4303_927E_8232D67AA1AB#28571 AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#28645, COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#28590L AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#28646L, COL_7B8D598B_1EE2_466A_A3A3_CBA6A5A3910C#28591]
+- Project [cast(EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#28412 as string) AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#28571, cast(EVALUATION_QUAL_37976_COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#28451 as int) AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#28572, cast(EVALUATION_QUAL_37976_COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#28454 as int) AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#28573, cast(EVALUATION_QUAL_37976_COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#28457 as int) AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#28574, cast(EVALUATION_QUAL_37976_COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#28453 as int) AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#28575, cast(EVALUATION_QUAL_37976_COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#28458 as int) AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#28576, cast(EVALUATION_QUAL_37976_COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#28441 as int) AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#28577, cast(EVALUATION_QUAL_37976_COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#28442 as int) AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#28578, cast(EVALUATION_QUAL_37976_COL_464A280A_485C_42DC_883D_1B8FCCF5258D#28440 as int) AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#28579, cast(EVALUATION_QUAL_37976_COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#28438 as int) AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#28580, cast(EVALUATION_QUAL_37976_COL_45927A2C_7B5E_46F0_B288_4E446278061F#28448 as int) AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#28581, cast(EVALUATION_QUAL_37976_COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#28447 as int) AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#28582, cast(EVALUATION_QUAL_37976_COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#28444 as int) AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#28583, cast(EVALUATION_QUAL_37976_COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#28443 as int) AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#28584, cast(EVALUATION_QUAL_37976_COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#28446 as int) AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#28585, cast(EVALUATION_QUAL_37976_COL_726D968C_42FA_4E31_BD79_225187FD2C06#28445 as int) AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#28586, cast(EVALUATION_QUAL_37976_COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#28449 as int) AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#28587, cast(EVALUATION_QUAL_37976_COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#28450 as int) AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#28588, cast(EVALUATION_QUAL_37976_COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#28439 as int) AS COL_013B4432_4745_457D_A136_EA9290A58319#28589, cast(EVALUATION_QUAL_37976_COL_4C315D79_D322_4165_A505_BACE77D2FFCE#28456L as bigint) AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#28590L, cast(EVALUATION_QUAL_37976_COL_EEE9A71F_02BD_41C8_850A_D39BA6231369#28468 as array<string>) AS COL_7B8D598B_1EE2_466A_A3A3_CBA6A5A3910C#28591]
+- Project [COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#28129 AS EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#28412, COL_BE341768_3194_4DD8_99AF_6C95339F9D93#28130 AS EVALUATION_QUAL_37976_COL_BE341768_3194_4DD8_99AF_6C95339F9D93#28413, COL_1839416A_7E82_4851_9843_99CFBF41CD08#28131 AS EVALUATION_QUAL_37976_COL_1839416A_7E82_4851_9843_99CFBF41CD08#28414, COL_30D07025_5684_4705_A04C_1C678E65ED32#28132 AS EVALUATION_QUAL_37976_COL_30D07025_5684_4705_A04C_1C678E65ED32#28415, COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#28133 AS EVALUATION_QUAL_37976_COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#28416, COL_648D9173_ED6C_4044_8903_158C1196A3E2#28134 AS EVALUATION_QUAL_37976_COL_648D9173_ED6C_4044_8903_158C1196A3E2#28417, COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#28135 AS EVALUATION_QUAL_37976_COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#28418, COL_A5976546_E656_4E43_9B26_F4C3A85BA303#28136 AS EVALUATION_QUAL_37976_COL_A5976546_E656_4E43_9B26_F4C3A85BA303#28419, COL_903F51D5_1E51_488D_9761_67785F7AF263#28137 AS EVALUATION_QUAL_37976_COL_903F51D5_1E51_488D_9761_67785F7AF263#28420, COL_07DE422A_6DBA_4611_A969_1471FD804B90#28138 AS EVALUATION_QUAL_37976_COL_07DE422A_6DBA_4611_A969_1471FD804B90#28421, COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#28139 AS EVALUATION_QUAL_37976_COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#28422, COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#28140 AS EVALUATION_QUAL_37976_COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#28423, COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#28141 AS EVALUATION_QUAL_37976_COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#28424, COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#28142 AS EVALUATION_QUAL_37976_COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#28425, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#28143 AS EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#28426, COL_898D946E_34EC_4196_88F6_338B6B38B05F#28144 AS EVALUATION_QUAL_37976_COL_898D946E_34EC_4196_88F6_338B6B38B05F#28427, COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#28145 AS EVALUATION_QUAL_37976_COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#28428, COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#28146 AS EVALUATION_QUAL_37976_COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#28429, COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#28147 AS EVALUATION_QUAL_37976_COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#28430, COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#28148 AS EVALUATION_QUAL_37976_COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#28431, COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#28149 AS EVALUATION_QUAL_37976_COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#28432, COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#28150 AS EVALUATION_QUAL_37976_COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#28433, COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#28151 AS EVALUATION_QUAL_37976_COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#28434, COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#28152 AS EVALUATION_QUAL_37976_COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#28435, ... 37 more fields]
+- SubqueryAlias EVALUATION_QUAL_37976117
+- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#28129,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#28130,COL_1839416A_7E82_4851_9843_99CFBF41CD08#28131,COL_30D07025_5684_4705_A04C_1C678E65ED32#28132,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#28133,COL_648D9173_ED6C_4044_8903_158C1196A3E2#28134,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#28135,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#28136,COL_903F51D5_1E51_488D_9761_67785F7AF263#28137,COL_07DE422A_6DBA_4611_A969_1471FD804B90#28138,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#28139,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#28140,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#28141,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#28142,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#28143,COL_898D946E_34EC_4196_88F6_338B6B38B05F#28144,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#28145,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#28146,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#28147,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#28148,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#28149,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#28150,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#28151,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#28152,... 37 more fields] parquet
