== 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_388119176`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#35012, Nom_Usage#35013, Nom_Naissance#35014, Prenom#35015, Sexe#35016, Date_Naissance#35017, N_Identification_National#35018, N_Securite_Social#35019], false
(4) Project
Arguments: [N_Patient_Etablissement#35012 AS N_Patient_Etablissement#35036, Nom_Usage#35013 AS Nom_Usage#35037, Nom_Naissance#35014 AS Nom_Naissance#35038, Prenom#35015 AS Prenom#35039, Sexe#35016 AS Sexe#35040, Date_Naissance#35017 AS Date_Naissance#35041, N_Identification_National#35018 AS N_Identification_National#35042, N_Securite_Social#35019 AS N_Securite_Social#35043]
(5) Project
Arguments: [N_Patient_Etablissement#35036, Nom_Usage#35037, Nom_Naissance#35038, Prenom#35039, Sexe#35040, Date_Naissance#35041, N_Identification_National#35042, N_Securite_Social#35043]
(6) Project
Arguments: [Date_Naissance#35041 AS DATE_NAISSANCE_388125#35061, Nom_Naissance#35038 AS NOM_NAISSANCE_388122#35062, Nom_Usage#35037 AS NOM_USAGE_388121#35063, N_Identification_National#35042 AS N_IDENTIFICATIO_388126#35064, N_Patient_Etablissement#35036 AS N_PATIENT_ETABL_388120#35065, N_Securite_Social#35043 AS N_SECURITE_SOCI_388127#35066, Prenom#35039 AS PRENOM_388123#35067, Sexe#35040 AS SEXE_388124#35068]
(7) LogicalRelation
Arguments: parquet, [IPP#35077, Nom_Usage#35078, Nom_Naissance#35079, Prenom#35080, Sexe-Pat#35081, Date_Naissance#35082, N_Identification_National#35083, N_Secu#35084, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#35085], false
(8) Project
Arguments: [IPP#35077 AS IPP#35095, Nom_Usage#35078, Nom_Naissance#35079, Prenom#35080, Sexe-Pat#35081, Date_Naissance#35082, N_Identification_National#35083, N_Secu#35084, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#35085]
(9) Project
Arguments: [IPP#35095, Nom_Usage#35078 AS Nom_Usage#35106, Nom_Naissance#35079, Prenom#35080, Sexe-Pat#35081, Date_Naissance#35082, N_Identification_National#35083, N_Secu#35084, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#35085]
(10) Project
Arguments: [IPP#35095, Nom_Usage#35106, Nom_Naissance#35079 AS Nom_Naissance#35116, Prenom#35080, Sexe-Pat#35081, Date_Naissance#35082, N_Identification_National#35083, N_Secu#35084, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#35085]
(11) Project
Arguments: [IPP#35095, Nom_Usage#35106, Nom_Naissance#35116, Prenom#35080 AS Prenom#35126, Sexe-Pat#35081, Date_Naissance#35082, N_Identification_National#35083, N_Secu#35084, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#35085]
(12) Project
Arguments: [IPP#35095, Nom_Usage#35106, Nom_Naissance#35116, Prenom#35126, Sexe-Pat#35081 AS Sexe-Pat#35136, Date_Naissance#35082, N_Identification_National#35083, N_Secu#35084, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#35085]
(13) Project
Arguments: [IPP#35095, Nom_Usage#35106, Nom_Naissance#35116, Prenom#35126, Sexe-Pat#35136, Date_Naissance#35082 AS Date_Naissance#35146, N_Identification_National#35083, N_Secu#35084, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#35085]
(14) Project
Arguments: [IPP#35095, Nom_Usage#35106, Nom_Naissance#35116, Prenom#35126, Sexe-Pat#35136, Date_Naissance#35146, N_Identification_National#35083 AS N_Identification_National#35156, N_Secu#35084, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#35085]
(15) Project
Arguments: [IPP#35095, Nom_Usage#35106, Nom_Naissance#35116, Prenom#35126, Sexe-Pat#35136, Date_Naissance#35146, N_Identification_National#35156, N_Secu#35084 AS N_Secu#35166, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#35085]
(16) Project
Arguments: [IPP#35095, Nom_Usage#35106, Nom_Naissance#35116, Prenom#35126, Sexe-Pat#35136, Date_Naissance#35146, N_Identification_National#35156, N_Secu#35166, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#35085 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#35176]
(17) Project
Arguments: [IPP#35095 AS IPP#35186, Nom_Usage#35106 AS Nom_Usage#35187, Nom_Naissance#35116 AS Nom_Naissance#35188, Prenom#35126 AS Prenom#35189, Sexe-Pat#35136 AS Sexe-Pat#35190, Date_Naissance#35146 AS Date_Naissance#35191, N_Identification_National#35156 AS N_Identification_National#35192, N_Secu#35166 AS N_Secu#35193, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#35176 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#35194]
(18) Project
Arguments: [IPP#35186, Nom_Usage#35187, Nom_Naissance#35188, Prenom#35189, Sexe-Pat#35190, Date_Naissance#35191, N_Identification_National#35192, N_Secu#35193, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#35194]
(19) Project
Arguments: [Date_Naissance#35191 AS DATE_NAISSANCE_388125#35213, Nom_Naissance#35188 AS NOM_NAISSANCE_388122#35214, Nom_Usage#35187 AS NOM_USAGE_388121#35215, N_Identification_National#35192 AS N_IDENTIFICATIO_388126#35216, IPP#35186 AS N_PATIENT_ETABL_388120#35217, N_Secu#35193 AS N_SECURITE_SOCI_388127#35218, Prenom#35189 AS PRENOM_388123#35219, cast(str_replace_extend(Sexe-Pat#35190, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#35221]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#35061, NOM_NAISSANCE_388122#35062, NOM_USAGE_388121#35063, N_IDENTIFICATIO_388126#35064, N_PATIENT_ETABL_388120#35065, N_SECURITE_SOCI_388127#35066, PRENOM_388123#35067, SEXE_388124#35068, str_encrypt(N_PATIENT_ETABL_388120#35065) AS ID_PATIENT_388128#35238, str_encrypt(N_PATIENT_ETABL_388120#35065) AS ID_PATIENT_BIS_388129#35239]