== 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_405142169`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Portefeuille#118168, Civilit%C3%A9#118169, Nom#118170, Id+Mandat#118171, N%C2%B0+Registre#118172, Taux+Honoraire#118173, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#118174], false
(4) Project
Arguments: [Portefeuille#118168 AS Portefeuille#118182, Civilit%C3%A9#118169, Nom#118170, Id+Mandat#118171, N%C2%B0+Registre#118172, Taux+Honoraire#118173, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#118174]
(5) Project
Arguments: [Portefeuille#118182, Civilit%C3%A9#118169 AS Civilité#118191, Nom#118170, Id+Mandat#118171, N%C2%B0+Registre#118172, Taux+Honoraire#118173, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#118174]
(6) Project
Arguments: [Portefeuille#118182, Civilité#118191, Nom#118170 AS Nom#118199, Id+Mandat#118171, N%C2%B0+Registre#118172, Taux+Honoraire#118173, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#118174]
(7) Project
Arguments: [Portefeuille#118182, Civilité#118191, Nom#118199, Id+Mandat#118171 AS Id Mandat#118207, N%C2%B0+Registre#118172, Taux+Honoraire#118173, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#118174]
(8) Project
Arguments: [Portefeuille#118182, Civilité#118191, Nom#118199, Id Mandat#118207, N%C2%B0+Registre#118172 AS N° Registre#118215, Taux+Honoraire#118173, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#118174]
(9) Project
Arguments: [Portefeuille#118182, Civilité#118191, Nom#118199, Id Mandat#118207, N° Registre#118215, Taux+Honoraire#118173 AS Taux Honoraire#118223, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#118174]
(10) Project
Arguments: [Portefeuille#118182, Civilité#118191, Nom#118199, Id Mandat#118207, N° Registre#118215, Taux Honoraire#118223, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#118174 AS 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#118231]
(11) Project
Arguments: [Portefeuille#118182 AS Portefeuille#118239, Civilité#118191 AS Civilité#118240, Nom#118199 AS Nom#118241, Id Mandat#118207 AS Id Mandat#118242, N° Registre#118215 AS N° Registre#118243, Taux Honoraire#118223 AS Taux Honoraire#118244, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#118231 AS 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#118245]
(12) Project
Arguments: [Portefeuille#118239, Civilité#118240, Nom#118241, Id Mandat#118242, N° Registre#118243, Taux Honoraire#118244, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#118245]
(13) Project
Arguments: [Civilité#118240 AS _CIVILIT#118260, Id Mandat#118242 AS _ID_MANDAT#118261, Nom#118241 AS _NOM#118262, N° Registre#118243 AS _N_REGISTRE#118263, Portefeuille#118239 AS _PORTEFEUILLE#118264, Taux Honoraire#118244 AS _TAUX_HONORAIRE#118265]
(14) Project
Arguments: [_CIVILIT#118260, _ID_MANDAT#118261, _NOM#118262, _N_REGISTRE#118263, _PORTEFEUILLE#118264, _TAUX_HONORAIRE#118265]
(15) View
Arguments: `PROPRIETAIRES_L_405135169`, true
(16) SubqueryAlias
Arguments: PROPRIETAIRES_L_405135169
(17) Project
Arguments: [_CIVILIT#118260 AS PROPRIETAIRES_L_405135__CIVILIT#118284, _ID_MANDAT#118261 AS PROPRIETAIRES_L_405135__ID_MANDAT#118285, _NOM#118262 AS PROPRIETAIRES_L_405135__NOM#118286, _N_REGISTRE#118263 AS PROPRIETAIRES_L_405135__N_REGISTRE#118287, _PORTEFEUILLE#118264 AS PROPRIETAIRES_L_405135__PORTEFEUILLE#118288, _TAUX_HONORAIRE#118265 AS PROPRIETAIRES_L_405135__TAUX_HONORAIRE#118289]
(18) Project
Arguments: [cast(PROPRIETAIRES_L_405135__PORTEFEUILLE#118288 as string) AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#118302, cast(PROPRIETAIRES_L_405135__CIVILIT#118284 as string) AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118303, cast(PROPRIETAIRES_L_405135__NOM#118286 as string) AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#118304, cast(PROPRIETAIRES_L_405135__ID_MANDAT#118285 as string) AS COL_84669589_3EDF_4867_8128_B2F334719709#118305, cast(PROPRIETAIRES_L_405135__N_REGISTRE#118287 as string) AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#118306, cast(PROPRIETAIRES_L_405135__TAUX_HONORAIRE#118289 as string) AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#118307]
(19) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#118302 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#118314, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118303 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118315, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#118304 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#118316, COL_84669589_3EDF_4867_8128_B2F334719709#118305 AS COL_84669589_3EDF_4867_8128_B2F334719709#118317, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#118306 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#118318, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#118307 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#118319]
(20) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#118314, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118315, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#118316, COL_84669589_3EDF_4867_8128_B2F334719709#118317, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#118318, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#118319, str_if_with_rule(CASE WHEN isnull(Contains(COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#118319, cast(- 0 as string))) THEN false ELSE Contains(COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#118319, cast(- 0 as string)) END, cast(Absence Taux as string), cast( as string)) AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#118326]
(21) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#118314, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118315, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#118316, COL_84669589_3EDF_4867_8128_B2F334719709#118317, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#118318, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#118319, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#118326, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118315, Madame, equal, struct(col1, Madame), struct(col1, ), true, MME, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118315, Monsieur, equal, struct(col1, MONSIEUR), struct(col1, ), true, MR, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118315, M et Mme, equal, struct(col1, M ET MME), struct(col1, ), true, M_ET_MME, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118315, Succession, equal, struct(col1, Succession), struct(col1, ), true, SUCCESSION, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118315, Ind., equal, struct(col1, IND.), struct(col1, ), true, IND., , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118315, Consorts, equal, struct(col1, CONSORTS), struct(col1, ), true, CONSORT, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118315, SCI, equal, struct(col1, SCI), struct(col1, ), true, SCI, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118315, SARL, equal, struct(col1, SARL), struct(col1, ), true, SARL, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118315, Indivision, equal, struct(col1, INDIVISION), struct(col1, ), true, INDIVISION, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118315, M ou Mme, equal, struct(col1, M OU MME), struct(col1, ), true, M_OU_MME, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118315, Messieurs, equal, struct(col1, MESSIEURS), struct(col1, ), true, MM, , null))) AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#118334]
(22) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#118314, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118315, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#118316, COL_84669589_3EDF_4867_8128_B2F334719709#118317, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#118318, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#118319, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#118326, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#118334, str_remove_space(str_remove_accent(str_transform_case(COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#118316, cast(UPPER as string))), cast(ONLY_ONE as string)) AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#118343]
(23) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#118314, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118315, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#118316, COL_84669589_3EDF_4867_8128_B2F334719709#118317, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#118318, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#118319, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#118326, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#118334, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#118343, str_join(array(COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#118334, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#118343), cast( as string)) AS COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#118359]
(24) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#118314 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#118370, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118315 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#118371, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#118316 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#118372, COL_84669589_3EDF_4867_8128_B2F334719709#118317 AS COL_84669589_3EDF_4867_8128_B2F334719709#118373, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#118318 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#118374, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#118319 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#118375, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#118326 AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#118376, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#118334 AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#118377, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#118343 AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#118378, COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#118359 AS COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#118379]