== 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#20040, Nom_Usage#20041, Nom_Naissance#20042, Prenom#20043, Sexe#20044, Date_Naissance#20045, N_Identification_National#20046, N_Securite_Social#20047], false
(4) Project
Arguments: [N_Patient_Etablissement#20040 AS N_Patient_Etablissement#20064, Nom_Usage#20041 AS Nom_Usage#20065, Nom_Naissance#20042 AS Nom_Naissance#20066, Prenom#20043 AS Prenom#20067, Sexe#20044 AS Sexe#20068, Date_Naissance#20045 AS Date_Naissance#20069, N_Identification_National#20046 AS N_Identification_National#20070, N_Securite_Social#20047 AS N_Securite_Social#20071]
(5) Project
Arguments: [N_Patient_Etablissement#20064, Nom_Usage#20065, Nom_Naissance#20066, Prenom#20067, Sexe#20068, Date_Naissance#20069, N_Identification_National#20070, N_Securite_Social#20071]
(6) Project
Arguments: [Date_Naissance#20069 AS DATE_NAISSANCE_388125#20089, Nom_Naissance#20066 AS NOM_NAISSANCE_388122#20090, Nom_Usage#20065 AS NOM_USAGE_388121#20091, N_Identification_National#20070 AS N_IDENTIFICATIO_388126#20092, N_Patient_Etablissement#20064 AS N_PATIENT_ETABL_388120#20093, N_Securite_Social#20071 AS N_SECURITE_SOCI_388127#20094, Prenom#20067 AS PRENOM_388123#20095, Sexe#20068 AS SEXE_388124#20096]
(7) LogicalRelation
Arguments: parquet, [IPP#20105, Nom_Usage#20106, Nom_Naissance#20107, Prenom#20108, Sexe-Pat#20109, Date_Naissance#20110, N_Identification_National#20111, N_Secu#20112, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113], false
(8) Project
Arguments: [IPP#20105 AS IPP#20123, Nom_Usage#20106, Nom_Naissance#20107, Prenom#20108, Sexe-Pat#20109, Date_Naissance#20110, N_Identification_National#20111, N_Secu#20112, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113]
(9) Project
Arguments: [IPP#20123, Nom_Usage#20106 AS Nom_Usage#20134, Nom_Naissance#20107, Prenom#20108, Sexe-Pat#20109, Date_Naissance#20110, N_Identification_National#20111, N_Secu#20112, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113]
(10) Project
Arguments: [IPP#20123, Nom_Usage#20134, Nom_Naissance#20107 AS Nom_Naissance#20144, Prenom#20108, Sexe-Pat#20109, Date_Naissance#20110, N_Identification_National#20111, N_Secu#20112, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113]
(11) Project
Arguments: [IPP#20123, Nom_Usage#20134, Nom_Naissance#20144, Prenom#20108 AS Prenom#20154, Sexe-Pat#20109, Date_Naissance#20110, N_Identification_National#20111, N_Secu#20112, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113]
(12) Project
Arguments: [IPP#20123, Nom_Usage#20134, Nom_Naissance#20144, Prenom#20154, Sexe-Pat#20109 AS Sexe-Pat#20164, Date_Naissance#20110, N_Identification_National#20111, N_Secu#20112, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113]
(13) Project
Arguments: [IPP#20123, Nom_Usage#20134, Nom_Naissance#20144, Prenom#20154, Sexe-Pat#20164, Date_Naissance#20110 AS Date_Naissance#20174, N_Identification_National#20111, N_Secu#20112, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113]
(14) Project
Arguments: [IPP#20123, Nom_Usage#20134, Nom_Naissance#20144, Prenom#20154, Sexe-Pat#20164, Date_Naissance#20174, N_Identification_National#20111 AS N_Identification_National#20184, N_Secu#20112, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113]
(15) Project
Arguments: [IPP#20123, Nom_Usage#20134, Nom_Naissance#20144, Prenom#20154, Sexe-Pat#20164, Date_Naissance#20174, N_Identification_National#20184, N_Secu#20112 AS N_Secu#20194, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113]
(16) Project
Arguments: [IPP#20123, Nom_Usage#20134, Nom_Naissance#20144, Prenom#20154, Sexe-Pat#20164, Date_Naissance#20174, N_Identification_National#20184, N_Secu#20194, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20113 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20204]
(17) Project
Arguments: [IPP#20123 AS IPP#20214, Nom_Usage#20134 AS Nom_Usage#20215, Nom_Naissance#20144 AS Nom_Naissance#20216, Prenom#20154 AS Prenom#20217, Sexe-Pat#20164 AS Sexe-Pat#20218, Date_Naissance#20174 AS Date_Naissance#20219, N_Identification_National#20184 AS N_Identification_National#20220, N_Secu#20194 AS N_Secu#20221, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20204 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20222]
(18) Project
Arguments: [IPP#20214, Nom_Usage#20215, Nom_Naissance#20216, Prenom#20217, Sexe-Pat#20218, Date_Naissance#20219, N_Identification_National#20220, N_Secu#20221, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#20222]
(19) Project
Arguments: [Date_Naissance#20219 AS DATE_NAISSANCE_388125#20241, Nom_Naissance#20216 AS NOM_NAISSANCE_388122#20242, Nom_Usage#20215 AS NOM_USAGE_388121#20243, N_Identification_National#20220 AS N_IDENTIFICATIO_388126#20244, IPP#20214 AS N_PATIENT_ETABL_388120#20245, N_Secu#20221 AS N_SECURITE_SOCI_388127#20246, Prenom#20217 AS PRENOM_388123#20247, cast(str_replace_extend(Sexe-Pat#20218, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#20249]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#20089, NOM_NAISSANCE_388122#20090, NOM_USAGE_388121#20091, N_IDENTIFICATIO_388126#20092, N_PATIENT_ETABL_388120#20093, N_SECURITE_SOCI_388127#20094, PRENOM_388123#20095, SEXE_388124#20096, str_encrypt(N_PATIENT_ETABL_388120#20093) AS ID_PATIENT_388128#20266, str_encrypt(N_PATIENT_ETABL_388120#20093) AS ID_PATIENT_BIS_388129#20267]