== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (24)
+- Project (23)
+- Project (22)
+- Project (21)
+- Project (20)
+- Project (19)
+- Project (18)
+- Project (17)
+- SubqueryAlias (16)
+- View (15)
+- Project (14)
+- Project (13)
+- Project (12)
+- Project (11)
+- Project (10)
+- Project (9)
+- Project (8)
+- Project (7)
+- Project (6)
+- Project (5)
+- Project (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `PROPRIETAIRES_L_405142174`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Portefeuille#124660, Civilit%C3%A9#124661, Nom#124662, Id+Mandat#124663, N%C2%B0+Registre#124664, Taux+Honoraire#124665, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#124666], false
(4) Project
Arguments: [Portefeuille#124660 AS Portefeuille#124674, Civilit%C3%A9#124661, Nom#124662, Id+Mandat#124663, N%C2%B0+Registre#124664, Taux+Honoraire#124665, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#124666]
(5) Project
Arguments: [Portefeuille#124674, Civilit%C3%A9#124661 AS Civilité#124683, Nom#124662, Id+Mandat#124663, N%C2%B0+Registre#124664, Taux+Honoraire#124665, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#124666]
(6) Project
Arguments: [Portefeuille#124674, Civilité#124683, Nom#124662 AS Nom#124691, Id+Mandat#124663, N%C2%B0+Registre#124664, Taux+Honoraire#124665, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#124666]
(7) Project
Arguments: [Portefeuille#124674, Civilité#124683, Nom#124691, Id+Mandat#124663 AS Id Mandat#124699, N%C2%B0+Registre#124664, Taux+Honoraire#124665, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#124666]
(8) Project
Arguments: [Portefeuille#124674, Civilité#124683, Nom#124691, Id Mandat#124699, N%C2%B0+Registre#124664 AS N° Registre#124707, Taux+Honoraire#124665, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#124666]
(9) Project
Arguments: [Portefeuille#124674, Civilité#124683, Nom#124691, Id Mandat#124699, N° Registre#124707, Taux+Honoraire#124665 AS Taux Honoraire#124715, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#124666]
(10) Project
Arguments: [Portefeuille#124674, Civilité#124683, Nom#124691, Id Mandat#124699, N° Registre#124707, Taux Honoraire#124715, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#124666 AS 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#124723]
(11) Project
Arguments: [Portefeuille#124674 AS Portefeuille#124731, Civilité#124683 AS Civilité#124732, Nom#124691 AS Nom#124733, Id Mandat#124699 AS Id Mandat#124734, N° Registre#124707 AS N° Registre#124735, Taux Honoraire#124715 AS Taux Honoraire#124736, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#124723 AS 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#124737]
(12) Project
Arguments: [Portefeuille#124731, Civilité#124732, Nom#124733, Id Mandat#124734, N° Registre#124735, Taux Honoraire#124736, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#124737]
(13) Project
Arguments: [Civilité#124732 AS _CIVILIT#124752, Id Mandat#124734 AS _ID_MANDAT#124753, Nom#124733 AS _NOM#124754, N° Registre#124735 AS _N_REGISTRE#124755, Portefeuille#124731 AS _PORTEFEUILLE#124756, Taux Honoraire#124736 AS _TAUX_HONORAIRE#124757]
(14) Project
Arguments: [_CIVILIT#124752, _ID_MANDAT#124753, _NOM#124754, _N_REGISTRE#124755, _PORTEFEUILLE#124756, _TAUX_HONORAIRE#124757]
(15) View
Arguments: `PROPRIETAIRES_L_405135174`, true
(16) SubqueryAlias
Arguments: PROPRIETAIRES_L_405135174
(17) Project
Arguments: [_CIVILIT#124752 AS PROPRIETAIRES_L_405135__CIVILIT#124776, _ID_MANDAT#124753 AS PROPRIETAIRES_L_405135__ID_MANDAT#124777, _NOM#124754 AS PROPRIETAIRES_L_405135__NOM#124778, _N_REGISTRE#124755 AS PROPRIETAIRES_L_405135__N_REGISTRE#124779, _PORTEFEUILLE#124756 AS PROPRIETAIRES_L_405135__PORTEFEUILLE#124780, _TAUX_HONORAIRE#124757 AS PROPRIETAIRES_L_405135__TAUX_HONORAIRE#124781]
(18) Project
Arguments: [cast(PROPRIETAIRES_L_405135__PORTEFEUILLE#124780 as string) AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#124794, cast(PROPRIETAIRES_L_405135__CIVILIT#124776 as string) AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124795, cast(PROPRIETAIRES_L_405135__NOM#124778 as string) AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#124796, cast(PROPRIETAIRES_L_405135__ID_MANDAT#124777 as string) AS COL_84669589_3EDF_4867_8128_B2F334719709#124797, cast(PROPRIETAIRES_L_405135__N_REGISTRE#124779 as string) AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#124798, cast(PROPRIETAIRES_L_405135__TAUX_HONORAIRE#124781 as string) AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#124799]
(19) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#124794 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#124806, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124795 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124807, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#124796 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#124808, COL_84669589_3EDF_4867_8128_B2F334719709#124797 AS COL_84669589_3EDF_4867_8128_B2F334719709#124809, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#124798 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#124810, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#124799 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#124811]
(20) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#124806, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124807, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#124808, COL_84669589_3EDF_4867_8128_B2F334719709#124809, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#124810, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#124811, str_if_with_rule(CASE WHEN isnull(Contains(COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#124811, cast(- 0 as string))) THEN false ELSE Contains(COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#124811, cast(- 0 as string)) END, cast(Absence Taux as string), cast( as string)) AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#124818]
(21) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#124806, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124807, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#124808, COL_84669589_3EDF_4867_8128_B2F334719709#124809, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#124810, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#124811, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#124818, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124807, Madame, equal, struct(col1, Madame), struct(col1, ), true, MME, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124807, Monsieur, equal, struct(col1, MONSIEUR), struct(col1, ), true, MR, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124807, M et Mme, equal, struct(col1, M ET MME), struct(col1, ), true, M_ET_MME, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124807, Succession, equal, struct(col1, Succession), struct(col1, ), true, SUCCESSION, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124807, Ind., equal, struct(col1, IND.), struct(col1, ), true, IND., , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124807, Consorts, equal, struct(col1, CONSORTS), struct(col1, ), true, CONSORT, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124807, SCI, equal, struct(col1, SCI), struct(col1, ), true, SCI, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124807, SARL, equal, struct(col1, SARL), struct(col1, ), true, SARL, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124807, Indivision, equal, struct(col1, INDIVISION), struct(col1, ), true, INDIVISION, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124807, M ou Mme, equal, struct(col1, M OU MME), struct(col1, ), true, M_OU_MME, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124807, Messieurs, equal, struct(col1, MESSIEURS), struct(col1, ), true, MM, , null))) AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#124826]
(22) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#124806, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124807, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#124808, COL_84669589_3EDF_4867_8128_B2F334719709#124809, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#124810, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#124811, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#124818, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#124826, str_remove_space(str_remove_accent(str_transform_case(COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#124808, cast(UPPER as string))), cast(ONLY_ONE as string)) AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#124835]
(23) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#124806, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124807, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#124808, COL_84669589_3EDF_4867_8128_B2F334719709#124809, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#124810, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#124811, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#124818, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#124826, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#124835, str_join(array(COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#124826, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#124835), cast( as string)) AS COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#124845]
(24) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#124806 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#124856, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124807 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#124857, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#124808 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#124858, COL_84669589_3EDF_4867_8128_B2F334719709#124809 AS COL_84669589_3EDF_4867_8128_B2F334719709#124859, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#124810 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#124860, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#124811 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#124861, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#124818 AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#124862, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#124826 AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#124863, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#124835 AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#124864, COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#124845 AS COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#124865]