== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12739 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12755, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12740 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12756, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12741L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12757L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12742 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12758, COL_F347CA59_C1A7_4324_B43B_588C17452144#12743L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#12759L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12744 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12760, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12745 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12761, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12746L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12762L]
+- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12723 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12739, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12724 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12740, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12725L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12741L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12726 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12742, COL_F347CA59_C1A7_4324_B43B_588C17452144#12727L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#12743L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12728 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12744, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12729 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12745, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12730L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12746L]
+- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12707 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12723, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12708 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12724, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12709L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12725L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12710 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12726, COL_F347CA59_C1A7_4324_B43B_588C17452144#12711L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#12727L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12712 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12728, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12713 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12729, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12714L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12730L]
+- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12691 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12707, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12692 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12708, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12693L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12709L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12694 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12710, COL_F347CA59_C1A7_4324_B43B_588C17452144#12695L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#12711L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12696 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12712, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12697 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12713, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12698L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12714L]
+- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12675 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12691, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12676 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12692, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12677L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12693L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12678 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12694, COL_F347CA59_C1A7_4324_B43B_588C17452144#12679L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#12695L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12680 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12696, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12681 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12697, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12682L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12698L]
+- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12657 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12675, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12658 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12676, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12659L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12677L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12660 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12678, COL_F347CA59_C1A7_4324_B43B_588C17452144#12661L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#12679L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12662 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12680, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12663 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12681, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12664L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12682L]
+- Project [cast(QUALITE_SYNTHES_38119_COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12568 as string) AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12657, cast(QUALITE_SYNTHES_38119_COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12569 as string) AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12658, cast(QUALITE_SYNTHES_38119_COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12570L as bigint) AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12659L, cast(QUALITE_SYNTHES_38119_COL_70424811_2DDC_469F_8639_7777D23A61D6#12571 as string) AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12660, cast(QUALITE_SYNTHES_38119_COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12572L as bigint) AS COL_F347CA59_C1A7_4324_B43B_588C17452144#12661L, cast(QUALITE_SYNTHES_38119_COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#12573 as string) AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12662, cast(QUALITE_SYNTHES_38119_COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#12574 as double) AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12663, cast(QUALITE_SYNTHES_38119_COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12575L as bigint) AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12664L]
+- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12495 AS QUALITE_SYNTHES_38119_COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12568, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12496 AS QUALITE_SYNTHES_38119_COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12569, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12497L AS QUALITE_SYNTHES_38119_COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12570L, COL_70424811_2DDC_469F_8639_7777D23A61D6#12498 AS QUALITE_SYNTHES_38119_COL_70424811_2DDC_469F_8639_7777D23A61D6#12571, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12499L AS QUALITE_SYNTHES_38119_COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12572L, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#12500 AS QUALITE_SYNTHES_38119_COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#12573, COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#12501 AS QUALITE_SYNTHES_38119_COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#12574, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12502L AS QUALITE_SYNTHES_38119_COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12575L]
+- SubqueryAlias QUALITE_SYNTHES_38119118
+- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117 AS COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12495, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12267 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12496, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12268L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12497L, COL_70424811_2DDC_469F_8639_7777D23A61D6#12287 AS COL_70424811_2DDC_469F_8639_7777D23A61D6#12498, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12269L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12499L, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#12322 AS COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#12500, COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#12380 AS COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#12501, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L AS COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12502L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12267, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12268L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12269L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, COL_70424811_2DDC_469F_8639_7777D23A61D6#12287, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#12322, dec_operator(cast(DIFFERENCE as string), struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12268L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12269L)) AS COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#12380]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12267, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12268L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12269L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, COL_70424811_2DDC_469F_8639_7777D23A61D6#12287, 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#12269L, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L)), 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#12322]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12267, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12268L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12269L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, 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#12268L, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L)), col2, cast(100 as double))), cast(2 as int))), col2, cast(% as string))) AS COL_70424811_2DDC_469F_8639_7777D23A61D6#12287]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12253 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12267, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12254L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12268L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12255L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12269L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12253, coalesce(COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12244L, cast(0 as bigint)) AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12254L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12232L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12255L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L]
+- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12232L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#12153L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12244L]
+- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#12151L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12232L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#12153L]
+- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#12151L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#12153L]
+- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#12151L, Avant traitement qualité_NULL_1#12152, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#12153L]
+- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#12143[0] AS Après traitement qualité_NULL_1#12150, __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```#12149[0] AS Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#12151L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#12143[1] AS Avant traitement qualité_NULL_1#12152, __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```#12149[1] AS Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#12153L]
+- Aggregate [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L], [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, 1 AS `NULL_1`#12136, Après traitement qualité, Avant traitement qualité, 0, 0) AS __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#12143, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#12137L, 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```#12149]
+- Aggregate [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11789, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#12060, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11790L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937], [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11789 AS COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#12060 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11790L AS COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, 1 AS 1 AS `NULL_1`#12136, sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11796L) AS sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#12137L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11795, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11796L, COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11789, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11790L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, str_join(struct(col1, str_transform_case(str_replace_extend(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11795, 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#12060]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11795, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11796L, COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11789, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11790L, str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11795)), cast(INIT as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11795)), 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#11937]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11787 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11795, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11788L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11796L, COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11789, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11790L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11755 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11787, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11760L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11788L, COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11618 AS COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11789, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11619L AS COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11790L]
+- Project [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11618, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11619L, COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11755, col1#11696L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11760L]
+- Project [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11618, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11619L, col0#11695 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11755, col1#11696L]
+- Project [COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#11362 AS COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11618, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#11388L AS COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11619L, col0#11695, col1#11696L]
+- Generate stack(18, Adresse_GIE (Init) - Vide ou Null_SUM, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#11578L, Code postal_GIE (Final) - Vide ou Null_SUM, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#11579L, Code Postal_GIE (Init) - Vide ou Null_SUM, COL_67BC478B_6031_4C57_9DCE_401ABA863959#11580L, Commune_GIE (Init) - Vide ou Null_SUM, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#11581L, Entité Juridique_GIE (Init) - Vide ou null_SUM, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#11582L, Mail_GIE (Final) - Vide ou Null_SUM, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#11583L, mail_GIE (Init) - Vide ou Null_SUM, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#11584L, SIREN_GIE (Final) - Vide ou Null_SUM, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#11585L, SIREN_GIE (Init) - Vide ou Null_SUM, COL_153C42A2_431C_44DE_92C1_40F644939BB5#11586L, SIRET_GIE (Final) - Vide ou Null_SUM, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#11587L, SIRET_GIE (Init) - Vide ou Null_SUM, COL_9968307D_4589_4C17_884D_E5235BA04755#11588L, téléphone_GIE (Final) - Vide ou Null_SUM, ... 13 more fields), false, [col0#11695, col1#11696L]
+- Project [COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#11390L AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#11578L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#11392L AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#11579L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#11394L AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#11580L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#11396L AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#11581L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#11398L AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#11582L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#11400L AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#11583L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#11402L AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#11584L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#11404L AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#11585L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#11406L AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#11586L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#11408L AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#11587L, COL_9968307D_4589_4C17_884D_E5235BA04755#11410L AS COL_9968307D_4589_4C17_884D_E5235BA04755#11588L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#11412L AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#11589L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#11414L AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#11590L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#11416L AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#11591L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#11418L AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#11592L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#11420L AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#11593L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#11422L AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#11594L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#11424L AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#11595L, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#11386L AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#11596L, COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#11362, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#11388L]
+- Project [COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#11362, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#11386L, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#11388L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#11390L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#11392L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#11394L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#11396L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#11398L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#11400L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#11402L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#11404L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#11406L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#11408L, COL_9968307D_4589_4C17_884D_E5235BA04755#11410L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#11412L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#11414L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#11416L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#11418L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#11420L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#11422L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#11424L]
+- Project [COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#11362, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#11386L, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#11388L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#11390L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#11392L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#11394L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#11396L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#11398L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#11400L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#11402L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#11404L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#11406L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#11408L, COL_9968307D_4589_4C17_884D_E5235BA04755#11410L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#11412L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#11414L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#11416L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#11418L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#11420L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#11422L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#11424L]
+- Aggregate [COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#11290], [COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#11290 AS COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#11362, 1 AS NULL_1#11425, first(COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#11338L, true) AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#11386L, first(COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#11291L, true) AS COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#11388L, sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#11319 as bigint)) AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#11390L, sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#11324 as bigint)) AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#11392L, sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#11325 as bigint)) AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#11394L, sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#11326 as bigint)) AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#11396L, sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#11327 as bigint)) AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#11398L, sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#11328 as bigint)) AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#11400L, sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#11329 as bigint)) AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#11402L, sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#11330 as bigint)) AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#11404L, sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#11331 as bigint)) AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#11406L, sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#11332 as bigint)) AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#11408L, sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#11333 as bigint)) AS COL_9968307D_4589_4C17_884D_E5235BA04755#11410L, sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#11334 as bigint)) AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#11412L, sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#11335 as bigint)) AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#11414L, sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#11336 as bigint)) AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#11416L, sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#11320 as bigint)) AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#11418L, sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#11321 as bigint)) AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#11420L, sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#11322 as bigint)) AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#11422L, sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#11323 as bigint)) AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#11424L]
+- Project [COL_56938DE4_4C31_41D9_801C_C0B0842C509A#11271 AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#11319, COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#11272 AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#11320, COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#11273 AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#11321, COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#11274 AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#11322, COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#11275 AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#11323, COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#11276 AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#11324, COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#11277 AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#11325, COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#11278 AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#11326, COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#11279 AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#11327, COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#11280 AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#11328, COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#11281 AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#11329, COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#11282 AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#11330, COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#11283 AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#11331, COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#11284 AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#11332, COL_3C783429_A484_4DEF_9A90_CFB70F06D809#11285 AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#11333, COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#11286 AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#11334, COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#11287 AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#11335, COL_013B4432_4745_457D_A136_EA9290A58319#11288 AS COL_013B4432_4745_457D_A136_EA9290A58319#11336, COL_925B308B_8FFC_4303_927E_8232D67AA1AB#11270 AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#11337, COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#11289L AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#11338L, COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#11290, COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#11291L]
+- Project [cast(EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#11126 as string) AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#11270, cast(EVALUATION_QUAL_37976_COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#11165 as int) AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#11271, cast(EVALUATION_QUAL_37976_COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#11168 as int) AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#11272, cast(EVALUATION_QUAL_37976_COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#11171 as int) AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#11273, cast(EVALUATION_QUAL_37976_COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#11167 as int) AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#11274, cast(EVALUATION_QUAL_37976_COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#11172 as int) AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#11275, cast(EVALUATION_QUAL_37976_COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#11155 as int) AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#11276, cast(EVALUATION_QUAL_37976_COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#11156 as int) AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#11277, cast(EVALUATION_QUAL_37976_COL_464A280A_485C_42DC_883D_1B8FCCF5258D#11154 as int) AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#11278, cast(EVALUATION_QUAL_37976_COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#11152 as int) AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#11279, cast(EVALUATION_QUAL_37976_COL_45927A2C_7B5E_46F0_B288_4E446278061F#11162 as int) AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#11280, cast(EVALUATION_QUAL_37976_COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#11161 as int) AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#11281, cast(EVALUATION_QUAL_37976_COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#11158 as int) AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#11282, cast(EVALUATION_QUAL_37976_COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#11157 as int) AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#11283, cast(EVALUATION_QUAL_37976_COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#11160 as int) AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#11284, cast(EVALUATION_QUAL_37976_COL_726D968C_42FA_4E31_BD79_225187FD2C06#11159 as int) AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#11285, cast(EVALUATION_QUAL_37976_COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#11163 as int) AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#11286, cast(EVALUATION_QUAL_37976_COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#11164 as int) AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#11287, cast(EVALUATION_QUAL_37976_COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#11153 as int) AS COL_013B4432_4745_457D_A136_EA9290A58319#11288, cast(EVALUATION_QUAL_37976_COL_4C315D79_D322_4165_A505_BACE77D2FFCE#11170L as bigint) AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#11289L, cast(EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#11140 as string) AS COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#11290, cast(EVALUATION_QUAL_37976_COL_AC509FFD_CA2F_4EC6_887A_704140CA7926#11169L as bigint) AS COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#11291L]
+- Project [COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#10845 AS EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#11126, COL_BE341768_3194_4DD8_99AF_6C95339F9D93#10846 AS EVALUATION_QUAL_37976_COL_BE341768_3194_4DD8_99AF_6C95339F9D93#11127, COL_1839416A_7E82_4851_9843_99CFBF41CD08#10847 AS EVALUATION_QUAL_37976_COL_1839416A_7E82_4851_9843_99CFBF41CD08#11128, COL_30D07025_5684_4705_A04C_1C678E65ED32#10848 AS EVALUATION_QUAL_37976_COL_30D07025_5684_4705_A04C_1C678E65ED32#11129, COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#10849 AS EVALUATION_QUAL_37976_COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#11130, COL_648D9173_ED6C_4044_8903_158C1196A3E2#10850 AS EVALUATION_QUAL_37976_COL_648D9173_ED6C_4044_8903_158C1196A3E2#11131, COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#10851 AS EVALUATION_QUAL_37976_COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#11132, COL_A5976546_E656_4E43_9B26_F4C3A85BA303#10852 AS EVALUATION_QUAL_37976_COL_A5976546_E656_4E43_9B26_F4C3A85BA303#11133, COL_903F51D5_1E51_488D_9761_67785F7AF263#10853 AS EVALUATION_QUAL_37976_COL_903F51D5_1E51_488D_9761_67785F7AF263#11134, COL_07DE422A_6DBA_4611_A969_1471FD804B90#10854 AS EVALUATION_QUAL_37976_COL_07DE422A_6DBA_4611_A969_1471FD804B90#11135, COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#10855 AS EVALUATION_QUAL_37976_COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#11136, COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#10856 AS EVALUATION_QUAL_37976_COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#11137, COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#10857 AS EVALUATION_QUAL_37976_COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#11138, COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#10858 AS EVALUATION_QUAL_37976_COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#11139, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#10859 AS EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#11140, COL_898D946E_34EC_4196_88F6_338B6B38B05F#10860 AS EVALUATION_QUAL_37976_COL_898D946E_34EC_4196_88F6_338B6B38B05F#11141, COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#10861 AS EVALUATION_QUAL_37976_COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#11142, COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#10862 AS EVALUATION_QUAL_37976_COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#11143, COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#10863 AS EVALUATION_QUAL_37976_COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#11144, COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#10864 AS EVALUATION_QUAL_37976_COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#11145, COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#10865 AS EVALUATION_QUAL_37976_COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#11146, COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#10866 AS EVALUATION_QUAL_37976_COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#11147, COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#10867 AS EVALUATION_QUAL_37976_COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#11148, COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#10868 AS EVALUATION_QUAL_37976_COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#11149, ... 37 more fields]
+- SubqueryAlias EVALUATION_QUAL_37976118
+- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#10845,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#10846,COL_1839416A_7E82_4851_9843_99CFBF41CD08#10847,COL_30D07025_5684_4705_A04C_1C678E65ED32#10848,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#10849,COL_648D9173_ED6C_4044_8903_158C1196A3E2#10850,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#10851,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#10852,COL_903F51D5_1E51_488D_9761_67785F7AF263#10853,COL_07DE422A_6DBA_4611_A969_1471FD804B90#10854,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#10855,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#10856,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#10857,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#10858,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#10859,COL_898D946E_34EC_4196_88F6_338B6B38B05F#10860,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#10861,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#10862,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#10863,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#10864,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#10865,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#10866,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#10867,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#10868,... 37 more fields] parquet
== Analyzed Logical Plan ==
COL_9980B029_8A00_4A2E_9348_EBFAB996E811: string, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E: string, COL_C7677B53_41ED_4612_9DA8_AC26770B1876: bigint, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5: string, COL_F347CA59_C1A7_4324_B43B_588C17452144: bigint, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52: string, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6: double, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F: bigint
GlobalLimit 500000
+- LocalLimit 500000
+- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12739 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12755, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12740 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12756, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12741L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12757L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12742 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12758, COL_F347CA59_C1A7_4324_B43B_588C17452144#12743L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#12759L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12744 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12760, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12745 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12761, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12746L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12762L]
+- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12723 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12739, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12724 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12740, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12725L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12741L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12726 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12742, COL_F347CA59_C1A7_4324_B43B_588C17452144#12727L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#12743L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12728 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12744, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12729 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12745, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12730L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12746L]
+- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12707 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12723, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12708 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12724, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12709L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12725L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12710 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12726, COL_F347CA59_C1A7_4324_B43B_588C17452144#12711L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#12727L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12712 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12728, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12713 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12729, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12714L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12730L]
+- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12691 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12707, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12692 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12708, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12693L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12709L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12694 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12710, COL_F347CA59_C1A7_4324_B43B_588C17452144#12695L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#12711L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12696 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12712, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12697 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12713, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12698L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12714L]
+- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12675 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12691, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12676 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12692, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12677L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12693L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12678 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12694, COL_F347CA59_C1A7_4324_B43B_588C17452144#12679L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#12695L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12680 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12696, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12681 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12697, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12682L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12698L]
+- Project [COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12657 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12675, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12658 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12676, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12659L AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12677L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12660 AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12678, COL_F347CA59_C1A7_4324_B43B_588C17452144#12661L AS COL_F347CA59_C1A7_4324_B43B_588C17452144#12679L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12662 AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12680, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12663 AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12681, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12664L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12682L]
+- Project [cast(QUALITE_SYNTHES_38119_COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12568 as string) AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12657, cast(QUALITE_SYNTHES_38119_COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12569 as string) AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12658, cast(QUALITE_SYNTHES_38119_COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12570L as bigint) AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12659L, cast(QUALITE_SYNTHES_38119_COL_70424811_2DDC_469F_8639_7777D23A61D6#12571 as string) AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12660, cast(QUALITE_SYNTHES_38119_COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12572L as bigint) AS COL_F347CA59_C1A7_4324_B43B_588C17452144#12661L, cast(QUALITE_SYNTHES_38119_COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#12573 as string) AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12662, cast(QUALITE_SYNTHES_38119_COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#12574 as double) AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12663, cast(QUALITE_SYNTHES_38119_COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12575L as bigint) AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12664L]
+- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12495 AS QUALITE_SYNTHES_38119_COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12568, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12496 AS QUALITE_SYNTHES_38119_COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12569, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12497L AS QUALITE_SYNTHES_38119_COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12570L, COL_70424811_2DDC_469F_8639_7777D23A61D6#12498 AS QUALITE_SYNTHES_38119_COL_70424811_2DDC_469F_8639_7777D23A61D6#12571, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12499L AS QUALITE_SYNTHES_38119_COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12572L, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#12500 AS QUALITE_SYNTHES_38119_COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#12573, COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#12501 AS QUALITE_SYNTHES_38119_COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#12574, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12502L AS QUALITE_SYNTHES_38119_COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12575L]
+- SubqueryAlias QUALITE_SYNTHES_38119118
+- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117 AS COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12495, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12267 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12496, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12268L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12497L, COL_70424811_2DDC_469F_8639_7777D23A61D6#12287 AS COL_70424811_2DDC_469F_8639_7777D23A61D6#12498, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12269L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12499L, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#12322 AS COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#12500, COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#12380 AS COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#12501, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L AS COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12502L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12267, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12268L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12269L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, COL_70424811_2DDC_469F_8639_7777D23A61D6#12287, COL_C9AB8E93_66BD_4006_9AF2_865D14B2B284#12322, dec_operator(cast(DIFFERENCE as string), struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12268L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12269L)) AS COL_1C48E1B5_7627_4AFE_AD3A_3DCB6B9B2694#12380]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12267, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12268L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12269L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, COL_70424811_2DDC_469F_8639_7777D23A61D6#12287, 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#12269L, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L)), 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#12322]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12267, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12268L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12269L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, 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#12268L, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L)), col2, cast(100 as double))), cast(2 as int))), col2, cast(% as string))) AS COL_70424811_2DDC_469F_8639_7777D23A61D6#12287]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12253 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12267, COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12254L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12268L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12255L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12269L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L]
+- Project [COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12253, coalesce(COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12244L, cast(0 as bigint)) AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12254L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12232L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12255L, COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L]
+- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12232L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#12153L AS COL_CF1B2EC2_6198_4115_B079_F51D532426DB#12244L]
+- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#12151L AS COL_1AD867EF_74A9_4253_97E3_892B44C7C916#12232L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#12153L]
+- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#12151L, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#12153L]
+- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#12151L, Avant traitement qualité_NULL_1#12152, Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#12153L]
+- Project [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#12143[0] AS Après traitement qualité_NULL_1#12150, __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```#12149[0] AS Après traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#12151L, __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#12143[1] AS Avant traitement qualité_NULL_1#12152, __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```#12149[1] AS Avant traitement qualité_COL_13D55021_C380_4F34_9553_27DE47738829#12153L]
+- Aggregate [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L], [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, 1 AS `NULL_1`#12136, Après traitement qualité, Avant traitement qualité, 0, 0) AS __pivot_1 AS `NULL_1` AS `1 AS ``NULL_1```#12143, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#12137L, 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```#12149]
+- Aggregate [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11789, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#12060, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11790L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937], [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11789 AS COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#12060 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11790L AS COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, 1 AS 1 AS `NULL_1`#12136, sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11796L) AS sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#12137L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11795, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11796L, COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11789, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11790L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, str_join(struct(col1, str_transform_case(str_replace_extend(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11795, 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#12060]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11795, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11796L, COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11789, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11790L, str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11795)), cast(INIT as string))) THEN false ELSE Contains(str_remove_accent(upper(COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11795)), 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#11937]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11787 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11795, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11788L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11796L, COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11789, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11790L]
+- Project [COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11755 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11787, COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11760L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11788L, COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11618 AS COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11789, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11619L AS COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11790L]
+- Project [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11618, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11619L, COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11755, col1#11696L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11760L]
+- Project [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11618, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11619L, col0#11695 AS COL_04A3C543_1B9D_48D6_B8F5_303BC872411C#11755, col1#11696L]
+- Project [COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#11362 AS COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11618, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#11388L AS COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11619L, col0#11695, col1#11696L]
+- Generate stack(18, Adresse_GIE (Init) - Vide ou Null_SUM, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#11578L, Code postal_GIE (Final) - Vide ou Null_SUM, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#11579L, Code Postal_GIE (Init) - Vide ou Null_SUM, COL_67BC478B_6031_4C57_9DCE_401ABA863959#11580L, Commune_GIE (Init) - Vide ou Null_SUM, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#11581L, Entité Juridique_GIE (Init) - Vide ou null_SUM, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#11582L, Mail_GIE (Final) - Vide ou Null_SUM, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#11583L, mail_GIE (Init) - Vide ou Null_SUM, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#11584L, SIREN_GIE (Final) - Vide ou Null_SUM, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#11585L, SIREN_GIE (Init) - Vide ou Null_SUM, COL_153C42A2_431C_44DE_92C1_40F644939BB5#11586L, SIRET_GIE (Final) - Vide ou Null_SUM, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#11587L, SIRET_GIE (Init) - Vide ou Null_SUM, COL_9968307D_4589_4C17_884D_E5235BA04755#11588L, téléphone_GIE (Final) - Vide ou Null_SUM, ... 13 more fields), false, [col0#11695, col1#11696L]
+- Project [COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#11390L AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#11578L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#11392L AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#11579L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#11394L AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#11580L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#11396L AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#11581L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#11398L AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#11582L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#11400L AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#11583L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#11402L AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#11584L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#11404L AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#11585L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#11406L AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#11586L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#11408L AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#11587L, COL_9968307D_4589_4C17_884D_E5235BA04755#11410L AS COL_9968307D_4589_4C17_884D_E5235BA04755#11588L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#11412L AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#11589L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#11414L AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#11590L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#11416L AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#11591L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#11418L AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#11592L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#11420L AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#11593L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#11422L AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#11594L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#11424L AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#11595L, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#11386L AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#11596L, COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#11362, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#11388L]
+- Project [COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#11362, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#11386L, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#11388L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#11390L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#11392L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#11394L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#11396L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#11398L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#11400L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#11402L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#11404L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#11406L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#11408L, COL_9968307D_4589_4C17_884D_E5235BA04755#11410L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#11412L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#11414L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#11416L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#11418L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#11420L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#11422L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#11424L]
+- Project [COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#11362, COL_F54B0E92_8372_4793_9A6B_69AA67D72621#11386L, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#11388L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#11390L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#11392L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#11394L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#11396L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#11398L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#11400L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#11402L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#11404L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#11406L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#11408L, COL_9968307D_4589_4C17_884D_E5235BA04755#11410L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#11412L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#11414L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#11416L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#11418L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#11420L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#11422L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#11424L]
+- Aggregate [COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#11290], [COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#11290 AS COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#11362, 1 AS NULL_1#11425, first(COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#11338L, true) AS COL_F54B0E92_8372_4793_9A6B_69AA67D72621#11386L, first(COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#11291L, true) AS COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#11388L, sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#11319 as bigint)) AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#11390L, sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#11324 as bigint)) AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#11392L, sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#11325 as bigint)) AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#11394L, sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#11326 as bigint)) AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#11396L, sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#11327 as bigint)) AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#11398L, sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#11328 as bigint)) AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#11400L, sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#11329 as bigint)) AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#11402L, sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#11330 as bigint)) AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#11404L, sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#11331 as bigint)) AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#11406L, sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#11332 as bigint)) AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#11408L, sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#11333 as bigint)) AS COL_9968307D_4589_4C17_884D_E5235BA04755#11410L, sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#11334 as bigint)) AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#11412L, sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#11335 as bigint)) AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#11414L, sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#11336 as bigint)) AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#11416L, sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#11320 as bigint)) AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#11418L, sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#11321 as bigint)) AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#11420L, sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#11322 as bigint)) AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#11422L, sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#11323 as bigint)) AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#11424L]
+- Project [COL_56938DE4_4C31_41D9_801C_C0B0842C509A#11271 AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#11319, COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#11272 AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#11320, COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#11273 AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#11321, COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#11274 AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#11322, COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#11275 AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#11323, COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#11276 AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#11324, COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#11277 AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#11325, COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#11278 AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#11326, COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#11279 AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#11327, COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#11280 AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#11328, COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#11281 AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#11329, COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#11282 AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#11330, COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#11283 AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#11331, COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#11284 AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#11332, COL_3C783429_A484_4DEF_9A90_CFB70F06D809#11285 AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#11333, COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#11286 AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#11334, COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#11287 AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#11335, COL_013B4432_4745_457D_A136_EA9290A58319#11288 AS COL_013B4432_4745_457D_A136_EA9290A58319#11336, COL_925B308B_8FFC_4303_927E_8232D67AA1AB#11270 AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#11337, COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#11289L AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#11338L, COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#11290, COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#11291L]
+- Project [cast(EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#11126 as string) AS COL_925B308B_8FFC_4303_927E_8232D67AA1AB#11270, cast(EVALUATION_QUAL_37976_COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#11165 as int) AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#11271, cast(EVALUATION_QUAL_37976_COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#11168 as int) AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#11272, cast(EVALUATION_QUAL_37976_COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#11171 as int) AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#11273, cast(EVALUATION_QUAL_37976_COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#11167 as int) AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#11274, cast(EVALUATION_QUAL_37976_COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#11172 as int) AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#11275, cast(EVALUATION_QUAL_37976_COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#11155 as int) AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#11276, cast(EVALUATION_QUAL_37976_COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#11156 as int) AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#11277, cast(EVALUATION_QUAL_37976_COL_464A280A_485C_42DC_883D_1B8FCCF5258D#11154 as int) AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#11278, cast(EVALUATION_QUAL_37976_COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#11152 as int) AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#11279, cast(EVALUATION_QUAL_37976_COL_45927A2C_7B5E_46F0_B288_4E446278061F#11162 as int) AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#11280, cast(EVALUATION_QUAL_37976_COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#11161 as int) AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#11281, cast(EVALUATION_QUAL_37976_COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#11158 as int) AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#11282, cast(EVALUATION_QUAL_37976_COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#11157 as int) AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#11283, cast(EVALUATION_QUAL_37976_COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#11160 as int) AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#11284, cast(EVALUATION_QUAL_37976_COL_726D968C_42FA_4E31_BD79_225187FD2C06#11159 as int) AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#11285, cast(EVALUATION_QUAL_37976_COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#11163 as int) AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#11286, cast(EVALUATION_QUAL_37976_COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#11164 as int) AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#11287, cast(EVALUATION_QUAL_37976_COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#11153 as int) AS COL_013B4432_4745_457D_A136_EA9290A58319#11288, cast(EVALUATION_QUAL_37976_COL_4C315D79_D322_4165_A505_BACE77D2FFCE#11170L as bigint) AS COL_5E9B56C6_D56A_4C87_8046_39BB31058E34#11289L, cast(EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#11140 as string) AS COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#11290, cast(EVALUATION_QUAL_37976_COL_AC509FFD_CA2F_4EC6_887A_704140CA7926#11169L as bigint) AS COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#11291L]
+- Project [COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#10845 AS EVALUATION_QUAL_37976_COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#11126, COL_BE341768_3194_4DD8_99AF_6C95339F9D93#10846 AS EVALUATION_QUAL_37976_COL_BE341768_3194_4DD8_99AF_6C95339F9D93#11127, COL_1839416A_7E82_4851_9843_99CFBF41CD08#10847 AS EVALUATION_QUAL_37976_COL_1839416A_7E82_4851_9843_99CFBF41CD08#11128, COL_30D07025_5684_4705_A04C_1C678E65ED32#10848 AS EVALUATION_QUAL_37976_COL_30D07025_5684_4705_A04C_1C678E65ED32#11129, COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#10849 AS EVALUATION_QUAL_37976_COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#11130, COL_648D9173_ED6C_4044_8903_158C1196A3E2#10850 AS EVALUATION_QUAL_37976_COL_648D9173_ED6C_4044_8903_158C1196A3E2#11131, COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#10851 AS EVALUATION_QUAL_37976_COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#11132, COL_A5976546_E656_4E43_9B26_F4C3A85BA303#10852 AS EVALUATION_QUAL_37976_COL_A5976546_E656_4E43_9B26_F4C3A85BA303#11133, COL_903F51D5_1E51_488D_9761_67785F7AF263#10853 AS EVALUATION_QUAL_37976_COL_903F51D5_1E51_488D_9761_67785F7AF263#11134, COL_07DE422A_6DBA_4611_A969_1471FD804B90#10854 AS EVALUATION_QUAL_37976_COL_07DE422A_6DBA_4611_A969_1471FD804B90#11135, COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#10855 AS EVALUATION_QUAL_37976_COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#11136, COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#10856 AS EVALUATION_QUAL_37976_COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#11137, COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#10857 AS EVALUATION_QUAL_37976_COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#11138, COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#10858 AS EVALUATION_QUAL_37976_COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#11139, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#10859 AS EVALUATION_QUAL_37976_COL_09DD6C48_8262_414D_9D00_17FFFC613E44#11140, COL_898D946E_34EC_4196_88F6_338B6B38B05F#10860 AS EVALUATION_QUAL_37976_COL_898D946E_34EC_4196_88F6_338B6B38B05F#11141, COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#10861 AS EVALUATION_QUAL_37976_COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#11142, COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#10862 AS EVALUATION_QUAL_37976_COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#11143, COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#10863 AS EVALUATION_QUAL_37976_COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#11144, COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#10864 AS EVALUATION_QUAL_37976_COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#11145, COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#10865 AS EVALUATION_QUAL_37976_COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#11146, COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#10866 AS EVALUATION_QUAL_37976_COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#11147, COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#10867 AS EVALUATION_QUAL_37976_COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#11148, COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#10868 AS EVALUATION_QUAL_37976_COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#11149, ... 37 more fields]
+- SubqueryAlias EVALUATION_QUAL_37976118
+- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#10845,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#10846,COL_1839416A_7E82_4851_9843_99CFBF41CD08#10847,COL_30D07025_5684_4705_A04C_1C678E65ED32#10848,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#10849,COL_648D9173_ED6C_4044_8903_158C1196A3E2#10850,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#10851,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#10852,COL_903F51D5_1E51_488D_9761_67785F7AF263#10853,COL_07DE422A_6DBA_4611_A969_1471FD804B90#10854,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#10855,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#10856,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#10857,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#10858,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#10859,COL_898D946E_34EC_4196_88F6_338B6B38B05F#10860,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#10861,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#10862,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#10863,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#10864,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#10865,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#10866,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#10867,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#10868,... 37 more fields] parquet
== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
+- Aggregate [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L], [COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117 AS COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12755, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118 AS COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12756, coalesce(pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#12137L, Après traitement qualité, Avant traitement qualité, 0, 0)[1], 0) AS COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12757L, str_concat(struct(col1, dec_to_str(dec_round(dec_operator(PRODUIT, struct(col1, dec_operator(DIVISION, struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, coalesce(pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#12137L, Après traitement qualité, Avant traitement qualité, 0, 0)[1], 0), COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L)), col2, 100.0)), 2)), col2, %)) AS COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12758, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#12137L, Après traitement qualité, Avant traitement qualité, 0, 0)[0] AS COL_F347CA59_C1A7_4324_B43B_588C17452144#12759L, str_replace_regex(str_concat(struct(col1, dec_to_str(dec_round(dec_operator(PRODUIT, struct(col1, dec_operator(DIVISION, struct(COL_1AD867EF_74A9_4253_97E3_892B44C7C916, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#12137L, Après traitement qualité, Avant traitement qualité, 0, 0)[0], COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L)), col2, 100.0)), 2)), col2, %)), (?<![0-9])%, Pas de traitement) AS COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12760, dec_operator(DIFFERENCE, struct(COL_CF1B2EC2_6198_4115_B079_F51D532426DB, coalesce(pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#12137L, Après traitement qualité, Avant traitement qualité, 0, 0)[1], 0), COL_1AD867EF_74A9_4253_97E3_892B44C7C916, pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#12137L, Après traitement qualité, Avant traitement qualité, 0, 0)[0])) AS COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12761, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L AS COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12762L]
+- Aggregate [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11789, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#12060, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11790L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937], [COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11789 AS COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#12060 AS COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11790L AS COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11796L) AS sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#12137L]
+- Project [col1#11696L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11796L, COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#11362 AS COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11789, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#11388L AS COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11790L, str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(col0#11695)), INIT)) THEN false ELSE Contains(str_remove_accent(upper(col0#11695)), INIT) END, Avant traitement qualité, Après traitement qualité) AS COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, str_join(struct(col1, str_transform_case(str_replace_extend(col0#11695, [ (Init) - Vide ou Null_SUM, (Final) - Vide ou Null_SUM, (Init) - Vide ou null_SUM], [,,]), UPPER), col2, non renseigné), - ) AS COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#12060]
+- Generate stack(18, Adresse_GIE (Init) - Vide ou Null_SUM, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#11390L, Code postal_GIE (Final) - Vide ou Null_SUM, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#11392L, Code Postal_GIE (Init) - Vide ou Null_SUM, COL_67BC478B_6031_4C57_9DCE_401ABA863959#11394L, Commune_GIE (Init) - Vide ou Null_SUM, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#11396L, Entité Juridique_GIE (Init) - Vide ou null_SUM, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#11398L, Mail_GIE (Final) - Vide ou Null_SUM, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#11400L, mail_GIE (Init) - Vide ou Null_SUM, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#11402L, SIREN_GIE (Final) - Vide ou Null_SUM, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#11404L, SIREN_GIE (Init) - Vide ou Null_SUM, COL_153C42A2_431C_44DE_92C1_40F644939BB5#11406L, SIRET_GIE (Final) - Vide ou Null_SUM, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#11408L, SIRET_GIE (Init) - Vide ou Null_SUM, COL_9968307D_4589_4C17_884D_E5235BA04755#11410L, téléphone_GIE (Final) - Vide ou Null_SUM, ... 13 more fields), [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17], false, [col0#11695, col1#11696L]
+- Project [COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#11390L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#11392L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#11394L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#11396L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#11398L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#11400L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#11402L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#11404L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#11406L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#11408L, COL_9968307D_4589_4C17_884D_E5235BA04755#11410L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#11412L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#11414L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#11416L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#11418L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#11420L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#11422L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#11424L, COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#11362, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#11388L]
+- Aggregate [COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#11290], [COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#11290 AS COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#11362, first(COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#11291L, true) AS COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#11388L, sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#11319 as bigint)) AS COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#11390L, sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#11324 as bigint)) AS COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#11392L, sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#11325 as bigint)) AS COL_67BC478B_6031_4C57_9DCE_401ABA863959#11394L, sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#11326 as bigint)) AS COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#11396L, sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#11327 as bigint)) AS COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#11398L, sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#11328 as bigint)) AS COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#11400L, sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#11329 as bigint)) AS COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#11402L, sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#11330 as bigint)) AS COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#11404L, sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#11331 as bigint)) AS COL_153C42A2_431C_44DE_92C1_40F644939BB5#11406L, sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#11332 as bigint)) AS COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#11408L, sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#11333 as bigint)) AS COL_9968307D_4589_4C17_884D_E5235BA04755#11410L, sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#11334 as bigint)) AS COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#11412L, sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#11335 as bigint)) AS COL_70092BF1_E4F8_403B_8545_24C37EE02207#11414L, sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#11336 as bigint)) AS COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#11416L, sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#11320 as bigint)) AS COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#11418L, sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#11321 as bigint)) AS COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#11420L, sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#11322 as bigint)) AS COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#11422L, sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#11323 as bigint)) AS COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#11424L]
+- Project [COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#10884 AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#11319, COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#10887 AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#11320, COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#10890 AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#11321, COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#10886 AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#11322, COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#10891 AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#11323, COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#10874 AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#11324, COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#10875 AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#11325, COL_464A280A_485C_42DC_883D_1B8FCCF5258D#10873 AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#11326, COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#10871 AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#11327, COL_45927A2C_7B5E_46F0_B288_4E446278061F#10881 AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#11328, COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#10880 AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#11329, COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#10877 AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#11330, COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#10876 AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#11331, COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#10879 AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#11332, COL_726D968C_42FA_4E31_BD79_225187FD2C06#10878 AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#11333, COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#10882 AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#11334, COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#10883 AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#11335, COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#10872 AS COL_013B4432_4745_457D_A136_EA9290A58319#11336, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#10859 AS COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#11290, COL_AC509FFD_CA2F_4EC6_887A_704140CA7926#10888L AS COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#11291L]
+- Relation[COL_C683E259_4FB8_4DAA_96BA_0AD7864C50A6#10845,COL_BE341768_3194_4DD8_99AF_6C95339F9D93#10846,COL_1839416A_7E82_4851_9843_99CFBF41CD08#10847,COL_30D07025_5684_4705_A04C_1C678E65ED32#10848,COL_A48621DB_AEDE_43C3_882E_B203C85FC1C3#10849,COL_648D9173_ED6C_4044_8903_158C1196A3E2#10850,COL_B2C8394C_9F0D_4E74_9EED_829CBF4A4810#10851,COL_A5976546_E656_4E43_9B26_F4C3A85BA303#10852,COL_903F51D5_1E51_488D_9761_67785F7AF263#10853,COL_07DE422A_6DBA_4611_A969_1471FD804B90#10854,COL_9F33CE29_FFB2_4DFA_97D7_0A4A99C7D776#10855,COL_DB755CD4_45C9_45B5_B7DD_DDDE45DC1DA1#10856,COL_7C8C595E_1715_4DA3_83E2_67991E9B8BE0#10857,COL_981808B2_1B46_42AD_A458_F0E0A6EE26BF#10858,COL_09DD6C48_8262_414D_9D00_17FFFC613E44#10859,COL_898D946E_34EC_4196_88F6_338B6B38B05F#10860,COL_A6FD6F33_B8FA_4B79_8130_F1F2A1CDEACA#10861,COL_8CDB4553_861B_4076_9AB3_EE1075F28F67#10862,COL_9761C78B_FA3D_40EA_9708_BD08A11671EF#10863,COL_B063A8C4_3CDA_4EB2_9691_1179E8CB219C#10864,COL_32300888_6BDE_4B2D_8A6E_19B0F15E2559#10865,COL_EE35EA73_3EA9_46AA_9520_14DC7680A68C#10866,COL_33BF8562_9375_470F_A9CB_6554EC19A2BF#10867,COL_BDDE5FC7_0FB4_4708_B598_3C03CBC8BCD3#10868,... 37 more fields] parquet
== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
+- HashAggregate(keys=[COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L], functions=[pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#12137L, Après traitement qualité, Avant traitement qualité, 0, 0)], output=[COL_9980B029_8A00_4A2E_9348_EBFAB996E811#12755, COL_B64A50C6_7FE4_4485_9C3F_51393E27482E#12756, COL_C7677B53_41ED_4612_9DA8_AC26770B1876#12757L, COL_3200A861_88EA_4638_BBCA_2362DA70EDB5#12758, COL_F347CA59_C1A7_4324_B43B_588C17452144#12759L, COL_AA1DA4B9_BAF7_4195_9454_37CF839A7E52#12760, COL_423974C8_5E1F_4A8F_AC5E_8650A7C3ADD6#12761, COL_69723EA3_E16C_4B3A_9B13_809AE33CF39F#12762L])
+- HashAggregate(keys=[COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L], functions=[partial_pivotfirst(COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#12137L, Après traitement qualité, Avant traitement qualité, 0, 0)], output=[COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, Après traitement qualité#12146L, Avant traitement qualité#12147L])
+- *(3) HashAggregate(keys=[COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11789, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#12060, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11790L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937], functions=[sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11796L)], output=[COL_C692E8BB_51D1_4111_A57B_21F14A02CD86#12117, COL_6BAF5448_EB23_44D3_915A_F807AA7B3F30#12118, COL_4438B8D5_1AFD_4703_91B8_DEBE4E73BCCE#12119L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, sum(`COL_D08E9E92_1F45_417D_929C_3D370D7552B8`) AS `COL_13D55021_C380_4F34_9553_27DE47738829`#12137L])
+- *(3) HashAggregate(keys=[COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11789, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#12060, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11790L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937], functions=[partial_sum(COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11796L)], output=[COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11789, COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#12060, COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11790L, COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, sum#12828L])
+- *(3) Project [col1#11696L AS COL_D08E9E92_1F45_417D_929C_3D370D7552B8#11796L, COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#11362 AS COL_7D803F30_2EE8_4BF1_B22D_D8687214B1AF#11789, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#11388L AS COL_05098269_8A7D_495A_8A38_2EFAD4A15F7F#11790L, str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(col0#11695)), INIT)) THEN false ELSE Contains(str_remove_accent(upper(col0#11695)), INIT) END, Avant traitement qualité, Après traitement qualité) AS COL_80F9BE73_1671_4BAF_9FF8_FDA1C5B70B6B#11937, str_join(struct(col1, str_transform_case(str_replace_extend(col0#11695, [ (Init) - Vide ou Null_SUM, (Final) - Vide ou Null_SUM, (Init) - Vide ou null_SUM], [,,]), UPPER), col2, non renseigné), - ) AS COL_1F506315_5AF6_4E5D_AD9B_CE3D6337535D#12060]
+- Generate stack(18, Adresse_GIE (Init) - Vide ou Null_SUM, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#11390L, Code postal_GIE (Final) - Vide ou Null_SUM, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#11392L, Code Postal_GIE (Init) - Vide ou Null_SUM, COL_67BC478B_6031_4C57_9DCE_401ABA863959#11394L, Commune_GIE (Init) - Vide ou Null_SUM, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#11396L, Entité Juridique_GIE (Init) - Vide ou null_SUM, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#11398L, Mail_GIE (Final) - Vide ou Null_SUM, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#11400L, mail_GIE (Init) - Vide ou Null_SUM, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#11402L, SIREN_GIE (Final) - Vide ou Null_SUM, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#11404L, SIREN_GIE (Init) - Vide ou Null_SUM, COL_153C42A2_431C_44DE_92C1_40F644939BB5#11406L, SIRET_GIE (Final) - Vide ou Null_SUM, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#11408L, SIRET_GIE (Init) - Vide ou Null_SUM, COL_9968307D_4589_4C17_884D_E5235BA04755#11410L, téléphone_GIE (Final) - Vide ou Null_SUM, ... 13 more fields), [COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#11362, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#11388L], false, [col0#11695, col1#11696L]
+- *(2) Project [COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#11390L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#11392L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#11394L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#11396L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#11398L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#11400L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#11402L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#11404L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#11406L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#11408L, COL_9968307D_4589_4C17_884D_E5235BA04755#11410L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#11412L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#11414L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#11416L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#11418L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#11420L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#11422L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#11424L, COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#11362, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#11388L]
+- *(2) HashAggregate(keys=[COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#11290], functions=[first(COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#11291L, true), sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#11319 as bigint)), sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#11324 as bigint)), sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#11325 as bigint)), sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#11326 as bigint)), sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#11327 as bigint)), sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#11328 as bigint)), sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#11329 as bigint)), sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#11330 as bigint)), sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#11331 as bigint)), sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#11332 as bigint)), sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#11333 as bigint)), sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#11334 as bigint)), sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#11335 as bigint)), sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#11336 as bigint)), sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#11320 as bigint)), sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#11321 as bigint)), sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#11322 as bigint)), sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#11323 as bigint))], output=[COL_72B2C06A_D593_47DE_8F53_83AAC073CF1D#11362, COL_84661C6C_F8DF_4239_8D5B_5B46CC2A8153#11388L, COL_6E9C7907_DCB4_4E9A_833A_28C59643D0E1#11390L, COL_D6FFA624_4991_4F6C_9675_E06CD20483DC#11392L, COL_67BC478B_6031_4C57_9DCE_401ABA863959#11394L, COL_B4EF0986_66F8_40AF_A09A_F0B90847DE03#11396L, COL_F8C5C76E_EE80_4BDE_B53E_BE9E973FCCB8#11398L, COL_933D4959_1290_43C4_A27B_8E295D2DA0C0#11400L, COL_838B0AB2_A953_4A47_AE97_8D37C19CE503#11402L, COL_0A72FEE1_6AA8_433C_9EB8_B4CCEF094AED#11404L, COL_153C42A2_431C_44DE_92C1_40F644939BB5#11406L, COL_4ED5F712_A2D5_49FB_AD2A_C7925328D3D1#11408L, COL_9968307D_4589_4C17_884D_E5235BA04755#11410L, COL_DBBFBB6C_2E1D_42FE_84A5_B2AB81A58302#11412L, COL_70092BF1_E4F8_403B_8545_24C37EE02207#11414L, COL_CDB27768_A028_4EBD_AC9E_2FEC3E3DF79B#11416L, COL_695EFFCD_EEFF_4DB0_9CE5_4A3A5B7770D3#11418L, COL_44C05EDE_42DD_4525_B11A_BE1845D491C9#11420L, COL_DF249A41_C2EB_4DC7_A7EB_7F547B659A65#11422L, COL_1D42D829_C468_48B4_9F4E_E2F006F5D3F5#11424L])
+- CustomShuffleReader coalesced
+- ShuffleQueryStage 0
+- Exchange hashpartitioning(COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#11290, 200), true, [id=#2925]
+- *(1) HashAggregate(keys=[COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#11290], functions=[partial_first(COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#11291L, true), partial_sum(cast(COL_56938DE4_4C31_41D9_801C_C0B0842C509A#11319 as bigint)), partial_sum(cast(COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#11324 as bigint)), partial_sum(cast(COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#11325 as bigint)), partial_sum(cast(COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#11326 as bigint)), partial_sum(cast(COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#11327 as bigint)), partial_sum(cast(COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#11328 as bigint)), partial_sum(cast(COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#11329 as bigint)), partial_sum(cast(COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#11330 as bigint)), partial_sum(cast(COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#11331 as bigint)), partial_sum(cast(COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#11332 as bigint)), partial_sum(cast(COL_3C783429_A484_4DEF_9A90_CFB70F06D809#11333 as bigint)), partial_sum(cast(COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#11334 as bigint)), partial_sum(cast(COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#11335 as bigint)), partial_sum(cast(COL_013B4432_4745_457D_A136_EA9290A58319#11336 as bigint)), partial_sum(cast(COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#11320 as bigint)), partial_sum(cast(COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#11321 as bigint)), partial_sum(cast(COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#11322 as bigint)), partial_sum(cast(COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#11323 as bigint))], output=[COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#11290, first#12849L, valueSet#12850, sum#12851L, sum#12852L, sum#12853L, sum#12854L, sum#12855L, sum#12856L, sum#12857L, sum#12858L, sum#12859L, sum#12860L, sum#12861L, sum#12862L, sum#12863L, sum#12864L, sum#12865L, sum#12866L, sum#12867L, sum#12868L])
+- *(1) Project [COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#10884 AS COL_56938DE4_4C31_41D9_801C_C0B0842C509A#11319, COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#10887 AS COL_B43F6C0C_E494_427C_AEC8_026F4F86241E#11320, COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#10890 AS COL_30D12E3A_618F_4431_93EC_A8F5FF73AECE#11321, COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#10886 AS COL_29290CC3_55A1_4D5E_91EF_9F8F4FCBC08E#11322, COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#10891 AS COL_2766316D_CB6D_453B_9993_1AAFDB895AD5#11323, COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#10874 AS COL_4D2158F9_DF52_4273_803B_CD46EA3DAA38#11324, COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#10875 AS COL_EA8BEB05_AB5B_4D4D_BF96_21684FB16201#11325, COL_464A280A_485C_42DC_883D_1B8FCCF5258D#10873 AS COL_BB617C61_B39C_492C_A16A_7E501EF41AEE#11326, COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#10871 AS COL_F9D52211_49D3_4323_92DD_5B4B62901D4B#11327, COL_45927A2C_7B5E_46F0_B288_4E446278061F#10881 AS COL_EA4B2D62_C35E_4246_8278_A5EC292806FB#11328, COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#10880 AS COL_1FB91A61_D028_42FB_B8A0_558BEEE7A859#11329, COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#10877 AS COL_77B536EA_3FEF_4EAA_8B20_ED964A04C815#11330, COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#10876 AS COL_46B81592_9C2E_457B_B6DE_43143E67DCAB#11331, COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#10879 AS COL_95D22719_57C0_46E6_8C32_988DD5FDFE44#11332, COL_726D968C_42FA_4E31_BD79_225187FD2C06#10878 AS COL_3C783429_A484_4DEF_9A90_CFB70F06D809#11333, COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#10882 AS COL_8471823A_B67F_4DFC_9FAF_FC66FF7700CF#11334, COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#10883 AS COL_D5324B64_B8F6_43D4_B51E_994107A4EEE3#11335, COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#10872 AS COL_013B4432_4745_457D_A136_EA9290A58319#11336, COL_09DD6C48_8262_414D_9D00_17FFFC613E44#10859 AS COL_1EFEB209_16CB_4372_8FB9_0777D4180E1F#11290, COL_AC509FFD_CA2F_4EC6_887A_704140CA7926#10888L AS COL_E46830EE_CDA4_4B8E_BE46_17DCB17C531F#11291L]
+- *(1) ColumnarToRow
+- FileScan parquet [COL_09DD6C48_8262_414D_9D00_17FFFC613E44#10859,COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2#10871,COL_40D289E5_4818_4F19_809D_5FEC1AF78A90#10872,COL_464A280A_485C_42DC_883D_1B8FCCF5258D#10873,COL_03CB91B0_5FE5_4E2B_A4BF_2F2AB802CFD7#10874,COL_18BE82CA_36B0_4D9C_A92D_0AC713C3A6BD#10875,COL_3730E4D3_45C4_4746_B73A_104BAF5AEAFC#10876,COL_5D83C594_190C_4566_BE6D_E45D569DBAB2#10877,COL_726D968C_42FA_4E31_BD79_225187FD2C06#10878,COL_10B95D56_DF6C_42F5_8A70_C528D8B4F746#10879,COL_2BBF7BDF_E7F0_41C8_9175_AE18220E9267#10880,COL_45927A2C_7B5E_46F0_B288_4E446278061F#10881,COL_BCD576D2_3B47_4169_8ECF_B730E8FE5553#10882,COL_2CFBFB44_139F_45EB_A541_8AA4E91114B3#10883,COL_B8F50996_FC36_4D16_A23F_466BA7D989D5#10884,COL_7B4B67CA_DFB3_40E5_AE69_8EAEE39E1D86#10886,COL_757206DF_B8CF_4236_9B63_51A2C7C2D52F#10887,COL_AC509FFD_CA2F_4EC6_887A_704140CA7926#10888L,COL_0617E11D_4EA9_4E04_BAFA_BCE535C976F5#10890,COL_F704EC97_9B54_4C4F_95BD_92A2D8E74351#10891] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/EVALUATION_QUAL_37976], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_09DD6C48_8262_414D_9D00_17FFFC613E44:string,COL_FF7AF031_054C_4DA5_8B85_7C085A6389A2:i...