== 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#7450, Nom_Usage#7451, Nom_Naissance#7452, Prenom#7453, Sexe#7454, Date_Naissance#7455, N_Identification_National#7456, N_Securite_Social#7457], false
(4) Project
Arguments: [N_Patient_Etablissement#7450 AS N_Patient_Etablissement#7474, Nom_Usage#7451 AS Nom_Usage#7475, Nom_Naissance#7452 AS Nom_Naissance#7476, Prenom#7453 AS Prenom#7477, Sexe#7454 AS Sexe#7478, Date_Naissance#7455 AS Date_Naissance#7479, N_Identification_National#7456 AS N_Identification_National#7480, N_Securite_Social#7457 AS N_Securite_Social#7481]
(5) Project
Arguments: [N_Patient_Etablissement#7474, Nom_Usage#7475, Nom_Naissance#7476, Prenom#7477, Sexe#7478, Date_Naissance#7479, N_Identification_National#7480, N_Securite_Social#7481]
(6) Project
Arguments: [Date_Naissance#7479 AS DATE_NAISSANCE_388125#7499, Nom_Naissance#7476 AS NOM_NAISSANCE_388122#7500, Nom_Usage#7475 AS NOM_USAGE_388121#7501, N_Identification_National#7480 AS N_IDENTIFICATIO_388126#7502, N_Patient_Etablissement#7474 AS N_PATIENT_ETABL_388120#7503, N_Securite_Social#7481 AS N_SECURITE_SOCI_388127#7504, Prenom#7477 AS PRENOM_388123#7505, Sexe#7478 AS SEXE_388124#7506]
(7) LogicalRelation
Arguments: parquet, [IPP#7515, Nom_Usage#7516, Nom_Naissance#7517, Prenom#7518, Sexe-Pat#7519, Date_Naissance#7520, N_Identification_National#7521, N_Secu#7522, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#7523], false
(8) Project
Arguments: [IPP#7515 AS IPP#7533, Nom_Usage#7516, Nom_Naissance#7517, Prenom#7518, Sexe-Pat#7519, Date_Naissance#7520, N_Identification_National#7521, N_Secu#7522, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#7523]
(9) Project
Arguments: [IPP#7533, Nom_Usage#7516 AS Nom_Usage#7544, Nom_Naissance#7517, Prenom#7518, Sexe-Pat#7519, Date_Naissance#7520, N_Identification_National#7521, N_Secu#7522, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#7523]
(10) Project
Arguments: [IPP#7533, Nom_Usage#7544, Nom_Naissance#7517 AS Nom_Naissance#7554, Prenom#7518, Sexe-Pat#7519, Date_Naissance#7520, N_Identification_National#7521, N_Secu#7522, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#7523]
(11) Project
Arguments: [IPP#7533, Nom_Usage#7544, Nom_Naissance#7554, Prenom#7518 AS Prenom#7564, Sexe-Pat#7519, Date_Naissance#7520, N_Identification_National#7521, N_Secu#7522, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#7523]
(12) Project
Arguments: [IPP#7533, Nom_Usage#7544, Nom_Naissance#7554, Prenom#7564, Sexe-Pat#7519 AS Sexe-Pat#7574, Date_Naissance#7520, N_Identification_National#7521, N_Secu#7522, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#7523]
(13) Project
Arguments: [IPP#7533, Nom_Usage#7544, Nom_Naissance#7554, Prenom#7564, Sexe-Pat#7574, Date_Naissance#7520 AS Date_Naissance#7584, N_Identification_National#7521, N_Secu#7522, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#7523]
(14) Project
Arguments: [IPP#7533, Nom_Usage#7544, Nom_Naissance#7554, Prenom#7564, Sexe-Pat#7574, Date_Naissance#7584, N_Identification_National#7521 AS N_Identification_National#7594, N_Secu#7522, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#7523]
(15) Project
Arguments: [IPP#7533, Nom_Usage#7544, Nom_Naissance#7554, Prenom#7564, Sexe-Pat#7574, Date_Naissance#7584, N_Identification_National#7594, N_Secu#7522 AS N_Secu#7604, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#7523]
(16) Project
Arguments: [IPP#7533, Nom_Usage#7544, Nom_Naissance#7554, Prenom#7564, Sexe-Pat#7574, Date_Naissance#7584, N_Identification_National#7594, N_Secu#7604, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#7523 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#7614]
(17) Project
Arguments: [IPP#7533 AS IPP#7624, Nom_Usage#7544 AS Nom_Usage#7625, Nom_Naissance#7554 AS Nom_Naissance#7626, Prenom#7564 AS Prenom#7627, Sexe-Pat#7574 AS Sexe-Pat#7628, Date_Naissance#7584 AS Date_Naissance#7629, N_Identification_National#7594 AS N_Identification_National#7630, N_Secu#7604 AS N_Secu#7631, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#7614 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#7632]
(18) Project
Arguments: [IPP#7624, Nom_Usage#7625, Nom_Naissance#7626, Prenom#7627, Sexe-Pat#7628, Date_Naissance#7629, N_Identification_National#7630, N_Secu#7631, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#7632]
(19) Project
Arguments: [Date_Naissance#7629 AS DATE_NAISSANCE_388125#7651, Nom_Naissance#7626 AS NOM_NAISSANCE_388122#7652, Nom_Usage#7625 AS NOM_USAGE_388121#7653, N_Identification_National#7630 AS N_IDENTIFICATIO_388126#7654, IPP#7624 AS N_PATIENT_ETABL_388120#7655, N_Secu#7631 AS N_SECURITE_SOCI_388127#7656, Prenom#7627 AS PRENOM_388123#7657, cast(str_replace_extend(Sexe-Pat#7628, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#7659]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#7499, NOM_NAISSANCE_388122#7500, NOM_USAGE_388121#7501, N_IDENTIFICATIO_388126#7502, N_PATIENT_ETABL_388120#7503, N_SECURITE_SOCI_388127#7504, PRENOM_388123#7505, SEXE_388124#7506, str_encrypt(N_PATIENT_ETABL_388120#7503) AS ID_PATIENT_388128#7676, str_encrypt(N_PATIENT_ETABL_388120#7503) AS ID_PATIENT_BIS_388129#7677]