== 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#12450, Nom_Usage#12451, Nom_Naissance#12452, Prenom#12453, Sexe#12454, Date_Naissance#12455, N_Identification_National#12456, N_Securite_Social#12457], false
(4) Project
Arguments: [N_Patient_Etablissement#12450 AS N_Patient_Etablissement#12474, Nom_Usage#12451 AS Nom_Usage#12475, Nom_Naissance#12452 AS Nom_Naissance#12476, Prenom#12453 AS Prenom#12477, Sexe#12454 AS Sexe#12478, Date_Naissance#12455 AS Date_Naissance#12479, N_Identification_National#12456 AS N_Identification_National#12480, N_Securite_Social#12457 AS N_Securite_Social#12481]
(5) Project
Arguments: [N_Patient_Etablissement#12474, Nom_Usage#12475, Nom_Naissance#12476, Prenom#12477, Sexe#12478, Date_Naissance#12479, N_Identification_National#12480, N_Securite_Social#12481]
(6) Project
Arguments: [Date_Naissance#12479 AS DATE_NAISSANCE_388125#12499, Nom_Naissance#12476 AS NOM_NAISSANCE_388122#12500, Nom_Usage#12475 AS NOM_USAGE_388121#12501, N_Identification_National#12480 AS N_IDENTIFICATIO_388126#12502, N_Patient_Etablissement#12474 AS N_PATIENT_ETABL_388120#12503, N_Securite_Social#12481 AS N_SECURITE_SOCI_388127#12504, Prenom#12477 AS PRENOM_388123#12505, Sexe#12478 AS SEXE_388124#12506]
(7) LogicalRelation
Arguments: parquet, [IPP#12515, Nom_Usage#12516, Nom_Naissance#12517, Prenom#12518, Sexe-Pat#12519, Date_Naissance#12520, N_Identification_National#12521, N_Secu#12522, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#12523], false
(8) Project
Arguments: [IPP#12515 AS IPP#12533, Nom_Usage#12516, Nom_Naissance#12517, Prenom#12518, Sexe-Pat#12519, Date_Naissance#12520, N_Identification_National#12521, N_Secu#12522, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#12523]
(9) Project
Arguments: [IPP#12533, Nom_Usage#12516 AS Nom_Usage#12544, Nom_Naissance#12517, Prenom#12518, Sexe-Pat#12519, Date_Naissance#12520, N_Identification_National#12521, N_Secu#12522, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#12523]
(10) Project
Arguments: [IPP#12533, Nom_Usage#12544, Nom_Naissance#12517 AS Nom_Naissance#12554, Prenom#12518, Sexe-Pat#12519, Date_Naissance#12520, N_Identification_National#12521, N_Secu#12522, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#12523]
(11) Project
Arguments: [IPP#12533, Nom_Usage#12544, Nom_Naissance#12554, Prenom#12518 AS Prenom#12564, Sexe-Pat#12519, Date_Naissance#12520, N_Identification_National#12521, N_Secu#12522, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#12523]
(12) Project
Arguments: [IPP#12533, Nom_Usage#12544, Nom_Naissance#12554, Prenom#12564, Sexe-Pat#12519 AS Sexe-Pat#12574, Date_Naissance#12520, N_Identification_National#12521, N_Secu#12522, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#12523]
(13) Project
Arguments: [IPP#12533, Nom_Usage#12544, Nom_Naissance#12554, Prenom#12564, Sexe-Pat#12574, Date_Naissance#12520 AS Date_Naissance#12584, N_Identification_National#12521, N_Secu#12522, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#12523]
(14) Project
Arguments: [IPP#12533, Nom_Usage#12544, Nom_Naissance#12554, Prenom#12564, Sexe-Pat#12574, Date_Naissance#12584, N_Identification_National#12521 AS N_Identification_National#12594, N_Secu#12522, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#12523]
(15) Project
Arguments: [IPP#12533, Nom_Usage#12544, Nom_Naissance#12554, Prenom#12564, Sexe-Pat#12574, Date_Naissance#12584, N_Identification_National#12594, N_Secu#12522 AS N_Secu#12604, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#12523]
(16) Project
Arguments: [IPP#12533, Nom_Usage#12544, Nom_Naissance#12554, Prenom#12564, Sexe-Pat#12574, Date_Naissance#12584, N_Identification_National#12594, N_Secu#12604, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#12523 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#12614]
(17) Project
Arguments: [IPP#12533 AS IPP#12624, Nom_Usage#12544 AS Nom_Usage#12625, Nom_Naissance#12554 AS Nom_Naissance#12626, Prenom#12564 AS Prenom#12627, Sexe-Pat#12574 AS Sexe-Pat#12628, Date_Naissance#12584 AS Date_Naissance#12629, N_Identification_National#12594 AS N_Identification_National#12630, N_Secu#12604 AS N_Secu#12631, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#12614 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#12632]
(18) Project
Arguments: [IPP#12624, Nom_Usage#12625, Nom_Naissance#12626, Prenom#12627, Sexe-Pat#12628, Date_Naissance#12629, N_Identification_National#12630, N_Secu#12631, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#12632]
(19) Project
Arguments: [Date_Naissance#12629 AS DATE_NAISSANCE_388125#12651, Nom_Naissance#12626 AS NOM_NAISSANCE_388122#12652, Nom_Usage#12625 AS NOM_USAGE_388121#12653, N_Identification_National#12630 AS N_IDENTIFICATIO_388126#12654, IPP#12624 AS N_PATIENT_ETABL_388120#12655, N_Secu#12631 AS N_SECURITE_SOCI_388127#12656, Prenom#12627 AS PRENOM_388123#12657, cast(str_replace_extend(Sexe-Pat#12628, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#12659]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#12499, NOM_NAISSANCE_388122#12500, NOM_USAGE_388121#12501, N_IDENTIFICATIO_388126#12502, N_PATIENT_ETABL_388120#12503, N_SECURITE_SOCI_388127#12504, PRENOM_388123#12505, SEXE_388124#12506, str_encrypt(N_PATIENT_ETABL_388120#12503) AS ID_PATIENT_388128#12676, str_encrypt(N_PATIENT_ETABL_388120#12503) AS ID_PATIENT_BIS_388129#12677]