== 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_405142172`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Portefeuille#221436, Civilit%C3%A9#221437, Nom#221438, Id+Mandat#221439, N%C2%B0+Registre#221440, Taux+Honoraire#221441, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#221442], false
(4) Project
Arguments: [Portefeuille#221436 AS Portefeuille#221450, Civilit%C3%A9#221437, Nom#221438, Id+Mandat#221439, N%C2%B0+Registre#221440, Taux+Honoraire#221441, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#221442]
(5) Project
Arguments: [Portefeuille#221450, Civilit%C3%A9#221437 AS Civilité#221459, Nom#221438, Id+Mandat#221439, N%C2%B0+Registre#221440, Taux+Honoraire#221441, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#221442]
(6) Project
Arguments: [Portefeuille#221450, Civilité#221459, Nom#221438 AS Nom#221467, Id+Mandat#221439, N%C2%B0+Registre#221440, Taux+Honoraire#221441, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#221442]
(7) Project
Arguments: [Portefeuille#221450, Civilité#221459, Nom#221467, Id+Mandat#221439 AS Id Mandat#221475, N%C2%B0+Registre#221440, Taux+Honoraire#221441, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#221442]
(8) Project
Arguments: [Portefeuille#221450, Civilité#221459, Nom#221467, Id Mandat#221475, N%C2%B0+Registre#221440 AS N° Registre#221483, Taux+Honoraire#221441, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#221442]
(9) Project
Arguments: [Portefeuille#221450, Civilité#221459, Nom#221467, Id Mandat#221475, N° Registre#221483, Taux+Honoraire#221441 AS Taux Honoraire#221491, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#221442]
(10) Project
Arguments: [Portefeuille#221450, Civilité#221459, Nom#221467, Id Mandat#221475, N° Registre#221483, Taux Honoraire#221491, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#221442 AS 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#221499]
(11) Project
Arguments: [Portefeuille#221450 AS Portefeuille#221507, Civilité#221459 AS Civilité#221508, Nom#221467 AS Nom#221509, Id Mandat#221475 AS Id Mandat#221510, N° Registre#221483 AS N° Registre#221511, Taux Honoraire#221491 AS Taux Honoraire#221512, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#221499 AS 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#221513]
(12) Project
Arguments: [Portefeuille#221507, Civilité#221508, Nom#221509, Id Mandat#221510, N° Registre#221511, Taux Honoraire#221512, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#221513]
(13) Project
Arguments: [Civilité#221508 AS _CIVILIT#221528, Id Mandat#221510 AS _ID_MANDAT#221529, Nom#221509 AS _NOM#221530, N° Registre#221511 AS _N_REGISTRE#221531, Portefeuille#221507 AS _PORTEFEUILLE#221532, Taux Honoraire#221512 AS _TAUX_HONORAIRE#221533]
(14) Project
Arguments: [_CIVILIT#221528, _ID_MANDAT#221529, _NOM#221530, _N_REGISTRE#221531, _PORTEFEUILLE#221532, _TAUX_HONORAIRE#221533]
(15) View
Arguments: `PROPRIETAIRES_L_405135172`, true
(16) SubqueryAlias
Arguments: PROPRIETAIRES_L_405135172
(17) Project
Arguments: [_CIVILIT#221528 AS PROPRIETAIRES_L_405135__CIVILIT#221552, _ID_MANDAT#221529 AS PROPRIETAIRES_L_405135__ID_MANDAT#221553, _NOM#221530 AS PROPRIETAIRES_L_405135__NOM#221554, _N_REGISTRE#221531 AS PROPRIETAIRES_L_405135__N_REGISTRE#221555, _PORTEFEUILLE#221532 AS PROPRIETAIRES_L_405135__PORTEFEUILLE#221556, _TAUX_HONORAIRE#221533 AS PROPRIETAIRES_L_405135__TAUX_HONORAIRE#221557]
(18) Project
Arguments: [cast(PROPRIETAIRES_L_405135__PORTEFEUILLE#221556 as string) AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#221570, cast(PROPRIETAIRES_L_405135__CIVILIT#221552 as string) AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221571, cast(PROPRIETAIRES_L_405135__NOM#221554 as string) AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#221572, cast(PROPRIETAIRES_L_405135__ID_MANDAT#221553 as string) AS COL_84669589_3EDF_4867_8128_B2F334719709#221573, cast(PROPRIETAIRES_L_405135__N_REGISTRE#221555 as string) AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#221574, cast(PROPRIETAIRES_L_405135__TAUX_HONORAIRE#221557 as string) AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#221575]
(19) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#221570 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#221582, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221571 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221583, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#221572 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#221584, COL_84669589_3EDF_4867_8128_B2F334719709#221573 AS COL_84669589_3EDF_4867_8128_B2F334719709#221585, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#221574 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#221586, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#221575 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#221587]
(20) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#221582, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221583, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#221584, COL_84669589_3EDF_4867_8128_B2F334719709#221585, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#221586, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#221587, str_if_with_rule(CASE WHEN isnull(Contains(COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#221587, cast(- 0 as string))) THEN false ELSE Contains(COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#221587, cast(- 0 as string)) END, cast(Absence Taux as string), cast( as string)) AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#221594]
(21) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#221582, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221583, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#221584, COL_84669589_3EDF_4867_8128_B2F334719709#221585, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#221586, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#221587, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#221594, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221583, Madame, equal, struct(col1, Madame), struct(col1, ), true, MME, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221583, Monsieur, equal, struct(col1, MONSIEUR), struct(col1, ), true, MR, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221583, M et Mme, equal, struct(col1, M ET MME), struct(col1, ), true, M_ET_MME, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221583, Succession, equal, struct(col1, Succession), struct(col1, ), true, SUCCESSION, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221583, Ind., equal, struct(col1, IND.), struct(col1, ), true, IND., , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221583, Consorts, equal, struct(col1, CONSORTS), struct(col1, ), true, CONSORT, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221583, SCI, equal, struct(col1, SCI), struct(col1, ), true, SCI, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221583, SARL, equal, struct(col1, SARL), struct(col1, ), true, SARL, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221583, Indivision, equal, struct(col1, INDIVISION), struct(col1, ), true, INDIVISION, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221583, M ou Mme, equal, struct(col1, M OU MME), struct(col1, ), true, M_OU_MME, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221583, Messieurs, equal, struct(col1, MESSIEURS), struct(col1, ), true, MM, , null))) AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#221602]
(22) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#221582, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221583, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#221584, COL_84669589_3EDF_4867_8128_B2F334719709#221585, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#221586, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#221587, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#221594, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#221602, str_remove_space(str_remove_accent(str_transform_case(COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#221584, cast(UPPER as string))), cast(ONLY_ONE as string)) AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#221611]
(23) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#221582, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221583, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#221584, COL_84669589_3EDF_4867_8128_B2F334719709#221585, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#221586, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#221587, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#221594, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#221602, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#221611, str_join(array(COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#221602, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#221611), cast( as string)) AS COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#221621]
(24) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#221582 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#221632, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221583 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#221633, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#221584 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#221634, COL_84669589_3EDF_4867_8128_B2F334719709#221585 AS COL_84669589_3EDF_4867_8128_B2F334719709#221635, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#221586 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#221636, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#221587 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#221637, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#221594 AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#221638, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#221602 AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#221639, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#221611 AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#221640, COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#221621 AS COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#221641]