== 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_388119177`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#26362, Nom_Usage#26363, Nom_Naissance#26364, Prenom#26365, Sexe#26366, Date_Naissance#26367, N_Identification_National#26368, N_Securite_Social#26369], false
(4) Project
Arguments: [N_Patient_Etablissement#26362 AS N_Patient_Etablissement#26386, Nom_Usage#26363 AS Nom_Usage#26387, Nom_Naissance#26364 AS Nom_Naissance#26388, Prenom#26365 AS Prenom#26389, Sexe#26366 AS Sexe#26390, Date_Naissance#26367 AS Date_Naissance#26391, N_Identification_National#26368 AS N_Identification_National#26392, N_Securite_Social#26369 AS N_Securite_Social#26393]
(5) Project
Arguments: [N_Patient_Etablissement#26386, Nom_Usage#26387, Nom_Naissance#26388, Prenom#26389, Sexe#26390, Date_Naissance#26391, N_Identification_National#26392, N_Securite_Social#26393]
(6) Project
Arguments: [Date_Naissance#26391 AS DATE_NAISSANCE_388125#26411, Nom_Naissance#26388 AS NOM_NAISSANCE_388122#26412, Nom_Usage#26387 AS NOM_USAGE_388121#26413, N_Identification_National#26392 AS N_IDENTIFICATIO_388126#26414, N_Patient_Etablissement#26386 AS N_PATIENT_ETABL_388120#26415, N_Securite_Social#26393 AS N_SECURITE_SOCI_388127#26416, Prenom#26389 AS PRENOM_388123#26417, Sexe#26390 AS SEXE_388124#26418]
(7) LogicalRelation
Arguments: parquet, [IPP#26427, Nom_Usage#26428, Nom_Naissance#26429, Prenom#26430, Sexe-Pat#26431, Date_Naissance#26432, N_Identification_National#26433, N_Secu#26434, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435], false
(8) Project
Arguments: [IPP#26427 AS IPP#26445, Nom_Usage#26428, Nom_Naissance#26429, Prenom#26430, Sexe-Pat#26431, Date_Naissance#26432, N_Identification_National#26433, N_Secu#26434, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435]
(9) Project
Arguments: [IPP#26445, Nom_Usage#26428 AS Nom_Usage#26456, Nom_Naissance#26429, Prenom#26430, Sexe-Pat#26431, Date_Naissance#26432, N_Identification_National#26433, N_Secu#26434, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435]
(10) Project
Arguments: [IPP#26445, Nom_Usage#26456, Nom_Naissance#26429 AS Nom_Naissance#26466, Prenom#26430, Sexe-Pat#26431, Date_Naissance#26432, N_Identification_National#26433, N_Secu#26434, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435]
(11) Project
Arguments: [IPP#26445, Nom_Usage#26456, Nom_Naissance#26466, Prenom#26430 AS Prenom#26476, Sexe-Pat#26431, Date_Naissance#26432, N_Identification_National#26433, N_Secu#26434, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435]
(12) Project
Arguments: [IPP#26445, Nom_Usage#26456, Nom_Naissance#26466, Prenom#26476, Sexe-Pat#26431 AS Sexe-Pat#26486, Date_Naissance#26432, N_Identification_National#26433, N_Secu#26434, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435]
(13) Project
Arguments: [IPP#26445, Nom_Usage#26456, Nom_Naissance#26466, Prenom#26476, Sexe-Pat#26486, Date_Naissance#26432 AS Date_Naissance#26496, N_Identification_National#26433, N_Secu#26434, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435]
(14) Project
Arguments: [IPP#26445, Nom_Usage#26456, Nom_Naissance#26466, Prenom#26476, Sexe-Pat#26486, Date_Naissance#26496, N_Identification_National#26433 AS N_Identification_National#26506, N_Secu#26434, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435]
(15) Project
Arguments: [IPP#26445, Nom_Usage#26456, Nom_Naissance#26466, Prenom#26476, Sexe-Pat#26486, Date_Naissance#26496, N_Identification_National#26506, N_Secu#26434 AS N_Secu#26516, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435]
(16) Project
Arguments: [IPP#26445, Nom_Usage#26456, Nom_Naissance#26466, Prenom#26476, Sexe-Pat#26486, Date_Naissance#26496, N_Identification_National#26506, N_Secu#26516, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26435 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26526]
(17) Project
Arguments: [IPP#26445 AS IPP#26536, Nom_Usage#26456 AS Nom_Usage#26537, Nom_Naissance#26466 AS Nom_Naissance#26538, Prenom#26476 AS Prenom#26539, Sexe-Pat#26486 AS Sexe-Pat#26540, Date_Naissance#26496 AS Date_Naissance#26541, N_Identification_National#26506 AS N_Identification_National#26542, N_Secu#26516 AS N_Secu#26543, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26526 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26544]
(18) Project
Arguments: [IPP#26536, Nom_Usage#26537, Nom_Naissance#26538, Prenom#26539, Sexe-Pat#26540, Date_Naissance#26541, N_Identification_National#26542, N_Secu#26543, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#26544]
(19) Project
Arguments: [Date_Naissance#26541 AS DATE_NAISSANCE_388125#26563, Nom_Naissance#26538 AS NOM_NAISSANCE_388122#26564, Nom_Usage#26537 AS NOM_USAGE_388121#26565, N_Identification_National#26542 AS N_IDENTIFICATIO_388126#26566, IPP#26536 AS N_PATIENT_ETABL_388120#26567, N_Secu#26543 AS N_SECURITE_SOCI_388127#26568, Prenom#26539 AS PRENOM_388123#26569, cast(str_replace_extend(Sexe-Pat#26540, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#26571]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#26411, NOM_NAISSANCE_388122#26412, NOM_USAGE_388121#26413, N_IDENTIFICATIO_388126#26414, N_PATIENT_ETABL_388120#26415, N_SECURITE_SOCI_388127#26416, PRENOM_388123#26417, SEXE_388124#26418, str_encrypt(N_PATIENT_ETABL_388120#26415) AS ID_PATIENT_388128#26588, str_encrypt(N_PATIENT_ETABL_388120#26415) AS ID_PATIENT_BIS_388129#26589]