== 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_388119178`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#17604, Nom_Usage#17605, Nom_Naissance#17606, Prenom#17607, Sexe#17608, Date_Naissance#17609, N_Identification_National#17610, N_Securite_Social#17611], false
(4) Project
Arguments: [N_Patient_Etablissement#17604 AS N_Patient_Etablissement#17628, Nom_Usage#17605 AS Nom_Usage#17629, Nom_Naissance#17606 AS Nom_Naissance#17630, Prenom#17607 AS Prenom#17631, Sexe#17608 AS Sexe#17632, Date_Naissance#17609 AS Date_Naissance#17633, N_Identification_National#17610 AS N_Identification_National#17634, N_Securite_Social#17611 AS N_Securite_Social#17635]
(5) Project
Arguments: [N_Patient_Etablissement#17628, Nom_Usage#17629, Nom_Naissance#17630, Prenom#17631, Sexe#17632, Date_Naissance#17633, N_Identification_National#17634, N_Securite_Social#17635]
(6) Project
Arguments: [Date_Naissance#17633 AS DATE_NAISSANCE_388125#17653, Nom_Naissance#17630 AS NOM_NAISSANCE_388122#17654, Nom_Usage#17629 AS NOM_USAGE_388121#17655, N_Identification_National#17634 AS N_IDENTIFICATIO_388126#17656, N_Patient_Etablissement#17628 AS N_PATIENT_ETABL_388120#17657, N_Securite_Social#17635 AS N_SECURITE_SOCI_388127#17658, Prenom#17631 AS PRENOM_388123#17659, Sexe#17632 AS SEXE_388124#17660]
(7) LogicalRelation
Arguments: parquet, [IPP#17669, Nom_Usage#17670, Nom_Naissance#17671, Prenom#17672, Sexe-Pat#17673, Date_Naissance#17674, N_Identification_National#17675, N_Secu#17676, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677], false
(8) Project
Arguments: [IPP#17669 AS IPP#17687, Nom_Usage#17670, Nom_Naissance#17671, Prenom#17672, Sexe-Pat#17673, Date_Naissance#17674, N_Identification_National#17675, N_Secu#17676, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677]
(9) Project
Arguments: [IPP#17687, Nom_Usage#17670 AS Nom_Usage#17698, Nom_Naissance#17671, Prenom#17672, Sexe-Pat#17673, Date_Naissance#17674, N_Identification_National#17675, N_Secu#17676, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677]
(10) Project
Arguments: [IPP#17687, Nom_Usage#17698, Nom_Naissance#17671 AS Nom_Naissance#17708, Prenom#17672, Sexe-Pat#17673, Date_Naissance#17674, N_Identification_National#17675, N_Secu#17676, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677]
(11) Project
Arguments: [IPP#17687, Nom_Usage#17698, Nom_Naissance#17708, Prenom#17672 AS Prenom#17718, Sexe-Pat#17673, Date_Naissance#17674, N_Identification_National#17675, N_Secu#17676, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677]
(12) Project
Arguments: [IPP#17687, Nom_Usage#17698, Nom_Naissance#17708, Prenom#17718, Sexe-Pat#17673 AS Sexe-Pat#17728, Date_Naissance#17674, N_Identification_National#17675, N_Secu#17676, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677]
(13) Project
Arguments: [IPP#17687, Nom_Usage#17698, Nom_Naissance#17708, Prenom#17718, Sexe-Pat#17728, Date_Naissance#17674 AS Date_Naissance#17738, N_Identification_National#17675, N_Secu#17676, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677]
(14) Project
Arguments: [IPP#17687, Nom_Usage#17698, Nom_Naissance#17708, Prenom#17718, Sexe-Pat#17728, Date_Naissance#17738, N_Identification_National#17675 AS N_Identification_National#17748, N_Secu#17676, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677]
(15) Project
Arguments: [IPP#17687, Nom_Usage#17698, Nom_Naissance#17708, Prenom#17718, Sexe-Pat#17728, Date_Naissance#17738, N_Identification_National#17748, N_Secu#17676 AS N_Secu#17758, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677]
(16) Project
Arguments: [IPP#17687, Nom_Usage#17698, Nom_Naissance#17708, Prenom#17718, Sexe-Pat#17728, Date_Naissance#17738, N_Identification_National#17748, N_Secu#17758, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17677 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17768]
(17) Project
Arguments: [IPP#17687 AS IPP#17778, Nom_Usage#17698 AS Nom_Usage#17779, Nom_Naissance#17708 AS Nom_Naissance#17780, Prenom#17718 AS Prenom#17781, Sexe-Pat#17728 AS Sexe-Pat#17782, Date_Naissance#17738 AS Date_Naissance#17783, N_Identification_National#17748 AS N_Identification_National#17784, N_Secu#17758 AS N_Secu#17785, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17768 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17786]
(18) Project
Arguments: [IPP#17778, Nom_Usage#17779, Nom_Naissance#17780, Prenom#17781, Sexe-Pat#17782, Date_Naissance#17783, N_Identification_National#17784, N_Secu#17785, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#17786]
(19) Project
Arguments: [Date_Naissance#17783 AS DATE_NAISSANCE_388125#17805, Nom_Naissance#17780 AS NOM_NAISSANCE_388122#17806, Nom_Usage#17779 AS NOM_USAGE_388121#17807, N_Identification_National#17784 AS N_IDENTIFICATIO_388126#17808, IPP#17778 AS N_PATIENT_ETABL_388120#17809, N_Secu#17785 AS N_SECURITE_SOCI_388127#17810, Prenom#17781 AS PRENOM_388123#17811, cast(str_replace_extend(Sexe-Pat#17782, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#17813]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#17653, NOM_NAISSANCE_388122#17654, NOM_USAGE_388121#17655, N_IDENTIFICATIO_388126#17656, N_PATIENT_ETABL_388120#17657, N_SECURITE_SOCI_388127#17658, PRENOM_388123#17659, SEXE_388124#17660, str_encrypt(N_PATIENT_ETABL_388120#17657) AS ID_PATIENT_388128#17830, str_encrypt(N_PATIENT_ETABL_388120#17657) AS ID_PATIENT_BIS_388129#17831]