DC2 - Details for Query 168

Details for Query 168

Submitted Time: 2025/11/07 08:59:15
Duration: 0 ms
Show the Stage ID and Task ID that corresponds to the max metric
Details
== Parsed Logical Plan ==
CreateViewCommand `BASE_RECONCILIA_29344116`, false, true, LocalTempView
   +- Project [COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#60226 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#60435, COL_F7963371_9A10_40EE_879C_C4BE98325956#60209 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#60436, COL_AEEE92C5_F212_4094_B620_ED88D0177315#60224 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#60437, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#60223 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#60438, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#60225 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#60439, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#60221 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#60440, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#60222 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#60441, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#60210 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#60442, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#60211 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#60443, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#60212 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#60444, COL_5CC2E896_C215_4794_A45A_9945697CAE42#60213 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#60445, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#60214 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#60446, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#60216 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#60447, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#60219 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#60448, COL_5B422905_E031_409E_88DC_80808F8FC3B1#60220 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#60449, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#60215 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#60450, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#60217 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#60451, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#60218 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#60452]
      +- Project [COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#60208, COL_F7963371_9A10_40EE_879C_C4BE98325956#60209, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#60210, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#60211, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#60212, COL_5CC2E896_C215_4794_A45A_9945697CAE42#60213, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#60214, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#60215, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#60216, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#60217, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#60218, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#60219, COL_5B422905_E031_409E_88DC_80808F8FC3B1#60220, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#60221, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#60222, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#60223, COL_AEEE92C5_F212_4094_B620_ED88D0177315#60224, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#60225, COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#60226]
         +- Aggregate [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60131, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60132, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60135, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60136, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60137, COL_D67142F7_A207_4870_8963_E237B841636A#60138, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60139, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60140, COL_1C35A227_836A_4477_8139_CAB7258B4395#60141, COL_D171F390_EECB_4924_B2C2_095D45EAE768#60142, COL_15505186_7875_4C25_9AEA_F3510A184E50#60143, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60147, COL_8753F2C2_5508_43B2_93E7_9030916A7821#60148, COL_43DB4E14_8605_40F0_853F_057B052318BE#60145, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60144, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60149, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229], [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60131 AS COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#60208, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60132 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#60209, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60135 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#60210, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60136 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#60211, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60137 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#60212, COL_D67142F7_A207_4870_8963_E237B841636A#60138 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#60213, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60139 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#60214, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60140 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#60215, COL_1C35A227_836A_4477_8139_CAB7258B4395#60141 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#60216, COL_D171F390_EECB_4924_B2C2_095D45EAE768#60142 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#60217, COL_15505186_7875_4C25_9AEA_F3510A184E50#60143 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#60218, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60147 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#60219, COL_8753F2C2_5508_43B2_93E7_9030916A7821#60148 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#60220, COL_43DB4E14_8605_40F0_853F_057B052318BE#60145 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#60221, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#60222, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60144 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#60223, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#60224, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60149 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#60225, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#60226, 1 AS NULL_1#60251]
            +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60012 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60131, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60013 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60132, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#60014 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#60133, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#60015 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#60134, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60016 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60135, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60017 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60136, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60018 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60137, COL_D67142F7_A207_4870_8963_E237B841636A#60019 AS COL_D67142F7_A207_4870_8963_E237B841636A#60138, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60020 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60139, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60021 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60140, COL_1C35A227_836A_4477_8139_CAB7258B4395#60022 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#60141, COL_D171F390_EECB_4924_B2C2_095D45EAE768#60023 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#60142, COL_15505186_7875_4C25_9AEA_F3510A184E50#60024 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#60143, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60025 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60144, COL_43DB4E14_8605_40F0_853F_057B052318BE#60027 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#60145, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#60028 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#60146, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60029 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60147, COL_8753F2C2_5508_43B2_93E7_9030916A7821#60030 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#60148, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60026 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60149, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229]
               +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59381 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60012, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59382 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60013, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59383 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#60014, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59384 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#60015, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59385 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60016, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59386 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60017, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59387 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60018, COL_D67142F7_A207_4870_8963_E237B841636A#59388 AS COL_D67142F7_A207_4870_8963_E237B841636A#60019, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59389 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60020, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59390 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60021, COL_1C35A227_836A_4477_8139_CAB7258B4395#59391 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#60022, COL_D171F390_EECB_4924_B2C2_095D45EAE768#59392 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#60023, COL_15505186_7875_4C25_9AEA_F3510A184E50#59393 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#60024, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59394 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60025, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59395 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60026, COL_43DB4E14_8605_40F0_853F_057B052318BE#59984 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#60027, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#59985 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#60028, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#59986 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60029, COL_8753F2C2_5508_43B2_93E7_9030916A7821#59987 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#60030, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229]
                  +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59381, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59382, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59383, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59384, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59385, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59386, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59387, COL_D67142F7_A207_4870_8963_E237B841636A#59388, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59389, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59390, COL_1C35A227_836A_4477_8139_CAB7258B4395#59391, COL_D171F390_EECB_4924_B2C2_095D45EAE768#59392, COL_15505186_7875_4C25_9AEA_F3510A184E50#59393, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59394, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59395, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229, CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#59654 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#59984, CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#59656 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#59985, CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#59660 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#59986, CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#59661 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#59987]
                     +- Join LeftOuter, (COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59394 = CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#59663)
                        :- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59228 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59381, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59210 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59382, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59211 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59383, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59212 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59384, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59213 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59385, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59214 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59386, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59215 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59387, COL_D67142F7_A207_4870_8963_E237B841636A#59216 AS COL_D67142F7_A207_4870_8963_E237B841636A#59388, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59217 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59389, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59218 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59390, COL_1C35A227_836A_4477_8139_CAB7258B4395#59219 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#59391, COL_D171F390_EECB_4924_B2C2_095D45EAE768#59220 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#59392, COL_15505186_7875_4C25_9AEA_F3510A184E50#59221 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#59393, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59222 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59394, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59223 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59395, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229]
                        :  +- Project [COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59210, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59211, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59212, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59213, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59214, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59215, COL_D67142F7_A207_4870_8963_E237B841636A#56534 AS COL_D67142F7_A207_4870_8963_E237B841636A#59216, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59217, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59218, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#59219, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#59220, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#59221, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59222, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59223, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607 AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433 AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915 AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59076 AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59228, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59189 AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229]
                        :     +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59076, str_transform_case(str_remove_accent(str_replace_extend(COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, struct(col1, cast(CLIN. VET. as string), col2, cast(CAB. VET. as string), col3, cast(CLIN. VET . as string)), struct(col1, cast(CLINIQUE VETERINAIRE as string), col2, cast(CABINET VETERINAIRE as string), col3, cast(CABINET VETERINAIRE as string)))), cast(UPPER as string)) AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59189]
                        :        +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915, str_split(str_remove_space(COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915, cast(ONLY_ONE as string)), cast(  as string)) AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59076]
                        :           +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433, str_replace_extend(str_replace_regex(COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433, cast([0-9] as string), cast( as string)), struct(col1, cast( AV  as string), col2, cast( DES  as string), col3, cast( DE  as string), col4, cast( DU  as string), col5, cast( L  as string), col6, cast(PL  as string), col7, cast(IMPASSE  as string), col8, cast(IMP  as string), col9, cast(RN  as string), col10, cast( ZA  as string), col11, cast(ZAC  as string), col12, cast(TER  as string)), struct(col1, cast(  as string), col2, cast(  as string), col3, cast(  as string), col4, cast(  as string), col5, cast(  as string), col6, cast(  as string), col7, cast(  as string), col8, cast(  as string), col9, cast(  as string), col10, cast(  as string), col11, cast(  as string), col12, cast(  as string))) AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915]
                        :              +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607, str_replace_extend(str_concat(struct(col1, cast(  as string), COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607)), struct(col1, cast( RTE  as string), col2, cast( RUE  as string), col3, cast( BD  as string), col4, cast( ALL  as string), col5, cast( ALLEE  as string), col6, cast( CHEMIN  as string), col7, cast( CHEM  as string), col8, cast( AV  as string), col9, cast( DE  as string), col10, cast(- as string), col11, cast( LE  as string), col12, cast( LA  as string), ... 6 more fields), struct(col1, cast(  as string), col2, cast(  as string), col3, cast(  as string), col4, cast(  as string), col5, cast(  as string), col6, cast(  as string), col7, cast(  as string), col8, cast(  as string), col9, cast(  as string), col10, cast(  as string), col11, cast(  as string), col12, cast(  as string), ... 6 more fields)) AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433]
                        :                 +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, str_remove_space(str_replace_extend(str_replace_regex(str_remove_space(str_transform_case(str_remove_accent(COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535), cast(UPPER as string)), cast(ONLY_ONE as string)), cast(^CHEMIN  as string), cast(CHEM  as string)), struct(col1, cast(AVENUE  as string), col2, cast(ROUTE  as string), col3, cast(BOULEVARD  as string), col4, cast(PLACE  as string), col5, cast(BIS  as string), col6, cast(ALLEE  as string), col7, cast(' as string), col8, cast(AV.  as string), col9, cast(, as string)), struct(col1, cast(AV  as string), col2, cast(RTE  as string), col3, cast(BD  as string), col4, cast(PL  as string), col5, cast(B   as string), col6, cast(ALL  as string), col7, cast(  as string), col8, cast(AV  as string), col9, cast( as string))), cast(ONLY_ONE as string)) AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607]
                        :                    +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, str_remove_accent(str_transform_case(str_remove_space(str_remove_extend(str_list_as_str(str_extract_by_regex(COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, cast([0-9] as string))), struct(col1, cast([ as string), col2, cast(] as string), col3, cast(, as string), col4, cast(" as string), col5, cast(  as string), col6, cast( as string))), cast(ONLY_ONE as string)), cast(UPPER as string))) AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142]
                        :                       +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, str_remove_space(str_replace_extend(str_remove_accent(str_transform_case(str_remove_space(COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, cast(ONLY_ONE as string)), cast(UPPER as string))), struct(col1, cast(SAINT  as string), col2, cast(SAINTE  as string), col3, cast(- as string), col4, cast(' as string), col5, cast(SAINT- as string), col6, cast(SAINTE- as string)), struct(col1, cast(ST  as string), col2, cast(STE  as string), col3, cast(  as string), col4, cast(  as string), col5, cast(ST  as string), col6, cast(STE  as string))), cast(ONLY_ONE as string)) AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736]
                        :                          +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56461 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56462 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56463 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56464 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56465 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56466 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56467 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56468 AS COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56469 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56470 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56471 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56472 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56473 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#56539]
                        :                             +- Project [cast(BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56158 as string) AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56461, cast(BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56159 as string) AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56462, cast(BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56160 as string) AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56463, cast(BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56161 as string) AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56464, cast(BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56162 as string) AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56465, cast(BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56163 as string) AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56466, cast(BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56164 as string) AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56467, cast(BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#56165 as string) AS COL_D67142F7_A207_4870_8963_E237B841636A#56468, cast(BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56166 as string) AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56469, cast(BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56167 as string) AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56470, cast(BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#56168 as int) AS COL_1C35A227_836A_4477_8139_CAB7258B4395#56471, cast(BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#56169 as string) AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#56472, cast(BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#56170 as string) AS COL_15505186_7875_4C25_9AEA_F3510A184E50#56473]
                        :                                +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#54690 AS BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56158, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#54691 AS BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56159, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#54692 AS BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56160, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#54693 AS BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56161, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#54694 AS BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56162, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#54695 AS BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56163, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#54696 AS BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56164, COL_D67142F7_A207_4870_8963_E237B841636A#54697 AS BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#56165, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#54698 AS BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56166, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#54699 AS BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56167, COL_1C35A227_836A_4477_8139_CAB7258B4395#54700 AS BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#56168, COL_D171F390_EECB_4924_B2C2_095D45EAE768#54701 AS BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#56169, COL_15505186_7875_4C25_9AEA_F3510A184E50#54702 AS BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#56170, COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#54703 AS BASE_RECONCILIA_32037_COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#56171, COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#54704 AS BASE_RECONCILIA_32037_COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#56172, COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#54705 AS BASE_RECONCILIA_32037_COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#56173, COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#54706 AS BASE_RECONCILIA_32037_COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#56174, COL_7097258E_E88A_49F2_831E_C3EE780B3488#54707 AS BASE_RECONCILIA_32037_COL_7097258E_E88A_49F2_831E_C3EE780B3488#56175, COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#54708 AS BASE_RECONCILIA_32037_COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#56176, COL_3AA9677C_9524_43B7_9984_7C0506F35631#54709L AS BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#56177L, COL_E35C77C7_3C81_4648_9449_8217CD8A2230#54710L AS BASE_RECONCILIA_32037_COL_E35C77C7_3C81_4648_9449_8217CD8A2230#56178L, COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#54711 AS BASE_RECONCILIA_32037_COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#56179, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#54712 AS BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#56180, COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#54713L AS BASE_RECONCILIA_32037_COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#56181L, ... 2 more fields]
                        :                                   +- SubqueryAlias BASE_RECONCILIA_32037116
                        :                                      +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#54690,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#54691,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#54692,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#54693,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#54694,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#54695,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#54696,COL_D67142F7_A207_4870_8963_E237B841636A#54697,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#54698,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#54699,COL_1C35A227_836A_4477_8139_CAB7258B4395#54700,COL_D171F390_EECB_4924_B2C2_095D45EAE768#54701,COL_15505186_7875_4C25_9AEA_F3510A184E50#54702,COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#54703,COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#54704,COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#54705,COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#54706,COL_7097258E_E88A_49F2_831E_C3EE780B3488#54707,COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#54708,COL_3AA9677C_9524_43B7_9984_7C0506F35631#54709L,COL_E35C77C7_3C81_4648_9449_8217CD8A2230#54710L,COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#54711,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#54712,COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#54713L,... 2 more fields] parquet
                        +- Project [COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#55871 AS CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#59654, COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#55872 AS CODE_POSTAUX_ET_29368_COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#59655, COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#55873 AS CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#59656, COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#55874 AS CODE_POSTAUX_ET_29368_COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#59657, COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#55875 AS CODE_POSTAUX_ET_29368_COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#59658, COL_751AA3CB_093C_4274_81D1_CD0066B02F57#55876 AS CODE_POSTAUX_ET_29368_COL_751AA3CB_093C_4274_81D1_CD0066B02F57#59659, COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#55877 AS CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#59660, COL_704D2ED6_F724_48C5_9729_DF12E090DF44#55878 AS CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#59661, COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#55879 AS CODE_POSTAUX_ET_29368_COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#59662, COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#55880 AS CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#59663, COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#55881 AS CODE_POSTAUX_ET_29368_COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#59664, COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#55882 AS CODE_POSTAUX_ET_29368_COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#59665]
                           +- SubqueryAlias CODE_POSTAUX_ET_29368116
                              +- Relation[COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#55871,COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#55872,COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#55873,COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#55874,COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#55875,COL_751AA3CB_093C_4274_81D1_CD0066B02F57#55876,COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#55877,COL_704D2ED6_F724_48C5_9729_DF12E090DF44#55878,COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#55879,COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#55880,COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#55881,COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#55882] parquet

== Analyzed Logical Plan ==

CreateViewCommand `BASE_RECONCILIA_29344116`, false, true, LocalTempView
   +- Project [COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#60226 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#60435, COL_F7963371_9A10_40EE_879C_C4BE98325956#60209 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#60436, COL_AEEE92C5_F212_4094_B620_ED88D0177315#60224 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#60437, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#60223 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#60438, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#60225 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#60439, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#60221 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#60440, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#60222 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#60441, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#60210 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#60442, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#60211 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#60443, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#60212 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#60444, COL_5CC2E896_C215_4794_A45A_9945697CAE42#60213 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#60445, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#60214 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#60446, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#60216 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#60447, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#60219 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#60448, COL_5B422905_E031_409E_88DC_80808F8FC3B1#60220 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#60449, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#60215 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#60450, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#60217 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#60451, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#60218 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#60452]
      +- Project [COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#60208, COL_F7963371_9A10_40EE_879C_C4BE98325956#60209, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#60210, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#60211, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#60212, COL_5CC2E896_C215_4794_A45A_9945697CAE42#60213, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#60214, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#60215, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#60216, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#60217, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#60218, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#60219, COL_5B422905_E031_409E_88DC_80808F8FC3B1#60220, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#60221, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#60222, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#60223, COL_AEEE92C5_F212_4094_B620_ED88D0177315#60224, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#60225, COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#60226]
         +- Aggregate [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60131, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60132, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60135, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60136, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60137, COL_D67142F7_A207_4870_8963_E237B841636A#60138, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60139, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60140, COL_1C35A227_836A_4477_8139_CAB7258B4395#60141, COL_D171F390_EECB_4924_B2C2_095D45EAE768#60142, COL_15505186_7875_4C25_9AEA_F3510A184E50#60143, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60147, COL_8753F2C2_5508_43B2_93E7_9030916A7821#60148, COL_43DB4E14_8605_40F0_853F_057B052318BE#60145, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60144, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60149, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229], [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60131 AS COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#60208, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60132 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#60209, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60135 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#60210, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60136 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#60211, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60137 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#60212, COL_D67142F7_A207_4870_8963_E237B841636A#60138 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#60213, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60139 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#60214, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60140 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#60215, COL_1C35A227_836A_4477_8139_CAB7258B4395#60141 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#60216, COL_D171F390_EECB_4924_B2C2_095D45EAE768#60142 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#60217, COL_15505186_7875_4C25_9AEA_F3510A184E50#60143 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#60218, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60147 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#60219, COL_8753F2C2_5508_43B2_93E7_9030916A7821#60148 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#60220, COL_43DB4E14_8605_40F0_853F_057B052318BE#60145 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#60221, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#60222, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60144 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#60223, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#60224, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60149 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#60225, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#60226, 1 AS NULL_1#60251]
            +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60012 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60131, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60013 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60132, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#60014 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#60133, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#60015 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#60134, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60016 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60135, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60017 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60136, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60018 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60137, COL_D67142F7_A207_4870_8963_E237B841636A#60019 AS COL_D67142F7_A207_4870_8963_E237B841636A#60138, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60020 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60139, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60021 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60140, COL_1C35A227_836A_4477_8139_CAB7258B4395#60022 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#60141, COL_D171F390_EECB_4924_B2C2_095D45EAE768#60023 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#60142, COL_15505186_7875_4C25_9AEA_F3510A184E50#60024 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#60143, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60025 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60144, COL_43DB4E14_8605_40F0_853F_057B052318BE#60027 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#60145, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#60028 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#60146, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60029 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60147, COL_8753F2C2_5508_43B2_93E7_9030916A7821#60030 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#60148, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60026 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60149, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229]
               +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59381 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60012, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59382 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60013, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59383 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#60014, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59384 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#60015, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59385 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60016, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59386 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60017, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59387 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60018, COL_D67142F7_A207_4870_8963_E237B841636A#59388 AS COL_D67142F7_A207_4870_8963_E237B841636A#60019, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59389 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60020, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59390 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60021, COL_1C35A227_836A_4477_8139_CAB7258B4395#59391 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#60022, COL_D171F390_EECB_4924_B2C2_095D45EAE768#59392 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#60023, COL_15505186_7875_4C25_9AEA_F3510A184E50#59393 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#60024, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59394 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60025, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59395 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60026, COL_43DB4E14_8605_40F0_853F_057B052318BE#59984 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#60027, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#59985 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#60028, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#59986 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60029, COL_8753F2C2_5508_43B2_93E7_9030916A7821#59987 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#60030, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229]
                  +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59381, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59382, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59383, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59384, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59385, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59386, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59387, COL_D67142F7_A207_4870_8963_E237B841636A#59388, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59389, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59390, COL_1C35A227_836A_4477_8139_CAB7258B4395#59391, COL_D171F390_EECB_4924_B2C2_095D45EAE768#59392, COL_15505186_7875_4C25_9AEA_F3510A184E50#59393, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59394, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59395, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229, CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#59654 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#59984, CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#59656 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#59985, CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#59660 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#59986, CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#59661 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#59987]
                     +- Join LeftOuter, (COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59394 = CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#59663)
                        :- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59228 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59381, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59210 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59382, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59211 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59383, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59212 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59384, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59213 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59385, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59214 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59386, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59215 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59387, COL_D67142F7_A207_4870_8963_E237B841636A#59216 AS COL_D67142F7_A207_4870_8963_E237B841636A#59388, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59217 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59389, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59218 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59390, COL_1C35A227_836A_4477_8139_CAB7258B4395#59219 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#59391, COL_D171F390_EECB_4924_B2C2_095D45EAE768#59220 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#59392, COL_15505186_7875_4C25_9AEA_F3510A184E50#59221 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#59393, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59222 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59394, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59223 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59395, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229]
                        :  +- Project [COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59210, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59211, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59212, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59213, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59214, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59215, COL_D67142F7_A207_4870_8963_E237B841636A#56534 AS COL_D67142F7_A207_4870_8963_E237B841636A#59216, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59217, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59218, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#59219, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#59220, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#59221, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59222, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59223, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607 AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433 AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915 AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59076 AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59228, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59189 AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229]
                        :     +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59076, str_transform_case(str_remove_accent(str_replace_extend(COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, struct(col1, cast(CLIN. VET. as string), col2, cast(CAB. VET. as string), col3, cast(CLIN. VET . as string)), struct(col1, cast(CLINIQUE VETERINAIRE as string), col2, cast(CABINET VETERINAIRE as string), col3, cast(CABINET VETERINAIRE as string)))), cast(UPPER as string)) AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59189]
                        :        +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915, str_split(str_remove_space(COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915, cast(ONLY_ONE as string)), cast(  as string)) AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59076]
                        :           +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433, str_replace_extend(str_replace_regex(COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433, cast([0-9] as string), cast( as string)), struct(col1, cast( AV  as string), col2, cast( DES  as string), col3, cast( DE  as string), col4, cast( DU  as string), col5, cast( L  as string), col6, cast(PL  as string), col7, cast(IMPASSE  as string), col8, cast(IMP  as string), col9, cast(RN  as string), col10, cast( ZA  as string), col11, cast(ZAC  as string), col12, cast(TER  as string)), struct(col1, cast(  as string), col2, cast(  as string), col3, cast(  as string), col4, cast(  as string), col5, cast(  as string), col6, cast(  as string), col7, cast(  as string), col8, cast(  as string), col9, cast(  as string), col10, cast(  as string), col11, cast(  as string), col12, cast(  as string))) AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915]
                        :              +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607, str_replace_extend(str_concat(struct(col1, cast(  as string), COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607)), struct(col1, cast( RTE  as string), col2, cast( RUE  as string), col3, cast( BD  as string), col4, cast( ALL  as string), col5, cast( ALLEE  as string), col6, cast( CHEMIN  as string), col7, cast( CHEM  as string), col8, cast( AV  as string), col9, cast( DE  as string), col10, cast(- as string), col11, cast( LE  as string), col12, cast( LA  as string), ... 6 more fields), struct(col1, cast(  as string), col2, cast(  as string), col3, cast(  as string), col4, cast(  as string), col5, cast(  as string), col6, cast(  as string), col7, cast(  as string), col8, cast(  as string), col9, cast(  as string), col10, cast(  as string), col11, cast(  as string), col12, cast(  as string), ... 6 more fields)) AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433]
                        :                 +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, str_remove_space(str_replace_extend(str_replace_regex(str_remove_space(str_transform_case(str_remove_accent(COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535), cast(UPPER as string)), cast(ONLY_ONE as string)), cast(^CHEMIN  as string), cast(CHEM  as string)), struct(col1, cast(AVENUE  as string), col2, cast(ROUTE  as string), col3, cast(BOULEVARD  as string), col4, cast(PLACE  as string), col5, cast(BIS  as string), col6, cast(ALLEE  as string), col7, cast(' as string), col8, cast(AV.  as string), col9, cast(, as string)), struct(col1, cast(AV  as string), col2, cast(RTE  as string), col3, cast(BD  as string), col4, cast(PL  as string), col5, cast(B   as string), col6, cast(ALL  as string), col7, cast(  as string), col8, cast(AV  as string), col9, cast( as string))), cast(ONLY_ONE as string)) AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607]
                        :                    +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, str_remove_accent(str_transform_case(str_remove_space(str_remove_extend(str_list_as_str(str_extract_by_regex(COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, cast([0-9] as string))), struct(col1, cast([ as string), col2, cast(] as string), col3, cast(, as string), col4, cast(" as string), col5, cast(  as string), col6, cast( as string))), cast(ONLY_ONE as string)), cast(UPPER as string))) AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142]
                        :                       +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, str_remove_space(str_replace_extend(str_remove_accent(str_transform_case(str_remove_space(COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, cast(ONLY_ONE as string)), cast(UPPER as string))), struct(col1, cast(SAINT  as string), col2, cast(SAINTE  as string), col3, cast(- as string), col4, cast(' as string), col5, cast(SAINT- as string), col6, cast(SAINTE- as string)), struct(col1, cast(ST  as string), col2, cast(STE  as string), col3, cast(  as string), col4, cast(  as string), col5, cast(ST  as string), col6, cast(STE  as string))), cast(ONLY_ONE as string)) AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736]
                        :                          +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56461 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56462 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56463 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56464 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56465 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56466 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56467 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56468 AS COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56469 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56470 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56471 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56472 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56473 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#56539]
                        :                             +- Project [cast(BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56158 as string) AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56461, cast(BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56159 as string) AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56462, cast(BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56160 as string) AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56463, cast(BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56161 as string) AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56464, cast(BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56162 as string) AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56465, cast(BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56163 as string) AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56466, cast(BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56164 as string) AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56467, cast(BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#56165 as string) AS COL_D67142F7_A207_4870_8963_E237B841636A#56468, cast(BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56166 as string) AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56469, cast(BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56167 as string) AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56470, cast(BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#56168 as int) AS COL_1C35A227_836A_4477_8139_CAB7258B4395#56471, cast(BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#56169 as string) AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#56472, cast(BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#56170 as string) AS COL_15505186_7875_4C25_9AEA_F3510A184E50#56473]
                        :                                +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#54690 AS BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56158, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#54691 AS BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56159, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#54692 AS BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56160, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#54693 AS BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56161, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#54694 AS BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56162, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#54695 AS BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56163, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#54696 AS BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56164, COL_D67142F7_A207_4870_8963_E237B841636A#54697 AS BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#56165, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#54698 AS BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56166, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#54699 AS BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56167, COL_1C35A227_836A_4477_8139_CAB7258B4395#54700 AS BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#56168, COL_D171F390_EECB_4924_B2C2_095D45EAE768#54701 AS BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#56169, COL_15505186_7875_4C25_9AEA_F3510A184E50#54702 AS BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#56170, COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#54703 AS BASE_RECONCILIA_32037_COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#56171, COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#54704 AS BASE_RECONCILIA_32037_COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#56172, COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#54705 AS BASE_RECONCILIA_32037_COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#56173, COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#54706 AS BASE_RECONCILIA_32037_COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#56174, COL_7097258E_E88A_49F2_831E_C3EE780B3488#54707 AS BASE_RECONCILIA_32037_COL_7097258E_E88A_49F2_831E_C3EE780B3488#56175, COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#54708 AS BASE_RECONCILIA_32037_COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#56176, COL_3AA9677C_9524_43B7_9984_7C0506F35631#54709L AS BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#56177L, COL_E35C77C7_3C81_4648_9449_8217CD8A2230#54710L AS BASE_RECONCILIA_32037_COL_E35C77C7_3C81_4648_9449_8217CD8A2230#56178L, COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#54711 AS BASE_RECONCILIA_32037_COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#56179, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#54712 AS BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#56180, COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#54713L AS BASE_RECONCILIA_32037_COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#56181L, ... 2 more fields]
                        :                                   +- SubqueryAlias BASE_RECONCILIA_32037116
                        :                                      +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#54690,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#54691,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#54692,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#54693,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#54694,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#54695,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#54696,COL_D67142F7_A207_4870_8963_E237B841636A#54697,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#54698,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#54699,COL_1C35A227_836A_4477_8139_CAB7258B4395#54700,COL_D171F390_EECB_4924_B2C2_095D45EAE768#54701,COL_15505186_7875_4C25_9AEA_F3510A184E50#54702,COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#54703,COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#54704,COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#54705,COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#54706,COL_7097258E_E88A_49F2_831E_C3EE780B3488#54707,COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#54708,COL_3AA9677C_9524_43B7_9984_7C0506F35631#54709L,COL_E35C77C7_3C81_4648_9449_8217CD8A2230#54710L,COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#54711,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#54712,COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#54713L,... 2 more fields] parquet
                        +- Project [COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#55871 AS CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#59654, COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#55872 AS CODE_POSTAUX_ET_29368_COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#59655, COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#55873 AS CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#59656, COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#55874 AS CODE_POSTAUX_ET_29368_COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#59657, COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#55875 AS CODE_POSTAUX_ET_29368_COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#59658, COL_751AA3CB_093C_4274_81D1_CD0066B02F57#55876 AS CODE_POSTAUX_ET_29368_COL_751AA3CB_093C_4274_81D1_CD0066B02F57#59659, COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#55877 AS CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#59660, COL_704D2ED6_F724_48C5_9729_DF12E090DF44#55878 AS CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#59661, COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#55879 AS CODE_POSTAUX_ET_29368_COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#59662, COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#55880 AS CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#59663, COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#55881 AS CODE_POSTAUX_ET_29368_COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#59664, COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#55882 AS CODE_POSTAUX_ET_29368_COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#59665]
                           +- SubqueryAlias CODE_POSTAUX_ET_29368116
                              +- Relation[COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#55871,COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#55872,COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#55873,COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#55874,COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#55875,COL_751AA3CB_093C_4274_81D1_CD0066B02F57#55876,COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#55877,COL_704D2ED6_F724_48C5_9729_DF12E090DF44#55878,COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#55879,COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#55880,COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#55881,COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#55882] parquet

== Optimized Logical Plan ==
CreateViewCommand `BASE_RECONCILIA_29344116`, false, true, LocalTempView
   +- Project [COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#60226 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#60435, COL_F7963371_9A10_40EE_879C_C4BE98325956#60209 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#60436, COL_AEEE92C5_F212_4094_B620_ED88D0177315#60224 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#60437, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#60223 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#60438, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#60225 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#60439, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#60221 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#60440, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#60222 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#60441, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#60210 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#60442, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#60211 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#60443, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#60212 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#60444, COL_5CC2E896_C215_4794_A45A_9945697CAE42#60213 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#60445, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#60214 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#60446, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#60216 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#60447, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#60219 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#60448, COL_5B422905_E031_409E_88DC_80808F8FC3B1#60220 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#60449, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#60215 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#60450, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#60217 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#60451, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#60218 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#60452]
      +- Project [COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#60208, COL_F7963371_9A10_40EE_879C_C4BE98325956#60209, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#60210, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#60211, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#60212, COL_5CC2E896_C215_4794_A45A_9945697CAE42#60213, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#60214, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#60215, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#60216, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#60217, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#60218, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#60219, COL_5B422905_E031_409E_88DC_80808F8FC3B1#60220, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#60221, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#60222, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#60223, COL_AEEE92C5_F212_4094_B620_ED88D0177315#60224, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#60225, COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#60226]
         +- Aggregate [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60131, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60132, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60135, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60136, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60137, COL_D67142F7_A207_4870_8963_E237B841636A#60138, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60139, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60140, COL_1C35A227_836A_4477_8139_CAB7258B4395#60141, COL_D171F390_EECB_4924_B2C2_095D45EAE768#60142, COL_15505186_7875_4C25_9AEA_F3510A184E50#60143, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60147, COL_8753F2C2_5508_43B2_93E7_9030916A7821#60148, COL_43DB4E14_8605_40F0_853F_057B052318BE#60145, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60144, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60149, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229], [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60131 AS COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#60208, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60132 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#60209, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60135 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#60210, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60136 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#60211, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60137 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#60212, COL_D67142F7_A207_4870_8963_E237B841636A#60138 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#60213, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60139 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#60214, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60140 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#60215, COL_1C35A227_836A_4477_8139_CAB7258B4395#60141 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#60216, COL_D171F390_EECB_4924_B2C2_095D45EAE768#60142 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#60217, COL_15505186_7875_4C25_9AEA_F3510A184E50#60143 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#60218, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60147 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#60219, COL_8753F2C2_5508_43B2_93E7_9030916A7821#60148 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#60220, COL_43DB4E14_8605_40F0_853F_057B052318BE#60145 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#60221, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#60222, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60144 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#60223, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#60224, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60149 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#60225, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#60226, 1 AS NULL_1#60251]
            +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60012 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60131, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60013 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60132, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#60014 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#60133, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#60015 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#60134, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60016 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60135, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60017 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60136, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60018 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60137, COL_D67142F7_A207_4870_8963_E237B841636A#60019 AS COL_D67142F7_A207_4870_8963_E237B841636A#60138, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60020 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60139, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60021 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60140, COL_1C35A227_836A_4477_8139_CAB7258B4395#60022 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#60141, COL_D171F390_EECB_4924_B2C2_095D45EAE768#60023 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#60142, COL_15505186_7875_4C25_9AEA_F3510A184E50#60024 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#60143, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60025 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60144, COL_43DB4E14_8605_40F0_853F_057B052318BE#60027 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#60145, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#60028 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#60146, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60029 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60147, COL_8753F2C2_5508_43B2_93E7_9030916A7821#60030 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#60148, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60026 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60149, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229]
               +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59381 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60012, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59382 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60013, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59383 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#60014, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59384 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#60015, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59385 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60016, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59386 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60017, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59387 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60018, COL_D67142F7_A207_4870_8963_E237B841636A#59388 AS COL_D67142F7_A207_4870_8963_E237B841636A#60019, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59389 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60020, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59390 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60021, COL_1C35A227_836A_4477_8139_CAB7258B4395#59391 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#60022, COL_D171F390_EECB_4924_B2C2_095D45EAE768#59392 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#60023, COL_15505186_7875_4C25_9AEA_F3510A184E50#59393 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#60024, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59394 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60025, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59395 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60026, COL_43DB4E14_8605_40F0_853F_057B052318BE#59984 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#60027, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#59985 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#60028, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#59986 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60029, COL_8753F2C2_5508_43B2_93E7_9030916A7821#59987 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#60030, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229]
                  +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59381, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59382, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59383, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59384, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59385, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59386, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59387, COL_D67142F7_A207_4870_8963_E237B841636A#59388, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59389, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59390, COL_1C35A227_836A_4477_8139_CAB7258B4395#59391, COL_D171F390_EECB_4924_B2C2_095D45EAE768#59392, COL_15505186_7875_4C25_9AEA_F3510A184E50#59393, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59394, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59395, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229, CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#59654 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#59984, CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#59656 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#59985, CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#59660 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#59986, CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#59661 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#59987]
                     +- Join LeftOuter, (COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59394 = CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#59663)
                        :- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59228 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59381, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59210 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59382, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59211 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59383, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59212 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59384, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59213 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59385, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59214 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59386, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59215 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59387, COL_D67142F7_A207_4870_8963_E237B841636A#59216 AS COL_D67142F7_A207_4870_8963_E237B841636A#59388, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59217 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59389, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59218 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59390, COL_1C35A227_836A_4477_8139_CAB7258B4395#59219 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#59391, COL_D171F390_EECB_4924_B2C2_095D45EAE768#59220 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#59392, COL_15505186_7875_4C25_9AEA_F3510A184E50#59221 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#59393, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59222 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59394, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59223 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59395, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229]
                        :  +- Project [COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59210, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59211, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59212, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59213, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59214, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59215, COL_D67142F7_A207_4870_8963_E237B841636A#56534 AS COL_D67142F7_A207_4870_8963_E237B841636A#59216, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59217, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59218, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#59219, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#59220, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#59221, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59222, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59223, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607 AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433 AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915 AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59076 AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59228, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59189 AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229]
                        :     +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59076, str_transform_case(str_remove_accent(str_replace_extend(COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, struct(col1, cast(CLIN. VET. as string), col2, cast(CAB. VET. as string), col3, cast(CLIN. VET . as string)), struct(col1, cast(CLINIQUE VETERINAIRE as string), col2, cast(CABINET VETERINAIRE as string), col3, cast(CABINET VETERINAIRE as string)))), cast(UPPER as string)) AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59189]
                        :        +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915, str_split(str_remove_space(COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915, cast(ONLY_ONE as string)), cast(  as string)) AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59076]
                        :           +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433, str_replace_extend(str_replace_regex(COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433, cast([0-9] as string), cast( as string)), struct(col1, cast( AV  as string), col2, cast( DES  as string), col3, cast( DE  as string), col4, cast( DU  as string), col5, cast( L  as string), col6, cast(PL  as string), col7, cast(IMPASSE  as string), col8, cast(IMP  as string), col9, cast(RN  as string), col10, cast( ZA  as string), col11, cast(ZAC  as string), col12, cast(TER  as string)), struct(col1, cast(  as string), col2, cast(  as string), col3, cast(  as string), col4, cast(  as string), col5, cast(  as string), col6, cast(  as string), col7, cast(  as string), col8, cast(  as string), col9, cast(  as string), col10, cast(  as string), col11, cast(  as string), col12, cast(  as string))) AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915]
                        :              +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607, str_replace_extend(str_concat(struct(col1, cast(  as string), COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607)), struct(col1, cast( RTE  as string), col2, cast( RUE  as string), col3, cast( BD  as string), col4, cast( ALL  as string), col5, cast( ALLEE  as string), col6, cast( CHEMIN  as string), col7, cast( CHEM  as string), col8, cast( AV  as string), col9, cast( DE  as string), col10, cast(- as string), col11, cast( LE  as string), col12, cast( LA  as string), ... 6 more fields), struct(col1, cast(  as string), col2, cast(  as string), col3, cast(  as string), col4, cast(  as string), col5, cast(  as string), col6, cast(  as string), col7, cast(  as string), col8, cast(  as string), col9, cast(  as string), col10, cast(  as string), col11, cast(  as string), col12, cast(  as string), ... 6 more fields)) AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433]
                        :                 +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, str_remove_space(str_replace_extend(str_replace_regex(str_remove_space(str_transform_case(str_remove_accent(COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535), cast(UPPER as string)), cast(ONLY_ONE as string)), cast(^CHEMIN  as string), cast(CHEM  as string)), struct(col1, cast(AVENUE  as string), col2, cast(ROUTE  as string), col3, cast(BOULEVARD  as string), col4, cast(PLACE  as string), col5, cast(BIS  as string), col6, cast(ALLEE  as string), col7, cast(' as string), col8, cast(AV.  as string), col9, cast(, as string)), struct(col1, cast(AV  as string), col2, cast(RTE  as string), col3, cast(BD  as string), col4, cast(PL  as string), col5, cast(B   as string), col6, cast(ALL  as string), col7, cast(  as string), col8, cast(AV  as string), col9, cast( as string))), cast(ONLY_ONE as string)) AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607]
                        :                    +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, str_remove_accent(str_transform_case(str_remove_space(str_remove_extend(str_list_as_str(str_extract_by_regex(COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, cast([0-9] as string))), struct(col1, cast([ as string), col2, cast(] as string), col3, cast(, as string), col4, cast(" as string), col5, cast(  as string), col6, cast( as string))), cast(ONLY_ONE as string)), cast(UPPER as string))) AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142]
                        :                       +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, str_remove_space(str_replace_extend(str_remove_accent(str_transform_case(str_remove_space(COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, cast(ONLY_ONE as string)), cast(UPPER as string))), struct(col1, cast(SAINT  as string), col2, cast(SAINTE  as string), col3, cast(- as string), col4, cast(' as string), col5, cast(SAINT- as string), col6, cast(SAINTE- as string)), struct(col1, cast(ST  as string), col2, cast(STE  as string), col3, cast(  as string), col4, cast(  as string), col5, cast(ST  as string), col6, cast(STE  as string))), cast(ONLY_ONE as string)) AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736]
                        :                          +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56461 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56462 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56463 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56464 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56465 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56466 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56467 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56468 AS COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56469 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56470 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56471 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56472 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56473 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#56539]
                        :                             +- Project [cast(BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56158 as string) AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56461, cast(BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56159 as string) AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56462, cast(BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56160 as string) AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56463, cast(BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56161 as string) AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56464, cast(BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56162 as string) AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56465, cast(BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56163 as string) AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56466, cast(BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56164 as string) AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56467, cast(BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#56165 as string) AS COL_D67142F7_A207_4870_8963_E237B841636A#56468, cast(BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56166 as string) AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56469, cast(BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56167 as string) AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56470, cast(BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#56168 as int) AS COL_1C35A227_836A_4477_8139_CAB7258B4395#56471, cast(BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#56169 as string) AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#56472, cast(BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#56170 as string) AS COL_15505186_7875_4C25_9AEA_F3510A184E50#56473]
                        :                                +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#54690 AS BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56158, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#54691 AS BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56159, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#54692 AS BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56160, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#54693 AS BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56161, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#54694 AS BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56162, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#54695 AS BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56163, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#54696 AS BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56164, COL_D67142F7_A207_4870_8963_E237B841636A#54697 AS BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#56165, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#54698 AS BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56166, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#54699 AS BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56167, COL_1C35A227_836A_4477_8139_CAB7258B4395#54700 AS BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#56168, COL_D171F390_EECB_4924_B2C2_095D45EAE768#54701 AS BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#56169, COL_15505186_7875_4C25_9AEA_F3510A184E50#54702 AS BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#56170, COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#54703 AS BASE_RECONCILIA_32037_COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#56171, COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#54704 AS BASE_RECONCILIA_32037_COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#56172, COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#54705 AS BASE_RECONCILIA_32037_COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#56173, COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#54706 AS BASE_RECONCILIA_32037_COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#56174, COL_7097258E_E88A_49F2_831E_C3EE780B3488#54707 AS BASE_RECONCILIA_32037_COL_7097258E_E88A_49F2_831E_C3EE780B3488#56175, COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#54708 AS BASE_RECONCILIA_32037_COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#56176, COL_3AA9677C_9524_43B7_9984_7C0506F35631#54709L AS BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#56177L, COL_E35C77C7_3C81_4648_9449_8217CD8A2230#54710L AS BASE_RECONCILIA_32037_COL_E35C77C7_3C81_4648_9449_8217CD8A2230#56178L, COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#54711 AS BASE_RECONCILIA_32037_COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#56179, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#54712 AS BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#56180, COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#54713L AS BASE_RECONCILIA_32037_COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#56181L, ... 2 more fields]
                        :                                   +- SubqueryAlias BASE_RECONCILIA_32037116
                        :                                      +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#54690,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#54691,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#54692,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#54693,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#54694,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#54695,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#54696,COL_D67142F7_A207_4870_8963_E237B841636A#54697,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#54698,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#54699,COL_1C35A227_836A_4477_8139_CAB7258B4395#54700,COL_D171F390_EECB_4924_B2C2_095D45EAE768#54701,COL_15505186_7875_4C25_9AEA_F3510A184E50#54702,COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#54703,COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#54704,COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#54705,COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#54706,COL_7097258E_E88A_49F2_831E_C3EE780B3488#54707,COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#54708,COL_3AA9677C_9524_43B7_9984_7C0506F35631#54709L,COL_E35C77C7_3C81_4648_9449_8217CD8A2230#54710L,COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#54711,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#54712,COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#54713L,... 2 more fields] parquet
                        +- Project [COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#55871 AS CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#59654, COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#55872 AS CODE_POSTAUX_ET_29368_COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#59655, COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#55873 AS CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#59656, COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#55874 AS CODE_POSTAUX_ET_29368_COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#59657, COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#55875 AS CODE_POSTAUX_ET_29368_COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#59658, COL_751AA3CB_093C_4274_81D1_CD0066B02F57#55876 AS CODE_POSTAUX_ET_29368_COL_751AA3CB_093C_4274_81D1_CD0066B02F57#59659, COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#55877 AS CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#59660, COL_704D2ED6_F724_48C5_9729_DF12E090DF44#55878 AS CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#59661, COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#55879 AS CODE_POSTAUX_ET_29368_COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#59662, COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#55880 AS CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#59663, COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#55881 AS CODE_POSTAUX_ET_29368_COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#59664, COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#55882 AS CODE_POSTAUX_ET_29368_COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#59665]
                           +- SubqueryAlias CODE_POSTAUX_ET_29368116
                              +- Relation[COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#55871,COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#55872,COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#55873,COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#55874,COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#55875,COL_751AA3CB_093C_4274_81D1_CD0066B02F57#55876,COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#55877,COL_704D2ED6_F724_48C5_9729_DF12E090DF44#55878,COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#55879,COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#55880,COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#55881,COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#55882] parquet

== Physical Plan ==
Execute CreateViewCommand
   +- CreateViewCommand `BASE_RECONCILIA_29344116`, false, true, LocalTempView
         +- Project [COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#60226 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#60435, COL_F7963371_9A10_40EE_879C_C4BE98325956#60209 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#60436, COL_AEEE92C5_F212_4094_B620_ED88D0177315#60224 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#60437, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#60223 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#60438, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#60225 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#60439, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#60221 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#60440, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#60222 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#60441, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#60210 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#60442, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#60211 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#60443, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#60212 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#60444, COL_5CC2E896_C215_4794_A45A_9945697CAE42#60213 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#60445, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#60214 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#60446, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#60216 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#60447, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#60219 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#60448, COL_5B422905_E031_409E_88DC_80808F8FC3B1#60220 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#60449, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#60215 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#60450, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#60217 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#60451, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#60218 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#60452]
            +- Project [COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#60208, COL_F7963371_9A10_40EE_879C_C4BE98325956#60209, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#60210, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#60211, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#60212, COL_5CC2E896_C215_4794_A45A_9945697CAE42#60213, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#60214, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#60215, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#60216, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#60217, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#60218, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#60219, COL_5B422905_E031_409E_88DC_80808F8FC3B1#60220, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#60221, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#60222, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#60223, COL_AEEE92C5_F212_4094_B620_ED88D0177315#60224, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#60225, COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#60226]
               +- Aggregate [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60131, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60132, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60135, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60136, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60137, COL_D67142F7_A207_4870_8963_E237B841636A#60138, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60139, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60140, COL_1C35A227_836A_4477_8139_CAB7258B4395#60141, COL_D171F390_EECB_4924_B2C2_095D45EAE768#60142, COL_15505186_7875_4C25_9AEA_F3510A184E50#60143, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60147, COL_8753F2C2_5508_43B2_93E7_9030916A7821#60148, COL_43DB4E14_8605_40F0_853F_057B052318BE#60145, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60144, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60149, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229], [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60131 AS COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#60208, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60132 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#60209, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60135 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#60210, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60136 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#60211, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60137 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#60212, COL_D67142F7_A207_4870_8963_E237B841636A#60138 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#60213, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60139 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#60214, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60140 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#60215, COL_1C35A227_836A_4477_8139_CAB7258B4395#60141 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#60216, COL_D171F390_EECB_4924_B2C2_095D45EAE768#60142 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#60217, COL_15505186_7875_4C25_9AEA_F3510A184E50#60143 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#60218, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60147 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#60219, COL_8753F2C2_5508_43B2_93E7_9030916A7821#60148 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#60220, COL_43DB4E14_8605_40F0_853F_057B052318BE#60145 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#60221, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#60222, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60144 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#60223, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#60224, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60149 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#60225, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#60226, 1 AS NULL_1#60251]
                  +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60012 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60131, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60013 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60132, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#60014 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#60133, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#60015 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#60134, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60016 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60135, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60017 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60136, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60018 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60137, COL_D67142F7_A207_4870_8963_E237B841636A#60019 AS COL_D67142F7_A207_4870_8963_E237B841636A#60138, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60020 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60139, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60021 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60140, COL_1C35A227_836A_4477_8139_CAB7258B4395#60022 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#60141, COL_D171F390_EECB_4924_B2C2_095D45EAE768#60023 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#60142, COL_15505186_7875_4C25_9AEA_F3510A184E50#60024 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#60143, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60025 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60144, COL_43DB4E14_8605_40F0_853F_057B052318BE#60027 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#60145, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#60028 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#60146, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60029 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60147, COL_8753F2C2_5508_43B2_93E7_9030916A7821#60030 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#60148, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60026 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60149, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229]
                     +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59381 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#60012, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59382 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#60013, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59383 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#60014, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59384 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#60015, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59385 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#60016, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59386 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#60017, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59387 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#60018, COL_D67142F7_A207_4870_8963_E237B841636A#59388 AS COL_D67142F7_A207_4870_8963_E237B841636A#60019, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59389 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#60020, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59390 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#60021, COL_1C35A227_836A_4477_8139_CAB7258B4395#59391 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#60022, COL_D171F390_EECB_4924_B2C2_095D45EAE768#59392 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#60023, COL_15505186_7875_4C25_9AEA_F3510A184E50#59393 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#60024, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59394 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#60025, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59395 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#60026, COL_43DB4E14_8605_40F0_853F_057B052318BE#59984 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#60027, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#59985 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#60028, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#59986 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#60029, COL_8753F2C2_5508_43B2_93E7_9030916A7821#59987 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#60030, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229]
                        +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59381, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59382, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59383, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59384, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59385, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59386, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59387, COL_D67142F7_A207_4870_8963_E237B841636A#59388, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59389, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59390, COL_1C35A227_836A_4477_8139_CAB7258B4395#59391, COL_D171F390_EECB_4924_B2C2_095D45EAE768#59392, COL_15505186_7875_4C25_9AEA_F3510A184E50#59393, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59394, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59395, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229, CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#59654 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#59984, CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#59656 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#59985, CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#59660 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#59986, CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#59661 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#59987]
                           +- Join LeftOuter, (COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59394 = CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#59663)
                              :- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59228 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59381, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59210 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59382, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59211 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59383, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59212 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59384, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59213 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59385, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59214 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59386, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59215 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59387, COL_D67142F7_A207_4870_8963_E237B841636A#59216 AS COL_D67142F7_A207_4870_8963_E237B841636A#59388, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59217 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59389, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59218 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59390, COL_1C35A227_836A_4477_8139_CAB7258B4395#59219 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#59391, COL_D171F390_EECB_4924_B2C2_095D45EAE768#59220 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#59392, COL_15505186_7875_4C25_9AEA_F3510A184E50#59221 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#59393, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59222 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59394, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59223 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59395, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229]
                              :  +- Project [COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#59210, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#59211, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#59212, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#59213, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#59214, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#59215, COL_D67142F7_A207_4870_8963_E237B841636A#56534 AS COL_D67142F7_A207_4870_8963_E237B841636A#59216, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#59217, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#59218, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#59219, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#59220, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#59221, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#59222, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#59223, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607 AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#59224, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433 AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#59225, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915 AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#59226, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59076 AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59227, COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#59228, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59189 AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59229]
                              :     +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59076, str_transform_case(str_remove_accent(str_replace_extend(COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, struct(col1, cast(CLIN. VET. as string), col2, cast(CAB. VET. as string), col3, cast(CLIN. VET . as string)), struct(col1, cast(CLINIQUE VETERINAIRE as string), col2, cast(CABINET VETERINAIRE as string), col3, cast(CABINET VETERINAIRE as string)))), cast(UPPER as string)) AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#59189]
                              :        +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915, str_split(str_remove_space(COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915, cast(ONLY_ONE as string)), cast(  as string)) AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#59076]
                              :           +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433, str_replace_extend(str_replace_regex(COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433, cast([0-9] as string), cast( as string)), struct(col1, cast( AV  as string), col2, cast( DES  as string), col3, cast( DE  as string), col4, cast( DU  as string), col5, cast( L  as string), col6, cast(PL  as string), col7, cast(IMPASSE  as string), col8, cast(IMP  as string), col9, cast(RN  as string), col10, cast( ZA  as string), col11, cast(ZAC  as string), col12, cast(TER  as string)), struct(col1, cast(  as string), col2, cast(  as string), col3, cast(  as string), col4, cast(  as string), col5, cast(  as string), col6, cast(  as string), col7, cast(  as string), col8, cast(  as string), col9, cast(  as string), col10, cast(  as string), col11, cast(  as string), col12, cast(  as string))) AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#58915]
                              :              +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607, str_replace_extend(str_concat(struct(col1, cast(  as string), COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607)), struct(col1, cast( RTE  as string), col2, cast( RUE  as string), col3, cast( BD  as string), col4, cast( ALL  as string), col5, cast( ALLEE  as string), col6, cast( CHEMIN  as string), col7, cast( CHEM  as string), col8, cast( AV  as string), col9, cast( DE  as string), col10, cast(- as string), col11, cast( LE  as string), col12, cast( LA  as string), ... 6 more fields), struct(col1, cast(  as string), col2, cast(  as string), col3, cast(  as string), col4, cast(  as string), col5, cast(  as string), col6, cast(  as string), col7, cast(  as string), col8, cast(  as string), col9, cast(  as string), col10, cast(  as string), col11, cast(  as string), col12, cast(  as string), ... 6 more fields)) AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#58433]
                              :                 +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142, str_remove_space(str_replace_extend(str_replace_regex(str_remove_space(str_transform_case(str_remove_accent(COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535), cast(UPPER as string)), cast(ONLY_ONE as string)), cast(^CHEMIN  as string), cast(CHEM  as string)), struct(col1, cast(AVENUE  as string), col2, cast(ROUTE  as string), col3, cast(BOULEVARD  as string), col4, cast(PLACE  as string), col5, cast(BIS  as string), col6, cast(ALLEE  as string), col7, cast(' as string), col8, cast(AV.  as string), col9, cast(, as string)), struct(col1, cast(AV  as string), col2, cast(RTE  as string), col3, cast(BD  as string), col4, cast(PL  as string), col5, cast(B   as string), col6, cast(ALL  as string), col7, cast(  as string), col8, cast(AV  as string), col9, cast( as string))), cast(ONLY_ONE as string)) AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#57607]
                              :                    +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736, str_remove_accent(str_transform_case(str_remove_space(str_remove_extend(str_list_as_str(str_extract_by_regex(COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, cast([0-9] as string))), struct(col1, cast([ as string), col2, cast(] as string), col3, cast(, as string), col4, cast(" as string), col5, cast(  as string), col6, cast( as string))), cast(ONLY_ONE as string)), cast(UPPER as string))) AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#57142]
                              :                       +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56539, str_remove_space(str_replace_extend(str_remove_accent(str_transform_case(str_remove_space(COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, cast(ONLY_ONE as string)), cast(UPPER as string))), struct(col1, cast(SAINT  as string), col2, cast(SAINTE  as string), col3, cast(- as string), col4, cast(' as string), col5, cast(SAINT- as string), col6, cast(SAINTE- as string)), struct(col1, cast(ST  as string), col2, cast(STE  as string), col3, cast(  as string), col4, cast(  as string), col5, cast(ST  as string), col6, cast(STE  as string))), cast(ONLY_ONE as string)) AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#56736]
                              :                          +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56461 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56527, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56462 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56528, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56463 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56529, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56464 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56530, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56465 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56531, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56466 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56532, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56467 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56533, COL_D67142F7_A207_4870_8963_E237B841636A#56468 AS COL_D67142F7_A207_4870_8963_E237B841636A#56534, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56469 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56535, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56470 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56536, COL_1C35A227_836A_4477_8139_CAB7258B4395#56471 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#56537, COL_D171F390_EECB_4924_B2C2_095D45EAE768#56472 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#56538, COL_15505186_7875_4C25_9AEA_F3510A184E50#56473 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#56539]
                              :                             +- Project [cast(BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56158 as string) AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56461, cast(BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56159 as string) AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56462, cast(BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56160 as string) AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56463, cast(BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56161 as string) AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56464, cast(BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56162 as string) AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56465, cast(BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56163 as string) AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56466, cast(BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56164 as string) AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56467, cast(BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#56165 as string) AS COL_D67142F7_A207_4870_8963_E237B841636A#56468, cast(BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56166 as string) AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56469, cast(BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56167 as string) AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56470, cast(BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#56168 as int) AS COL_1C35A227_836A_4477_8139_CAB7258B4395#56471, cast(BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#56169 as string) AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#56472, cast(BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#56170 as string) AS COL_15505186_7875_4C25_9AEA_F3510A184E50#56473]
                              :                                +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#54690 AS BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#56158, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#54691 AS BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#56159, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#54692 AS BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#56160, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#54693 AS BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#56161, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#54694 AS BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#56162, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#54695 AS BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#56163, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#54696 AS BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#56164, COL_D67142F7_A207_4870_8963_E237B841636A#54697 AS BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#56165, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#54698 AS BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#56166, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#54699 AS BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#56167, COL_1C35A227_836A_4477_8139_CAB7258B4395#54700 AS BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#56168, COL_D171F390_EECB_4924_B2C2_095D45EAE768#54701 AS BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#56169, COL_15505186_7875_4C25_9AEA_F3510A184E50#54702 AS BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#56170, COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#54703 AS BASE_RECONCILIA_32037_COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#56171, COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#54704 AS BASE_RECONCILIA_32037_COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#56172, COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#54705 AS BASE_RECONCILIA_32037_COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#56173, COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#54706 AS BASE_RECONCILIA_32037_COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#56174, COL_7097258E_E88A_49F2_831E_C3EE780B3488#54707 AS BASE_RECONCILIA_32037_COL_7097258E_E88A_49F2_831E_C3EE780B3488#56175, COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#54708 AS BASE_RECONCILIA_32037_COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#56176, COL_3AA9677C_9524_43B7_9984_7C0506F35631#54709L AS BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#56177L, COL_E35C77C7_3C81_4648_9449_8217CD8A2230#54710L AS BASE_RECONCILIA_32037_COL_E35C77C7_3C81_4648_9449_8217CD8A2230#56178L, COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#54711 AS BASE_RECONCILIA_32037_COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#56179, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#54712 AS BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#56180, COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#54713L AS BASE_RECONCILIA_32037_COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#56181L, ... 2 more fields]
                              :                                   +- SubqueryAlias BASE_RECONCILIA_32037116
                              :                                      +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#54690,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#54691,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#54692,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#54693,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#54694,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#54695,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#54696,COL_D67142F7_A207_4870_8963_E237B841636A#54697,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#54698,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#54699,COL_1C35A227_836A_4477_8139_CAB7258B4395#54700,COL_D171F390_EECB_4924_B2C2_095D45EAE768#54701,COL_15505186_7875_4C25_9AEA_F3510A184E50#54702,COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#54703,COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#54704,COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#54705,COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#54706,COL_7097258E_E88A_49F2_831E_C3EE780B3488#54707,COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#54708,COL_3AA9677C_9524_43B7_9984_7C0506F35631#54709L,COL_E35C77C7_3C81_4648_9449_8217CD8A2230#54710L,COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#54711,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#54712,COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#54713L,... 2 more fields] parquet
                              +- Project [COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#55871 AS CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#59654, COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#55872 AS CODE_POSTAUX_ET_29368_COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#59655, COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#55873 AS CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#59656, COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#55874 AS CODE_POSTAUX_ET_29368_COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#59657, COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#55875 AS CODE_POSTAUX_ET_29368_COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#59658, COL_751AA3CB_093C_4274_81D1_CD0066B02F57#55876 AS CODE_POSTAUX_ET_29368_COL_751AA3CB_093C_4274_81D1_CD0066B02F57#59659, COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#55877 AS CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#59660, COL_704D2ED6_F724_48C5_9729_DF12E090DF44#55878 AS CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#59661, COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#55879 AS CODE_POSTAUX_ET_29368_COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#59662, COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#55880 AS CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#59663, COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#55881 AS CODE_POSTAUX_ET_29368_COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#59664, COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#55882 AS CODE_POSTAUX_ET_29368_COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#59665]
                                 +- SubqueryAlias CODE_POSTAUX_ET_29368116
                                    +- Relation[COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#55871,COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#55872,COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#55873,COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#55874,COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#55875,COL_751AA3CB_093C_4274_81D1_CD0066B02F57#55876,COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#55877,COL_704D2ED6_F724_48C5_9729_DF12E090DF44#55878,COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#55879,COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#55880,COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#55881,COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#55882] parquet