== 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_388119180`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#31466, Nom_Usage#31467, Nom_Naissance#31468, Prenom#31469, Sexe#31470, Date_Naissance#31471, N_Identification_National#31472, N_Securite_Social#31473], false
(4) Project
Arguments: [N_Patient_Etablissement#31466 AS N_Patient_Etablissement#31490, Nom_Usage#31467 AS Nom_Usage#31491, Nom_Naissance#31468 AS Nom_Naissance#31492, Prenom#31469 AS Prenom#31493, Sexe#31470 AS Sexe#31494, Date_Naissance#31471 AS Date_Naissance#31495, N_Identification_National#31472 AS N_Identification_National#31496, N_Securite_Social#31473 AS N_Securite_Social#31497]
(5) Project
Arguments: [N_Patient_Etablissement#31490, Nom_Usage#31491, Nom_Naissance#31492, Prenom#31493, Sexe#31494, Date_Naissance#31495, N_Identification_National#31496, N_Securite_Social#31497]
(6) Project
Arguments: [Date_Naissance#31495 AS DATE_NAISSANCE_388125#31515, Nom_Naissance#31492 AS NOM_NAISSANCE_388122#31516, Nom_Usage#31491 AS NOM_USAGE_388121#31517, N_Identification_National#31496 AS N_IDENTIFICATIO_388126#31518, N_Patient_Etablissement#31490 AS N_PATIENT_ETABL_388120#31519, N_Securite_Social#31497 AS N_SECURITE_SOCI_388127#31520, Prenom#31493 AS PRENOM_388123#31521, Sexe#31494 AS SEXE_388124#31522]
(7) LogicalRelation
Arguments: parquet, [IPP#31531, Nom_Usage#31532, Nom_Naissance#31533, Prenom#31534, Sexe-Pat#31535, Date_Naissance#31536, N_Identification_National#31537, N_Secu#31538, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539], false
(8) Project
Arguments: [IPP#31531 AS IPP#31549, Nom_Usage#31532, Nom_Naissance#31533, Prenom#31534, Sexe-Pat#31535, Date_Naissance#31536, N_Identification_National#31537, N_Secu#31538, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539]
(9) Project
Arguments: [IPP#31549, Nom_Usage#31532 AS Nom_Usage#31560, Nom_Naissance#31533, Prenom#31534, Sexe-Pat#31535, Date_Naissance#31536, N_Identification_National#31537, N_Secu#31538, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539]
(10) Project
Arguments: [IPP#31549, Nom_Usage#31560, Nom_Naissance#31533 AS Nom_Naissance#31570, Prenom#31534, Sexe-Pat#31535, Date_Naissance#31536, N_Identification_National#31537, N_Secu#31538, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539]
(11) Project
Arguments: [IPP#31549, Nom_Usage#31560, Nom_Naissance#31570, Prenom#31534 AS Prenom#31580, Sexe-Pat#31535, Date_Naissance#31536, N_Identification_National#31537, N_Secu#31538, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539]
(12) Project
Arguments: [IPP#31549, Nom_Usage#31560, Nom_Naissance#31570, Prenom#31580, Sexe-Pat#31535 AS Sexe-Pat#31590, Date_Naissance#31536, N_Identification_National#31537, N_Secu#31538, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539]
(13) Project
Arguments: [IPP#31549, Nom_Usage#31560, Nom_Naissance#31570, Prenom#31580, Sexe-Pat#31590, Date_Naissance#31536 AS Date_Naissance#31600, N_Identification_National#31537, N_Secu#31538, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539]
(14) Project
Arguments: [IPP#31549, Nom_Usage#31560, Nom_Naissance#31570, Prenom#31580, Sexe-Pat#31590, Date_Naissance#31600, N_Identification_National#31537 AS N_Identification_National#31610, N_Secu#31538, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539]
(15) Project
Arguments: [IPP#31549, Nom_Usage#31560, Nom_Naissance#31570, Prenom#31580, Sexe-Pat#31590, Date_Naissance#31600, N_Identification_National#31610, N_Secu#31538 AS N_Secu#31620, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539]
(16) Project
Arguments: [IPP#31549, Nom_Usage#31560, Nom_Naissance#31570, Prenom#31580, Sexe-Pat#31590, Date_Naissance#31600, N_Identification_National#31610, N_Secu#31620, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31539 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31630]
(17) Project
Arguments: [IPP#31549 AS IPP#31640, Nom_Usage#31560 AS Nom_Usage#31641, Nom_Naissance#31570 AS Nom_Naissance#31642, Prenom#31580 AS Prenom#31643, Sexe-Pat#31590 AS Sexe-Pat#31644, Date_Naissance#31600 AS Date_Naissance#31645, N_Identification_National#31610 AS N_Identification_National#31646, N_Secu#31620 AS N_Secu#31647, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31630 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31648]
(18) Project
Arguments: [IPP#31640, Nom_Usage#31641, Nom_Naissance#31642, Prenom#31643, Sexe-Pat#31644, Date_Naissance#31645, N_Identification_National#31646, N_Secu#31647, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#31648]
(19) Project
Arguments: [Date_Naissance#31645 AS DATE_NAISSANCE_388125#31667, Nom_Naissance#31642 AS NOM_NAISSANCE_388122#31668, Nom_Usage#31641 AS NOM_USAGE_388121#31669, N_Identification_National#31646 AS N_IDENTIFICATIO_388126#31670, IPP#31640 AS N_PATIENT_ETABL_388120#31671, N_Secu#31647 AS N_SECURITE_SOCI_388127#31672, Prenom#31643 AS PRENOM_388123#31673, cast(str_replace_extend(Sexe-Pat#31644, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#31675]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#31515, NOM_NAISSANCE_388122#31516, NOM_USAGE_388121#31517, N_IDENTIFICATIO_388126#31518, N_PATIENT_ETABL_388120#31519, N_SECURITE_SOCI_388127#31520, PRENOM_388123#31521, SEXE_388124#31522, str_encrypt(N_PATIENT_ETABL_388120#31519) AS ID_PATIENT_388128#31692, str_encrypt(N_PATIENT_ETABL_388120#31519) AS ID_PATIENT_BIS_388129#31693]