== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (21)
+- Union (20)
:- Project (6)
: +- Project (5)
: +- Project (4)
: +- LogicalRelation (3)
+- Project (19)
+- Project (18)
+- Project (17)
+- Project (16)
+- Project (15)
+- Project (14)
+- Project (13)
+- Project (12)
+- Project (11)
+- Project (10)
+- Project (9)
+- Project (8)
+- LogicalRelation (7)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `LES_PATIENTS_388119179`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#6200, Nom_Usage#6201, Nom_Naissance#6202, Prenom#6203, Sexe#6204, Date_Naissance#6205, N_Identification_National#6206, N_Securite_Social#6207], false
(4) Project
Arguments: [N_Patient_Etablissement#6200 AS N_Patient_Etablissement#6224, Nom_Usage#6201 AS Nom_Usage#6225, Nom_Naissance#6202 AS Nom_Naissance#6226, Prenom#6203 AS Prenom#6227, Sexe#6204 AS Sexe#6228, Date_Naissance#6205 AS Date_Naissance#6229, N_Identification_National#6206 AS N_Identification_National#6230, N_Securite_Social#6207 AS N_Securite_Social#6231]
(5) Project
Arguments: [N_Patient_Etablissement#6224, Nom_Usage#6225, Nom_Naissance#6226, Prenom#6227, Sexe#6228, Date_Naissance#6229, N_Identification_National#6230, N_Securite_Social#6231]
(6) Project
Arguments: [Date_Naissance#6229 AS DATE_NAISSANCE_388125#6249, Nom_Naissance#6226 AS NOM_NAISSANCE_388122#6250, Nom_Usage#6225 AS NOM_USAGE_388121#6251, N_Identification_National#6230 AS N_IDENTIFICATIO_388126#6252, N_Patient_Etablissement#6224 AS N_PATIENT_ETABL_388120#6253, N_Securite_Social#6231 AS N_SECURITE_SOCI_388127#6254, Prenom#6227 AS PRENOM_388123#6255, Sexe#6228 AS SEXE_388124#6256]
(7) LogicalRelation
Arguments: parquet, [IPP#6265, Nom_Usage#6266, Nom_Naissance#6267, Prenom#6268, Sexe-Pat#6269, Date_Naissance#6270, N_Identification_National#6271, N_Secu#6272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273], false
(8) Project
Arguments: [IPP#6265 AS IPP#6283, Nom_Usage#6266, Nom_Naissance#6267, Prenom#6268, Sexe-Pat#6269, Date_Naissance#6270, N_Identification_National#6271, N_Secu#6272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273]
(9) Project
Arguments: [IPP#6283, Nom_Usage#6266 AS Nom_Usage#6294, Nom_Naissance#6267, Prenom#6268, Sexe-Pat#6269, Date_Naissance#6270, N_Identification_National#6271, N_Secu#6272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273]
(10) Project
Arguments: [IPP#6283, Nom_Usage#6294, Nom_Naissance#6267 AS Nom_Naissance#6304, Prenom#6268, Sexe-Pat#6269, Date_Naissance#6270, N_Identification_National#6271, N_Secu#6272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273]
(11) Project
Arguments: [IPP#6283, Nom_Usage#6294, Nom_Naissance#6304, Prenom#6268 AS Prenom#6314, Sexe-Pat#6269, Date_Naissance#6270, N_Identification_National#6271, N_Secu#6272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273]
(12) Project
Arguments: [IPP#6283, Nom_Usage#6294, Nom_Naissance#6304, Prenom#6314, Sexe-Pat#6269 AS Sexe-Pat#6324, Date_Naissance#6270, N_Identification_National#6271, N_Secu#6272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273]
(13) Project
Arguments: [IPP#6283, Nom_Usage#6294, Nom_Naissance#6304, Prenom#6314, Sexe-Pat#6324, Date_Naissance#6270 AS Date_Naissance#6334, N_Identification_National#6271, N_Secu#6272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273]
(14) Project
Arguments: [IPP#6283, Nom_Usage#6294, Nom_Naissance#6304, Prenom#6314, Sexe-Pat#6324, Date_Naissance#6334, N_Identification_National#6271 AS N_Identification_National#6344, N_Secu#6272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273]
(15) Project
Arguments: [IPP#6283, Nom_Usage#6294, Nom_Naissance#6304, Prenom#6314, Sexe-Pat#6324, Date_Naissance#6334, N_Identification_National#6344, N_Secu#6272 AS N_Secu#6354, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273]
(16) Project
Arguments: [IPP#6283, Nom_Usage#6294, Nom_Naissance#6304, Prenom#6314, Sexe-Pat#6324, Date_Naissance#6334, N_Identification_National#6344, N_Secu#6354, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6273 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6364]
(17) Project
Arguments: [IPP#6283 AS IPP#6374, Nom_Usage#6294 AS Nom_Usage#6375, Nom_Naissance#6304 AS Nom_Naissance#6376, Prenom#6314 AS Prenom#6377, Sexe-Pat#6324 AS Sexe-Pat#6378, Date_Naissance#6334 AS Date_Naissance#6379, N_Identification_National#6344 AS N_Identification_National#6380, N_Secu#6354 AS N_Secu#6381, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6364 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6382]
(18) Project
Arguments: [IPP#6374, Nom_Usage#6375, Nom_Naissance#6376, Prenom#6377, Sexe-Pat#6378, Date_Naissance#6379, N_Identification_National#6380, N_Secu#6381, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#6382]
(19) Project
Arguments: [Date_Naissance#6379 AS DATE_NAISSANCE_388125#6401, Nom_Naissance#6376 AS NOM_NAISSANCE_388122#6402, Nom_Usage#6375 AS NOM_USAGE_388121#6403, N_Identification_National#6380 AS N_IDENTIFICATIO_388126#6404, IPP#6374 AS N_PATIENT_ETABL_388120#6405, N_Secu#6381 AS N_SECURITE_SOCI_388127#6406, Prenom#6377 AS PRENOM_388123#6407, cast(str_replace_extend(Sexe-Pat#6378, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#6409]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#6249, NOM_NAISSANCE_388122#6250, NOM_USAGE_388121#6251, N_IDENTIFICATIO_388126#6252, N_PATIENT_ETABL_388120#6253, N_SECURITE_SOCI_388127#6254, PRENOM_388123#6255, SEXE_388124#6256, str_encrypt(N_PATIENT_ETABL_388120#6253) AS ID_PATIENT_388128#6426, str_encrypt(N_PATIENT_ETABL_388120#6253) AS ID_PATIENT_BIS_388129#6427]