== 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#4950, Nom_Usage#4951, Nom_Naissance#4952, Prenom#4953, Sexe#4954, Date_Naissance#4955, N_Identification_National#4956, N_Securite_Social#4957], false
(4) Project
Arguments: [N_Patient_Etablissement#4950 AS N_Patient_Etablissement#4974, Nom_Usage#4951 AS Nom_Usage#4975, Nom_Naissance#4952 AS Nom_Naissance#4976, Prenom#4953 AS Prenom#4977, Sexe#4954 AS Sexe#4978, Date_Naissance#4955 AS Date_Naissance#4979, N_Identification_National#4956 AS N_Identification_National#4980, N_Securite_Social#4957 AS N_Securite_Social#4981]
(5) Project
Arguments: [N_Patient_Etablissement#4974, Nom_Usage#4975, Nom_Naissance#4976, Prenom#4977, Sexe#4978, Date_Naissance#4979, N_Identification_National#4980, N_Securite_Social#4981]
(6) Project
Arguments: [Date_Naissance#4979 AS DATE_NAISSANCE_388125#4999, Nom_Naissance#4976 AS NOM_NAISSANCE_388122#5000, Nom_Usage#4975 AS NOM_USAGE_388121#5001, N_Identification_National#4980 AS N_IDENTIFICATIO_388126#5002, N_Patient_Etablissement#4974 AS N_PATIENT_ETABL_388120#5003, N_Securite_Social#4981 AS N_SECURITE_SOCI_388127#5004, Prenom#4977 AS PRENOM_388123#5005, Sexe#4978 AS SEXE_388124#5006]
(7) LogicalRelation
Arguments: parquet, [IPP#5015, Nom_Usage#5016, Nom_Naissance#5017, Prenom#5018, Sexe-Pat#5019, Date_Naissance#5020, N_Identification_National#5021, N_Secu#5022, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#5023], false
(8) Project
Arguments: [IPP#5015 AS IPP#5033, Nom_Usage#5016, Nom_Naissance#5017, Prenom#5018, Sexe-Pat#5019, Date_Naissance#5020, N_Identification_National#5021, N_Secu#5022, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#5023]
(9) Project
Arguments: [IPP#5033, Nom_Usage#5016 AS Nom_Usage#5044, Nom_Naissance#5017, Prenom#5018, Sexe-Pat#5019, Date_Naissance#5020, N_Identification_National#5021, N_Secu#5022, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#5023]
(10) Project
Arguments: [IPP#5033, Nom_Usage#5044, Nom_Naissance#5017 AS Nom_Naissance#5054, Prenom#5018, Sexe-Pat#5019, Date_Naissance#5020, N_Identification_National#5021, N_Secu#5022, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#5023]
(11) Project
Arguments: [IPP#5033, Nom_Usage#5044, Nom_Naissance#5054, Prenom#5018 AS Prenom#5064, Sexe-Pat#5019, Date_Naissance#5020, N_Identification_National#5021, N_Secu#5022, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#5023]
(12) Project
Arguments: [IPP#5033, Nom_Usage#5044, Nom_Naissance#5054, Prenom#5064, Sexe-Pat#5019 AS Sexe-Pat#5074, Date_Naissance#5020, N_Identification_National#5021, N_Secu#5022, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#5023]
(13) Project
Arguments: [IPP#5033, Nom_Usage#5044, Nom_Naissance#5054, Prenom#5064, Sexe-Pat#5074, Date_Naissance#5020 AS Date_Naissance#5084, N_Identification_National#5021, N_Secu#5022, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#5023]
(14) Project
Arguments: [IPP#5033, Nom_Usage#5044, Nom_Naissance#5054, Prenom#5064, Sexe-Pat#5074, Date_Naissance#5084, N_Identification_National#5021 AS N_Identification_National#5094, N_Secu#5022, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#5023]
(15) Project
Arguments: [IPP#5033, Nom_Usage#5044, Nom_Naissance#5054, Prenom#5064, Sexe-Pat#5074, Date_Naissance#5084, N_Identification_National#5094, N_Secu#5022 AS N_Secu#5104, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#5023]
(16) Project
Arguments: [IPP#5033, Nom_Usage#5044, Nom_Naissance#5054, Prenom#5064, Sexe-Pat#5074, Date_Naissance#5084, N_Identification_National#5094, N_Secu#5104, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#5023 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#5114]
(17) Project
Arguments: [IPP#5033 AS IPP#5124, Nom_Usage#5044 AS Nom_Usage#5125, Nom_Naissance#5054 AS Nom_Naissance#5126, Prenom#5064 AS Prenom#5127, Sexe-Pat#5074 AS Sexe-Pat#5128, Date_Naissance#5084 AS Date_Naissance#5129, N_Identification_National#5094 AS N_Identification_National#5130, N_Secu#5104 AS N_Secu#5131, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#5114 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#5132]
(18) Project
Arguments: [IPP#5124, Nom_Usage#5125, Nom_Naissance#5126, Prenom#5127, Sexe-Pat#5128, Date_Naissance#5129, N_Identification_National#5130, N_Secu#5131, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#5132]
(19) Project
Arguments: [Date_Naissance#5129 AS DATE_NAISSANCE_388125#5151, Nom_Naissance#5126 AS NOM_NAISSANCE_388122#5152, Nom_Usage#5125 AS NOM_USAGE_388121#5153, N_Identification_National#5130 AS N_IDENTIFICATIO_388126#5154, IPP#5124 AS N_PATIENT_ETABL_388120#5155, N_Secu#5131 AS N_SECURITE_SOCI_388127#5156, Prenom#5127 AS PRENOM_388123#5157, cast(str_replace_extend(Sexe-Pat#5128, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#5159]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#4999, NOM_NAISSANCE_388122#5000, NOM_USAGE_388121#5001, N_IDENTIFICATIO_388126#5002, N_PATIENT_ETABL_388120#5003, N_SECURITE_SOCI_388127#5004, PRENOM_388123#5005, SEXE_388124#5006, str_encrypt(N_PATIENT_ETABL_388120#5003) AS ID_PATIENT_388128#5176, str_encrypt(N_PATIENT_ETABL_388120#5003) AS ID_PATIENT_BIS_388129#5177]