== 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#3551, Nom_Usage#3552, Nom_Naissance#3553, Prenom#3554, Sexe#3555, Date_Naissance#3556, N_Identification_National#3557, N_Securite_Social#3558], false
(4) Project
Arguments: [N_Patient_Etablissement#3551 AS N_Patient_Etablissement#3575, Nom_Usage#3552 AS Nom_Usage#3576, Nom_Naissance#3553 AS Nom_Naissance#3577, Prenom#3554 AS Prenom#3578, Sexe#3555 AS Sexe#3579, Date_Naissance#3556 AS Date_Naissance#3580, N_Identification_National#3557 AS N_Identification_National#3581, N_Securite_Social#3558 AS N_Securite_Social#3582]
(5) Project
Arguments: [N_Patient_Etablissement#3575, Nom_Usage#3576, Nom_Naissance#3577, Prenom#3578, Sexe#3579, Date_Naissance#3580, N_Identification_National#3581, N_Securite_Social#3582]
(6) Project
Arguments: [Date_Naissance#3580 AS DATE_NAISSANCE_388125#3600, Nom_Naissance#3577 AS NOM_NAISSANCE_388122#3601, Nom_Usage#3576 AS NOM_USAGE_388121#3602, N_Identification_National#3581 AS N_IDENTIFICATIO_388126#3603, N_Patient_Etablissement#3575 AS N_PATIENT_ETABL_388120#3604, N_Securite_Social#3582 AS N_SECURITE_SOCI_388127#3605, Prenom#3578 AS PRENOM_388123#3606, Sexe#3579 AS SEXE_388124#3607]
(7) LogicalRelation
Arguments: parquet, [IPP#3765, Nom_Usage#3766, Nom_Naissance#3767, Prenom#3768, Sexe-Pat#3769, Date_Naissance#3770, N_Identification_National#3771, N_Secu#3772, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#3773], false
(8) Project
Arguments: [IPP#3765 AS IPP#3783, Nom_Usage#3766, Nom_Naissance#3767, Prenom#3768, Sexe-Pat#3769, Date_Naissance#3770, N_Identification_National#3771, N_Secu#3772, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#3773]
(9) Project
Arguments: [IPP#3783, Nom_Usage#3766 AS Nom_Usage#3794, Nom_Naissance#3767, Prenom#3768, Sexe-Pat#3769, Date_Naissance#3770, N_Identification_National#3771, N_Secu#3772, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#3773]
(10) Project
Arguments: [IPP#3783, Nom_Usage#3794, Nom_Naissance#3767 AS Nom_Naissance#3804, Prenom#3768, Sexe-Pat#3769, Date_Naissance#3770, N_Identification_National#3771, N_Secu#3772, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#3773]
(11) Project
Arguments: [IPP#3783, Nom_Usage#3794, Nom_Naissance#3804, Prenom#3768 AS Prenom#3814, Sexe-Pat#3769, Date_Naissance#3770, N_Identification_National#3771, N_Secu#3772, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#3773]
(12) Project
Arguments: [IPP#3783, Nom_Usage#3794, Nom_Naissance#3804, Prenom#3814, Sexe-Pat#3769 AS Sexe-Pat#3824, Date_Naissance#3770, N_Identification_National#3771, N_Secu#3772, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#3773]
(13) Project
Arguments: [IPP#3783, Nom_Usage#3794, Nom_Naissance#3804, Prenom#3814, Sexe-Pat#3824, Date_Naissance#3770 AS Date_Naissance#3834, N_Identification_National#3771, N_Secu#3772, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#3773]
(14) Project
Arguments: [IPP#3783, Nom_Usage#3794, Nom_Naissance#3804, Prenom#3814, Sexe-Pat#3824, Date_Naissance#3834, N_Identification_National#3771 AS N_Identification_National#3844, N_Secu#3772, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#3773]
(15) Project
Arguments: [IPP#3783, Nom_Usage#3794, Nom_Naissance#3804, Prenom#3814, Sexe-Pat#3824, Date_Naissance#3834, N_Identification_National#3844, N_Secu#3772 AS N_Secu#3854, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#3773]
(16) Project
Arguments: [IPP#3783, Nom_Usage#3794, Nom_Naissance#3804, Prenom#3814, Sexe-Pat#3824, Date_Naissance#3834, N_Identification_National#3844, N_Secu#3854, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#3773 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#3864]
(17) Project
Arguments: [IPP#3783 AS IPP#3874, Nom_Usage#3794 AS Nom_Usage#3875, Nom_Naissance#3804 AS Nom_Naissance#3876, Prenom#3814 AS Prenom#3877, Sexe-Pat#3824 AS Sexe-Pat#3878, Date_Naissance#3834 AS Date_Naissance#3879, N_Identification_National#3844 AS N_Identification_National#3880, N_Secu#3854 AS N_Secu#3881, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#3864 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#3882]
(18) Project
Arguments: [IPP#3874, Nom_Usage#3875, Nom_Naissance#3876, Prenom#3877, Sexe-Pat#3878, Date_Naissance#3879, N_Identification_National#3880, N_Secu#3881, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#3882]
(19) Project
Arguments: [Date_Naissance#3879 AS DATE_NAISSANCE_388125#3901, Nom_Naissance#3876 AS NOM_NAISSANCE_388122#3902, Nom_Usage#3875 AS NOM_USAGE_388121#3903, N_Identification_National#3880 AS N_IDENTIFICATIO_388126#3904, IPP#3874 AS N_PATIENT_ETABL_388120#3905, N_Secu#3881 AS N_SECURITE_SOCI_388127#3906, Prenom#3877 AS PRENOM_388123#3907, cast(str_replace_extend(Sexe-Pat#3878, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#3909]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#3600, NOM_NAISSANCE_388122#3601, NOM_USAGE_388121#3602, N_IDENTIFICATIO_388126#3603, N_PATIENT_ETABL_388120#3604, N_SECURITE_SOCI_388127#3605, PRENOM_388123#3606, SEXE_388124#3607, str_encrypt(N_PATIENT_ETABL_388120#3604) AS ID_PATIENT_388128#3926, str_encrypt(N_PATIENT_ETABL_388120#3604) AS ID_PATIENT_BIS_388129#3927]