== 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_388119180`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#11200, Nom_Usage#11201, Nom_Naissance#11202, Prenom#11203, Sexe#11204, Date_Naissance#11205, N_Identification_National#11206, N_Securite_Social#11207], false
(4) Project
Arguments: [N_Patient_Etablissement#11200 AS N_Patient_Etablissement#11224, Nom_Usage#11201 AS Nom_Usage#11225, Nom_Naissance#11202 AS Nom_Naissance#11226, Prenom#11203 AS Prenom#11227, Sexe#11204 AS Sexe#11228, Date_Naissance#11205 AS Date_Naissance#11229, N_Identification_National#11206 AS N_Identification_National#11230, N_Securite_Social#11207 AS N_Securite_Social#11231]
(5) Project
Arguments: [N_Patient_Etablissement#11224, Nom_Usage#11225, Nom_Naissance#11226, Prenom#11227, Sexe#11228, Date_Naissance#11229, N_Identification_National#11230, N_Securite_Social#11231]
(6) Project
Arguments: [Date_Naissance#11229 AS DATE_NAISSANCE_388125#11249, Nom_Naissance#11226 AS NOM_NAISSANCE_388122#11250, Nom_Usage#11225 AS NOM_USAGE_388121#11251, N_Identification_National#11230 AS N_IDENTIFICATIO_388126#11252, N_Patient_Etablissement#11224 AS N_PATIENT_ETABL_388120#11253, N_Securite_Social#11231 AS N_SECURITE_SOCI_388127#11254, Prenom#11227 AS PRENOM_388123#11255, Sexe#11228 AS SEXE_388124#11256]
(7) LogicalRelation
Arguments: parquet, [IPP#11265, Nom_Usage#11266, Nom_Naissance#11267, Prenom#11268, Sexe-Pat#11269, Date_Naissance#11270, N_Identification_National#11271, N_Secu#11272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273], false
(8) Project
Arguments: [IPP#11265 AS IPP#11283, Nom_Usage#11266, Nom_Naissance#11267, Prenom#11268, Sexe-Pat#11269, Date_Naissance#11270, N_Identification_National#11271, N_Secu#11272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273]
(9) Project
Arguments: [IPP#11283, Nom_Usage#11266 AS Nom_Usage#11294, Nom_Naissance#11267, Prenom#11268, Sexe-Pat#11269, Date_Naissance#11270, N_Identification_National#11271, N_Secu#11272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273]
(10) Project
Arguments: [IPP#11283, Nom_Usage#11294, Nom_Naissance#11267 AS Nom_Naissance#11304, Prenom#11268, Sexe-Pat#11269, Date_Naissance#11270, N_Identification_National#11271, N_Secu#11272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273]
(11) Project
Arguments: [IPP#11283, Nom_Usage#11294, Nom_Naissance#11304, Prenom#11268 AS Prenom#11314, Sexe-Pat#11269, Date_Naissance#11270, N_Identification_National#11271, N_Secu#11272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273]
(12) Project
Arguments: [IPP#11283, Nom_Usage#11294, Nom_Naissance#11304, Prenom#11314, Sexe-Pat#11269 AS Sexe-Pat#11324, Date_Naissance#11270, N_Identification_National#11271, N_Secu#11272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273]
(13) Project
Arguments: [IPP#11283, Nom_Usage#11294, Nom_Naissance#11304, Prenom#11314, Sexe-Pat#11324, Date_Naissance#11270 AS Date_Naissance#11334, N_Identification_National#11271, N_Secu#11272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273]
(14) Project
Arguments: [IPP#11283, Nom_Usage#11294, Nom_Naissance#11304, Prenom#11314, Sexe-Pat#11324, Date_Naissance#11334, N_Identification_National#11271 AS N_Identification_National#11344, N_Secu#11272, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273]
(15) Project
Arguments: [IPP#11283, Nom_Usage#11294, Nom_Naissance#11304, Prenom#11314, Sexe-Pat#11324, Date_Naissance#11334, N_Identification_National#11344, N_Secu#11272 AS N_Secu#11354, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273]
(16) Project
Arguments: [IPP#11283, Nom_Usage#11294, Nom_Naissance#11304, Prenom#11314, Sexe-Pat#11324, Date_Naissance#11334, N_Identification_National#11344, N_Secu#11354, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11273 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11364]
(17) Project
Arguments: [IPP#11283 AS IPP#11374, Nom_Usage#11294 AS Nom_Usage#11375, Nom_Naissance#11304 AS Nom_Naissance#11376, Prenom#11314 AS Prenom#11377, Sexe-Pat#11324 AS Sexe-Pat#11378, Date_Naissance#11334 AS Date_Naissance#11379, N_Identification_National#11344 AS N_Identification_National#11380, N_Secu#11354 AS N_Secu#11381, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11364 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11382]
(18) Project
Arguments: [IPP#11374, Nom_Usage#11375, Nom_Naissance#11376, Prenom#11377, Sexe-Pat#11378, Date_Naissance#11379, N_Identification_National#11380, N_Secu#11381, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#11382]
(19) Project
Arguments: [Date_Naissance#11379 AS DATE_NAISSANCE_388125#11401, Nom_Naissance#11376 AS NOM_NAISSANCE_388122#11402, Nom_Usage#11375 AS NOM_USAGE_388121#11403, N_Identification_National#11380 AS N_IDENTIFICATIO_388126#11404, IPP#11374 AS N_PATIENT_ETABL_388120#11405, N_Secu#11381 AS N_SECURITE_SOCI_388127#11406, Prenom#11377 AS PRENOM_388123#11407, cast(str_replace_extend(Sexe-Pat#11378, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#11409]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#11249, NOM_NAISSANCE_388122#11250, NOM_USAGE_388121#11251, N_IDENTIFICATIO_388126#11252, N_PATIENT_ETABL_388120#11253, N_SECURITE_SOCI_388127#11254, PRENOM_388123#11255, SEXE_388124#11256, str_encrypt(N_PATIENT_ETABL_388120#11253) AS ID_PATIENT_388128#11426, str_encrypt(N_PATIENT_ETABL_388120#11253) AS ID_PATIENT_BIS_388129#11427]