== Parsed Logical Plan ==
CreateViewCommand `BASE_RECONCILIA_29344115`, false, true, LocalTempView
+- Project [COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52578 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52777, COL_F7963371_9A10_40EE_879C_C4BE98325956#52561 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#52778, COL_AEEE92C5_F212_4094_B620_ED88D0177315#52576 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#52779, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52575 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52780, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52577 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52781, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52573 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52782, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52574 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52783, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52562 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52784, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52563 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52785, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52564 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52786, COL_5CC2E896_C215_4794_A45A_9945697CAE42#52565 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#52787, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52566 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52788, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52568 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52789, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52571 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52790, COL_5B422905_E031_409E_88DC_80808F8FC3B1#52572 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#52791, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52567 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52792, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52569 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52793, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52570 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52794]
+- Project [COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#52560, COL_F7963371_9A10_40EE_879C_C4BE98325956#52561, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52562, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52563, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52564, COL_5CC2E896_C215_4794_A45A_9945697CAE42#52565, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52566, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52567, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52568, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52569, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52570, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52571, COL_5B422905_E031_409E_88DC_80808F8FC3B1#52572, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52573, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52574, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52575, COL_AEEE92C5_F212_4094_B620_ED88D0177315#52576, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52577, COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52578]
+- Aggregate [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52399, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52400, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52403, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52404, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52405, COL_D67142F7_A207_4870_8963_E237B841636A#52406, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52407, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52408, COL_1C35A227_836A_4477_8139_CAB7258B4395#52409, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52410, COL_15505186_7875_4C25_9AEA_F3510A184E50#52411, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52415, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52416, COL_43DB4E14_8605_40F0_853F_057B052318BE#52413, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52412, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52417, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636], [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52399 AS COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#52560, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52400 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#52561, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52403 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52562, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52404 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52563, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52405 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52564, COL_D67142F7_A207_4870_8963_E237B841636A#52406 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#52565, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52407 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52566, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52408 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52567, COL_1C35A227_836A_4477_8139_CAB7258B4395#52409 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52568, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52410 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52569, COL_15505186_7875_4C25_9AEA_F3510A184E50#52411 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52570, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52415 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52571, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52416 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#52572, COL_43DB4E14_8605_40F0_853F_057B052318BE#52413 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52573, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52574, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52412 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52575, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#52576, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52417 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52577, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52578, 1 AS NULL_1#52631]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52289 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52399, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52290 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52400, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52291 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52401, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52292 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52402, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52293 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52403, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52294 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52404, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52295 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52405, COL_D67142F7_A207_4870_8963_E237B841636A#52296 AS COL_D67142F7_A207_4870_8963_E237B841636A#52406, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52297 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52407, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52298 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52408, COL_1C35A227_836A_4477_8139_CAB7258B4395#52299 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52409, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52300 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52410, COL_15505186_7875_4C25_9AEA_F3510A184E50#52301 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52411, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52302 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52412, COL_43DB4E14_8605_40F0_853F_057B052318BE#52304 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52413, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52305 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52414, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52306 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52415, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52307 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52416, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52303 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52417, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51814 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52289, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51815 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52290, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51816 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52291, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51817 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52292, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51818 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52293, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51819 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52294, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51820 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52295, COL_D67142F7_A207_4870_8963_E237B841636A#51821 AS COL_D67142F7_A207_4870_8963_E237B841636A#52296, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51822 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52297, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51823 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52298, COL_1C35A227_836A_4477_8139_CAB7258B4395#51824 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52299, COL_D171F390_EECB_4924_B2C2_095D45EAE768#51825 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52300, COL_15505186_7875_4C25_9AEA_F3510A184E50#51826 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52301, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51827 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52302, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51828 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52303, COL_43DB4E14_8605_40F0_853F_057B052318BE#52217 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52304, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52218 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52305, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52219 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52306, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52220 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52307, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51814, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51815, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51816, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51817, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51818, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51819, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51820, COL_D67142F7_A207_4870_8963_E237B841636A#51821, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51822, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51823, COL_1C35A227_836A_4477_8139_CAB7258B4395#51824, COL_D171F390_EECB_4924_B2C2_095D45EAE768#51825, COL_15505186_7875_4C25_9AEA_F3510A184E50#51826, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51827, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51828, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636, CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#51950 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52217, CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#51952 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52218, CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#51956 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52219, CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#51957 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52220]
+- Join LeftOuter, (COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51827 = CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#51959)
:- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51635 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51814, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51617 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51815, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51618 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51816, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51619 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51817, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51620 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51818, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51621 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51819, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51622 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51820, COL_D67142F7_A207_4870_8963_E237B841636A#51623 AS COL_D67142F7_A207_4870_8963_E237B841636A#51821, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51624 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51822, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51625 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51823, COL_1C35A227_836A_4477_8139_CAB7258B4395#51626 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#51824, COL_D171F390_EECB_4924_B2C2_095D45EAE768#51627 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#51825, COL_15505186_7875_4C25_9AEA_F3510A184E50#51628 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#51826, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51629 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51827, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51630 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51828, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636]
: +- Project [COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51617, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51618, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51619, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51620, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51621, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51622, COL_D67142F7_A207_4870_8963_E237B841636A#50325 AS COL_D67142F7_A207_4870_8963_E237B841636A#51623, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51624, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51625, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#51626, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#51627, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#51628, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51629, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51630, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954 AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099 AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51285 AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51366 AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51635, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51421 AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51285, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51366, str_transform_case(str_remove_accent(str_replace_extend(COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, 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#51421]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51285, str_split(str_remove_space(COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51285, cast(ONLY_ONE as string)), cast( as string)) AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51366]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099, str_replace_extend(str_replace_regex(COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099, 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#51285]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954, str_replace_extend(str_concat(struct(col1, cast( as string), COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954)), 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#51099]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, str_remove_space(str_replace_extend(str_replace_regex(str_remove_space(str_transform_case(str_remove_accent(COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326), 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#50954]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, 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#50321, 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#50797]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, str_remove_space(str_replace_extend(str_remove_accent(str_transform_case(str_remove_space(COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, 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#50464]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50215 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50216 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50217 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50218 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50219 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50220 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50221 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50222 AS COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50223 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50224 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50225 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50226 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50227 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#50330]
: +- Project [cast(BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50109 as string) AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50215, cast(BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50110 as string) AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50216, cast(BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50111 as string) AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50217, cast(BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50112 as string) AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50218, cast(BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50113 as string) AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50219, cast(BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50114 as string) AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50220, cast(BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50115 as string) AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50221, cast(BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#50116 as string) AS COL_D67142F7_A207_4870_8963_E237B841636A#50222, cast(BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50117 as string) AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50223, cast(BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50118 as string) AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50224, cast(BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#50119 as int) AS COL_1C35A227_836A_4477_8139_CAB7258B4395#50225, cast(BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#50120 as string) AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#50226, cast(BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#50121 as string) AS COL_15505186_7875_4C25_9AEA_F3510A184E50#50227]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#47676 AS BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50109, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#47677 AS BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50110, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#47678 AS BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50111, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#47679 AS BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50112, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#47680 AS BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50113, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#47681 AS BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50114, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#47682 AS BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50115, COL_D67142F7_A207_4870_8963_E237B841636A#47683 AS BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#50116, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#47684 AS BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50117, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#47685 AS BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50118, COL_1C35A227_836A_4477_8139_CAB7258B4395#47686 AS BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#50119, COL_D171F390_EECB_4924_B2C2_095D45EAE768#47687 AS BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#50120, COL_15505186_7875_4C25_9AEA_F3510A184E50#47688 AS BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#50121, COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#47689 AS BASE_RECONCILIA_32037_COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#50122, COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#47690 AS BASE_RECONCILIA_32037_COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#50123, COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#47691 AS BASE_RECONCILIA_32037_COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#50124, COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#47692 AS BASE_RECONCILIA_32037_COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#50125, COL_7097258E_E88A_49F2_831E_C3EE780B3488#47693 AS BASE_RECONCILIA_32037_COL_7097258E_E88A_49F2_831E_C3EE780B3488#50126, COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#47694 AS BASE_RECONCILIA_32037_COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#50127, COL_3AA9677C_9524_43B7_9984_7C0506F35631#47695L AS BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#50128L, COL_E35C77C7_3C81_4648_9449_8217CD8A2230#47696L AS BASE_RECONCILIA_32037_COL_E35C77C7_3C81_4648_9449_8217CD8A2230#50129L, COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#47697 AS BASE_RECONCILIA_32037_COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#50130, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#47698 AS BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#50131, COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#47699L AS BASE_RECONCILIA_32037_COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#50132L, ... 2 more fields]
: +- SubqueryAlias BASE_RECONCILIA_32037115
: +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#47676,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#47677,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#47678,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#47679,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#47680,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#47681,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#47682,COL_D67142F7_A207_4870_8963_E237B841636A#47683,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#47684,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#47685,COL_1C35A227_836A_4477_8139_CAB7258B4395#47686,COL_D171F390_EECB_4924_B2C2_095D45EAE768#47687,COL_15505186_7875_4C25_9AEA_F3510A184E50#47688,COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#47689,COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#47690,COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#47691,COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#47692,COL_7097258E_E88A_49F2_831E_C3EE780B3488#47693,COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#47694,COL_3AA9677C_9524_43B7_9984_7C0506F35631#47695L,COL_E35C77C7_3C81_4648_9449_8217CD8A2230#47696L,COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#47697,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#47698,COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#47699L,... 2 more fields] parquet
+- Project [COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#49751 AS CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#51950, COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#49753 AS CODE_POSTAUX_ET_29368_COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#51951, COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#49755 AS CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#51952, COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#49757 AS CODE_POSTAUX_ET_29368_COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#51953, COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#49759 AS CODE_POSTAUX_ET_29368_COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#51954, COL_751AA3CB_093C_4274_81D1_CD0066B02F57#49761 AS CODE_POSTAUX_ET_29368_COL_751AA3CB_093C_4274_81D1_CD0066B02F57#51955, COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#49763 AS CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#51956, COL_704D2ED6_F724_48C5_9729_DF12E090DF44#49765 AS CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#51957, COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#49767 AS CODE_POSTAUX_ET_29368_COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#51958, COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#49769 AS CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#51959, COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#49771 AS CODE_POSTAUX_ET_29368_COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#51960, COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#49773 AS CODE_POSTAUX_ET_29368_COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#51961]
+- SubqueryAlias CODE_POSTAUX_ET_29368115
+- Relation[COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#49751,COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#49753,COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#49755,COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#49757,COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#49759,COL_751AA3CB_093C_4274_81D1_CD0066B02F57#49761,COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#49763,COL_704D2ED6_F724_48C5_9729_DF12E090DF44#49765,COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#49767,COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#49769,COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#49771,COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#49773] parquet
== Analyzed Logical Plan ==
CreateViewCommand `BASE_RECONCILIA_29344115`, false, true, LocalTempView
+- Project [COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52578 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52777, COL_F7963371_9A10_40EE_879C_C4BE98325956#52561 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#52778, COL_AEEE92C5_F212_4094_B620_ED88D0177315#52576 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#52779, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52575 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52780, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52577 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52781, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52573 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52782, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52574 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52783, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52562 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52784, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52563 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52785, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52564 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52786, COL_5CC2E896_C215_4794_A45A_9945697CAE42#52565 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#52787, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52566 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52788, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52568 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52789, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52571 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52790, COL_5B422905_E031_409E_88DC_80808F8FC3B1#52572 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#52791, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52567 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52792, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52569 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52793, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52570 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52794]
+- Project [COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#52560, COL_F7963371_9A10_40EE_879C_C4BE98325956#52561, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52562, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52563, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52564, COL_5CC2E896_C215_4794_A45A_9945697CAE42#52565, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52566, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52567, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52568, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52569, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52570, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52571, COL_5B422905_E031_409E_88DC_80808F8FC3B1#52572, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52573, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52574, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52575, COL_AEEE92C5_F212_4094_B620_ED88D0177315#52576, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52577, COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52578]
+- Aggregate [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52399, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52400, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52403, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52404, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52405, COL_D67142F7_A207_4870_8963_E237B841636A#52406, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52407, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52408, COL_1C35A227_836A_4477_8139_CAB7258B4395#52409, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52410, COL_15505186_7875_4C25_9AEA_F3510A184E50#52411, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52415, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52416, COL_43DB4E14_8605_40F0_853F_057B052318BE#52413, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52412, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52417, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636], [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52399 AS COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#52560, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52400 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#52561, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52403 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52562, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52404 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52563, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52405 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52564, COL_D67142F7_A207_4870_8963_E237B841636A#52406 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#52565, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52407 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52566, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52408 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52567, COL_1C35A227_836A_4477_8139_CAB7258B4395#52409 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52568, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52410 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52569, COL_15505186_7875_4C25_9AEA_F3510A184E50#52411 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52570, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52415 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52571, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52416 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#52572, COL_43DB4E14_8605_40F0_853F_057B052318BE#52413 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52573, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52574, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52412 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52575, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#52576, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52417 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52577, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52578, 1 AS NULL_1#52631]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52289 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52399, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52290 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52400, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52291 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52401, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52292 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52402, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52293 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52403, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52294 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52404, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52295 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52405, COL_D67142F7_A207_4870_8963_E237B841636A#52296 AS COL_D67142F7_A207_4870_8963_E237B841636A#52406, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52297 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52407, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52298 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52408, COL_1C35A227_836A_4477_8139_CAB7258B4395#52299 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52409, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52300 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52410, COL_15505186_7875_4C25_9AEA_F3510A184E50#52301 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52411, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52302 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52412, COL_43DB4E14_8605_40F0_853F_057B052318BE#52304 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52413, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52305 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52414, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52306 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52415, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52307 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52416, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52303 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52417, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51814 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52289, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51815 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52290, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51816 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52291, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51817 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52292, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51818 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52293, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51819 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52294, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51820 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52295, COL_D67142F7_A207_4870_8963_E237B841636A#51821 AS COL_D67142F7_A207_4870_8963_E237B841636A#52296, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51822 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52297, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51823 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52298, COL_1C35A227_836A_4477_8139_CAB7258B4395#51824 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52299, COL_D171F390_EECB_4924_B2C2_095D45EAE768#51825 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52300, COL_15505186_7875_4C25_9AEA_F3510A184E50#51826 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52301, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51827 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52302, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51828 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52303, COL_43DB4E14_8605_40F0_853F_057B052318BE#52217 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52304, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52218 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52305, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52219 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52306, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52220 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52307, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51814, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51815, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51816, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51817, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51818, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51819, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51820, COL_D67142F7_A207_4870_8963_E237B841636A#51821, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51822, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51823, COL_1C35A227_836A_4477_8139_CAB7258B4395#51824, COL_D171F390_EECB_4924_B2C2_095D45EAE768#51825, COL_15505186_7875_4C25_9AEA_F3510A184E50#51826, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51827, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51828, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636, CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#51950 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52217, CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#51952 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52218, CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#51956 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52219, CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#51957 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52220]
+- Join LeftOuter, (COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51827 = CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#51959)
:- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51635 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51814, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51617 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51815, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51618 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51816, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51619 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51817, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51620 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51818, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51621 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51819, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51622 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51820, COL_D67142F7_A207_4870_8963_E237B841636A#51623 AS COL_D67142F7_A207_4870_8963_E237B841636A#51821, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51624 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51822, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51625 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51823, COL_1C35A227_836A_4477_8139_CAB7258B4395#51626 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#51824, COL_D171F390_EECB_4924_B2C2_095D45EAE768#51627 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#51825, COL_15505186_7875_4C25_9AEA_F3510A184E50#51628 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#51826, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51629 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51827, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51630 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51828, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636]
: +- Project [COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51617, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51618, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51619, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51620, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51621, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51622, COL_D67142F7_A207_4870_8963_E237B841636A#50325 AS COL_D67142F7_A207_4870_8963_E237B841636A#51623, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51624, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51625, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#51626, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#51627, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#51628, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51629, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51630, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954 AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099 AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51285 AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51366 AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51635, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51421 AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51285, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51366, str_transform_case(str_remove_accent(str_replace_extend(COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, 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#51421]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51285, str_split(str_remove_space(COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51285, cast(ONLY_ONE as string)), cast( as string)) AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51366]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099, str_replace_extend(str_replace_regex(COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099, 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#51285]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954, str_replace_extend(str_concat(struct(col1, cast( as string), COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954)), 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#51099]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, str_remove_space(str_replace_extend(str_replace_regex(str_remove_space(str_transform_case(str_remove_accent(COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326), 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#50954]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, 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#50321, 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#50797]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, str_remove_space(str_replace_extend(str_remove_accent(str_transform_case(str_remove_space(COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, 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#50464]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50215 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50216 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50217 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50218 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50219 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50220 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50221 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50222 AS COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50223 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50224 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50225 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50226 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50227 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#50330]
: +- Project [cast(BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50109 as string) AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50215, cast(BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50110 as string) AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50216, cast(BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50111 as string) AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50217, cast(BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50112 as string) AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50218, cast(BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50113 as string) AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50219, cast(BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50114 as string) AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50220, cast(BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50115 as string) AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50221, cast(BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#50116 as string) AS COL_D67142F7_A207_4870_8963_E237B841636A#50222, cast(BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50117 as string) AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50223, cast(BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50118 as string) AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50224, cast(BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#50119 as int) AS COL_1C35A227_836A_4477_8139_CAB7258B4395#50225, cast(BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#50120 as string) AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#50226, cast(BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#50121 as string) AS COL_15505186_7875_4C25_9AEA_F3510A184E50#50227]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#47676 AS BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50109, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#47677 AS BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50110, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#47678 AS BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50111, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#47679 AS BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50112, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#47680 AS BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50113, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#47681 AS BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50114, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#47682 AS BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50115, COL_D67142F7_A207_4870_8963_E237B841636A#47683 AS BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#50116, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#47684 AS BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50117, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#47685 AS BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50118, COL_1C35A227_836A_4477_8139_CAB7258B4395#47686 AS BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#50119, COL_D171F390_EECB_4924_B2C2_095D45EAE768#47687 AS BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#50120, COL_15505186_7875_4C25_9AEA_F3510A184E50#47688 AS BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#50121, COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#47689 AS BASE_RECONCILIA_32037_COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#50122, COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#47690 AS BASE_RECONCILIA_32037_COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#50123, COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#47691 AS BASE_RECONCILIA_32037_COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#50124, COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#47692 AS BASE_RECONCILIA_32037_COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#50125, COL_7097258E_E88A_49F2_831E_C3EE780B3488#47693 AS BASE_RECONCILIA_32037_COL_7097258E_E88A_49F2_831E_C3EE780B3488#50126, COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#47694 AS BASE_RECONCILIA_32037_COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#50127, COL_3AA9677C_9524_43B7_9984_7C0506F35631#47695L AS BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#50128L, COL_E35C77C7_3C81_4648_9449_8217CD8A2230#47696L AS BASE_RECONCILIA_32037_COL_E35C77C7_3C81_4648_9449_8217CD8A2230#50129L, COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#47697 AS BASE_RECONCILIA_32037_COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#50130, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#47698 AS BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#50131, COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#47699L AS BASE_RECONCILIA_32037_COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#50132L, ... 2 more fields]
: +- SubqueryAlias BASE_RECONCILIA_32037115
: +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#47676,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#47677,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#47678,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#47679,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#47680,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#47681,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#47682,COL_D67142F7_A207_4870_8963_E237B841636A#47683,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#47684,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#47685,COL_1C35A227_836A_4477_8139_CAB7258B4395#47686,COL_D171F390_EECB_4924_B2C2_095D45EAE768#47687,COL_15505186_7875_4C25_9AEA_F3510A184E50#47688,COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#47689,COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#47690,COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#47691,COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#47692,COL_7097258E_E88A_49F2_831E_C3EE780B3488#47693,COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#47694,COL_3AA9677C_9524_43B7_9984_7C0506F35631#47695L,COL_E35C77C7_3C81_4648_9449_8217CD8A2230#47696L,COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#47697,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#47698,COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#47699L,... 2 more fields] parquet
+- Project [COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#49751 AS CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#51950, COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#49753 AS CODE_POSTAUX_ET_29368_COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#51951, COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#49755 AS CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#51952, COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#49757 AS CODE_POSTAUX_ET_29368_COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#51953, COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#49759 AS CODE_POSTAUX_ET_29368_COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#51954, COL_751AA3CB_093C_4274_81D1_CD0066B02F57#49761 AS CODE_POSTAUX_ET_29368_COL_751AA3CB_093C_4274_81D1_CD0066B02F57#51955, COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#49763 AS CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#51956, COL_704D2ED6_F724_48C5_9729_DF12E090DF44#49765 AS CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#51957, COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#49767 AS CODE_POSTAUX_ET_29368_COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#51958, COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#49769 AS CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#51959, COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#49771 AS CODE_POSTAUX_ET_29368_COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#51960, COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#49773 AS CODE_POSTAUX_ET_29368_COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#51961]
+- SubqueryAlias CODE_POSTAUX_ET_29368115
+- Relation[COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#49751,COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#49753,COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#49755,COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#49757,COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#49759,COL_751AA3CB_093C_4274_81D1_CD0066B02F57#49761,COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#49763,COL_704D2ED6_F724_48C5_9729_DF12E090DF44#49765,COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#49767,COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#49769,COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#49771,COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#49773] parquet
== Optimized Logical Plan ==
CreateViewCommand `BASE_RECONCILIA_29344115`, false, true, LocalTempView
+- Project [COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52578 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52777, COL_F7963371_9A10_40EE_879C_C4BE98325956#52561 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#52778, COL_AEEE92C5_F212_4094_B620_ED88D0177315#52576 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#52779, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52575 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52780, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52577 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52781, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52573 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52782, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52574 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52783, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52562 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52784, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52563 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52785, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52564 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52786, COL_5CC2E896_C215_4794_A45A_9945697CAE42#52565 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#52787, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52566 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52788, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52568 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52789, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52571 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52790, COL_5B422905_E031_409E_88DC_80808F8FC3B1#52572 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#52791, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52567 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52792, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52569 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52793, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52570 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52794]
+- Project [COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#52560, COL_F7963371_9A10_40EE_879C_C4BE98325956#52561, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52562, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52563, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52564, COL_5CC2E896_C215_4794_A45A_9945697CAE42#52565, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52566, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52567, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52568, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52569, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52570, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52571, COL_5B422905_E031_409E_88DC_80808F8FC3B1#52572, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52573, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52574, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52575, COL_AEEE92C5_F212_4094_B620_ED88D0177315#52576, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52577, COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52578]
+- Aggregate [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52399, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52400, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52403, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52404, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52405, COL_D67142F7_A207_4870_8963_E237B841636A#52406, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52407, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52408, COL_1C35A227_836A_4477_8139_CAB7258B4395#52409, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52410, COL_15505186_7875_4C25_9AEA_F3510A184E50#52411, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52415, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52416, COL_43DB4E14_8605_40F0_853F_057B052318BE#52413, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52412, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52417, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636], [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52399 AS COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#52560, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52400 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#52561, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52403 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52562, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52404 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52563, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52405 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52564, COL_D67142F7_A207_4870_8963_E237B841636A#52406 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#52565, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52407 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52566, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52408 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52567, COL_1C35A227_836A_4477_8139_CAB7258B4395#52409 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52568, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52410 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52569, COL_15505186_7875_4C25_9AEA_F3510A184E50#52411 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52570, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52415 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52571, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52416 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#52572, COL_43DB4E14_8605_40F0_853F_057B052318BE#52413 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52573, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52574, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52412 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52575, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#52576, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52417 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52577, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52578, 1 AS NULL_1#52631]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52289 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52399, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52290 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52400, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52291 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52401, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52292 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52402, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52293 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52403, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52294 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52404, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52295 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52405, COL_D67142F7_A207_4870_8963_E237B841636A#52296 AS COL_D67142F7_A207_4870_8963_E237B841636A#52406, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52297 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52407, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52298 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52408, COL_1C35A227_836A_4477_8139_CAB7258B4395#52299 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52409, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52300 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52410, COL_15505186_7875_4C25_9AEA_F3510A184E50#52301 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52411, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52302 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52412, COL_43DB4E14_8605_40F0_853F_057B052318BE#52304 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52413, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52305 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52414, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52306 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52415, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52307 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52416, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52303 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52417, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51814 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52289, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51815 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52290, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51816 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52291, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51817 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52292, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51818 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52293, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51819 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52294, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51820 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52295, COL_D67142F7_A207_4870_8963_E237B841636A#51821 AS COL_D67142F7_A207_4870_8963_E237B841636A#52296, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51822 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52297, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51823 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52298, COL_1C35A227_836A_4477_8139_CAB7258B4395#51824 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52299, COL_D171F390_EECB_4924_B2C2_095D45EAE768#51825 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52300, COL_15505186_7875_4C25_9AEA_F3510A184E50#51826 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52301, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51827 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52302, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51828 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52303, COL_43DB4E14_8605_40F0_853F_057B052318BE#52217 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52304, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52218 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52305, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52219 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52306, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52220 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52307, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51814, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51815, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51816, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51817, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51818, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51819, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51820, COL_D67142F7_A207_4870_8963_E237B841636A#51821, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51822, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51823, COL_1C35A227_836A_4477_8139_CAB7258B4395#51824, COL_D171F390_EECB_4924_B2C2_095D45EAE768#51825, COL_15505186_7875_4C25_9AEA_F3510A184E50#51826, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51827, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51828, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636, CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#51950 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52217, CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#51952 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52218, CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#51956 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52219, CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#51957 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52220]
+- Join LeftOuter, (COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51827 = CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#51959)
:- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51635 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51814, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51617 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51815, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51618 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51816, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51619 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51817, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51620 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51818, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51621 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51819, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51622 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51820, COL_D67142F7_A207_4870_8963_E237B841636A#51623 AS COL_D67142F7_A207_4870_8963_E237B841636A#51821, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51624 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51822, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51625 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51823, COL_1C35A227_836A_4477_8139_CAB7258B4395#51626 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#51824, COL_D171F390_EECB_4924_B2C2_095D45EAE768#51627 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#51825, COL_15505186_7875_4C25_9AEA_F3510A184E50#51628 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#51826, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51629 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51827, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51630 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51828, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636]
: +- Project [COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51617, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51618, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51619, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51620, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51621, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51622, COL_D67142F7_A207_4870_8963_E237B841636A#50325 AS COL_D67142F7_A207_4870_8963_E237B841636A#51623, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51624, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51625, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#51626, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#51627, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#51628, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51629, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51630, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954 AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099 AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51285 AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51366 AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51635, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51421 AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51285, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51366, str_transform_case(str_remove_accent(str_replace_extend(COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, 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#51421]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51285, str_split(str_remove_space(COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51285, cast(ONLY_ONE as string)), cast( as string)) AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51366]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099, str_replace_extend(str_replace_regex(COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099, 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#51285]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954, str_replace_extend(str_concat(struct(col1, cast( as string), COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954)), 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#51099]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, str_remove_space(str_replace_extend(str_replace_regex(str_remove_space(str_transform_case(str_remove_accent(COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326), 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#50954]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, 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#50321, 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#50797]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, str_remove_space(str_replace_extend(str_remove_accent(str_transform_case(str_remove_space(COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, 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#50464]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50215 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50216 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50217 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50218 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50219 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50220 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50221 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50222 AS COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50223 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50224 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50225 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50226 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50227 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#50330]
: +- Project [cast(BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50109 as string) AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50215, cast(BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50110 as string) AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50216, cast(BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50111 as string) AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50217, cast(BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50112 as string) AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50218, cast(BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50113 as string) AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50219, cast(BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50114 as string) AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50220, cast(BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50115 as string) AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50221, cast(BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#50116 as string) AS COL_D67142F7_A207_4870_8963_E237B841636A#50222, cast(BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50117 as string) AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50223, cast(BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50118 as string) AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50224, cast(BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#50119 as int) AS COL_1C35A227_836A_4477_8139_CAB7258B4395#50225, cast(BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#50120 as string) AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#50226, cast(BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#50121 as string) AS COL_15505186_7875_4C25_9AEA_F3510A184E50#50227]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#47676 AS BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50109, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#47677 AS BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50110, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#47678 AS BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50111, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#47679 AS BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50112, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#47680 AS BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50113, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#47681 AS BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50114, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#47682 AS BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50115, COL_D67142F7_A207_4870_8963_E237B841636A#47683 AS BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#50116, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#47684 AS BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50117, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#47685 AS BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50118, COL_1C35A227_836A_4477_8139_CAB7258B4395#47686 AS BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#50119, COL_D171F390_EECB_4924_B2C2_095D45EAE768#47687 AS BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#50120, COL_15505186_7875_4C25_9AEA_F3510A184E50#47688 AS BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#50121, COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#47689 AS BASE_RECONCILIA_32037_COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#50122, COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#47690 AS BASE_RECONCILIA_32037_COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#50123, COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#47691 AS BASE_RECONCILIA_32037_COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#50124, COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#47692 AS BASE_RECONCILIA_32037_COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#50125, COL_7097258E_E88A_49F2_831E_C3EE780B3488#47693 AS BASE_RECONCILIA_32037_COL_7097258E_E88A_49F2_831E_C3EE780B3488#50126, COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#47694 AS BASE_RECONCILIA_32037_COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#50127, COL_3AA9677C_9524_43B7_9984_7C0506F35631#47695L AS BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#50128L, COL_E35C77C7_3C81_4648_9449_8217CD8A2230#47696L AS BASE_RECONCILIA_32037_COL_E35C77C7_3C81_4648_9449_8217CD8A2230#50129L, COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#47697 AS BASE_RECONCILIA_32037_COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#50130, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#47698 AS BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#50131, COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#47699L AS BASE_RECONCILIA_32037_COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#50132L, ... 2 more fields]
: +- SubqueryAlias BASE_RECONCILIA_32037115
: +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#47676,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#47677,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#47678,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#47679,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#47680,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#47681,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#47682,COL_D67142F7_A207_4870_8963_E237B841636A#47683,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#47684,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#47685,COL_1C35A227_836A_4477_8139_CAB7258B4395#47686,COL_D171F390_EECB_4924_B2C2_095D45EAE768#47687,COL_15505186_7875_4C25_9AEA_F3510A184E50#47688,COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#47689,COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#47690,COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#47691,COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#47692,COL_7097258E_E88A_49F2_831E_C3EE780B3488#47693,COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#47694,COL_3AA9677C_9524_43B7_9984_7C0506F35631#47695L,COL_E35C77C7_3C81_4648_9449_8217CD8A2230#47696L,COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#47697,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#47698,COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#47699L,... 2 more fields] parquet
+- Project [COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#49751 AS CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#51950, COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#49753 AS CODE_POSTAUX_ET_29368_COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#51951, COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#49755 AS CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#51952, COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#49757 AS CODE_POSTAUX_ET_29368_COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#51953, COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#49759 AS CODE_POSTAUX_ET_29368_COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#51954, COL_751AA3CB_093C_4274_81D1_CD0066B02F57#49761 AS CODE_POSTAUX_ET_29368_COL_751AA3CB_093C_4274_81D1_CD0066B02F57#51955, COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#49763 AS CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#51956, COL_704D2ED6_F724_48C5_9729_DF12E090DF44#49765 AS CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#51957, COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#49767 AS CODE_POSTAUX_ET_29368_COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#51958, COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#49769 AS CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#51959, COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#49771 AS CODE_POSTAUX_ET_29368_COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#51960, COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#49773 AS CODE_POSTAUX_ET_29368_COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#51961]
+- SubqueryAlias CODE_POSTAUX_ET_29368115
+- Relation[COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#49751,COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#49753,COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#49755,COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#49757,COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#49759,COL_751AA3CB_093C_4274_81D1_CD0066B02F57#49761,COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#49763,COL_704D2ED6_F724_48C5_9729_DF12E090DF44#49765,COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#49767,COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#49769,COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#49771,COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#49773] parquet
== Physical Plan ==
Execute CreateViewCommand
+- CreateViewCommand `BASE_RECONCILIA_29344115`, false, true, LocalTempView
+- Project [COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52578 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52777, COL_F7963371_9A10_40EE_879C_C4BE98325956#52561 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#52778, COL_AEEE92C5_F212_4094_B620_ED88D0177315#52576 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#52779, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52575 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52780, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52577 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52781, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52573 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52782, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52574 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52783, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52562 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52784, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52563 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52785, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52564 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52786, COL_5CC2E896_C215_4794_A45A_9945697CAE42#52565 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#52787, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52566 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52788, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52568 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52789, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52571 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52790, COL_5B422905_E031_409E_88DC_80808F8FC3B1#52572 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#52791, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52567 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52792, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52569 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52793, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52570 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52794]
+- Project [COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#52560, COL_F7963371_9A10_40EE_879C_C4BE98325956#52561, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52562, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52563, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52564, COL_5CC2E896_C215_4794_A45A_9945697CAE42#52565, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52566, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52567, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52568, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52569, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52570, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52571, COL_5B422905_E031_409E_88DC_80808F8FC3B1#52572, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52573, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52574, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52575, COL_AEEE92C5_F212_4094_B620_ED88D0177315#52576, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52577, COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52578]
+- Aggregate [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52399, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52400, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52403, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52404, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52405, COL_D67142F7_A207_4870_8963_E237B841636A#52406, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52407, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52408, COL_1C35A227_836A_4477_8139_CAB7258B4395#52409, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52410, COL_15505186_7875_4C25_9AEA_F3510A184E50#52411, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52415, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52416, COL_43DB4E14_8605_40F0_853F_057B052318BE#52413, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52412, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52417, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636], [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52399 AS COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#52560, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52400 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#52561, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52403 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52562, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52404 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52563, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52405 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52564, COL_D67142F7_A207_4870_8963_E237B841636A#52406 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#52565, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52407 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52566, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52408 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52567, COL_1C35A227_836A_4477_8139_CAB7258B4395#52409 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52568, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52410 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52569, COL_15505186_7875_4C25_9AEA_F3510A184E50#52411 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52570, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52415 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52571, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52416 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#52572, COL_43DB4E14_8605_40F0_853F_057B052318BE#52413 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52573, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52574, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52412 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52575, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#52576, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52417 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52577, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52578, 1 AS NULL_1#52631]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52289 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52399, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52290 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52400, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52291 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52401, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52292 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52402, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52293 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52403, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52294 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52404, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52295 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52405, COL_D67142F7_A207_4870_8963_E237B841636A#52296 AS COL_D67142F7_A207_4870_8963_E237B841636A#52406, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52297 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52407, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52298 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52408, COL_1C35A227_836A_4477_8139_CAB7258B4395#52299 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52409, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52300 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52410, COL_15505186_7875_4C25_9AEA_F3510A184E50#52301 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52411, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52302 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52412, COL_43DB4E14_8605_40F0_853F_057B052318BE#52304 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52413, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52305 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52414, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52306 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52415, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52307 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52416, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52303 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52417, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51814 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52289, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51815 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52290, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51816 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52291, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51817 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52292, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51818 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52293, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51819 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52294, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51820 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52295, COL_D67142F7_A207_4870_8963_E237B841636A#51821 AS COL_D67142F7_A207_4870_8963_E237B841636A#52296, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51822 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52297, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51823 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52298, COL_1C35A227_836A_4477_8139_CAB7258B4395#51824 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52299, COL_D171F390_EECB_4924_B2C2_095D45EAE768#51825 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52300, COL_15505186_7875_4C25_9AEA_F3510A184E50#51826 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52301, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51827 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52302, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51828 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52303, COL_43DB4E14_8605_40F0_853F_057B052318BE#52217 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52304, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52218 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52305, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52219 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52306, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52220 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52307, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51814, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51815, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51816, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51817, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51818, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51819, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51820, COL_D67142F7_A207_4870_8963_E237B841636A#51821, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51822, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51823, COL_1C35A227_836A_4477_8139_CAB7258B4395#51824, COL_D171F390_EECB_4924_B2C2_095D45EAE768#51825, COL_15505186_7875_4C25_9AEA_F3510A184E50#51826, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51827, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51828, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636, CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#51950 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52217, CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#51952 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52218, CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#51956 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52219, CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#51957 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52220]
+- Join LeftOuter, (COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51827 = CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#51959)
:- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51635 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51814, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51617 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51815, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51618 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51816, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51619 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51817, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51620 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51818, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51621 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51819, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51622 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51820, COL_D67142F7_A207_4870_8963_E237B841636A#51623 AS COL_D67142F7_A207_4870_8963_E237B841636A#51821, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51624 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51822, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51625 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51823, COL_1C35A227_836A_4477_8139_CAB7258B4395#51626 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#51824, COL_D171F390_EECB_4924_B2C2_095D45EAE768#51627 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#51825, COL_15505186_7875_4C25_9AEA_F3510A184E50#51628 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#51826, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51629 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51827, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51630 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51828, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636]
: +- Project [COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51617, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51618, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51619, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51620, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51621, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#51622, COL_D67142F7_A207_4870_8963_E237B841636A#50325 AS COL_D67142F7_A207_4870_8963_E237B841636A#51623, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#51624, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#51625, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#51626, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#51627, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#51628, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#51629, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#51630, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954 AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51631, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099 AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51632, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51285 AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51633, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51366 AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51634, COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#51635, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51421 AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51636]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51285, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51366, str_transform_case(str_remove_accent(str_replace_extend(COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, 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#51421]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51285, str_split(str_remove_space(COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51285, cast(ONLY_ONE as string)), cast( as string)) AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51366]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099, str_replace_extend(str_replace_regex(COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51099, 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#51285]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954, str_replace_extend(str_concat(struct(col1, cast( as string), COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#50954)), 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#51099]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50797, str_remove_space(str_replace_extend(str_replace_regex(str_remove_space(str_transform_case(str_remove_accent(COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326), 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#50954]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50464, 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#50321, 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#50797]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50330, str_remove_space(str_replace_extend(str_remove_accent(str_transform_case(str_remove_space(COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, 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#50464]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50215 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50318, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50216 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50319, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50217 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50320, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50218 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50321, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50219 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50322, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50220 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50323, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50221 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50324, COL_D67142F7_A207_4870_8963_E237B841636A#50222 AS COL_D67142F7_A207_4870_8963_E237B841636A#50325, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50223 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50326, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50224 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50327, COL_1C35A227_836A_4477_8139_CAB7258B4395#50225 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#50328, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50226 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#50329, COL_15505186_7875_4C25_9AEA_F3510A184E50#50227 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#50330]
: +- Project [cast(BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50109 as string) AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50215, cast(BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50110 as string) AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50216, cast(BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50111 as string) AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50217, cast(BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50112 as string) AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50218, cast(BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50113 as string) AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50219, cast(BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50114 as string) AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50220, cast(BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50115 as string) AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50221, cast(BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#50116 as string) AS COL_D67142F7_A207_4870_8963_E237B841636A#50222, cast(BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50117 as string) AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50223, cast(BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50118 as string) AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50224, cast(BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#50119 as int) AS COL_1C35A227_836A_4477_8139_CAB7258B4395#50225, cast(BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#50120 as string) AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#50226, cast(BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#50121 as string) AS COL_15505186_7875_4C25_9AEA_F3510A184E50#50227]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#47676 AS BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50109, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#47677 AS BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50110, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#47678 AS BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50111, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#47679 AS BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50112, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#47680 AS BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50113, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#47681 AS BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50114, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#47682 AS BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50115, COL_D67142F7_A207_4870_8963_E237B841636A#47683 AS BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#50116, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#47684 AS BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50117, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#47685 AS BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50118, COL_1C35A227_836A_4477_8139_CAB7258B4395#47686 AS BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#50119, COL_D171F390_EECB_4924_B2C2_095D45EAE768#47687 AS BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#50120, COL_15505186_7875_4C25_9AEA_F3510A184E50#47688 AS BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#50121, COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#47689 AS BASE_RECONCILIA_32037_COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#50122, COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#47690 AS BASE_RECONCILIA_32037_COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#50123, COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#47691 AS BASE_RECONCILIA_32037_COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#50124, COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#47692 AS BASE_RECONCILIA_32037_COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#50125, COL_7097258E_E88A_49F2_831E_C3EE780B3488#47693 AS BASE_RECONCILIA_32037_COL_7097258E_E88A_49F2_831E_C3EE780B3488#50126, COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#47694 AS BASE_RECONCILIA_32037_COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#50127, COL_3AA9677C_9524_43B7_9984_7C0506F35631#47695L AS BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#50128L, COL_E35C77C7_3C81_4648_9449_8217CD8A2230#47696L AS BASE_RECONCILIA_32037_COL_E35C77C7_3C81_4648_9449_8217CD8A2230#50129L, COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#47697 AS BASE_RECONCILIA_32037_COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#50130, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#47698 AS BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#50131, COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#47699L AS BASE_RECONCILIA_32037_COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#50132L, ... 2 more fields]
: +- SubqueryAlias BASE_RECONCILIA_32037115
: +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#47676,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#47677,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#47678,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#47679,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#47680,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#47681,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#47682,COL_D67142F7_A207_4870_8963_E237B841636A#47683,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#47684,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#47685,COL_1C35A227_836A_4477_8139_CAB7258B4395#47686,COL_D171F390_EECB_4924_B2C2_095D45EAE768#47687,COL_15505186_7875_4C25_9AEA_F3510A184E50#47688,COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#47689,COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#47690,COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#47691,COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#47692,COL_7097258E_E88A_49F2_831E_C3EE780B3488#47693,COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#47694,COL_3AA9677C_9524_43B7_9984_7C0506F35631#47695L,COL_E35C77C7_3C81_4648_9449_8217CD8A2230#47696L,COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#47697,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#47698,COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#47699L,... 2 more fields] parquet
+- Project [COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#49751 AS CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#51950, COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#49753 AS CODE_POSTAUX_ET_29368_COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#51951, COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#49755 AS CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#51952, COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#49757 AS CODE_POSTAUX_ET_29368_COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#51953, COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#49759 AS CODE_POSTAUX_ET_29368_COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#51954, COL_751AA3CB_093C_4274_81D1_CD0066B02F57#49761 AS CODE_POSTAUX_ET_29368_COL_751AA3CB_093C_4274_81D1_CD0066B02F57#51955, COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#49763 AS CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#51956, COL_704D2ED6_F724_48C5_9729_DF12E090DF44#49765 AS CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#51957, COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#49767 AS CODE_POSTAUX_ET_29368_COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#51958, COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#49769 AS CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#51959, COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#49771 AS CODE_POSTAUX_ET_29368_COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#51960, COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#49773 AS CODE_POSTAUX_ET_29368_COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#51961]
+- SubqueryAlias CODE_POSTAUX_ET_29368115
+- Relation[COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#49751,COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#49753,COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#49755,COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#49757,COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#49759,COL_751AA3CB_093C_4274_81D1_CD0066B02F57#49761,COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#49763,COL_704D2ED6_F724_48C5_9729_DF12E090DF44#49765,COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#49767,COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#49769,COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#49771,COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#49773] parquet