== 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_388119181`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#23694, Nom_Usage#23695, Nom_Naissance#23696, Prenom#23697, Sexe#23698, Date_Naissance#23699, N_Identification_National#23700, N_Securite_Social#23701], false
(4) Project
Arguments: [N_Patient_Etablissement#23694 AS N_Patient_Etablissement#23718, Nom_Usage#23695 AS Nom_Usage#23719, Nom_Naissance#23696 AS Nom_Naissance#23720, Prenom#23697 AS Prenom#23721, Sexe#23698 AS Sexe#23722, Date_Naissance#23699 AS Date_Naissance#23723, N_Identification_National#23700 AS N_Identification_National#23724, N_Securite_Social#23701 AS N_Securite_Social#23725]
(5) Project
Arguments: [N_Patient_Etablissement#23718, Nom_Usage#23719, Nom_Naissance#23720, Prenom#23721, Sexe#23722, Date_Naissance#23723, N_Identification_National#23724, N_Securite_Social#23725]
(6) Project
Arguments: [Date_Naissance#23723 AS DATE_NAISSANCE_388125#23743, Nom_Naissance#23720 AS NOM_NAISSANCE_388122#23744, Nom_Usage#23719 AS NOM_USAGE_388121#23745, N_Identification_National#23724 AS N_IDENTIFICATIO_388126#23746, N_Patient_Etablissement#23718 AS N_PATIENT_ETABL_388120#23747, N_Securite_Social#23725 AS N_SECURITE_SOCI_388127#23748, Prenom#23721 AS PRENOM_388123#23749, Sexe#23722 AS SEXE_388124#23750]
(7) LogicalRelation
Arguments: parquet, [IPP#23759, Nom_Usage#23760, Nom_Naissance#23761, Prenom#23762, Sexe-Pat#23763, Date_Naissance#23764, N_Identification_National#23765, N_Secu#23766, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767], false
(8) Project
Arguments: [IPP#23759 AS IPP#23777, Nom_Usage#23760, Nom_Naissance#23761, Prenom#23762, Sexe-Pat#23763, Date_Naissance#23764, N_Identification_National#23765, N_Secu#23766, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767]
(9) Project
Arguments: [IPP#23777, Nom_Usage#23760 AS Nom_Usage#23788, Nom_Naissance#23761, Prenom#23762, Sexe-Pat#23763, Date_Naissance#23764, N_Identification_National#23765, N_Secu#23766, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767]
(10) Project
Arguments: [IPP#23777, Nom_Usage#23788, Nom_Naissance#23761 AS Nom_Naissance#23798, Prenom#23762, Sexe-Pat#23763, Date_Naissance#23764, N_Identification_National#23765, N_Secu#23766, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767]
(11) Project
Arguments: [IPP#23777, Nom_Usage#23788, Nom_Naissance#23798, Prenom#23762 AS Prenom#23808, Sexe-Pat#23763, Date_Naissance#23764, N_Identification_National#23765, N_Secu#23766, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767]
(12) Project
Arguments: [IPP#23777, Nom_Usage#23788, Nom_Naissance#23798, Prenom#23808, Sexe-Pat#23763 AS Sexe-Pat#23818, Date_Naissance#23764, N_Identification_National#23765, N_Secu#23766, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767]
(13) Project
Arguments: [IPP#23777, Nom_Usage#23788, Nom_Naissance#23798, Prenom#23808, Sexe-Pat#23818, Date_Naissance#23764 AS Date_Naissance#23828, N_Identification_National#23765, N_Secu#23766, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767]
(14) Project
Arguments: [IPP#23777, Nom_Usage#23788, Nom_Naissance#23798, Prenom#23808, Sexe-Pat#23818, Date_Naissance#23828, N_Identification_National#23765 AS N_Identification_National#23838, N_Secu#23766, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767]
(15) Project
Arguments: [IPP#23777, Nom_Usage#23788, Nom_Naissance#23798, Prenom#23808, Sexe-Pat#23818, Date_Naissance#23828, N_Identification_National#23838, N_Secu#23766 AS N_Secu#23848, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767]
(16) Project
Arguments: [IPP#23777, Nom_Usage#23788, Nom_Naissance#23798, Prenom#23808, Sexe-Pat#23818, Date_Naissance#23828, N_Identification_National#23838, N_Secu#23848, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23767 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23858]
(17) Project
Arguments: [IPP#23777 AS IPP#23868, Nom_Usage#23788 AS Nom_Usage#23869, Nom_Naissance#23798 AS Nom_Naissance#23870, Prenom#23808 AS Prenom#23871, Sexe-Pat#23818 AS Sexe-Pat#23872, Date_Naissance#23828 AS Date_Naissance#23873, N_Identification_National#23838 AS N_Identification_National#23874, N_Secu#23848 AS N_Secu#23875, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23858 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23876]
(18) Project
Arguments: [IPP#23868, Nom_Usage#23869, Nom_Naissance#23870, Prenom#23871, Sexe-Pat#23872, Date_Naissance#23873, N_Identification_National#23874, N_Secu#23875, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#23876]
(19) Project
Arguments: [Date_Naissance#23873 AS DATE_NAISSANCE_388125#23895, Nom_Naissance#23870 AS NOM_NAISSANCE_388122#23896, Nom_Usage#23869 AS NOM_USAGE_388121#23897, N_Identification_National#23874 AS N_IDENTIFICATIO_388126#23898, IPP#23868 AS N_PATIENT_ETABL_388120#23899, N_Secu#23875 AS N_SECURITE_SOCI_388127#23900, Prenom#23871 AS PRENOM_388123#23901, cast(str_replace_extend(Sexe-Pat#23872, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#23903]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#23743, NOM_NAISSANCE_388122#23744, NOM_USAGE_388121#23745, N_IDENTIFICATIO_388126#23746, N_PATIENT_ETABL_388120#23747, N_SECURITE_SOCI_388127#23748, PRENOM_388123#23749, SEXE_388124#23750, str_encrypt(N_PATIENT_ETABL_388120#23747) AS ID_PATIENT_388128#23920, str_encrypt(N_PATIENT_ETABL_388120#23747) AS ID_PATIENT_BIS_388129#23921]