== 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_405142167`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Portefeuille#82043, Civilit%C3%A9#82044, Nom#82045, Id+Mandat#82046, N%C2%B0+Registre#82047, Taux+Honoraire#82048, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#82049], false
(4) Project
Arguments: [Portefeuille#82043 AS Portefeuille#82088, Civilit%C3%A9#82044, Nom#82045, Id+Mandat#82046, N%C2%B0+Registre#82047, Taux+Honoraire#82048, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#82049]
(5) Project
Arguments: [Portefeuille#82088, Civilit%C3%A9#82044 AS Civilité#82097, Nom#82045, Id+Mandat#82046, N%C2%B0+Registre#82047, Taux+Honoraire#82048, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#82049]
(6) Project
Arguments: [Portefeuille#82088, Civilité#82097, Nom#82045 AS Nom#82105, Id+Mandat#82046, N%C2%B0+Registre#82047, Taux+Honoraire#82048, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#82049]
(7) Project
Arguments: [Portefeuille#82088, Civilité#82097, Nom#82105, Id+Mandat#82046 AS Id Mandat#82113, N%C2%B0+Registre#82047, Taux+Honoraire#82048, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#82049]
(8) Project
Arguments: [Portefeuille#82088, Civilité#82097, Nom#82105, Id Mandat#82113, N%C2%B0+Registre#82047 AS N° Registre#82121, Taux+Honoraire#82048, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#82049]
(9) Project
Arguments: [Portefeuille#82088, Civilité#82097, Nom#82105, Id Mandat#82113, N° Registre#82121, Taux+Honoraire#82048 AS Taux Honoraire#82129, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#82049]
(10) Project
Arguments: [Portefeuille#82088, Civilité#82097, Nom#82105, Id Mandat#82113, N° Registre#82121, Taux Honoraire#82129, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#82049 AS 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#82137]
(11) Project
Arguments: [Portefeuille#82088 AS Portefeuille#82151, Civilité#82097 AS Civilité#82152, Nom#82105 AS Nom#82153, Id Mandat#82113 AS Id Mandat#82154, N° Registre#82121 AS N° Registre#82155, Taux Honoraire#82129 AS Taux Honoraire#82156, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#82137 AS 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#82157]
(12) Project
Arguments: [Portefeuille#82151, Civilité#82152, Nom#82153, Id Mandat#82154, N° Registre#82155, Taux Honoraire#82156, 1210D38A_30A1_417E_AC30_A633AB773A43HEADER_COL_DETAIL_DEPOT#82157]
(13) Project
Arguments: [Civilité#82152 AS _CIVILIT#82172, Id Mandat#82154 AS _ID_MANDAT#82173, Nom#82153 AS _NOM#82174, N° Registre#82155 AS _N_REGISTRE#82175, Portefeuille#82151 AS _PORTEFEUILLE#82176, Taux Honoraire#82156 AS _TAUX_HONORAIRE#82177]
(14) Project
Arguments: [_CIVILIT#82172, _ID_MANDAT#82173, _NOM#82174, _N_REGISTRE#82175, _PORTEFEUILLE#82176, _TAUX_HONORAIRE#82177]
(15) View
Arguments: `PROPRIETAIRES_L_405135167`, true
(16) SubqueryAlias
Arguments: PROPRIETAIRES_L_405135167
(17) Project
Arguments: [_CIVILIT#82172 AS PROPRIETAIRES_L_405135__CIVILIT#82241, _ID_MANDAT#82173 AS PROPRIETAIRES_L_405135__ID_MANDAT#82242, _NOM#82174 AS PROPRIETAIRES_L_405135__NOM#82243, _N_REGISTRE#82175 AS PROPRIETAIRES_L_405135__N_REGISTRE#82244, _PORTEFEUILLE#82176 AS PROPRIETAIRES_L_405135__PORTEFEUILLE#82245, _TAUX_HONORAIRE#82177 AS PROPRIETAIRES_L_405135__TAUX_HONORAIRE#82246]
(18) Project
Arguments: [cast(PROPRIETAIRES_L_405135__PORTEFEUILLE#82245 as string) AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82259, cast(PROPRIETAIRES_L_405135__CIVILIT#82241 as string) AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82260, cast(PROPRIETAIRES_L_405135__NOM#82243 as string) AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82261, cast(PROPRIETAIRES_L_405135__ID_MANDAT#82242 as string) AS COL_84669589_3EDF_4867_8128_B2F334719709#82262, cast(PROPRIETAIRES_L_405135__N_REGISTRE#82244 as string) AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82263, cast(PROPRIETAIRES_L_405135__TAUX_HONORAIRE#82246 as string) AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82264]
(19) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82259 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82271, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82260 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82261 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82273, COL_84669589_3EDF_4867_8128_B2F334719709#82262 AS COL_84669589_3EDF_4867_8128_B2F334719709#82274, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82263 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82275, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82264 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82276]
(20) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82271, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82273, COL_84669589_3EDF_4867_8128_B2F334719709#82274, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82275, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82276, str_if_with_rule(CASE WHEN isnull(Contains(COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82276, cast(- 0 as string))) THEN false ELSE Contains(COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82276, cast(- 0 as string)) END, cast(Absence Taux as string), cast( as string)) AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82283]
(21) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82271, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82273, COL_84669589_3EDF_4867_8128_B2F334719709#82274, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82275, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82276, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82283, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, Madame, equal, struct(col1, Madame), struct(col1, ), true, MME, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, Monsieur, equal, struct(col1, MONSIEUR), struct(col1, ), true, MR, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, M et Mme, equal, struct(col1, M ET MME), struct(col1, ), true, M_ET_MME, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, Succession, equal, struct(col1, Succession), struct(col1, ), true, SUCCESSION, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, Ind., equal, struct(col1, IND.), struct(col1, ), true, IND., , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, Consorts, equal, struct(col1, CONSORTS), struct(col1, ), true, CONSORT, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, SCI, equal, struct(col1, SCI), struct(col1, ), true, SCI, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, SARL, equal, struct(col1, SARL), struct(col1, ), true, SARL, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, Indivision, equal, struct(col1, INDIVISION), struct(col1, ), true, INDIVISION, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, M ou Mme, equal, struct(col1, M OU MME), struct(col1, ), true, M_OU_MME, , null), RANKING_STRING(COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, Messieurs, equal, struct(col1, MESSIEURS), struct(col1, ), true, MM, , null))) AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82291]
(22) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82271, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82273, COL_84669589_3EDF_4867_8128_B2F334719709#82274, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82275, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82276, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82283, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82291, str_remove_space(str_remove_accent(str_transform_case(COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82273, cast(UPPER as string))), cast(ONLY_ONE as string)) AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82300]
(23) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82271, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82273, COL_84669589_3EDF_4867_8128_B2F334719709#82274, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82275, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82276, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82283, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82291, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82300, str_join(array(COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82291, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82300), cast( as string)) AS COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82310]
(24) Project
Arguments: [COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82271 AS COL_5CE62B0F_C8B6_403A_BC06_6D127FD5EFFF#82321, COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82272 AS COL_B7606B94_B63C_4AC8_85DC_76BF33699940#82322, COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82273 AS COL_8118CDA6_09D5_4FBE_9754_F3DCADC3F2CB#82323, COL_84669589_3EDF_4867_8128_B2F334719709#82274 AS COL_84669589_3EDF_4867_8128_B2F334719709#82324, COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82275 AS COL_BB923AB9_180A_4698_AD19_3E6D6C901BD7#82325, COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82276 AS COL_79B2AE2E_91DA_45D0_8FAD_B2A696E7D6AF#82326, COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82283 AS COL_1BDC3498_C4CC_4B85_B455_EA2C1F8F15D7#82327, COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82291 AS COL_17F69EDB_8ED1_41D8_B647_A4169C7B4BBA#82328, COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82300 AS COL_31F3DB3A_17F8_4175_BE1B_49D5880B49DF#82329, COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82310 AS COL_96752C46_5D61_4995_9B22_B6F3C38A6B04#82330]