== 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#18822, Nom_Usage#18823, Nom_Naissance#18824, Prenom#18825, Sexe#18826, Date_Naissance#18827, N_Identification_National#18828, N_Securite_Social#18829], false
(4) Project
Arguments: [N_Patient_Etablissement#18822 AS N_Patient_Etablissement#18846, Nom_Usage#18823 AS Nom_Usage#18847, Nom_Naissance#18824 AS Nom_Naissance#18848, Prenom#18825 AS Prenom#18849, Sexe#18826 AS Sexe#18850, Date_Naissance#18827 AS Date_Naissance#18851, N_Identification_National#18828 AS N_Identification_National#18852, N_Securite_Social#18829 AS N_Securite_Social#18853]
(5) Project
Arguments: [N_Patient_Etablissement#18846, Nom_Usage#18847, Nom_Naissance#18848, Prenom#18849, Sexe#18850, Date_Naissance#18851, N_Identification_National#18852, N_Securite_Social#18853]
(6) Project
Arguments: [Date_Naissance#18851 AS DATE_NAISSANCE_388125#18871, Nom_Naissance#18848 AS NOM_NAISSANCE_388122#18872, Nom_Usage#18847 AS NOM_USAGE_388121#18873, N_Identification_National#18852 AS N_IDENTIFICATIO_388126#18874, N_Patient_Etablissement#18846 AS N_PATIENT_ETABL_388120#18875, N_Securite_Social#18853 AS N_SECURITE_SOCI_388127#18876, Prenom#18849 AS PRENOM_388123#18877, Sexe#18850 AS SEXE_388124#18878]
(7) LogicalRelation
Arguments: parquet, [IPP#18887, Nom_Usage#18888, Nom_Naissance#18889, Prenom#18890, Sexe-Pat#18891, Date_Naissance#18892, N_Identification_National#18893, N_Secu#18894, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#18895], false
(8) Project
Arguments: [IPP#18887 AS IPP#18905, Nom_Usage#18888, Nom_Naissance#18889, Prenom#18890, Sexe-Pat#18891, Date_Naissance#18892, N_Identification_National#18893, N_Secu#18894, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#18895]
(9) Project
Arguments: [IPP#18905, Nom_Usage#18888 AS Nom_Usage#18916, Nom_Naissance#18889, Prenom#18890, Sexe-Pat#18891, Date_Naissance#18892, N_Identification_National#18893, N_Secu#18894, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#18895]
(10) Project
Arguments: [IPP#18905, Nom_Usage#18916, Nom_Naissance#18889 AS Nom_Naissance#18926, Prenom#18890, Sexe-Pat#18891, Date_Naissance#18892, N_Identification_National#18893, N_Secu#18894, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#18895]
(11) Project
Arguments: [IPP#18905, Nom_Usage#18916, Nom_Naissance#18926, Prenom#18890 AS Prenom#18936, Sexe-Pat#18891, Date_Naissance#18892, N_Identification_National#18893, N_Secu#18894, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#18895]
(12) Project
Arguments: [IPP#18905, Nom_Usage#18916, Nom_Naissance#18926, Prenom#18936, Sexe-Pat#18891 AS Sexe-Pat#18946, Date_Naissance#18892, N_Identification_National#18893, N_Secu#18894, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#18895]
(13) Project
Arguments: [IPP#18905, Nom_Usage#18916, Nom_Naissance#18926, Prenom#18936, Sexe-Pat#18946, Date_Naissance#18892 AS Date_Naissance#18956, N_Identification_National#18893, N_Secu#18894, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#18895]
(14) Project
Arguments: [IPP#18905, Nom_Usage#18916, Nom_Naissance#18926, Prenom#18936, Sexe-Pat#18946, Date_Naissance#18956, N_Identification_National#18893 AS N_Identification_National#18966, N_Secu#18894, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#18895]
(15) Project
Arguments: [IPP#18905, Nom_Usage#18916, Nom_Naissance#18926, Prenom#18936, Sexe-Pat#18946, Date_Naissance#18956, N_Identification_National#18966, N_Secu#18894 AS N_Secu#18976, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#18895]
(16) Project
Arguments: [IPP#18905, Nom_Usage#18916, Nom_Naissance#18926, Prenom#18936, Sexe-Pat#18946, Date_Naissance#18956, N_Identification_National#18966, N_Secu#18976, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#18895 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#18986]
(17) Project
Arguments: [IPP#18905 AS IPP#18996, Nom_Usage#18916 AS Nom_Usage#18997, Nom_Naissance#18926 AS Nom_Naissance#18998, Prenom#18936 AS Prenom#18999, Sexe-Pat#18946 AS Sexe-Pat#19000, Date_Naissance#18956 AS Date_Naissance#19001, N_Identification_National#18966 AS N_Identification_National#19002, N_Secu#18976 AS N_Secu#19003, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#18986 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#19004]
(18) Project
Arguments: [IPP#18996, Nom_Usage#18997, Nom_Naissance#18998, Prenom#18999, Sexe-Pat#19000, Date_Naissance#19001, N_Identification_National#19002, N_Secu#19003, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#19004]
(19) Project
Arguments: [Date_Naissance#19001 AS DATE_NAISSANCE_388125#19023, Nom_Naissance#18998 AS NOM_NAISSANCE_388122#19024, Nom_Usage#18997 AS NOM_USAGE_388121#19025, N_Identification_National#19002 AS N_IDENTIFICATIO_388126#19026, IPP#18996 AS N_PATIENT_ETABL_388120#19027, N_Secu#19003 AS N_SECURITE_SOCI_388127#19028, Prenom#18999 AS PRENOM_388123#19029, cast(str_replace_extend(Sexe-Pat#19000, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#19031]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#18871, NOM_NAISSANCE_388122#18872, NOM_USAGE_388121#18873, N_IDENTIFICATIO_388126#18874, N_PATIENT_ETABL_388120#18875, N_SECURITE_SOCI_388127#18876, PRENOM_388123#18877, SEXE_388124#18878, str_encrypt(N_PATIENT_ETABL_388120#18875) AS ID_PATIENT_388128#19048, str_encrypt(N_PATIENT_ETABL_388120#18875) AS ID_PATIENT_BIS_388129#19049]