== 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_388119174`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#30248, Nom_Usage#30249, Nom_Naissance#30250, Prenom#30251, Sexe#30252, Date_Naissance#30253, N_Identification_National#30254, N_Securite_Social#30255], false
(4) Project
Arguments: [N_Patient_Etablissement#30248 AS N_Patient_Etablissement#30272, Nom_Usage#30249 AS Nom_Usage#30273, Nom_Naissance#30250 AS Nom_Naissance#30274, Prenom#30251 AS Prenom#30275, Sexe#30252 AS Sexe#30276, Date_Naissance#30253 AS Date_Naissance#30277, N_Identification_National#30254 AS N_Identification_National#30278, N_Securite_Social#30255 AS N_Securite_Social#30279]
(5) Project
Arguments: [N_Patient_Etablissement#30272, Nom_Usage#30273, Nom_Naissance#30274, Prenom#30275, Sexe#30276, Date_Naissance#30277, N_Identification_National#30278, N_Securite_Social#30279]
(6) Project
Arguments: [Date_Naissance#30277 AS DATE_NAISSANCE_388125#30297, Nom_Naissance#30274 AS NOM_NAISSANCE_388122#30298, Nom_Usage#30273 AS NOM_USAGE_388121#30299, N_Identification_National#30278 AS N_IDENTIFICATIO_388126#30300, N_Patient_Etablissement#30272 AS N_PATIENT_ETABL_388120#30301, N_Securite_Social#30279 AS N_SECURITE_SOCI_388127#30302, Prenom#30275 AS PRENOM_388123#30303, Sexe#30276 AS SEXE_388124#30304]
(7) LogicalRelation
Arguments: parquet, [IPP#30313, Nom_Usage#30314, Nom_Naissance#30315, Prenom#30316, Sexe-Pat#30317, Date_Naissance#30318, N_Identification_National#30319, N_Secu#30320, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#30321], false
(8) Project
Arguments: [IPP#30313 AS IPP#30331, Nom_Usage#30314, Nom_Naissance#30315, Prenom#30316, Sexe-Pat#30317, Date_Naissance#30318, N_Identification_National#30319, N_Secu#30320, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#30321]
(9) Project
Arguments: [IPP#30331, Nom_Usage#30314 AS Nom_Usage#30342, Nom_Naissance#30315, Prenom#30316, Sexe-Pat#30317, Date_Naissance#30318, N_Identification_National#30319, N_Secu#30320, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#30321]
(10) Project
Arguments: [IPP#30331, Nom_Usage#30342, Nom_Naissance#30315 AS Nom_Naissance#30352, Prenom#30316, Sexe-Pat#30317, Date_Naissance#30318, N_Identification_National#30319, N_Secu#30320, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#30321]
(11) Project
Arguments: [IPP#30331, Nom_Usage#30342, Nom_Naissance#30352, Prenom#30316 AS Prenom#30362, Sexe-Pat#30317, Date_Naissance#30318, N_Identification_National#30319, N_Secu#30320, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#30321]
(12) Project
Arguments: [IPP#30331, Nom_Usage#30342, Nom_Naissance#30352, Prenom#30362, Sexe-Pat#30317 AS Sexe-Pat#30372, Date_Naissance#30318, N_Identification_National#30319, N_Secu#30320, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#30321]
(13) Project
Arguments: [IPP#30331, Nom_Usage#30342, Nom_Naissance#30352, Prenom#30362, Sexe-Pat#30372, Date_Naissance#30318 AS Date_Naissance#30382, N_Identification_National#30319, N_Secu#30320, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#30321]
(14) Project
Arguments: [IPP#30331, Nom_Usage#30342, Nom_Naissance#30352, Prenom#30362, Sexe-Pat#30372, Date_Naissance#30382, N_Identification_National#30319 AS N_Identification_National#30392, N_Secu#30320, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#30321]
(15) Project
Arguments: [IPP#30331, Nom_Usage#30342, Nom_Naissance#30352, Prenom#30362, Sexe-Pat#30372, Date_Naissance#30382, N_Identification_National#30392, N_Secu#30320 AS N_Secu#30402, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#30321]
(16) Project
Arguments: [IPP#30331, Nom_Usage#30342, Nom_Naissance#30352, Prenom#30362, Sexe-Pat#30372, Date_Naissance#30382, N_Identification_National#30392, N_Secu#30402, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#30321 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#30412]
(17) Project
Arguments: [IPP#30331 AS IPP#30422, Nom_Usage#30342 AS Nom_Usage#30423, Nom_Naissance#30352 AS Nom_Naissance#30424, Prenom#30362 AS Prenom#30425, Sexe-Pat#30372 AS Sexe-Pat#30426, Date_Naissance#30382 AS Date_Naissance#30427, N_Identification_National#30392 AS N_Identification_National#30428, N_Secu#30402 AS N_Secu#30429, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#30412 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#30430]
(18) Project
Arguments: [IPP#30422, Nom_Usage#30423, Nom_Naissance#30424, Prenom#30425, Sexe-Pat#30426, Date_Naissance#30427, N_Identification_National#30428, N_Secu#30429, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#30430]
(19) Project
Arguments: [Date_Naissance#30427 AS DATE_NAISSANCE_388125#30449, Nom_Naissance#30424 AS NOM_NAISSANCE_388122#30450, Nom_Usage#30423 AS NOM_USAGE_388121#30451, N_Identification_National#30428 AS N_IDENTIFICATIO_388126#30452, IPP#30422 AS N_PATIENT_ETABL_388120#30453, N_Secu#30429 AS N_SECURITE_SOCI_388127#30454, Prenom#30425 AS PRENOM_388123#30455, cast(str_replace_extend(Sexe-Pat#30426, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#30457]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#30297, NOM_NAISSANCE_388122#30298, NOM_USAGE_388121#30299, N_IDENTIFICATIO_388126#30300, N_PATIENT_ETABL_388120#30301, N_SECURITE_SOCI_388127#30302, PRENOM_388123#30303, SEXE_388124#30304, str_encrypt(N_PATIENT_ETABL_388120#30301) AS ID_PATIENT_388128#30474, str_encrypt(N_PATIENT_ETABL_388120#30301) AS ID_PATIENT_BIS_388129#30475]