== 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#25028, Nom_Usage#25029, Nom_Naissance#25030, Prenom#25031, Sexe#25032, Date_Naissance#25033, N_Identification_National#25034, N_Securite_Social#25035], false
(4) Project
Arguments: [N_Patient_Etablissement#25028 AS N_Patient_Etablissement#25052, Nom_Usage#25029 AS Nom_Usage#25053, Nom_Naissance#25030 AS Nom_Naissance#25054, Prenom#25031 AS Prenom#25055, Sexe#25032 AS Sexe#25056, Date_Naissance#25033 AS Date_Naissance#25057, N_Identification_National#25034 AS N_Identification_National#25058, N_Securite_Social#25035 AS N_Securite_Social#25059]
(5) Project
Arguments: [N_Patient_Etablissement#25052, Nom_Usage#25053, Nom_Naissance#25054, Prenom#25055, Sexe#25056, Date_Naissance#25057, N_Identification_National#25058, N_Securite_Social#25059]
(6) Project
Arguments: [Date_Naissance#25057 AS DATE_NAISSANCE_388125#25077, Nom_Naissance#25054 AS NOM_NAISSANCE_388122#25078, Nom_Usage#25053 AS NOM_USAGE_388121#25079, N_Identification_National#25058 AS N_IDENTIFICATIO_388126#25080, N_Patient_Etablissement#25052 AS N_PATIENT_ETABL_388120#25081, N_Securite_Social#25059 AS N_SECURITE_SOCI_388127#25082, Prenom#25055 AS PRENOM_388123#25083, Sexe#25056 AS SEXE_388124#25084]
(7) LogicalRelation
Arguments: parquet, [IPP#25093, Nom_Usage#25094, Nom_Naissance#25095, Prenom#25096, Sexe-Pat#25097, Date_Naissance#25098, N_Identification_National#25099, N_Secu#25100, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#25101], false
(8) Project
Arguments: [IPP#25093 AS IPP#25111, Nom_Usage#25094, Nom_Naissance#25095, Prenom#25096, Sexe-Pat#25097, Date_Naissance#25098, N_Identification_National#25099, N_Secu#25100, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#25101]
(9) Project
Arguments: [IPP#25111, Nom_Usage#25094 AS Nom_Usage#25122, Nom_Naissance#25095, Prenom#25096, Sexe-Pat#25097, Date_Naissance#25098, N_Identification_National#25099, N_Secu#25100, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#25101]
(10) Project
Arguments: [IPP#25111, Nom_Usage#25122, Nom_Naissance#25095 AS Nom_Naissance#25132, Prenom#25096, Sexe-Pat#25097, Date_Naissance#25098, N_Identification_National#25099, N_Secu#25100, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#25101]
(11) Project
Arguments: [IPP#25111, Nom_Usage#25122, Nom_Naissance#25132, Prenom#25096 AS Prenom#25142, Sexe-Pat#25097, Date_Naissance#25098, N_Identification_National#25099, N_Secu#25100, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#25101]
(12) Project
Arguments: [IPP#25111, Nom_Usage#25122, Nom_Naissance#25132, Prenom#25142, Sexe-Pat#25097 AS Sexe-Pat#25152, Date_Naissance#25098, N_Identification_National#25099, N_Secu#25100, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#25101]
(13) Project
Arguments: [IPP#25111, Nom_Usage#25122, Nom_Naissance#25132, Prenom#25142, Sexe-Pat#25152, Date_Naissance#25098 AS Date_Naissance#25162, N_Identification_National#25099, N_Secu#25100, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#25101]
(14) Project
Arguments: [IPP#25111, Nom_Usage#25122, Nom_Naissance#25132, Prenom#25142, Sexe-Pat#25152, Date_Naissance#25162, N_Identification_National#25099 AS N_Identification_National#25172, N_Secu#25100, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#25101]
(15) Project
Arguments: [IPP#25111, Nom_Usage#25122, Nom_Naissance#25132, Prenom#25142, Sexe-Pat#25152, Date_Naissance#25162, N_Identification_National#25172, N_Secu#25100 AS N_Secu#25182, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#25101]
(16) Project
Arguments: [IPP#25111, Nom_Usage#25122, Nom_Naissance#25132, Prenom#25142, Sexe-Pat#25152, Date_Naissance#25162, N_Identification_National#25172, N_Secu#25182, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#25101 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#25192]
(17) Project
Arguments: [IPP#25111 AS IPP#25202, Nom_Usage#25122 AS Nom_Usage#25203, Nom_Naissance#25132 AS Nom_Naissance#25204, Prenom#25142 AS Prenom#25205, Sexe-Pat#25152 AS Sexe-Pat#25206, Date_Naissance#25162 AS Date_Naissance#25207, N_Identification_National#25172 AS N_Identification_National#25208, N_Secu#25182 AS N_Secu#25209, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#25192 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#25210]
(18) Project
Arguments: [IPP#25202, Nom_Usage#25203, Nom_Naissance#25204, Prenom#25205, Sexe-Pat#25206, Date_Naissance#25207, N_Identification_National#25208, N_Secu#25209, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#25210]
(19) Project
Arguments: [Date_Naissance#25207 AS DATE_NAISSANCE_388125#25229, Nom_Naissance#25204 AS NOM_NAISSANCE_388122#25230, Nom_Usage#25203 AS NOM_USAGE_388121#25231, N_Identification_National#25208 AS N_IDENTIFICATIO_388126#25232, IPP#25202 AS N_PATIENT_ETABL_388120#25233, N_Secu#25209 AS N_SECURITE_SOCI_388127#25234, Prenom#25205 AS PRENOM_388123#25235, cast(str_replace_extend(Sexe-Pat#25206, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#25237]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#25077, NOM_NAISSANCE_388122#25078, NOM_USAGE_388121#25079, N_IDENTIFICATIO_388126#25080, N_PATIENT_ETABL_388120#25081, N_SECURITE_SOCI_388127#25082, PRENOM_388123#25083, SEXE_388124#25084, str_encrypt(N_PATIENT_ETABL_388120#25081) AS ID_PATIENT_388128#25254, str_encrypt(N_PATIENT_ETABL_388120#25081) AS ID_PATIENT_BIS_388129#25255]