== 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#21258, Nom_Usage#21259, Nom_Naissance#21260, Prenom#21261, Sexe#21262, Date_Naissance#21263, N_Identification_National#21264, N_Securite_Social#21265], false
(4) Project
Arguments: [N_Patient_Etablissement#21258 AS N_Patient_Etablissement#21282, Nom_Usage#21259 AS Nom_Usage#21283, Nom_Naissance#21260 AS Nom_Naissance#21284, Prenom#21261 AS Prenom#21285, Sexe#21262 AS Sexe#21286, Date_Naissance#21263 AS Date_Naissance#21287, N_Identification_National#21264 AS N_Identification_National#21288, N_Securite_Social#21265 AS N_Securite_Social#21289]
(5) Project
Arguments: [N_Patient_Etablissement#21282, Nom_Usage#21283, Nom_Naissance#21284, Prenom#21285, Sexe#21286, Date_Naissance#21287, N_Identification_National#21288, N_Securite_Social#21289]
(6) Project
Arguments: [Date_Naissance#21287 AS DATE_NAISSANCE_388125#21307, Nom_Naissance#21284 AS NOM_NAISSANCE_388122#21308, Nom_Usage#21283 AS NOM_USAGE_388121#21309, N_Identification_National#21288 AS N_IDENTIFICATIO_388126#21310, N_Patient_Etablissement#21282 AS N_PATIENT_ETABL_388120#21311, N_Securite_Social#21289 AS N_SECURITE_SOCI_388127#21312, Prenom#21285 AS PRENOM_388123#21313, Sexe#21286 AS SEXE_388124#21314]
(7) LogicalRelation
Arguments: parquet, [IPP#21323, Nom_Usage#21324, Nom_Naissance#21325, Prenom#21326, Sexe-Pat#21327, Date_Naissance#21328, N_Identification_National#21329, N_Secu#21330, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331], false
(8) Project
Arguments: [IPP#21323 AS IPP#21341, Nom_Usage#21324, Nom_Naissance#21325, Prenom#21326, Sexe-Pat#21327, Date_Naissance#21328, N_Identification_National#21329, N_Secu#21330, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331]
(9) Project
Arguments: [IPP#21341, Nom_Usage#21324 AS Nom_Usage#21352, Nom_Naissance#21325, Prenom#21326, Sexe-Pat#21327, Date_Naissance#21328, N_Identification_National#21329, N_Secu#21330, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331]
(10) Project
Arguments: [IPP#21341, Nom_Usage#21352, Nom_Naissance#21325 AS Nom_Naissance#21362, Prenom#21326, Sexe-Pat#21327, Date_Naissance#21328, N_Identification_National#21329, N_Secu#21330, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331]
(11) Project
Arguments: [IPP#21341, Nom_Usage#21352, Nom_Naissance#21362, Prenom#21326 AS Prenom#21372, Sexe-Pat#21327, Date_Naissance#21328, N_Identification_National#21329, N_Secu#21330, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331]
(12) Project
Arguments: [IPP#21341, Nom_Usage#21352, Nom_Naissance#21362, Prenom#21372, Sexe-Pat#21327 AS Sexe-Pat#21382, Date_Naissance#21328, N_Identification_National#21329, N_Secu#21330, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331]
(13) Project
Arguments: [IPP#21341, Nom_Usage#21352, Nom_Naissance#21362, Prenom#21372, Sexe-Pat#21382, Date_Naissance#21328 AS Date_Naissance#21392, N_Identification_National#21329, N_Secu#21330, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331]
(14) Project
Arguments: [IPP#21341, Nom_Usage#21352, Nom_Naissance#21362, Prenom#21372, Sexe-Pat#21382, Date_Naissance#21392, N_Identification_National#21329 AS N_Identification_National#21402, N_Secu#21330, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331]
(15) Project
Arguments: [IPP#21341, Nom_Usage#21352, Nom_Naissance#21362, Prenom#21372, Sexe-Pat#21382, Date_Naissance#21392, N_Identification_National#21402, N_Secu#21330 AS N_Secu#21412, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331]
(16) Project
Arguments: [IPP#21341, Nom_Usage#21352, Nom_Naissance#21362, Prenom#21372, Sexe-Pat#21382, Date_Naissance#21392, N_Identification_National#21402, N_Secu#21412, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21331 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21422]
(17) Project
Arguments: [IPP#21341 AS IPP#21432, Nom_Usage#21352 AS Nom_Usage#21433, Nom_Naissance#21362 AS Nom_Naissance#21434, Prenom#21372 AS Prenom#21435, Sexe-Pat#21382 AS Sexe-Pat#21436, Date_Naissance#21392 AS Date_Naissance#21437, N_Identification_National#21402 AS N_Identification_National#21438, N_Secu#21412 AS N_Secu#21439, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21422 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21440]
(18) Project
Arguments: [IPP#21432, Nom_Usage#21433, Nom_Naissance#21434, Prenom#21435, Sexe-Pat#21436, Date_Naissance#21437, N_Identification_National#21438, N_Secu#21439, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#21440]
(19) Project
Arguments: [Date_Naissance#21437 AS DATE_NAISSANCE_388125#21459, Nom_Naissance#21434 AS NOM_NAISSANCE_388122#21460, Nom_Usage#21433 AS NOM_USAGE_388121#21461, N_Identification_National#21438 AS N_IDENTIFICATIO_388126#21462, IPP#21432 AS N_PATIENT_ETABL_388120#21463, N_Secu#21439 AS N_SECURITE_SOCI_388127#21464, Prenom#21435 AS PRENOM_388123#21465, cast(str_replace_extend(Sexe-Pat#21436, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#21467]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#21307, NOM_NAISSANCE_388122#21308, NOM_USAGE_388121#21309, N_IDENTIFICATIO_388126#21310, N_PATIENT_ETABL_388120#21311, N_SECURITE_SOCI_388127#21312, PRENOM_388123#21313, SEXE_388124#21314, str_encrypt(N_PATIENT_ETABL_388120#21311) AS ID_PATIENT_388128#21484, str_encrypt(N_PATIENT_ETABL_388120#21311) AS ID_PATIENT_BIS_388129#21485]