== 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_388119175`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#28914, Nom_Usage#28915, Nom_Naissance#28916, Prenom#28917, Sexe#28918, Date_Naissance#28919, N_Identification_National#28920, N_Securite_Social#28921], false
(4) Project
Arguments: [N_Patient_Etablissement#28914 AS N_Patient_Etablissement#28938, Nom_Usage#28915 AS Nom_Usage#28939, Nom_Naissance#28916 AS Nom_Naissance#28940, Prenom#28917 AS Prenom#28941, Sexe#28918 AS Sexe#28942, Date_Naissance#28919 AS Date_Naissance#28943, N_Identification_National#28920 AS N_Identification_National#28944, N_Securite_Social#28921 AS N_Securite_Social#28945]
(5) Project
Arguments: [N_Patient_Etablissement#28938, Nom_Usage#28939, Nom_Naissance#28940, Prenom#28941, Sexe#28942, Date_Naissance#28943, N_Identification_National#28944, N_Securite_Social#28945]
(6) Project
Arguments: [Date_Naissance#28943 AS DATE_NAISSANCE_388125#28963, Nom_Naissance#28940 AS NOM_NAISSANCE_388122#28964, Nom_Usage#28939 AS NOM_USAGE_388121#28965, N_Identification_National#28944 AS N_IDENTIFICATIO_388126#28966, N_Patient_Etablissement#28938 AS N_PATIENT_ETABL_388120#28967, N_Securite_Social#28945 AS N_SECURITE_SOCI_388127#28968, Prenom#28941 AS PRENOM_388123#28969, Sexe#28942 AS SEXE_388124#28970]
(7) LogicalRelation
Arguments: parquet, [IPP#28979, Nom_Usage#28980, Nom_Naissance#28981, Prenom#28982, Sexe-Pat#28983, Date_Naissance#28984, N_Identification_National#28985, N_Secu#28986, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987], false
(8) Project
Arguments: [IPP#28979 AS IPP#28997, Nom_Usage#28980, Nom_Naissance#28981, Prenom#28982, Sexe-Pat#28983, Date_Naissance#28984, N_Identification_National#28985, N_Secu#28986, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987]
(9) Project
Arguments: [IPP#28997, Nom_Usage#28980 AS Nom_Usage#29008, Nom_Naissance#28981, Prenom#28982, Sexe-Pat#28983, Date_Naissance#28984, N_Identification_National#28985, N_Secu#28986, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987]
(10) Project
Arguments: [IPP#28997, Nom_Usage#29008, Nom_Naissance#28981 AS Nom_Naissance#29018, Prenom#28982, Sexe-Pat#28983, Date_Naissance#28984, N_Identification_National#28985, N_Secu#28986, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987]
(11) Project
Arguments: [IPP#28997, Nom_Usage#29008, Nom_Naissance#29018, Prenom#28982 AS Prenom#29028, Sexe-Pat#28983, Date_Naissance#28984, N_Identification_National#28985, N_Secu#28986, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987]
(12) Project
Arguments: [IPP#28997, Nom_Usage#29008, Nom_Naissance#29018, Prenom#29028, Sexe-Pat#28983 AS Sexe-Pat#29038, Date_Naissance#28984, N_Identification_National#28985, N_Secu#28986, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987]
(13) Project
Arguments: [IPP#28997, Nom_Usage#29008, Nom_Naissance#29018, Prenom#29028, Sexe-Pat#29038, Date_Naissance#28984 AS Date_Naissance#29048, N_Identification_National#28985, N_Secu#28986, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987]
(14) Project
Arguments: [IPP#28997, Nom_Usage#29008, Nom_Naissance#29018, Prenom#29028, Sexe-Pat#29038, Date_Naissance#29048, N_Identification_National#28985 AS N_Identification_National#29058, N_Secu#28986, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987]
(15) Project
Arguments: [IPP#28997, Nom_Usage#29008, Nom_Naissance#29018, Prenom#29028, Sexe-Pat#29038, Date_Naissance#29048, N_Identification_National#29058, N_Secu#28986 AS N_Secu#29068, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987]
(16) Project
Arguments: [IPP#28997, Nom_Usage#29008, Nom_Naissance#29018, Prenom#29028, Sexe-Pat#29038, Date_Naissance#29048, N_Identification_National#29058, N_Secu#29068, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#28987 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#29078]
(17) Project
Arguments: [IPP#28997 AS IPP#29088, Nom_Usage#29008 AS Nom_Usage#29089, Nom_Naissance#29018 AS Nom_Naissance#29090, Prenom#29028 AS Prenom#29091, Sexe-Pat#29038 AS Sexe-Pat#29092, Date_Naissance#29048 AS Date_Naissance#29093, N_Identification_National#29058 AS N_Identification_National#29094, N_Secu#29068 AS N_Secu#29095, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#29078 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#29096]
(18) Project
Arguments: [IPP#29088, Nom_Usage#29089, Nom_Naissance#29090, Prenom#29091, Sexe-Pat#29092, Date_Naissance#29093, N_Identification_National#29094, N_Secu#29095, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#29096]
(19) Project
Arguments: [Date_Naissance#29093 AS DATE_NAISSANCE_388125#29115, Nom_Naissance#29090 AS NOM_NAISSANCE_388122#29116, Nom_Usage#29089 AS NOM_USAGE_388121#29117, N_Identification_National#29094 AS N_IDENTIFICATIO_388126#29118, IPP#29088 AS N_PATIENT_ETABL_388120#29119, N_Secu#29095 AS N_SECURITE_SOCI_388127#29120, Prenom#29091 AS PRENOM_388123#29121, cast(str_replace_extend(Sexe-Pat#29092, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#29123]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#28963, NOM_NAISSANCE_388122#28964, NOM_USAGE_388121#28965, N_IDENTIFICATIO_388126#28966, N_PATIENT_ETABL_388120#28967, N_SECURITE_SOCI_388127#28968, PRENOM_388123#28969, SEXE_388124#28970, str_encrypt(N_PATIENT_ETABL_388120#28967) AS ID_PATIENT_388128#29140, str_encrypt(N_PATIENT_ETABL_388120#28967) AS ID_PATIENT_BIS_388129#29141]