== 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#22476, Nom_Usage#22477, Nom_Naissance#22478, Prenom#22479, Sexe#22480, Date_Naissance#22481, N_Identification_National#22482, N_Securite_Social#22483], false
(4) Project
Arguments: [N_Patient_Etablissement#22476 AS N_Patient_Etablissement#22500, Nom_Usage#22477 AS Nom_Usage#22501, Nom_Naissance#22478 AS Nom_Naissance#22502, Prenom#22479 AS Prenom#22503, Sexe#22480 AS Sexe#22504, Date_Naissance#22481 AS Date_Naissance#22505, N_Identification_National#22482 AS N_Identification_National#22506, N_Securite_Social#22483 AS N_Securite_Social#22507]
(5) Project
Arguments: [N_Patient_Etablissement#22500, Nom_Usage#22501, Nom_Naissance#22502, Prenom#22503, Sexe#22504, Date_Naissance#22505, N_Identification_National#22506, N_Securite_Social#22507]
(6) Project
Arguments: [Date_Naissance#22505 AS DATE_NAISSANCE_388125#22525, Nom_Naissance#22502 AS NOM_NAISSANCE_388122#22526, Nom_Usage#22501 AS NOM_USAGE_388121#22527, N_Identification_National#22506 AS N_IDENTIFICATIO_388126#22528, N_Patient_Etablissement#22500 AS N_PATIENT_ETABL_388120#22529, N_Securite_Social#22507 AS N_SECURITE_SOCI_388127#22530, Prenom#22503 AS PRENOM_388123#22531, Sexe#22504 AS SEXE_388124#22532]
(7) LogicalRelation
Arguments: parquet, [IPP#22541, Nom_Usage#22542, Nom_Naissance#22543, Prenom#22544, Sexe-Pat#22545, Date_Naissance#22546, N_Identification_National#22547, N_Secu#22548, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#22549], false
(8) Project
Arguments: [IPP#22541 AS IPP#22559, Nom_Usage#22542, Nom_Naissance#22543, Prenom#22544, Sexe-Pat#22545, Date_Naissance#22546, N_Identification_National#22547, N_Secu#22548, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#22549]
(9) Project
Arguments: [IPP#22559, Nom_Usage#22542 AS Nom_Usage#22570, Nom_Naissance#22543, Prenom#22544, Sexe-Pat#22545, Date_Naissance#22546, N_Identification_National#22547, N_Secu#22548, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#22549]
(10) Project
Arguments: [IPP#22559, Nom_Usage#22570, Nom_Naissance#22543 AS Nom_Naissance#22580, Prenom#22544, Sexe-Pat#22545, Date_Naissance#22546, N_Identification_National#22547, N_Secu#22548, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#22549]
(11) Project
Arguments: [IPP#22559, Nom_Usage#22570, Nom_Naissance#22580, Prenom#22544 AS Prenom#22590, Sexe-Pat#22545, Date_Naissance#22546, N_Identification_National#22547, N_Secu#22548, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#22549]
(12) Project
Arguments: [IPP#22559, Nom_Usage#22570, Nom_Naissance#22580, Prenom#22590, Sexe-Pat#22545 AS Sexe-Pat#22600, Date_Naissance#22546, N_Identification_National#22547, N_Secu#22548, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#22549]
(13) Project
Arguments: [IPP#22559, Nom_Usage#22570, Nom_Naissance#22580, Prenom#22590, Sexe-Pat#22600, Date_Naissance#22546 AS Date_Naissance#22610, N_Identification_National#22547, N_Secu#22548, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#22549]
(14) Project
Arguments: [IPP#22559, Nom_Usage#22570, Nom_Naissance#22580, Prenom#22590, Sexe-Pat#22600, Date_Naissance#22610, N_Identification_National#22547 AS N_Identification_National#22620, N_Secu#22548, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#22549]
(15) Project
Arguments: [IPP#22559, Nom_Usage#22570, Nom_Naissance#22580, Prenom#22590, Sexe-Pat#22600, Date_Naissance#22610, N_Identification_National#22620, N_Secu#22548 AS N_Secu#22630, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#22549]
(16) Project
Arguments: [IPP#22559, Nom_Usage#22570, Nom_Naissance#22580, Prenom#22590, Sexe-Pat#22600, Date_Naissance#22610, N_Identification_National#22620, N_Secu#22630, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#22549 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#22640]
(17) Project
Arguments: [IPP#22559 AS IPP#22650, Nom_Usage#22570 AS Nom_Usage#22651, Nom_Naissance#22580 AS Nom_Naissance#22652, Prenom#22590 AS Prenom#22653, Sexe-Pat#22600 AS Sexe-Pat#22654, Date_Naissance#22610 AS Date_Naissance#22655, N_Identification_National#22620 AS N_Identification_National#22656, N_Secu#22630 AS N_Secu#22657, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#22640 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#22658]
(18) Project
Arguments: [IPP#22650, Nom_Usage#22651, Nom_Naissance#22652, Prenom#22653, Sexe-Pat#22654, Date_Naissance#22655, N_Identification_National#22656, N_Secu#22657, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#22658]
(19) Project
Arguments: [Date_Naissance#22655 AS DATE_NAISSANCE_388125#22677, Nom_Naissance#22652 AS NOM_NAISSANCE_388122#22678, Nom_Usage#22651 AS NOM_USAGE_388121#22679, N_Identification_National#22656 AS N_IDENTIFICATIO_388126#22680, IPP#22650 AS N_PATIENT_ETABL_388120#22681, N_Secu#22657 AS N_SECURITE_SOCI_388127#22682, Prenom#22653 AS PRENOM_388123#22683, cast(str_replace_extend(Sexe-Pat#22654, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#22685]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#22525, NOM_NAISSANCE_388122#22526, NOM_USAGE_388121#22527, N_IDENTIFICATIO_388126#22528, N_PATIENT_ETABL_388120#22529, N_SECURITE_SOCI_388127#22530, PRENOM_388123#22531, SEXE_388124#22532, str_encrypt(N_PATIENT_ETABL_388120#22529) AS ID_PATIENT_388128#22702, str_encrypt(N_PATIENT_ETABL_388120#22529) AS ID_PATIENT_BIS_388129#22703]