== Parsed Logical Plan ==
CreateViewCommand `BASE_RECONCILIA_29344114`, false, true, LocalTempView
+- Project [COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52857 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#53039, COL_F7963371_9A10_40EE_879C_C4BE98325956#52840 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#53040, COL_AEEE92C5_F212_4094_B620_ED88D0177315#52855 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#53041, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52854 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#53042, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52856 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#53043, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52852 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#53044, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52853 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#53045, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52841 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#53046, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52842 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#53047, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52843 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#53048, COL_5CC2E896_C215_4794_A45A_9945697CAE42#52844 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#53049, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52845 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#53050, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52847 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#53051, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52850 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#53052, COL_5B422905_E031_409E_88DC_80808F8FC3B1#52851 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#53053, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52846 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#53054, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52848 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#53055, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52849 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#53056]
+- Project [COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#52839, COL_F7963371_9A10_40EE_879C_C4BE98325956#52840, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52841, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52842, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52843, COL_5CC2E896_C215_4794_A45A_9945697CAE42#52844, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52845, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52846, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52847, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52848, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52849, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52850, COL_5B422905_E031_409E_88DC_80808F8FC3B1#52851, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52852, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52853, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52854, COL_AEEE92C5_F212_4094_B620_ED88D0177315#52855, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52856, COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52857]
+- Aggregate [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52739, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52740, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52743, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52744, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52745, COL_D67142F7_A207_4870_8963_E237B841636A#52746, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52747, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52748, COL_1C35A227_836A_4477_8139_CAB7258B4395#52749, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52750, COL_15505186_7875_4C25_9AEA_F3510A184E50#52751, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52755, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52756, COL_43DB4E14_8605_40F0_853F_057B052318BE#52753, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52752, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52757, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014], [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52739 AS COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#52839, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52740 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#52840, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52743 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52841, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52744 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52842, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52745 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52843, COL_D67142F7_A207_4870_8963_E237B841636A#52746 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#52844, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52747 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52845, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52748 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52846, COL_1C35A227_836A_4477_8139_CAB7258B4395#52749 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52847, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52750 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52848, COL_15505186_7875_4C25_9AEA_F3510A184E50#52751 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52849, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52755 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52850, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52756 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#52851, COL_43DB4E14_8605_40F0_853F_057B052318BE#52753 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52852, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52853, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52752 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52854, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#52855, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52757 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52856, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52857, 1 AS NULL_1#52920]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52656 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52739, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52657 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52740, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52658 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52741, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52659 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52742, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52660 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52743, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52661 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52744, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52662 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52745, COL_D67142F7_A207_4870_8963_E237B841636A#52663 AS COL_D67142F7_A207_4870_8963_E237B841636A#52746, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52664 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52747, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52665 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52748, COL_1C35A227_836A_4477_8139_CAB7258B4395#52666 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52749, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52667 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52750, COL_15505186_7875_4C25_9AEA_F3510A184E50#52668 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52751, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52669 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52752, COL_43DB4E14_8605_40F0_853F_057B052318BE#52671 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52753, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52672 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52754, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52673 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52755, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52674 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52756, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52670 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52757, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52115 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52656, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52117 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52657, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52119 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52658, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52121 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52659, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52123 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52660, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52124 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52661, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52126 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52662, COL_D67142F7_A207_4870_8963_E237B841636A#52128 AS COL_D67142F7_A207_4870_8963_E237B841636A#52663, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52130 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52664, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52132 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52665, COL_1C35A227_836A_4477_8139_CAB7258B4395#52134 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52666, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52136 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52667, COL_15505186_7875_4C25_9AEA_F3510A184E50#52138 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52668, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52140 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52669, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52142 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52670, COL_43DB4E14_8605_40F0_853F_057B052318BE#52556 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52671, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52557 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52672, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52558 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52673, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52559 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52674, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52115, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52117, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52119, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52121, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52123, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52124, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52126, COL_D67142F7_A207_4870_8963_E237B841636A#52128, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52130, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52132, COL_1C35A227_836A_4477_8139_CAB7258B4395#52134, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52136, COL_15505186_7875_4C25_9AEA_F3510A184E50#52138, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52140, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014, CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#52253 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52556, CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#52255 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52557, CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#52259 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52558, CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#52260 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52559]
+- Join LeftOuter, (COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52140 = CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#52262)
:- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52013 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52115, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51995 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52117, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51996 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52119, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51997 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52121, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51998 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52123, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51999 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52124, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52000 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52126, COL_D67142F7_A207_4870_8963_E237B841636A#52001 AS COL_D67142F7_A207_4870_8963_E237B841636A#52128, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52002 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52130, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52003 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52132, COL_1C35A227_836A_4477_8139_CAB7258B4395#52004 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52134, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52005 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52136, COL_15505186_7875_4C25_9AEA_F3510A184E50#52006 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52138, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52007 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52140, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52008 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014]
: +- Project [COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51995, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51996, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51997, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51998, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51999, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52000, COL_D67142F7_A207_4870_8963_E237B841636A#50528 AS COL_D67142F7_A207_4870_8963_E237B841636A#52001, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52002, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52003, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52004, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52005, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52006, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52007, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52008, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024 AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100 AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51367 AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51562 AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52013, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51829 AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51367, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51562, str_transform_case(str_remove_accent(str_replace_extend(COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, 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#51829]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51367, str_split(str_remove_space(COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51367, cast(ONLY_ONE as string)), cast( as string)) AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51562]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100, str_replace_extend(str_replace_regex(COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100, 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#51367]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024, str_replace_extend(str_concat(struct(col1, cast( as string), COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024)), 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#51100]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, str_remove_space(str_replace_extend(str_replace_regex(str_remove_space(str_transform_case(str_remove_accent(COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529), 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#51024]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, 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#50524, 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#50925]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, str_remove_space(str_replace_extend(str_remove_accent(str_transform_case(str_remove_space(COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, 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#50617]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50425 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50426 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50427 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50428 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50429 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50430 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50431 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50432 AS COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50433 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50434 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50435 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50436 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50437 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#50533]
: +- Project [cast(BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50279 as string) AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50425, cast(BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50280 as string) AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50426, cast(BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50281 as string) AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50427, cast(BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50282 as string) AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50428, cast(BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50283 as string) AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50429, cast(BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50284 as string) AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50430, cast(BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50285 as string) AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50431, cast(BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#50286 as string) AS COL_D67142F7_A207_4870_8963_E237B841636A#50432, cast(BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50287 as string) AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50433, cast(BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50288 as string) AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50434, cast(BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#50289 as int) AS COL_1C35A227_836A_4477_8139_CAB7258B4395#50435, cast(BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#50290 as string) AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#50436, cast(BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#50291 as string) AS COL_15505186_7875_4C25_9AEA_F3510A184E50#50437]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#48330 AS BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50279, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#48331 AS BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50280, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#48332 AS BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50281, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#48333 AS BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50282, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#48334 AS BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50283, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#48335 AS BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50284, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#48336 AS BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50285, COL_D67142F7_A207_4870_8963_E237B841636A#48337 AS BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#50286, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#48338 AS BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50287, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#48339 AS BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50288, COL_1C35A227_836A_4477_8139_CAB7258B4395#48340 AS BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#50289, COL_D171F390_EECB_4924_B2C2_095D45EAE768#48341 AS BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#50290, COL_15505186_7875_4C25_9AEA_F3510A184E50#48342 AS BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#50291, COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#48343 AS BASE_RECONCILIA_32037_COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#50292, COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#48344 AS BASE_RECONCILIA_32037_COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#50293, COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#48345 AS BASE_RECONCILIA_32037_COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#50294, COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#48346 AS BASE_RECONCILIA_32037_COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#50295, COL_7097258E_E88A_49F2_831E_C3EE780B3488#48347 AS BASE_RECONCILIA_32037_COL_7097258E_E88A_49F2_831E_C3EE780B3488#50296, COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#48348 AS BASE_RECONCILIA_32037_COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#50297, COL_3AA9677C_9524_43B7_9984_7C0506F35631#48349L AS BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#50298L, COL_E35C77C7_3C81_4648_9449_8217CD8A2230#48350L AS BASE_RECONCILIA_32037_COL_E35C77C7_3C81_4648_9449_8217CD8A2230#50299L, COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#48351 AS BASE_RECONCILIA_32037_COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#50300, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#48352 AS BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#50301, COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#48353L AS BASE_RECONCILIA_32037_COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#50302L, ... 2 more fields]
: +- SubqueryAlias BASE_RECONCILIA_32037114
: +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#48330,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#48331,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#48332,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#48333,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#48334,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#48335,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#48336,COL_D67142F7_A207_4870_8963_E237B841636A#48337,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#48338,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#48339,COL_1C35A227_836A_4477_8139_CAB7258B4395#48340,COL_D171F390_EECB_4924_B2C2_095D45EAE768#48341,COL_15505186_7875_4C25_9AEA_F3510A184E50#48342,COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#48343,COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#48344,COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#48345,COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#48346,COL_7097258E_E88A_49F2_831E_C3EE780B3488#48347,COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#48348,COL_3AA9677C_9524_43B7_9984_7C0506F35631#48349L,COL_E35C77C7_3C81_4648_9449_8217CD8A2230#48350L,COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#48351,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#48352,COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#48353L,... 2 more fields] parquet
+- Project [COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#49980 AS CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#52253, COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#49981 AS CODE_POSTAUX_ET_29368_COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#52254, COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#49982 AS CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#52255, COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#49983 AS CODE_POSTAUX_ET_29368_COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#52256, COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#49984 AS CODE_POSTAUX_ET_29368_COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#52257, COL_751AA3CB_093C_4274_81D1_CD0066B02F57#49985 AS CODE_POSTAUX_ET_29368_COL_751AA3CB_093C_4274_81D1_CD0066B02F57#52258, COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#49986 AS CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#52259, COL_704D2ED6_F724_48C5_9729_DF12E090DF44#49987 AS CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#52260, COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#49988 AS CODE_POSTAUX_ET_29368_COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#52261, COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#49989 AS CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#52262, COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#49990 AS CODE_POSTAUX_ET_29368_COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#52263, COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#49991 AS CODE_POSTAUX_ET_29368_COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#52264]
+- SubqueryAlias CODE_POSTAUX_ET_29368114
+- Relation[COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#49980,COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#49981,COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#49982,COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#49983,COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#49984,COL_751AA3CB_093C_4274_81D1_CD0066B02F57#49985,COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#49986,COL_704D2ED6_F724_48C5_9729_DF12E090DF44#49987,COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#49988,COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#49989,COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#49990,COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#49991] parquet
== Analyzed Logical Plan ==
CreateViewCommand `BASE_RECONCILIA_29344114`, false, true, LocalTempView
+- Project [COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52857 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#53039, COL_F7963371_9A10_40EE_879C_C4BE98325956#52840 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#53040, COL_AEEE92C5_F212_4094_B620_ED88D0177315#52855 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#53041, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52854 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#53042, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52856 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#53043, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52852 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#53044, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52853 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#53045, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52841 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#53046, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52842 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#53047, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52843 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#53048, COL_5CC2E896_C215_4794_A45A_9945697CAE42#52844 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#53049, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52845 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#53050, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52847 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#53051, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52850 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#53052, COL_5B422905_E031_409E_88DC_80808F8FC3B1#52851 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#53053, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52846 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#53054, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52848 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#53055, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52849 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#53056]
+- Project [COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#52839, COL_F7963371_9A10_40EE_879C_C4BE98325956#52840, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52841, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52842, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52843, COL_5CC2E896_C215_4794_A45A_9945697CAE42#52844, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52845, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52846, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52847, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52848, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52849, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52850, COL_5B422905_E031_409E_88DC_80808F8FC3B1#52851, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52852, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52853, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52854, COL_AEEE92C5_F212_4094_B620_ED88D0177315#52855, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52856, COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52857]
+- Aggregate [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52739, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52740, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52743, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52744, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52745, COL_D67142F7_A207_4870_8963_E237B841636A#52746, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52747, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52748, COL_1C35A227_836A_4477_8139_CAB7258B4395#52749, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52750, COL_15505186_7875_4C25_9AEA_F3510A184E50#52751, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52755, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52756, COL_43DB4E14_8605_40F0_853F_057B052318BE#52753, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52752, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52757, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014], [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52739 AS COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#52839, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52740 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#52840, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52743 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52841, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52744 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52842, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52745 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52843, COL_D67142F7_A207_4870_8963_E237B841636A#52746 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#52844, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52747 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52845, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52748 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52846, COL_1C35A227_836A_4477_8139_CAB7258B4395#52749 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52847, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52750 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52848, COL_15505186_7875_4C25_9AEA_F3510A184E50#52751 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52849, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52755 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52850, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52756 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#52851, COL_43DB4E14_8605_40F0_853F_057B052318BE#52753 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52852, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52853, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52752 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52854, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#52855, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52757 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52856, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52857, 1 AS NULL_1#52920]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52656 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52739, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52657 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52740, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52658 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52741, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52659 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52742, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52660 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52743, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52661 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52744, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52662 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52745, COL_D67142F7_A207_4870_8963_E237B841636A#52663 AS COL_D67142F7_A207_4870_8963_E237B841636A#52746, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52664 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52747, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52665 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52748, COL_1C35A227_836A_4477_8139_CAB7258B4395#52666 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52749, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52667 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52750, COL_15505186_7875_4C25_9AEA_F3510A184E50#52668 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52751, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52669 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52752, COL_43DB4E14_8605_40F0_853F_057B052318BE#52671 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52753, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52672 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52754, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52673 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52755, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52674 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52756, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52670 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52757, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52115 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52656, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52117 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52657, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52119 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52658, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52121 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52659, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52123 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52660, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52124 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52661, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52126 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52662, COL_D67142F7_A207_4870_8963_E237B841636A#52128 AS COL_D67142F7_A207_4870_8963_E237B841636A#52663, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52130 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52664, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52132 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52665, COL_1C35A227_836A_4477_8139_CAB7258B4395#52134 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52666, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52136 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52667, COL_15505186_7875_4C25_9AEA_F3510A184E50#52138 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52668, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52140 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52669, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52142 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52670, COL_43DB4E14_8605_40F0_853F_057B052318BE#52556 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52671, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52557 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52672, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52558 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52673, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52559 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52674, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52115, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52117, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52119, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52121, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52123, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52124, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52126, COL_D67142F7_A207_4870_8963_E237B841636A#52128, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52130, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52132, COL_1C35A227_836A_4477_8139_CAB7258B4395#52134, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52136, COL_15505186_7875_4C25_9AEA_F3510A184E50#52138, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52140, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014, CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#52253 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52556, CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#52255 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52557, CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#52259 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52558, CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#52260 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52559]
+- Join LeftOuter, (COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52140 = CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#52262)
:- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52013 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52115, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51995 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52117, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51996 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52119, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51997 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52121, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51998 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52123, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51999 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52124, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52000 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52126, COL_D67142F7_A207_4870_8963_E237B841636A#52001 AS COL_D67142F7_A207_4870_8963_E237B841636A#52128, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52002 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52130, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52003 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52132, COL_1C35A227_836A_4477_8139_CAB7258B4395#52004 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52134, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52005 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52136, COL_15505186_7875_4C25_9AEA_F3510A184E50#52006 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52138, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52007 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52140, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52008 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014]
: +- Project [COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51995, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51996, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51997, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51998, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51999, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52000, COL_D67142F7_A207_4870_8963_E237B841636A#50528 AS COL_D67142F7_A207_4870_8963_E237B841636A#52001, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52002, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52003, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52004, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52005, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52006, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52007, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52008, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024 AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100 AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51367 AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51562 AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52013, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51829 AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51367, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51562, str_transform_case(str_remove_accent(str_replace_extend(COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, 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#51829]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51367, str_split(str_remove_space(COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51367, cast(ONLY_ONE as string)), cast( as string)) AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51562]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100, str_replace_extend(str_replace_regex(COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100, 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#51367]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024, str_replace_extend(str_concat(struct(col1, cast( as string), COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024)), 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#51100]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, str_remove_space(str_replace_extend(str_replace_regex(str_remove_space(str_transform_case(str_remove_accent(COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529), 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#51024]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, 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#50524, 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#50925]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, str_remove_space(str_replace_extend(str_remove_accent(str_transform_case(str_remove_space(COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, 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#50617]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50425 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50426 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50427 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50428 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50429 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50430 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50431 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50432 AS COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50433 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50434 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50435 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50436 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50437 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#50533]
: +- Project [cast(BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50279 as string) AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50425, cast(BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50280 as string) AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50426, cast(BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50281 as string) AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50427, cast(BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50282 as string) AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50428, cast(BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50283 as string) AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50429, cast(BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50284 as string) AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50430, cast(BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50285 as string) AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50431, cast(BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#50286 as string) AS COL_D67142F7_A207_4870_8963_E237B841636A#50432, cast(BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50287 as string) AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50433, cast(BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50288 as string) AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50434, cast(BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#50289 as int) AS COL_1C35A227_836A_4477_8139_CAB7258B4395#50435, cast(BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#50290 as string) AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#50436, cast(BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#50291 as string) AS COL_15505186_7875_4C25_9AEA_F3510A184E50#50437]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#48330 AS BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50279, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#48331 AS BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50280, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#48332 AS BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50281, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#48333 AS BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50282, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#48334 AS BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50283, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#48335 AS BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50284, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#48336 AS BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50285, COL_D67142F7_A207_4870_8963_E237B841636A#48337 AS BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#50286, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#48338 AS BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50287, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#48339 AS BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50288, COL_1C35A227_836A_4477_8139_CAB7258B4395#48340 AS BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#50289, COL_D171F390_EECB_4924_B2C2_095D45EAE768#48341 AS BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#50290, COL_15505186_7875_4C25_9AEA_F3510A184E50#48342 AS BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#50291, COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#48343 AS BASE_RECONCILIA_32037_COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#50292, COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#48344 AS BASE_RECONCILIA_32037_COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#50293, COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#48345 AS BASE_RECONCILIA_32037_COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#50294, COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#48346 AS BASE_RECONCILIA_32037_COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#50295, COL_7097258E_E88A_49F2_831E_C3EE780B3488#48347 AS BASE_RECONCILIA_32037_COL_7097258E_E88A_49F2_831E_C3EE780B3488#50296, COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#48348 AS BASE_RECONCILIA_32037_COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#50297, COL_3AA9677C_9524_43B7_9984_7C0506F35631#48349L AS BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#50298L, COL_E35C77C7_3C81_4648_9449_8217CD8A2230#48350L AS BASE_RECONCILIA_32037_COL_E35C77C7_3C81_4648_9449_8217CD8A2230#50299L, COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#48351 AS BASE_RECONCILIA_32037_COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#50300, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#48352 AS BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#50301, COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#48353L AS BASE_RECONCILIA_32037_COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#50302L, ... 2 more fields]
: +- SubqueryAlias BASE_RECONCILIA_32037114
: +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#48330,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#48331,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#48332,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#48333,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#48334,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#48335,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#48336,COL_D67142F7_A207_4870_8963_E237B841636A#48337,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#48338,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#48339,COL_1C35A227_836A_4477_8139_CAB7258B4395#48340,COL_D171F390_EECB_4924_B2C2_095D45EAE768#48341,COL_15505186_7875_4C25_9AEA_F3510A184E50#48342,COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#48343,COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#48344,COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#48345,COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#48346,COL_7097258E_E88A_49F2_831E_C3EE780B3488#48347,COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#48348,COL_3AA9677C_9524_43B7_9984_7C0506F35631#48349L,COL_E35C77C7_3C81_4648_9449_8217CD8A2230#48350L,COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#48351,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#48352,COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#48353L,... 2 more fields] parquet
+- Project [COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#49980 AS CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#52253, COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#49981 AS CODE_POSTAUX_ET_29368_COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#52254, COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#49982 AS CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#52255, COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#49983 AS CODE_POSTAUX_ET_29368_COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#52256, COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#49984 AS CODE_POSTAUX_ET_29368_COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#52257, COL_751AA3CB_093C_4274_81D1_CD0066B02F57#49985 AS CODE_POSTAUX_ET_29368_COL_751AA3CB_093C_4274_81D1_CD0066B02F57#52258, COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#49986 AS CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#52259, COL_704D2ED6_F724_48C5_9729_DF12E090DF44#49987 AS CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#52260, COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#49988 AS CODE_POSTAUX_ET_29368_COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#52261, COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#49989 AS CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#52262, COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#49990 AS CODE_POSTAUX_ET_29368_COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#52263, COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#49991 AS CODE_POSTAUX_ET_29368_COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#52264]
+- SubqueryAlias CODE_POSTAUX_ET_29368114
+- Relation[COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#49980,COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#49981,COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#49982,COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#49983,COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#49984,COL_751AA3CB_093C_4274_81D1_CD0066B02F57#49985,COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#49986,COL_704D2ED6_F724_48C5_9729_DF12E090DF44#49987,COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#49988,COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#49989,COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#49990,COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#49991] parquet
== Optimized Logical Plan ==
CreateViewCommand `BASE_RECONCILIA_29344114`, false, true, LocalTempView
+- Project [COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52857 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#53039, COL_F7963371_9A10_40EE_879C_C4BE98325956#52840 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#53040, COL_AEEE92C5_F212_4094_B620_ED88D0177315#52855 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#53041, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52854 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#53042, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52856 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#53043, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52852 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#53044, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52853 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#53045, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52841 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#53046, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52842 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#53047, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52843 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#53048, COL_5CC2E896_C215_4794_A45A_9945697CAE42#52844 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#53049, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52845 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#53050, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52847 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#53051, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52850 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#53052, COL_5B422905_E031_409E_88DC_80808F8FC3B1#52851 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#53053, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52846 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#53054, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52848 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#53055, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52849 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#53056]
+- Project [COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#52839, COL_F7963371_9A10_40EE_879C_C4BE98325956#52840, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52841, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52842, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52843, COL_5CC2E896_C215_4794_A45A_9945697CAE42#52844, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52845, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52846, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52847, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52848, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52849, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52850, COL_5B422905_E031_409E_88DC_80808F8FC3B1#52851, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52852, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52853, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52854, COL_AEEE92C5_F212_4094_B620_ED88D0177315#52855, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52856, COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52857]
+- Aggregate [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52739, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52740, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52743, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52744, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52745, COL_D67142F7_A207_4870_8963_E237B841636A#52746, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52747, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52748, COL_1C35A227_836A_4477_8139_CAB7258B4395#52749, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52750, COL_15505186_7875_4C25_9AEA_F3510A184E50#52751, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52755, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52756, COL_43DB4E14_8605_40F0_853F_057B052318BE#52753, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52752, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52757, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014], [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52739 AS COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#52839, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52740 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#52840, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52743 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52841, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52744 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52842, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52745 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52843, COL_D67142F7_A207_4870_8963_E237B841636A#52746 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#52844, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52747 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52845, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52748 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52846, COL_1C35A227_836A_4477_8139_CAB7258B4395#52749 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52847, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52750 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52848, COL_15505186_7875_4C25_9AEA_F3510A184E50#52751 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52849, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52755 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52850, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52756 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#52851, COL_43DB4E14_8605_40F0_853F_057B052318BE#52753 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52852, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52853, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52752 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52854, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#52855, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52757 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52856, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52857, 1 AS NULL_1#52920]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52656 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52739, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52657 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52740, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52658 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52741, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52659 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52742, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52660 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52743, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52661 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52744, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52662 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52745, COL_D67142F7_A207_4870_8963_E237B841636A#52663 AS COL_D67142F7_A207_4870_8963_E237B841636A#52746, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52664 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52747, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52665 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52748, COL_1C35A227_836A_4477_8139_CAB7258B4395#52666 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52749, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52667 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52750, COL_15505186_7875_4C25_9AEA_F3510A184E50#52668 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52751, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52669 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52752, COL_43DB4E14_8605_40F0_853F_057B052318BE#52671 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52753, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52672 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52754, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52673 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52755, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52674 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52756, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52670 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52757, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52115 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52656, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52117 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52657, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52119 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52658, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52121 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52659, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52123 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52660, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52124 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52661, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52126 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52662, COL_D67142F7_A207_4870_8963_E237B841636A#52128 AS COL_D67142F7_A207_4870_8963_E237B841636A#52663, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52130 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52664, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52132 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52665, COL_1C35A227_836A_4477_8139_CAB7258B4395#52134 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52666, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52136 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52667, COL_15505186_7875_4C25_9AEA_F3510A184E50#52138 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52668, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52140 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52669, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52142 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52670, COL_43DB4E14_8605_40F0_853F_057B052318BE#52556 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52671, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52557 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52672, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52558 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52673, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52559 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52674, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52115, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52117, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52119, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52121, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52123, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52124, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52126, COL_D67142F7_A207_4870_8963_E237B841636A#52128, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52130, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52132, COL_1C35A227_836A_4477_8139_CAB7258B4395#52134, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52136, COL_15505186_7875_4C25_9AEA_F3510A184E50#52138, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52140, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014, CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#52253 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52556, CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#52255 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52557, CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#52259 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52558, CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#52260 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52559]
+- Join LeftOuter, (COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52140 = CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#52262)
:- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52013 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52115, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51995 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52117, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51996 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52119, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51997 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52121, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51998 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52123, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51999 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52124, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52000 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52126, COL_D67142F7_A207_4870_8963_E237B841636A#52001 AS COL_D67142F7_A207_4870_8963_E237B841636A#52128, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52002 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52130, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52003 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52132, COL_1C35A227_836A_4477_8139_CAB7258B4395#52004 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52134, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52005 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52136, COL_15505186_7875_4C25_9AEA_F3510A184E50#52006 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52138, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52007 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52140, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52008 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014]
: +- Project [COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51995, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51996, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51997, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51998, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51999, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52000, COL_D67142F7_A207_4870_8963_E237B841636A#50528 AS COL_D67142F7_A207_4870_8963_E237B841636A#52001, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52002, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52003, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52004, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52005, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52006, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52007, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52008, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024 AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100 AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51367 AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51562 AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52013, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51829 AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51367, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51562, str_transform_case(str_remove_accent(str_replace_extend(COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, 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#51829]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51367, str_split(str_remove_space(COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51367, cast(ONLY_ONE as string)), cast( as string)) AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51562]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100, str_replace_extend(str_replace_regex(COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100, 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#51367]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024, str_replace_extend(str_concat(struct(col1, cast( as string), COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024)), 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#51100]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, str_remove_space(str_replace_extend(str_replace_regex(str_remove_space(str_transform_case(str_remove_accent(COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529), 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#51024]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, 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#50524, 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#50925]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, str_remove_space(str_replace_extend(str_remove_accent(str_transform_case(str_remove_space(COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, 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#50617]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50425 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50426 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50427 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50428 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50429 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50430 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50431 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50432 AS COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50433 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50434 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50435 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50436 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50437 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#50533]
: +- Project [cast(BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50279 as string) AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50425, cast(BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50280 as string) AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50426, cast(BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50281 as string) AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50427, cast(BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50282 as string) AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50428, cast(BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50283 as string) AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50429, cast(BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50284 as string) AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50430, cast(BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50285 as string) AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50431, cast(BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#50286 as string) AS COL_D67142F7_A207_4870_8963_E237B841636A#50432, cast(BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50287 as string) AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50433, cast(BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50288 as string) AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50434, cast(BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#50289 as int) AS COL_1C35A227_836A_4477_8139_CAB7258B4395#50435, cast(BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#50290 as string) AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#50436, cast(BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#50291 as string) AS COL_15505186_7875_4C25_9AEA_F3510A184E50#50437]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#48330 AS BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50279, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#48331 AS BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50280, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#48332 AS BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50281, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#48333 AS BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50282, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#48334 AS BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50283, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#48335 AS BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50284, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#48336 AS BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50285, COL_D67142F7_A207_4870_8963_E237B841636A#48337 AS BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#50286, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#48338 AS BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50287, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#48339 AS BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50288, COL_1C35A227_836A_4477_8139_CAB7258B4395#48340 AS BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#50289, COL_D171F390_EECB_4924_B2C2_095D45EAE768#48341 AS BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#50290, COL_15505186_7875_4C25_9AEA_F3510A184E50#48342 AS BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#50291, COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#48343 AS BASE_RECONCILIA_32037_COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#50292, COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#48344 AS BASE_RECONCILIA_32037_COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#50293, COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#48345 AS BASE_RECONCILIA_32037_COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#50294, COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#48346 AS BASE_RECONCILIA_32037_COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#50295, COL_7097258E_E88A_49F2_831E_C3EE780B3488#48347 AS BASE_RECONCILIA_32037_COL_7097258E_E88A_49F2_831E_C3EE780B3488#50296, COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#48348 AS BASE_RECONCILIA_32037_COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#50297, COL_3AA9677C_9524_43B7_9984_7C0506F35631#48349L AS BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#50298L, COL_E35C77C7_3C81_4648_9449_8217CD8A2230#48350L AS BASE_RECONCILIA_32037_COL_E35C77C7_3C81_4648_9449_8217CD8A2230#50299L, COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#48351 AS BASE_RECONCILIA_32037_COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#50300, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#48352 AS BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#50301, COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#48353L AS BASE_RECONCILIA_32037_COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#50302L, ... 2 more fields]
: +- SubqueryAlias BASE_RECONCILIA_32037114
: +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#48330,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#48331,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#48332,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#48333,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#48334,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#48335,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#48336,COL_D67142F7_A207_4870_8963_E237B841636A#48337,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#48338,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#48339,COL_1C35A227_836A_4477_8139_CAB7258B4395#48340,COL_D171F390_EECB_4924_B2C2_095D45EAE768#48341,COL_15505186_7875_4C25_9AEA_F3510A184E50#48342,COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#48343,COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#48344,COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#48345,COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#48346,COL_7097258E_E88A_49F2_831E_C3EE780B3488#48347,COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#48348,COL_3AA9677C_9524_43B7_9984_7C0506F35631#48349L,COL_E35C77C7_3C81_4648_9449_8217CD8A2230#48350L,COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#48351,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#48352,COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#48353L,... 2 more fields] parquet
+- Project [COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#49980 AS CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#52253, COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#49981 AS CODE_POSTAUX_ET_29368_COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#52254, COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#49982 AS CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#52255, COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#49983 AS CODE_POSTAUX_ET_29368_COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#52256, COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#49984 AS CODE_POSTAUX_ET_29368_COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#52257, COL_751AA3CB_093C_4274_81D1_CD0066B02F57#49985 AS CODE_POSTAUX_ET_29368_COL_751AA3CB_093C_4274_81D1_CD0066B02F57#52258, COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#49986 AS CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#52259, COL_704D2ED6_F724_48C5_9729_DF12E090DF44#49987 AS CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#52260, COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#49988 AS CODE_POSTAUX_ET_29368_COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#52261, COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#49989 AS CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#52262, COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#49990 AS CODE_POSTAUX_ET_29368_COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#52263, COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#49991 AS CODE_POSTAUX_ET_29368_COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#52264]
+- SubqueryAlias CODE_POSTAUX_ET_29368114
+- Relation[COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#49980,COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#49981,COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#49982,COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#49983,COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#49984,COL_751AA3CB_093C_4274_81D1_CD0066B02F57#49985,COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#49986,COL_704D2ED6_F724_48C5_9729_DF12E090DF44#49987,COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#49988,COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#49989,COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#49990,COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#49991] parquet
== Physical Plan ==
Execute CreateViewCommand
+- CreateViewCommand `BASE_RECONCILIA_29344114`, false, true, LocalTempView
+- Project [COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52857 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#53039, COL_F7963371_9A10_40EE_879C_C4BE98325956#52840 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#53040, COL_AEEE92C5_F212_4094_B620_ED88D0177315#52855 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#53041, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52854 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#53042, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52856 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#53043, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52852 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#53044, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52853 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#53045, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52841 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#53046, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52842 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#53047, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52843 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#53048, COL_5CC2E896_C215_4794_A45A_9945697CAE42#52844 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#53049, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52845 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#53050, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52847 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#53051, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52850 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#53052, COL_5B422905_E031_409E_88DC_80808F8FC3B1#52851 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#53053, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52846 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#53054, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52848 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#53055, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52849 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#53056]
+- Project [COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#52839, COL_F7963371_9A10_40EE_879C_C4BE98325956#52840, COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52841, COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52842, COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52843, COL_5CC2E896_C215_4794_A45A_9945697CAE42#52844, COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52845, COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52846, COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52847, COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52848, COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52849, COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52850, COL_5B422905_E031_409E_88DC_80808F8FC3B1#52851, COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52852, COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52853, COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52854, COL_AEEE92C5_F212_4094_B620_ED88D0177315#52855, COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52856, COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52857]
+- Aggregate [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52739, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52740, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52743, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52744, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52745, COL_D67142F7_A207_4870_8963_E237B841636A#52746, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52747, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52748, COL_1C35A227_836A_4477_8139_CAB7258B4395#52749, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52750, COL_15505186_7875_4C25_9AEA_F3510A184E50#52751, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52755, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52756, COL_43DB4E14_8605_40F0_853F_057B052318BE#52753, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52752, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52757, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014], [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52739 AS COL_404D3E0A_0596_4987_B88D_9D94FC2CC23C#52839, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52740 AS COL_F7963371_9A10_40EE_879C_C4BE98325956#52840, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52743 AS COL_3D21C63F_D82A_485E_B7EE_9B96F5A4824A#52841, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52744 AS COL_B1E15F32_F75D_46AE_AED7_0B1845CE85BB#52842, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52745 AS COL_2F7BB558_04F7_443D_A85F_5BF5AA7D7FDD#52843, COL_D67142F7_A207_4870_8963_E237B841636A#52746 AS COL_5CC2E896_C215_4794_A45A_9945697CAE42#52844, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52747 AS COL_0526B2C4_CE15_4470_B5AF_24EC95A3DE25#52845, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52748 AS COL_DB04290B_9CA1_4F00_804C_CD188E8BF347#52846, COL_1C35A227_836A_4477_8139_CAB7258B4395#52749 AS COL_F6421F2B_EFE8_415C_BE9B_BD6EB611742A#52847, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52750 AS COL_3ED1C505_ED04_4D02_A7F1_8F840B120464#52848, COL_15505186_7875_4C25_9AEA_F3510A184E50#52751 AS COL_0BDC6CDA_C404_49DF_A61D_B5CC0CA86F33#52849, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52755 AS COL_D772A94C_1E4E_4537_BC51_6C9A15F124E7#52850, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52756 AS COL_5B422905_E031_409E_88DC_80808F8FC3B1#52851, COL_43DB4E14_8605_40F0_853F_057B052318BE#52753 AS COL_6FC4500D_B278_45D6_95C0_F2446D7F36BC#52852, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012 AS COL_FA27A728_B458_49E6_9EE3_09317DB691A6#52853, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52752 AS COL_0448AC7A_2262_4795_92E2_462F8D17BBBE#52854, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009 AS COL_AEEE92C5_F212_4094_B620_ED88D0177315#52855, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52757 AS COL_E73C5AF7_D070_450A_83D0_D37E6028068C#52856, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014 AS COL_AFB3BC30_ED55_4267_9AD7_6E5374A8E7C2#52857, 1 AS NULL_1#52920]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52656 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52739, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52657 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52740, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52658 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52741, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52659 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52742, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52660 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52743, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52661 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52744, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52662 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52745, COL_D67142F7_A207_4870_8963_E237B841636A#52663 AS COL_D67142F7_A207_4870_8963_E237B841636A#52746, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52664 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52747, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52665 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52748, COL_1C35A227_836A_4477_8139_CAB7258B4395#52666 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52749, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52667 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52750, COL_15505186_7875_4C25_9AEA_F3510A184E50#52668 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52751, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52669 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52752, COL_43DB4E14_8605_40F0_853F_057B052318BE#52671 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52753, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52672 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52754, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52673 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52755, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52674 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52756, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52670 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52757, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52115 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52656, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52117 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52657, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52119 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52658, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52121 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52659, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52123 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52660, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52124 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52661, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52126 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52662, COL_D67142F7_A207_4870_8963_E237B841636A#52128 AS COL_D67142F7_A207_4870_8963_E237B841636A#52663, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52130 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52664, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52132 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52665, COL_1C35A227_836A_4477_8139_CAB7258B4395#52134 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52666, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52136 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52667, COL_15505186_7875_4C25_9AEA_F3510A184E50#52138 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52668, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52140 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52669, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52142 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52670, COL_43DB4E14_8605_40F0_853F_057B052318BE#52556 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52671, COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52557 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52672, COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52558 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52673, COL_8753F2C2_5508_43B2_93E7_9030916A7821#52559 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52674, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014]
+- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52115, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52117, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52119, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52121, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52123, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52124, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52126, COL_D67142F7_A207_4870_8963_E237B841636A#52128, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52130, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52132, COL_1C35A227_836A_4477_8139_CAB7258B4395#52134, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52136, COL_15505186_7875_4C25_9AEA_F3510A184E50#52138, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52140, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014, CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#52253 AS COL_43DB4E14_8605_40F0_853F_057B052318BE#52556, CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#52255 AS COL_5ADB645E_4670_45D6_BBA3_A520838C6B81#52557, CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#52259 AS COL_98D50C86_6D7B_4D87_962C_4FD23EF946D1#52558, CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#52260 AS COL_8753F2C2_5508_43B2_93E7_9030916A7821#52559]
+- Join LeftOuter, (COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52140 = CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#52262)
:- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52013 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52115, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51995 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#52117, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51996 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#52119, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51997 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#52121, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51998 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#52123, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51999 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#52124, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52000 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52126, COL_D67142F7_A207_4870_8963_E237B841636A#52001 AS COL_D67142F7_A207_4870_8963_E237B841636A#52128, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52002 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52130, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52003 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52132, COL_1C35A227_836A_4477_8139_CAB7258B4395#52004 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52134, COL_D171F390_EECB_4924_B2C2_095D45EAE768#52005 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52136, COL_15505186_7875_4C25_9AEA_F3510A184E50#52006 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52138, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52007 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52140, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52008 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52142, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014]
: +- Project [COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#51995, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#51996, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#51997, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#51998, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#51999, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#52000, COL_D67142F7_A207_4870_8963_E237B841636A#50528 AS COL_D67142F7_A207_4870_8963_E237B841636A#52001, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#52002, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#52003, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#52004, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#52005, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#52006, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617 AS COL_0B397755_5134_465F_9DF7_BE869AEF3A25#52007, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925 AS COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#52008, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024 AS COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#52009, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100 AS COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#52010, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51367 AS COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#52011, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51562 AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#52012, COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#52013, COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#51829 AS COL_CC0DAE07_0228_40CF_BB56_B6B1B4E1F7A8#52014]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51367, COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51562, str_transform_case(str_remove_accent(str_replace_extend(COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, 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#51829]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100, COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51367, str_split(str_remove_space(COL_FF7D069B_5CBB_42B1_BC80_AEA2CC71B932#51367, cast(ONLY_ONE as string)), cast( as string)) AS COL_74E4AB7F_D7DA_4980_BA4F_0560C2246349#51562]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024, COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100, str_replace_extend(str_replace_regex(COL_42CFEA5A_A3FF_4B31_8AEA_FFC9260699DB#51100, 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#51367]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024, str_replace_extend(str_concat(struct(col1, cast( as string), COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6, COL_45FFC697_4E47_4F8A_81C7_A7C9874F99B6#51024)), 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#51100]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, COL_136B127C_5DD0_41CF_8579_2B9F54CA7A52#50925, str_remove_space(str_replace_extend(str_replace_regex(str_remove_space(str_transform_case(str_remove_accent(COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529), 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#51024]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, COL_0B397755_5134_465F_9DF7_BE869AEF3A25#50617, 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#50524, 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#50925]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50533, str_remove_space(str_replace_extend(str_remove_accent(str_transform_case(str_remove_space(COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, 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#50617]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50425 AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50521, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50426 AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50522, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50427 AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50523, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50428 AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50524, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50429 AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50525, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50430 AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50526, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50431 AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50527, COL_D67142F7_A207_4870_8963_E237B841636A#50432 AS COL_D67142F7_A207_4870_8963_E237B841636A#50528, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50433 AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50529, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50434 AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50530, COL_1C35A227_836A_4477_8139_CAB7258B4395#50435 AS COL_1C35A227_836A_4477_8139_CAB7258B4395#50531, COL_D171F390_EECB_4924_B2C2_095D45EAE768#50436 AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#50532, COL_15505186_7875_4C25_9AEA_F3510A184E50#50437 AS COL_15505186_7875_4C25_9AEA_F3510A184E50#50533]
: +- Project [cast(BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50279 as string) AS COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50425, cast(BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50280 as string) AS COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50426, cast(BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50281 as string) AS COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50427, cast(BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50282 as string) AS COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50428, cast(BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50283 as string) AS COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50429, cast(BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50284 as string) AS COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50430, cast(BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50285 as string) AS COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50431, cast(BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#50286 as string) AS COL_D67142F7_A207_4870_8963_E237B841636A#50432, cast(BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50287 as string) AS COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50433, cast(BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50288 as string) AS COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50434, cast(BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#50289 as int) AS COL_1C35A227_836A_4477_8139_CAB7258B4395#50435, cast(BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#50290 as string) AS COL_D171F390_EECB_4924_B2C2_095D45EAE768#50436, cast(BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#50291 as string) AS COL_15505186_7875_4C25_9AEA_F3510A184E50#50437]
: +- Project [COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#48330 AS BASE_RECONCILIA_32037_COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#50279, COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#48331 AS BASE_RECONCILIA_32037_COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#50280, COL_A9D2F897_5240_48C1_9585_64F572ED87DD#48332 AS BASE_RECONCILIA_32037_COL_A9D2F897_5240_48C1_9585_64F572ED87DD#50281, COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#48333 AS BASE_RECONCILIA_32037_COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#50282, COL_E78D776C_4947_4F88_826F_D6A3A22EF306#48334 AS BASE_RECONCILIA_32037_COL_E78D776C_4947_4F88_826F_D6A3A22EF306#50283, COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#48335 AS BASE_RECONCILIA_32037_COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#50284, COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#48336 AS BASE_RECONCILIA_32037_COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#50285, COL_D67142F7_A207_4870_8963_E237B841636A#48337 AS BASE_RECONCILIA_32037_COL_D67142F7_A207_4870_8963_E237B841636A#50286, COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#48338 AS BASE_RECONCILIA_32037_COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#50287, COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#48339 AS BASE_RECONCILIA_32037_COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#50288, COL_1C35A227_836A_4477_8139_CAB7258B4395#48340 AS BASE_RECONCILIA_32037_COL_1C35A227_836A_4477_8139_CAB7258B4395#50289, COL_D171F390_EECB_4924_B2C2_095D45EAE768#48341 AS BASE_RECONCILIA_32037_COL_D171F390_EECB_4924_B2C2_095D45EAE768#50290, COL_15505186_7875_4C25_9AEA_F3510A184E50#48342 AS BASE_RECONCILIA_32037_COL_15505186_7875_4C25_9AEA_F3510A184E50#50291, COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#48343 AS BASE_RECONCILIA_32037_COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#50292, COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#48344 AS BASE_RECONCILIA_32037_COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#50293, COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#48345 AS BASE_RECONCILIA_32037_COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#50294, COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#48346 AS BASE_RECONCILIA_32037_COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#50295, COL_7097258E_E88A_49F2_831E_C3EE780B3488#48347 AS BASE_RECONCILIA_32037_COL_7097258E_E88A_49F2_831E_C3EE780B3488#50296, COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#48348 AS BASE_RECONCILIA_32037_COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#50297, COL_3AA9677C_9524_43B7_9984_7C0506F35631#48349L AS BASE_RECONCILIA_32037_COL_3AA9677C_9524_43B7_9984_7C0506F35631#50298L, COL_E35C77C7_3C81_4648_9449_8217CD8A2230#48350L AS BASE_RECONCILIA_32037_COL_E35C77C7_3C81_4648_9449_8217CD8A2230#50299L, COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#48351 AS BASE_RECONCILIA_32037_COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#50300, COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#48352 AS BASE_RECONCILIA_32037_COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#50301, COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#48353L AS BASE_RECONCILIA_32037_COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#50302L, ... 2 more fields]
: +- SubqueryAlias BASE_RECONCILIA_32037114
: +- Relation[COL_5D8D2F5C_F830_4505_BF17_BA213CA447E2#48330,COL_2E9C6AB7_3233_4A3B_9A39_90D9FEAC6B92#48331,COL_A9D2F897_5240_48C1_9585_64F572ED87DD#48332,COL_2886BF11_4989_4F4A_AEC4_3E62688A4E7D#48333,COL_E78D776C_4947_4F88_826F_D6A3A22EF306#48334,COL_CA4EFECB_A4E3_4DBD_B0CC_66A14454C508#48335,COL_2B5A180A_8ABA_4438_90CB_A1F3096A952E#48336,COL_D67142F7_A207_4870_8963_E237B841636A#48337,COL_6C9B78F5_69CF_4C3C_905D_5B4A777C6708#48338,COL_759035A2_F085_40B2_80A9_EFA1BD3E6BDC#48339,COL_1C35A227_836A_4477_8139_CAB7258B4395#48340,COL_D171F390_EECB_4924_B2C2_095D45EAE768#48341,COL_15505186_7875_4C25_9AEA_F3510A184E50#48342,COL_717F3FDC_17CB_4A48_A4EC_5220E0178C29#48343,COL_17B22E0E_D35B_49D6_99E9_C82BA8E25369#48344,COL_BA25DF44_C9E4_4905_AA09_C3A31046A3F3#48345,COL_36F4DE5E_8ED3_4401_88A5_4C529ED53B02#48346,COL_7097258E_E88A_49F2_831E_C3EE780B3488#48347,COL_7A769EE6_7D6A_4046_8FAE_C84C84E95090#48348,COL_3AA9677C_9524_43B7_9984_7C0506F35631#48349L,COL_E35C77C7_3C81_4648_9449_8217CD8A2230#48350L,COL_6294DD0F_ABA4_45C0_A0F8_55EBB14B5126#48351,COL_391734AA_B2EC_4EEF_B5D7_80AABD494595#48352,COL_D67D58CA_B4F6_4BB7_ADD9_DFC1898BC180#48353L,... 2 more fields] parquet
+- Project [COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#49980 AS CODE_POSTAUX_ET_29368_COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#52253, COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#49981 AS CODE_POSTAUX_ET_29368_COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#52254, COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#49982 AS CODE_POSTAUX_ET_29368_COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#52255, COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#49983 AS CODE_POSTAUX_ET_29368_COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#52256, COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#49984 AS CODE_POSTAUX_ET_29368_COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#52257, COL_751AA3CB_093C_4274_81D1_CD0066B02F57#49985 AS CODE_POSTAUX_ET_29368_COL_751AA3CB_093C_4274_81D1_CD0066B02F57#52258, COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#49986 AS CODE_POSTAUX_ET_29368_COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#52259, COL_704D2ED6_F724_48C5_9729_DF12E090DF44#49987 AS CODE_POSTAUX_ET_29368_COL_704D2ED6_F724_48C5_9729_DF12E090DF44#52260, COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#49988 AS CODE_POSTAUX_ET_29368_COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#52261, COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#49989 AS CODE_POSTAUX_ET_29368_COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#52262, COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#49990 AS CODE_POSTAUX_ET_29368_COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#52263, COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#49991 AS CODE_POSTAUX_ET_29368_COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#52264]
+- SubqueryAlias CODE_POSTAUX_ET_29368114
+- Relation[COL_D9E89BBC_CBA0_41BC_A5DE_5F3868276454#49980,COL_7D93692F_6C34_4B55_A81B_C80EAE5C3D38#49981,COL_D38AB54B_FC4C_4540_A40E_EF160CF33DD7#49982,COL_DA1CD58B_E7C7_4F93_BBB9_71CE1B6BFB6F#49983,COL_25E878F6_F2DA_46F8_B31D_0B4D7FE94D6D#49984,COL_751AA3CB_093C_4274_81D1_CD0066B02F57#49985,COL_8BA6BD51_C5A2_4D68_8CDE_5388155A919E#49986,COL_704D2ED6_F724_48C5_9729_DF12E090DF44#49987,COL_EBB4E3A5_B9F0_41AD_BD3D_1C1BE6E286ED#49988,COL_91FF9C8A_8D6B_4FC8_B06C_C6C8A72F51CB#49989,COL_0657DF81_0C98_47CB_9B62_A8BF6F038377#49990,COL_A3D83D09_1D2C_4204_9D80_67FF5635169D#49991] parquet
