== Parsed Logical Plan ==
CreateViewCommand `BASE_RECONCILIA_29344118`, false, true, LocalTempView
+- Project [COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#46107 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#46172, COL_F7963371_9A10_40EE_879C_C4BE98325956#46090 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#46173, COL_AEEE92C5_F212_4094_B620_ED88D0177315#46105 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#46174, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#46104 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#46175, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#46106 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#46176, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#46102 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#46177, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#46103 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#46178, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#46091 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#46179, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#46092 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#46180, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#46093 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#46181, COL_5CC2E896_C215_4794_A45A_9945697CAE42#46094 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#46182, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#46095 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#46183, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#46097 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#46184, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#46100 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#46185, COL_5B422905_E031_409E_88DC_80808F8FC3B1#46101 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#46186, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#46096 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#46187, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#46098 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#46188, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#46099 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#46189]
+- Project [COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#46089, COL_F7963371_9A10_40EE_879C_C4BE98325956#46090, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#46091, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#46092, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#46093, COL_5CC2E896_C215_4794_A45A_9945697CAE42#46094, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#46095, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#46096, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#46097, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#46098, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#46099, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#46100, COL_5B422905_E031_409E_88DC_80808F8FC3B1#46101, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#46102, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#46103, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#46104, COL_AEEE92C5_F212_4094_B620_ED88D0177315#46105, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#46106, COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#46107]
+- Aggregate [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46046, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46047, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46050, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46051, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46052, COL_D67142F7_A207_4870_8963_E237B841636A#46053, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46054, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46055, COL_1C35A227_836A_4477_8139_CAB7258B4395#46056, COL_D171F390_EECB_4924_B2C2_095D45EAE768#46057, COL_15505186_7875_4C25_9AEA_F3510A184E50#46058, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46062, COL_8753F2C2_5508_43B2_93E7_9030916A7821#46063, COL_43DB4E14_8605_40F0_853F_057B052318BE#46060, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46059, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46064, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651], [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46046 AS COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#46089, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46047 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#46090, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46050 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#46091, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46051 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#46092, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46052 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#46093, COL_D67142F7_A207_4870_8963_E237B841636A#46053 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#46094, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46054 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#46095, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46055 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#46096, COL_1C35A227_836A_4477_8139_CAB7258B4395#46056 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#46097, COL_D171F390_EECB_4924_B2C2_095D45EAE768#46057 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#46098, COL_15505186_7875_4C25_9AEA_F3510A184E50#46058 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#46099, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46062 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#46100, COL_8753F2C2_5508_43B2_93E7_9030916A7821#46063 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#46101, COL_43DB4E14_8605_40F0_853F_057B052318BE#46060 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#46102, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#46103, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46059 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#46104, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#46105, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46064 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#46106, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#46107, 1 AS NULL_1#46132]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46003 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46046, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46004 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46047, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#46005 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#46048, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#46006 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#46049, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46007 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46050, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46008 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46051, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46009 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46052, COL_D67142F7_A207_4870_8963_E237B841636A#46010 AS COL_D67142F7_A207_4870_8963_E237B841636A#46053, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46011 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46054, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46012 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46055, COL_1C35A227_836A_4477_8139_CAB7258B4395#46013 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#46056, COL_D171F390_EECB_4924_B2C2_095D45EAE768#46014 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#46057, COL_15505186_7875_4C25_9AEA_F3510A184E50#46015 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#46058, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46016 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46059, COL_43DB4E14_8605_40F0_853F_057B052318BE#46018 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#46060, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#46019 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#46061, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46020 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46062, COL_8753F2C2_5508_43B2_93E7_9030916A7821#46021 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#46063, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46017 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46064, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45740 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46003, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45741 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46004, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45742 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#46005, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45743 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#46006, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45744 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46007, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45745 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46008, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45746 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46009, COL_D67142F7_A207_4870_8963_E237B841636A#45747 AS COL_D67142F7_A207_4870_8963_E237B841636A#46010, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45748 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46011, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45749 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46012, COL_1C35A227_836A_4477_8139_CAB7258B4395#45750 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#46013, COL_D171F390_EECB_4924_B2C2_095D45EAE768#45751 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#46014, COL_15505186_7875_4C25_9AEA_F3510A184E50#45752 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#46015, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45753 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46016, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45754 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46017, COL_43DB4E14_8605_40F0_853F_057B052318BE#45975 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#46018, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#45976 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#46019, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#45977 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46020, COL_8753F2C2_5508_43B2_93E7_9030916A7821#45978 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#46021, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45740, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45741, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45742, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45743, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45744, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45745, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45746, COL_D67142F7_A207_4870_8963_E237B841636A#45747, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45748, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45749, COL_1C35A227_836A_4477_8139_CAB7258B4395#45750, COL_D171F390_EECB_4924_B2C2_095D45EAE768#45751, COL_15505186_7875_4C25_9AEA_F3510A184E50#45752, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45753, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45754, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651, CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#45821 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#45975, CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#45823 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#45976, CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#45827 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#45977, CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#45828 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#45978]
+- Join LeftOuter, (COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45753 = CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#45830)
:- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45650 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45740, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45632 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45741, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45633 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45742, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45634 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45743, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45635 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45744, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45636 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45745, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45637 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45746, COL_D67142F7_A207_4870_8963_E237B841636A#45638 AS COL_D67142F7_A207_4870_8963_E237B841636A#45747, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45639 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45748, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45640 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45749, COL_1C35A227_836A_4477_8139_CAB7258B4395#45641 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#45750, COL_D171F390_EECB_4924_B2C2_095D45EAE768#45642 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#45751, COL_15505186_7875_4C25_9AEA_F3510A184E50#45643 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#45752, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45644 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45753, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45645 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45754, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651]
: +- Project [COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45632, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45633, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45634, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45635, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45636, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45637, COL_D67142F7_A207_4870_8963_E237B841636A#44761 AS COL_D67142F7_A207_4870_8963_E237B841636A#45638, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45639, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45640, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#45641, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#45642, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#45643, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45644, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45645, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857 AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314 AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45436 AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45523 AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45650, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45577 AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45436, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45523, str_transform_case(str_remove_accent(str_replace_extend(COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, 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#45577]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45436, str_split(str_remove_space(COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45436, cast(ONLY_ONE as string)), cast( as string)) AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45523]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314, str_replace_extend(str_replace_regex(COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314, 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#45436]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857, str_replace_extend(str_concat(struct(col1, cast( as string), COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857)), 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#45314]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, str_remove_space(str_replace_extend(str_replace_regex(str_remove_space(str_transform_case(str_remove_accent(COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762), 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#44857]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, 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#44757, 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#44841]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, str_remove_space(str_replace_extend(str_remove_accent(str_transform_case(str_remove_space(COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, 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#44811]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44695 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44696 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44697 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44698 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44699 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44700 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44701 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44702 AS COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44703 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44704 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44705 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44706 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44707 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#44766]
: +- Project [cast(BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44567 as string) AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44695, cast(BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44568 as string) AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44696, cast(BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44569 as string) AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44697, cast(BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44570 as string) AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44698, cast(BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44571 as string) AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44699, cast(BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44572 as string) AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44700, cast(BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44573 as string) AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44701, cast(BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#44574 as string) AS COL_D67142F7_A207_4870_8963_E237B841636A#44702, cast(BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44575 as string) AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44703, cast(BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44576 as string) AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44704, cast(BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#44577 as int) AS COL_1C35A227_836A_4477_8139_CAB7258B4395#44705, cast(BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#44578 as string) AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#44706, cast(BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#44579 as string) AS COL_15505186_7875_4C25_9AEA_F3510A184E50#44707]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#43199 AS BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44567, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#43200 AS BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44568, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#43201 AS BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44569, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#43202 AS BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44570, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#43203 AS BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44571, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#43204 AS BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44572, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#43205 AS BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44573, COL_D67142F7_A207_4870_8963_E237B841636A#43206 AS BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#44574, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#43207 AS BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44575, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#43208 AS BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44576, COL_1C35A227_836A_4477_8139_CAB7258B4395#43209 AS BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#44577, COL_D171F390_EECB_4924_B2C2_095D45EAE768#43210 AS BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#44578, COL_15505186_7875_4C25_9AEA_F3510A184E50#43211 AS BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#44579, COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#43212 AS BASE_RECONCILIA_32037_COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#44580, COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#43213 AS BASE_RECONCILIA_32037_COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#44581, COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#43214 AS BASE_RECONCILIA_32037_COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#44582, COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#43215 AS BASE_RECONCILIA_32037_COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#44583, COL_7097258E_E88A_49F2_831E_C3EE780B3488#43216 AS BASE_RECONCILIA_32037_COL_7097258E_E88A_49F2_831E_C3EE780B3488#44584, COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#43217 AS BASE_RECONCILIA_32037_COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#44585, COL_3AA9677C_9524_43B7_9984_7C0506F35631#43218L AS BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#44586L, COL_E35C77C7_3C81_4648_9449_8217CD8A2230#43219L AS BASE_RECONCILIA_32037_COL_E35C77C7_3C81_4648_9449_8217CD8A2230#44587L, COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#43220 AS BASE_RECONCILIA_32037_COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#44588, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#43221 AS BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#44589, COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#43222L AS BASE_RECONCILIA_32037_COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#44590L, ... 2 more fields]
: +- SubqueryAlias BASE_RECONCILIA_32037118
: +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#43199,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#43200,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#43201,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#43202,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#43203,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#43204,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#43205,COL_D67142F7_A207_4870_8963_E237B841636A#43206,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#43207,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#43208,COL_1C35A227_836A_4477_8139_CAB7258B4395#43209,COL_D171F390_EECB_4924_B2C2_095D45EAE768#43210,COL_15505186_7875_4C25_9AEA_F3510A184E50#43211,COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#43212,COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#43213,COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#43214,COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#43215,COL_7097258E_E88A_49F2_831E_C3EE780B3488#43216,COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#43217,COL_3AA9677C_9524_43B7_9984_7C0506F35631#43218L,COL_E35C77C7_3C81_4648_9449_8217CD8A2230#43219L,COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#43220,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#43221,COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#43222L,... 2 more fields] parquet
+- Project [COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#44310 AS CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#45821, COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#44311 AS CODE_POSTAUX_ET_29368_COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#45822, COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#44312 AS CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#45823, COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#44313 AS CODE_POSTAUX_ET_29368_COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#45824, COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#44314 AS CODE_POSTAUX_ET_29368_COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#45825, COL_751AA3CB_093C_4274_81D1_CD0066B02F57#44315 AS CODE_POSTAUX_ET_29368_COL_751AA3CB_093C_4274_81D1_CD0066B02F57#45826, COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#44316 AS CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#45827, COL_704D2ED6_F724_48C5_9729_DF12E090DF44#44317 AS CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#45828, COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#44318 AS CODE_POSTAUX_ET_29368_COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#45829, COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#44319 AS CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#45830, COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#44320 AS CODE_POSTAUX_ET_29368_COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#45831, COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#44321 AS CODE_POSTAUX_ET_29368_COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#45832]
+- SubqueryAlias CODE_POSTAUX_ET_29368118
+- Relation[COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#44310,COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#44311,COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#44312,COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#44313,COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#44314,COL_751AA3CB_093C_4274_81D1_CD0066B02F57#44315,COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#44316,COL_704D2ED6_F724_48C5_9729_DF12E090DF44#44317,COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#44318,COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#44319,COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#44320,COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#44321] parquet
== Analyzed Logical Plan ==
CreateViewCommand `BASE_RECONCILIA_29344118`, false, true, LocalTempView
+- Project [COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#46107 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#46172, COL_F7963371_9A10_40EE_879C_C4BE98325956#46090 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#46173, COL_AEEE92C5_F212_4094_B620_ED88D0177315#46105 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#46174, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#46104 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#46175, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#46106 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#46176, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#46102 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#46177, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#46103 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#46178, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#46091 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#46179, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#46092 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#46180, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#46093 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#46181, COL_5CC2E896_C215_4794_A45A_9945697CAE42#46094 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#46182, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#46095 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#46183, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#46097 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#46184, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#46100 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#46185, COL_5B422905_E031_409E_88DC_80808F8FC3B1#46101 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#46186, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#46096 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#46187, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#46098 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#46188, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#46099 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#46189]
+- Project [COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#46089, COL_F7963371_9A10_40EE_879C_C4BE98325956#46090, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#46091, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#46092, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#46093, COL_5CC2E896_C215_4794_A45A_9945697CAE42#46094, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#46095, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#46096, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#46097, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#46098, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#46099, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#46100, COL_5B422905_E031_409E_88DC_80808F8FC3B1#46101, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#46102, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#46103, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#46104, COL_AEEE92C5_F212_4094_B620_ED88D0177315#46105, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#46106, COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#46107]
+- Aggregate [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46046, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46047, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46050, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46051, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46052, COL_D67142F7_A207_4870_8963_E237B841636A#46053, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46054, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46055, COL_1C35A227_836A_4477_8139_CAB7258B4395#46056, COL_D171F390_EECB_4924_B2C2_095D45EAE768#46057, COL_15505186_7875_4C25_9AEA_F3510A184E50#46058, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46062, COL_8753F2C2_5508_43B2_93E7_9030916A7821#46063, COL_43DB4E14_8605_40F0_853F_057B052318BE#46060, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46059, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46064, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651], [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46046 AS COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#46089, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46047 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#46090, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46050 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#46091, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46051 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#46092, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46052 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#46093, COL_D67142F7_A207_4870_8963_E237B841636A#46053 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#46094, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46054 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#46095, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46055 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#46096, COL_1C35A227_836A_4477_8139_CAB7258B4395#46056 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#46097, COL_D171F390_EECB_4924_B2C2_095D45EAE768#46057 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#46098, COL_15505186_7875_4C25_9AEA_F3510A184E50#46058 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#46099, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46062 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#46100, COL_8753F2C2_5508_43B2_93E7_9030916A7821#46063 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#46101, COL_43DB4E14_8605_40F0_853F_057B052318BE#46060 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#46102, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#46103, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46059 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#46104, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#46105, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46064 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#46106, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#46107, 1 AS NULL_1#46132]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46003 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46046, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46004 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46047, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#46005 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#46048, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#46006 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#46049, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46007 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46050, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46008 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46051, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46009 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46052, COL_D67142F7_A207_4870_8963_E237B841636A#46010 AS COL_D67142F7_A207_4870_8963_E237B841636A#46053, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46011 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46054, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46012 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46055, COL_1C35A227_836A_4477_8139_CAB7258B4395#46013 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#46056, COL_D171F390_EECB_4924_B2C2_095D45EAE768#46014 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#46057, COL_15505186_7875_4C25_9AEA_F3510A184E50#46015 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#46058, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46016 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46059, COL_43DB4E14_8605_40F0_853F_057B052318BE#46018 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#46060, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#46019 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#46061, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46020 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46062, COL_8753F2C2_5508_43B2_93E7_9030916A7821#46021 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#46063, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46017 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46064, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45740 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46003, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45741 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46004, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45742 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#46005, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45743 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#46006, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45744 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46007, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45745 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46008, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45746 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46009, COL_D67142F7_A207_4870_8963_E237B841636A#45747 AS COL_D67142F7_A207_4870_8963_E237B841636A#46010, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45748 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46011, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45749 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46012, COL_1C35A227_836A_4477_8139_CAB7258B4395#45750 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#46013, COL_D171F390_EECB_4924_B2C2_095D45EAE768#45751 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#46014, COL_15505186_7875_4C25_9AEA_F3510A184E50#45752 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#46015, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45753 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46016, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45754 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46017, COL_43DB4E14_8605_40F0_853F_057B052318BE#45975 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#46018, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#45976 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#46019, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#45977 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46020, COL_8753F2C2_5508_43B2_93E7_9030916A7821#45978 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#46021, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45740, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45741, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45742, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45743, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45744, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45745, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45746, COL_D67142F7_A207_4870_8963_E237B841636A#45747, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45748, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45749, COL_1C35A227_836A_4477_8139_CAB7258B4395#45750, COL_D171F390_EECB_4924_B2C2_095D45EAE768#45751, COL_15505186_7875_4C25_9AEA_F3510A184E50#45752, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45753, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45754, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651, CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#45821 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#45975, CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#45823 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#45976, CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#45827 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#45977, CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#45828 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#45978]
+- Join LeftOuter, (COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45753 = CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#45830)
:- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45650 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45740, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45632 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45741, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45633 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45742, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45634 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45743, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45635 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45744, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45636 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45745, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45637 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45746, COL_D67142F7_A207_4870_8963_E237B841636A#45638 AS COL_D67142F7_A207_4870_8963_E237B841636A#45747, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45639 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45748, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45640 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45749, COL_1C35A227_836A_4477_8139_CAB7258B4395#45641 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#45750, COL_D171F390_EECB_4924_B2C2_095D45EAE768#45642 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#45751, COL_15505186_7875_4C25_9AEA_F3510A184E50#45643 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#45752, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45644 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45753, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45645 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45754, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651]
: +- Project [COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45632, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45633, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45634, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45635, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45636, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45637, COL_D67142F7_A207_4870_8963_E237B841636A#44761 AS COL_D67142F7_A207_4870_8963_E237B841636A#45638, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45639, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45640, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#45641, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#45642, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#45643, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45644, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45645, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857 AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314 AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45436 AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45523 AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45650, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45577 AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45436, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45523, str_transform_case(str_remove_accent(str_replace_extend(COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, 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#45577]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45436, str_split(str_remove_space(COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45436, cast(ONLY_ONE as string)), cast( as string)) AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45523]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314, str_replace_extend(str_replace_regex(COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314, 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#45436]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857, str_replace_extend(str_concat(struct(col1, cast( as string), COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857)), 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#45314]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, str_remove_space(str_replace_extend(str_replace_regex(str_remove_space(str_transform_case(str_remove_accent(COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762), 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#44857]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, 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#44757, 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#44841]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, str_remove_space(str_replace_extend(str_remove_accent(str_transform_case(str_remove_space(COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, 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#44811]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44695 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44696 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44697 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44698 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44699 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44700 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44701 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44702 AS COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44703 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44704 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44705 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44706 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44707 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#44766]
: +- Project [cast(BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44567 as string) AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44695, cast(BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44568 as string) AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44696, cast(BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44569 as string) AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44697, cast(BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44570 as string) AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44698, cast(BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44571 as string) AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44699, cast(BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44572 as string) AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44700, cast(BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44573 as string) AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44701, cast(BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#44574 as string) AS COL_D67142F7_A207_4870_8963_E237B841636A#44702, cast(BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44575 as string) AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44703, cast(BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44576 as string) AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44704, cast(BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#44577 as int) AS COL_1C35A227_836A_4477_8139_CAB7258B4395#44705, cast(BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#44578 as string) AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#44706, cast(BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#44579 as string) AS COL_15505186_7875_4C25_9AEA_F3510A184E50#44707]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#43199 AS BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44567, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#43200 AS BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44568, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#43201 AS BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44569, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#43202 AS BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44570, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#43203 AS BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44571, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#43204 AS BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44572, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#43205 AS BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44573, COL_D67142F7_A207_4870_8963_E237B841636A#43206 AS BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#44574, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#43207 AS BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44575, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#43208 AS BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44576, COL_1C35A227_836A_4477_8139_CAB7258B4395#43209 AS BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#44577, COL_D171F390_EECB_4924_B2C2_095D45EAE768#43210 AS BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#44578, COL_15505186_7875_4C25_9AEA_F3510A184E50#43211 AS BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#44579, COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#43212 AS BASE_RECONCILIA_32037_COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#44580, COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#43213 AS BASE_RECONCILIA_32037_COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#44581, COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#43214 AS BASE_RECONCILIA_32037_COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#44582, COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#43215 AS BASE_RECONCILIA_32037_COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#44583, COL_7097258E_E88A_49F2_831E_C3EE780B3488#43216 AS BASE_RECONCILIA_32037_COL_7097258E_E88A_49F2_831E_C3EE780B3488#44584, COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#43217 AS BASE_RECONCILIA_32037_COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#44585, COL_3AA9677C_9524_43B7_9984_7C0506F35631#43218L AS BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#44586L, COL_E35C77C7_3C81_4648_9449_8217CD8A2230#43219L AS BASE_RECONCILIA_32037_COL_E35C77C7_3C81_4648_9449_8217CD8A2230#44587L, COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#43220 AS BASE_RECONCILIA_32037_COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#44588, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#43221 AS BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#44589, COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#43222L AS BASE_RECONCILIA_32037_COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#44590L, ... 2 more fields]
: +- SubqueryAlias BASE_RECONCILIA_32037118
: +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#43199,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#43200,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#43201,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#43202,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#43203,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#43204,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#43205,COL_D67142F7_A207_4870_8963_E237B841636A#43206,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#43207,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#43208,COL_1C35A227_836A_4477_8139_CAB7258B4395#43209,COL_D171F390_EECB_4924_B2C2_095D45EAE768#43210,COL_15505186_7875_4C25_9AEA_F3510A184E50#43211,COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#43212,COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#43213,COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#43214,COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#43215,COL_7097258E_E88A_49F2_831E_C3EE780B3488#43216,COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#43217,COL_3AA9677C_9524_43B7_9984_7C0506F35631#43218L,COL_E35C77C7_3C81_4648_9449_8217CD8A2230#43219L,COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#43220,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#43221,COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#43222L,... 2 more fields] parquet
+- Project [COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#44310 AS CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#45821, COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#44311 AS CODE_POSTAUX_ET_29368_COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#45822, COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#44312 AS CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#45823, COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#44313 AS CODE_POSTAUX_ET_29368_COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#45824, COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#44314 AS CODE_POSTAUX_ET_29368_COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#45825, COL_751AA3CB_093C_4274_81D1_CD0066B02F57#44315 AS CODE_POSTAUX_ET_29368_COL_751AA3CB_093C_4274_81D1_CD0066B02F57#45826, COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#44316 AS CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#45827, COL_704D2ED6_F724_48C5_9729_DF12E090DF44#44317 AS CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#45828, COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#44318 AS CODE_POSTAUX_ET_29368_COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#45829, COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#44319 AS CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#45830, COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#44320 AS CODE_POSTAUX_ET_29368_COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#45831, COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#44321 AS CODE_POSTAUX_ET_29368_COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#45832]
+- SubqueryAlias CODE_POSTAUX_ET_29368118
+- Relation[COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#44310,COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#44311,COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#44312,COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#44313,COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#44314,COL_751AA3CB_093C_4274_81D1_CD0066B02F57#44315,COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#44316,COL_704D2ED6_F724_48C5_9729_DF12E090DF44#44317,COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#44318,COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#44319,COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#44320,COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#44321] parquet
== Optimized Logical Plan ==
CreateViewCommand `BASE_RECONCILIA_29344118`, false, true, LocalTempView
+- Project [COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#46107 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#46172, COL_F7963371_9A10_40EE_879C_C4BE98325956#46090 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#46173, COL_AEEE92C5_F212_4094_B620_ED88D0177315#46105 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#46174, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#46104 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#46175, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#46106 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#46176, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#46102 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#46177, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#46103 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#46178, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#46091 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#46179, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#46092 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#46180, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#46093 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#46181, COL_5CC2E896_C215_4794_A45A_9945697CAE42#46094 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#46182, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#46095 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#46183, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#46097 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#46184, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#46100 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#46185, COL_5B422905_E031_409E_88DC_80808F8FC3B1#46101 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#46186, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#46096 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#46187, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#46098 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#46188, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#46099 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#46189]
+- Project [COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#46089, COL_F7963371_9A10_40EE_879C_C4BE98325956#46090, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#46091, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#46092, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#46093, COL_5CC2E896_C215_4794_A45A_9945697CAE42#46094, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#46095, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#46096, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#46097, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#46098, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#46099, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#46100, COL_5B422905_E031_409E_88DC_80808F8FC3B1#46101, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#46102, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#46103, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#46104, COL_AEEE92C5_F212_4094_B620_ED88D0177315#46105, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#46106, COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#46107]
+- Aggregate [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46046, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46047, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46050, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46051, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46052, COL_D67142F7_A207_4870_8963_E237B841636A#46053, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46054, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46055, COL_1C35A227_836A_4477_8139_CAB7258B4395#46056, COL_D171F390_EECB_4924_B2C2_095D45EAE768#46057, COL_15505186_7875_4C25_9AEA_F3510A184E50#46058, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46062, COL_8753F2C2_5508_43B2_93E7_9030916A7821#46063, COL_43DB4E14_8605_40F0_853F_057B052318BE#46060, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46059, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46064, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651], [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46046 AS COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#46089, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46047 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#46090, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46050 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#46091, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46051 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#46092, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46052 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#46093, COL_D67142F7_A207_4870_8963_E237B841636A#46053 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#46094, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46054 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#46095, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46055 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#46096, COL_1C35A227_836A_4477_8139_CAB7258B4395#46056 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#46097, COL_D171F390_EECB_4924_B2C2_095D45EAE768#46057 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#46098, COL_15505186_7875_4C25_9AEA_F3510A184E50#46058 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#46099, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46062 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#46100, COL_8753F2C2_5508_43B2_93E7_9030916A7821#46063 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#46101, COL_43DB4E14_8605_40F0_853F_057B052318BE#46060 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#46102, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#46103, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46059 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#46104, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#46105, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46064 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#46106, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#46107, 1 AS NULL_1#46132]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46003 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46046, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46004 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46047, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#46005 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#46048, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#46006 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#46049, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46007 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46050, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46008 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46051, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46009 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46052, COL_D67142F7_A207_4870_8963_E237B841636A#46010 AS COL_D67142F7_A207_4870_8963_E237B841636A#46053, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46011 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46054, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46012 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46055, COL_1C35A227_836A_4477_8139_CAB7258B4395#46013 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#46056, COL_D171F390_EECB_4924_B2C2_095D45EAE768#46014 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#46057, COL_15505186_7875_4C25_9AEA_F3510A184E50#46015 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#46058, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46016 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46059, COL_43DB4E14_8605_40F0_853F_057B052318BE#46018 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#46060, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#46019 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#46061, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46020 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46062, COL_8753F2C2_5508_43B2_93E7_9030916A7821#46021 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#46063, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46017 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46064, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45740 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46003, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45741 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46004, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45742 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#46005, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45743 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#46006, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45744 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46007, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45745 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46008, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45746 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46009, COL_D67142F7_A207_4870_8963_E237B841636A#45747 AS COL_D67142F7_A207_4870_8963_E237B841636A#46010, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45748 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46011, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45749 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46012, COL_1C35A227_836A_4477_8139_CAB7258B4395#45750 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#46013, COL_D171F390_EECB_4924_B2C2_095D45EAE768#45751 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#46014, COL_15505186_7875_4C25_9AEA_F3510A184E50#45752 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#46015, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45753 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46016, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45754 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46017, COL_43DB4E14_8605_40F0_853F_057B052318BE#45975 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#46018, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#45976 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#46019, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#45977 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46020, COL_8753F2C2_5508_43B2_93E7_9030916A7821#45978 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#46021, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45740, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45741, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45742, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45743, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45744, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45745, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45746, COL_D67142F7_A207_4870_8963_E237B841636A#45747, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45748, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45749, COL_1C35A227_836A_4477_8139_CAB7258B4395#45750, COL_D171F390_EECB_4924_B2C2_095D45EAE768#45751, COL_15505186_7875_4C25_9AEA_F3510A184E50#45752, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45753, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45754, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651, CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#45821 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#45975, CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#45823 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#45976, CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#45827 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#45977, CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#45828 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#45978]
+- Join LeftOuter, (COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45753 = CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#45830)
:- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45650 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45740, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45632 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45741, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45633 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45742, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45634 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45743, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45635 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45744, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45636 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45745, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45637 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45746, COL_D67142F7_A207_4870_8963_E237B841636A#45638 AS COL_D67142F7_A207_4870_8963_E237B841636A#45747, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45639 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45748, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45640 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45749, COL_1C35A227_836A_4477_8139_CAB7258B4395#45641 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#45750, COL_D171F390_EECB_4924_B2C2_095D45EAE768#45642 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#45751, COL_15505186_7875_4C25_9AEA_F3510A184E50#45643 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#45752, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45644 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45753, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45645 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45754, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651]
: +- Project [COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45632, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45633, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45634, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45635, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45636, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45637, COL_D67142F7_A207_4870_8963_E237B841636A#44761 AS COL_D67142F7_A207_4870_8963_E237B841636A#45638, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45639, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45640, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#45641, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#45642, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#45643, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45644, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45645, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857 AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314 AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45436 AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45523 AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45650, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45577 AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45436, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45523, str_transform_case(str_remove_accent(str_replace_extend(COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, 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#45577]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45436, str_split(str_remove_space(COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45436, cast(ONLY_ONE as string)), cast( as string)) AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45523]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314, str_replace_extend(str_replace_regex(COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314, 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#45436]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857, str_replace_extend(str_concat(struct(col1, cast( as string), COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857)), 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#45314]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, str_remove_space(str_replace_extend(str_replace_regex(str_remove_space(str_transform_case(str_remove_accent(COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762), 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#44857]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, 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#44757, 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#44841]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, str_remove_space(str_replace_extend(str_remove_accent(str_transform_case(str_remove_space(COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, 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#44811]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44695 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44696 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44697 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44698 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44699 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44700 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44701 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44702 AS COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44703 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44704 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44705 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44706 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44707 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#44766]
: +- Project [cast(BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44567 as string) AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44695, cast(BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44568 as string) AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44696, cast(BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44569 as string) AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44697, cast(BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44570 as string) AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44698, cast(BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44571 as string) AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44699, cast(BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44572 as string) AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44700, cast(BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44573 as string) AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44701, cast(BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#44574 as string) AS COL_D67142F7_A207_4870_8963_E237B841636A#44702, cast(BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44575 as string) AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44703, cast(BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44576 as string) AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44704, cast(BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#44577 as int) AS COL_1C35A227_836A_4477_8139_CAB7258B4395#44705, cast(BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#44578 as string) AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#44706, cast(BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#44579 as string) AS COL_15505186_7875_4C25_9AEA_F3510A184E50#44707]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#43199 AS BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44567, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#43200 AS BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44568, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#43201 AS BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44569, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#43202 AS BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44570, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#43203 AS BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44571, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#43204 AS BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44572, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#43205 AS BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44573, COL_D67142F7_A207_4870_8963_E237B841636A#43206 AS BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#44574, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#43207 AS BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44575, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#43208 AS BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44576, COL_1C35A227_836A_4477_8139_CAB7258B4395#43209 AS BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#44577, COL_D171F390_EECB_4924_B2C2_095D45EAE768#43210 AS BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#44578, COL_15505186_7875_4C25_9AEA_F3510A184E50#43211 AS BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#44579, COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#43212 AS BASE_RECONCILIA_32037_COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#44580, COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#43213 AS BASE_RECONCILIA_32037_COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#44581, COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#43214 AS BASE_RECONCILIA_32037_COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#44582, COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#43215 AS BASE_RECONCILIA_32037_COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#44583, COL_7097258E_E88A_49F2_831E_C3EE780B3488#43216 AS BASE_RECONCILIA_32037_COL_7097258E_E88A_49F2_831E_C3EE780B3488#44584, COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#43217 AS BASE_RECONCILIA_32037_COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#44585, COL_3AA9677C_9524_43B7_9984_7C0506F35631#43218L AS BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#44586L, COL_E35C77C7_3C81_4648_9449_8217CD8A2230#43219L AS BASE_RECONCILIA_32037_COL_E35C77C7_3C81_4648_9449_8217CD8A2230#44587L, COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#43220 AS BASE_RECONCILIA_32037_COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#44588, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#43221 AS BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#44589, COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#43222L AS BASE_RECONCILIA_32037_COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#44590L, ... 2 more fields]
: +- SubqueryAlias BASE_RECONCILIA_32037118
: +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#43199,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#43200,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#43201,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#43202,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#43203,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#43204,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#43205,COL_D67142F7_A207_4870_8963_E237B841636A#43206,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#43207,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#43208,COL_1C35A227_836A_4477_8139_CAB7258B4395#43209,COL_D171F390_EECB_4924_B2C2_095D45EAE768#43210,COL_15505186_7875_4C25_9AEA_F3510A184E50#43211,COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#43212,COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#43213,COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#43214,COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#43215,COL_7097258E_E88A_49F2_831E_C3EE780B3488#43216,COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#43217,COL_3AA9677C_9524_43B7_9984_7C0506F35631#43218L,COL_E35C77C7_3C81_4648_9449_8217CD8A2230#43219L,COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#43220,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#43221,COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#43222L,... 2 more fields] parquet
+- Project [COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#44310 AS CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#45821, COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#44311 AS CODE_POSTAUX_ET_29368_COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#45822, COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#44312 AS CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#45823, COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#44313 AS CODE_POSTAUX_ET_29368_COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#45824, COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#44314 AS CODE_POSTAUX_ET_29368_COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#45825, COL_751AA3CB_093C_4274_81D1_CD0066B02F57#44315 AS CODE_POSTAUX_ET_29368_COL_751AA3CB_093C_4274_81D1_CD0066B02F57#45826, COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#44316 AS CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#45827, COL_704D2ED6_F724_48C5_9729_DF12E090DF44#44317 AS CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#45828, COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#44318 AS CODE_POSTAUX_ET_29368_COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#45829, COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#44319 AS CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#45830, COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#44320 AS CODE_POSTAUX_ET_29368_COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#45831, COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#44321 AS CODE_POSTAUX_ET_29368_COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#45832]
+- SubqueryAlias CODE_POSTAUX_ET_29368118
+- Relation[COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#44310,COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#44311,COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#44312,COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#44313,COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#44314,COL_751AA3CB_093C_4274_81D1_CD0066B02F57#44315,COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#44316,COL_704D2ED6_F724_48C5_9729_DF12E090DF44#44317,COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#44318,COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#44319,COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#44320,COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#44321] parquet
== Physical Plan ==
Execute CreateViewCommand
+- CreateViewCommand `BASE_RECONCILIA_29344118`, false, true, LocalTempView
+- Project [COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#46107 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#46172, COL_F7963371_9A10_40EE_879C_C4BE98325956#46090 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#46173, COL_AEEE92C5_F212_4094_B620_ED88D0177315#46105 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#46174, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#46104 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#46175, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#46106 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#46176, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#46102 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#46177, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#46103 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#46178, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#46091 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#46179, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#46092 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#46180, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#46093 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#46181, COL_5CC2E896_C215_4794_A45A_9945697CAE42#46094 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#46182, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#46095 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#46183, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#46097 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#46184, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#46100 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#46185, COL_5B422905_E031_409E_88DC_80808F8FC3B1#46101 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#46186, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#46096 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#46187, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#46098 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#46188, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#46099 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#46189]
+- Project [COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#46089, COL_F7963371_9A10_40EE_879C_C4BE98325956#46090, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#46091, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#46092, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#46093, COL_5CC2E896_C215_4794_A45A_9945697CAE42#46094, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#46095, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#46096, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#46097, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#46098, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#46099, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#46100, COL_5B422905_E031_409E_88DC_80808F8FC3B1#46101, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#46102, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#46103, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#46104, COL_AEEE92C5_F212_4094_B620_ED88D0177315#46105, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#46106, COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#46107]
+- Aggregate [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46046, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46047, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46050, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46051, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46052, COL_D67142F7_A207_4870_8963_E237B841636A#46053, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46054, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46055, COL_1C35A227_836A_4477_8139_CAB7258B4395#46056, COL_D171F390_EECB_4924_B2C2_095D45EAE768#46057, COL_15505186_7875_4C25_9AEA_F3510A184E50#46058, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46062, COL_8753F2C2_5508_43B2_93E7_9030916A7821#46063, COL_43DB4E14_8605_40F0_853F_057B052318BE#46060, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46059, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46064, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651], [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46046 AS COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#46089, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46047 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#46090, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46050 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#46091, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46051 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#46092, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46052 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#46093, COL_D67142F7_A207_4870_8963_E237B841636A#46053 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#46094, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46054 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#46095, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46055 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#46096, COL_1C35A227_836A_4477_8139_CAB7258B4395#46056 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#46097, COL_D171F390_EECB_4924_B2C2_095D45EAE768#46057 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#46098, COL_15505186_7875_4C25_9AEA_F3510A184E50#46058 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#46099, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46062 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#46100, COL_8753F2C2_5508_43B2_93E7_9030916A7821#46063 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#46101, COL_43DB4E14_8605_40F0_853F_057B052318BE#46060 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#46102, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#46103, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46059 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#46104, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#46105, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46064 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#46106, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#46107, 1 AS NULL_1#46132]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46003 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46046, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46004 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46047, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#46005 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#46048, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#46006 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#46049, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46007 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46050, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46008 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46051, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46009 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46052, COL_D67142F7_A207_4870_8963_E237B841636A#46010 AS COL_D67142F7_A207_4870_8963_E237B841636A#46053, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46011 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46054, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46012 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46055, COL_1C35A227_836A_4477_8139_CAB7258B4395#46013 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#46056, COL_D171F390_EECB_4924_B2C2_095D45EAE768#46014 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#46057, COL_15505186_7875_4C25_9AEA_F3510A184E50#46015 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#46058, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46016 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46059, COL_43DB4E14_8605_40F0_853F_057B052318BE#46018 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#46060, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#46019 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#46061, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46020 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46062, COL_8753F2C2_5508_43B2_93E7_9030916A7821#46021 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#46063, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46017 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46064, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45740 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#46003, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45741 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#46004, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45742 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#46005, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45743 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#46006, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45744 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#46007, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45745 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#46008, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45746 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#46009, COL_D67142F7_A207_4870_8963_E237B841636A#45747 AS COL_D67142F7_A207_4870_8963_E237B841636A#46010, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45748 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#46011, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45749 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#46012, COL_1C35A227_836A_4477_8139_CAB7258B4395#45750 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#46013, COL_D171F390_EECB_4924_B2C2_095D45EAE768#45751 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#46014, COL_15505186_7875_4C25_9AEA_F3510A184E50#45752 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#46015, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45753 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#46016, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45754 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#46017, COL_43DB4E14_8605_40F0_853F_057B052318BE#45975 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#46018, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#45976 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#46019, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#45977 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#46020, COL_8753F2C2_5508_43B2_93E7_9030916A7821#45978 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#46021, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45740, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45741, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45742, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45743, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45744, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45745, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45746, COL_D67142F7_A207_4870_8963_E237B841636A#45747, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45748, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45749, COL_1C35A227_836A_4477_8139_CAB7258B4395#45750, COL_D171F390_EECB_4924_B2C2_095D45EAE768#45751, COL_15505186_7875_4C25_9AEA_F3510A184E50#45752, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45753, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45754, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651, CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#45821 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#45975, CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#45823 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#45976, CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#45827 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#45977, CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#45828 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#45978]
+- Join LeftOuter, (COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45753 = CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#45830)
:- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45650 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45740, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45632 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45741, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45633 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45742, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45634 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45743, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45635 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45744, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45636 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45745, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45637 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45746, COL_D67142F7_A207_4870_8963_E237B841636A#45638 AS COL_D67142F7_A207_4870_8963_E237B841636A#45747, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45639 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45748, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45640 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45749, COL_1C35A227_836A_4477_8139_CAB7258B4395#45641 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#45750, COL_D171F390_EECB_4924_B2C2_095D45EAE768#45642 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#45751, COL_15505186_7875_4C25_9AEA_F3510A184E50#45643 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#45752, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45644 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45753, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45645 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45754, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651]
: +- Project [COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#45632, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#45633, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#45634, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#45635, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#45636, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#45637, COL_D67142F7_A207_4870_8963_E237B841636A#44761 AS COL_D67142F7_A207_4870_8963_E237B841636A#45638, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#45639, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#45640, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#45641, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#45642, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#45643, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#45644, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#45645, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857 AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#45646, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314 AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45647, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45436 AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45648, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45523 AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45649, COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#45650, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45577 AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#45651]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45436, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45523, str_transform_case(str_remove_accent(str_replace_extend(COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, 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#45577]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45436, str_split(str_remove_space(COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#45436, cast(ONLY_ONE as string)), cast( as string)) AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#45523]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314, str_replace_extend(str_replace_regex(COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#45314, 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#45436]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857, str_replace_extend(str_concat(struct(col1, cast( as string), COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#44857)), 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#45314]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#44841, str_remove_space(str_replace_extend(str_replace_regex(str_remove_space(str_transform_case(str_remove_accent(COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762), 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#44857]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#44811, 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#44757, 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#44841]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44766, str_remove_space(str_replace_extend(str_remove_accent(str_transform_case(str_remove_space(COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, 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#44811]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44695 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44754, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44696 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44755, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44697 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44756, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44698 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44757, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44699 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44758, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44700 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44759, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44701 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44760, COL_D67142F7_A207_4870_8963_E237B841636A#44702 AS COL_D67142F7_A207_4870_8963_E237B841636A#44761, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44703 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44762, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44704 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44763, COL_1C35A227_836A_4477_8139_CAB7258B4395#44705 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#44764, COL_D171F390_EECB_4924_B2C2_095D45EAE768#44706 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#44765, COL_15505186_7875_4C25_9AEA_F3510A184E50#44707 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#44766]
: +- Project [cast(BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44567 as string) AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44695, cast(BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44568 as string) AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44696, cast(BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44569 as string) AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44697, cast(BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44570 as string) AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44698, cast(BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44571 as string) AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44699, cast(BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44572 as string) AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44700, cast(BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44573 as string) AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44701, cast(BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#44574 as string) AS COL_D67142F7_A207_4870_8963_E237B841636A#44702, cast(BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44575 as string) AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44703, cast(BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44576 as string) AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44704, cast(BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#44577 as int) AS COL_1C35A227_836A_4477_8139_CAB7258B4395#44705, cast(BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#44578 as string) AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#44706, cast(BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#44579 as string) AS COL_15505186_7875_4C25_9AEA_F3510A184E50#44707]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#43199 AS BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#44567, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#43200 AS BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#44568, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#43201 AS BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#44569, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#43202 AS BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#44570, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#43203 AS BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#44571, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#43204 AS BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#44572, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#43205 AS BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#44573, COL_D67142F7_A207_4870_8963_E237B841636A#43206 AS BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#44574, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#43207 AS BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#44575, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#43208 AS BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#44576, COL_1C35A227_836A_4477_8139_CAB7258B4395#43209 AS BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#44577, COL_D171F390_EECB_4924_B2C2_095D45EAE768#43210 AS BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#44578, COL_15505186_7875_4C25_9AEA_F3510A184E50#43211 AS BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#44579, COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#43212 AS BASE_RECONCILIA_32037_COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#44580, COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#43213 AS BASE_RECONCILIA_32037_COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#44581, COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#43214 AS BASE_RECONCILIA_32037_COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#44582, COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#43215 AS BASE_RECONCILIA_32037_COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#44583, COL_7097258E_E88A_49F2_831E_C3EE780B3488#43216 AS BASE_RECONCILIA_32037_COL_7097258E_E88A_49F2_831E_C3EE780B3488#44584, COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#43217 AS BASE_RECONCILIA_32037_COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#44585, COL_3AA9677C_9524_43B7_9984_7C0506F35631#43218L AS BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#44586L, COL_E35C77C7_3C81_4648_9449_8217CD8A2230#43219L AS BASE_RECONCILIA_32037_COL_E35C77C7_3C81_4648_9449_8217CD8A2230#44587L, COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#43220 AS BASE_RECONCILIA_32037_COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#44588, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#43221 AS BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#44589, COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#43222L AS BASE_RECONCILIA_32037_COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#44590L, ... 2 more fields]
: +- SubqueryAlias BASE_RECONCILIA_32037118
: +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#43199,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#43200,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#43201,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#43202,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#43203,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#43204,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#43205,COL_D67142F7_A207_4870_8963_E237B841636A#43206,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#43207,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#43208,COL_1C35A227_836A_4477_8139_CAB7258B4395#43209,COL_D171F390_EECB_4924_B2C2_095D45EAE768#43210,COL_15505186_7875_4C25_9AEA_F3510A184E50#43211,COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#43212,COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#43213,COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#43214,COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#43215,COL_7097258E_E88A_49F2_831E_C3EE780B3488#43216,COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#43217,COL_3AA9677C_9524_43B7_9984_7C0506F35631#43218L,COL_E35C77C7_3C81_4648_9449_8217CD8A2230#43219L,COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#43220,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#43221,COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#43222L,... 2 more fields] parquet
+- Project [COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#44310 AS CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#45821, COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#44311 AS CODE_POSTAUX_ET_29368_COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#45822, COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#44312 AS CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#45823, COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#44313 AS CODE_POSTAUX_ET_29368_COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#45824, COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#44314 AS CODE_POSTAUX_ET_29368_COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#45825, COL_751AA3CB_093C_4274_81D1_CD0066B02F57#44315 AS CODE_POSTAUX_ET_29368_COL_751AA3CB_093C_4274_81D1_CD0066B02F57#45826, COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#44316 AS CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#45827, COL_704D2ED6_F724_48C5_9729_DF12E090DF44#44317 AS CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#45828, COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#44318 AS CODE_POSTAUX_ET_29368_COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#45829, COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#44319 AS CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#45830, COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#44320 AS CODE_POSTAUX_ET_29368_COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#45831, COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#44321 AS CODE_POSTAUX_ET_29368_COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#45832]
+- SubqueryAlias CODE_POSTAUX_ET_29368118
+- Relation[COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#44310,COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#44311,COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#44312,COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#44313,COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#44314,COL_751AA3CB_093C_4274_81D1_CD0066B02F57#44315,COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#44316,COL_704D2ED6_F724_48C5_9729_DF12E090DF44#44317,COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#44318,COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#44319,COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#44320,COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#44321] parquet
