== 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_405142173`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Portefeuille#116047, Civilit%C3%A9#116048, Nom#116049, Id+Mandat#116050, N%C2%B0+Registre#116051, Taux+Honoraire#116052, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#116053], false
(4) Project
Arguments: [Portefeuille#116047 AS Portefeuille#116061, Civilit%C3%A9#116048, Nom#116049, Id+Mandat#116050, N%C2%B0+Registre#116051, Taux+Honoraire#116052, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#116053]
(5) Project
Arguments: [Portefeuille#116061, Civilit%C3%A9#116048 AS Civilité#116070, Nom#116049, Id+Mandat#116050, N%C2%B0+Registre#116051, Taux+Honoraire#116052, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#116053]
(6) Project
Arguments: [Portefeuille#116061, Civilité#116070, Nom#116049 AS Nom#116078, Id+Mandat#116050, N%C2%B0+Registre#116051, Taux+Honoraire#116052, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#116053]
(7) Project
Arguments: [Portefeuille#116061, Civilité#116070, Nom#116078, Id+Mandat#116050 AS Id Mandat#116086, N%C2%B0+Registre#116051, Taux+Honoraire#116052, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#116053]
(8) Project
Arguments: [Portefeuille#116061, Civilité#116070, Nom#116078, Id Mandat#116086, N%C2%B0+Registre#116051 AS N° Registre#116094, Taux+Honoraire#116052, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#116053]
(9) Project
Arguments: [Portefeuille#116061, Civilité#116070, Nom#116078, Id Mandat#116086, N° Registre#116094, Taux+Honoraire#116052 AS Taux Honoraire#116102, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#116053]
(10) Project
Arguments: [Portefeuille#116061, Civilité#116070, Nom#116078, Id Mandat#116086, N° Registre#116094, Taux Honoraire#116102, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#116053 AS 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#116110]
(11) Project
Arguments: [Portefeuille#116061 AS Portefeuille#116118, Civilité#116070 AS Civilité#116119, Nom#116078 AS Nom#116120, Id Mandat#116086 AS Id Mandat#116121, N° Registre#116094 AS N° Registre#116122, Taux Honoraire#116102 AS Taux Honoraire#116123, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#116110 AS 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#116124]
(12) Project
Arguments: [Portefeuille#116118, Civilité#116119, Nom#116120, Id Mandat#116121, N° Registre#116122, Taux Honoraire#116123, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#116124]
(13) Project
Arguments: [Civilité#116119 AS _CIVILIT#116139, Id Mandat#116121 AS _ID_MANDAT#116140, Nom#116120 AS _NOM#116141, N° Registre#116122 AS _N_REGISTRE#116142, Portefeuille#116118 AS _PORTEFEUILLE#116143, Taux Honoraire#116123 AS _TAUX_HONORAIRE#116144]
(14) Project
Arguments: [_CIVILIT#116139, _ID_MANDAT#116140, _NOM#116141, _N_REGISTRE#116142, _PORTEFEUILLE#116143, _TAUX_HONORAIRE#116144]
(15) View
Arguments: `PROPRIETAIRES_L_405135173`, true
(16) SubqueryAlias
Arguments: PROPRIETAIRES_L_405135173
(17) Project
Arguments: [_CIVILIT#116139 AS PROPRIETAIRES_L_405135__CIVILIT#116163, _ID_MANDAT#116140 AS PROPRIETAIRES_L_405135__ID_MANDAT#116164, _NOM#116141 AS PROPRIETAIRES_L_405135__NOM#116165, _N_REGISTRE#116142 AS PROPRIETAIRES_L_405135__N_REGISTRE#116166, _PORTEFEUILLE#116143 AS PROPRIETAIRES_L_405135__PORTEFEUILLE#116167, _TAUX_HONORAIRE#116144 AS PROPRIETAIRES_L_405135__TAUX_HONORAIRE#116168]
(18) Project
Arguments: [cast(PROPRIETAIRES_L_405135__PORTEFEUILLE#116167 as string) AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#116181, cast(PROPRIETAIRES_L_405135__CIVILIT#116163 as string) AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116182, cast(PROPRIETAIRES_L_405135__NOM#116165 as string) AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#116183, cast(PROPRIETAIRES_L_405135__ID_MANDAT#116164 as string) AS COL_84669589_3EDF_4867_8128_B2F334719709#116184, cast(PROPRIETAIRES_L_405135__N_REGISTRE#116166 as string) AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#116185, cast(PROPRIETAIRES_L_405135__TAUX_HONORAIRE#116168 as string) AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#116186]
(19) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#116181 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#116193, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116182 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116194, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#116183 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#116195, COL_84669589_3EDF_4867_8128_B2F334719709#116184 AS COL_84669589_3EDF_4867_8128_B2F334719709#116196, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#116185 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#116197, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#116186 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#116198]
(20) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#116193, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116194, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#116195, COL_84669589_3EDF_4867_8128_B2F334719709#116196, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#116197, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#116198, str_if_with_rule(CASE WHEN isnull(Contains(COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#116198, cast(- 0 as string))) THEN false ELSE Contains(COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#116198, cast(- 0 as string)) END, cast(Absence Taux as string), cast( as string)) AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#116205]
(21) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#116193, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116194, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#116195, COL_84669589_3EDF_4867_8128_B2F334719709#116196, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#116197, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#116198, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#116205, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116194, Madame, equal, struct(col1, Madame), struct(col1, ), true, MME, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116194, Monsieur, equal, struct(col1, MONSIEUR), struct(col1, ), true, MR, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116194, M et Mme, equal, struct(col1, M ET MME), struct(col1, ), true, M_ET_MME, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116194, Succession, equal, struct(col1, Succession), struct(col1, ), true, SUCCESSION, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116194, Ind., equal, struct(col1, IND.), struct(col1, ), true, IND., , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116194, Consorts, equal, struct(col1, CONSORTS), struct(col1, ), true, CONSORT, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116194, SCI, equal, struct(col1, SCI), struct(col1, ), true, SCI, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116194, SARL, equal, struct(col1, SARL), struct(col1, ), true, SARL, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116194, Indivision, equal, struct(col1, INDIVISION), struct(col1, ), true, INDIVISION, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116194, M ou Mme, equal, struct(col1, M OU MME), struct(col1, ), true, M_OU_MME, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116194, Messieurs, equal, struct(col1, MESSIEURS), struct(col1, ), true, MM, , null))) AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#116213]
(22) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#116193, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116194, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#116195, COL_84669589_3EDF_4867_8128_B2F334719709#116196, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#116197, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#116198, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#116205, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#116213, str_remove_space(str_remove_accent(str_transform_case(COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#116195, cast(UPPER as string))), cast(ONLY_ONE as string)) AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#116222]
(23) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#116193, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116194, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#116195, COL_84669589_3EDF_4867_8128_B2F334719709#116196, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#116197, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#116198, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#116205, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#116213, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#116222, str_join(array(COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#116213, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#116222), cast( as string)) AS COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#116232]
(24) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#116193 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#116243, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116194 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#116244, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#116195 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#116245, COL_84669589_3EDF_4867_8128_B2F334719709#116196 AS COL_84669589_3EDF_4867_8128_B2F334719709#116246, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#116197 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#116247, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#116198 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#116248, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#116205 AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#116249, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#116213 AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#116250, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#116222 AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#116251, COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#116232 AS COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#116252]