== 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#8700, Nom_Usage#8701, Nom_Naissance#8702, Prenom#8703, Sexe#8704, Date_Naissance#8705, N_Identification_National#8706, N_Securite_Social#8707], false
(4) Project
Arguments: [N_Patient_Etablissement#8700 AS N_Patient_Etablissement#8724, Nom_Usage#8701 AS Nom_Usage#8725, Nom_Naissance#8702 AS Nom_Naissance#8726, Prenom#8703 AS Prenom#8727, Sexe#8704 AS Sexe#8728, Date_Naissance#8705 AS Date_Naissance#8729, N_Identification_National#8706 AS N_Identification_National#8730, N_Securite_Social#8707 AS N_Securite_Social#8731]
(5) Project
Arguments: [N_Patient_Etablissement#8724, Nom_Usage#8725, Nom_Naissance#8726, Prenom#8727, Sexe#8728, Date_Naissance#8729, N_Identification_National#8730, N_Securite_Social#8731]
(6) Project
Arguments: [Date_Naissance#8729 AS DATE_NAISSANCE_388125#8749, Nom_Naissance#8726 AS NOM_NAISSANCE_388122#8750, Nom_Usage#8725 AS NOM_USAGE_388121#8751, N_Identification_National#8730 AS N_IDENTIFICATIO_388126#8752, N_Patient_Etablissement#8724 AS N_PATIENT_ETABL_388120#8753, N_Securite_Social#8731 AS N_SECURITE_SOCI_388127#8754, Prenom#8727 AS PRENOM_388123#8755, Sexe#8728 AS SEXE_388124#8756]
(7) LogicalRelation
Arguments: parquet, [IPP#8765, Nom_Usage#8766, Nom_Naissance#8767, Prenom#8768, Sexe-Pat#8769, Date_Naissance#8770, N_Identification_National#8771, N_Secu#8772, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#8773], false
(8) Project
Arguments: [IPP#8765 AS IPP#8783, Nom_Usage#8766, Nom_Naissance#8767, Prenom#8768, Sexe-Pat#8769, Date_Naissance#8770, N_Identification_National#8771, N_Secu#8772, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#8773]
(9) Project
Arguments: [IPP#8783, Nom_Usage#8766 AS Nom_Usage#8794, Nom_Naissance#8767, Prenom#8768, Sexe-Pat#8769, Date_Naissance#8770, N_Identification_National#8771, N_Secu#8772, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#8773]
(10) Project
Arguments: [IPP#8783, Nom_Usage#8794, Nom_Naissance#8767 AS Nom_Naissance#8804, Prenom#8768, Sexe-Pat#8769, Date_Naissance#8770, N_Identification_National#8771, N_Secu#8772, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#8773]
(11) Project
Arguments: [IPP#8783, Nom_Usage#8794, Nom_Naissance#8804, Prenom#8768 AS Prenom#8814, Sexe-Pat#8769, Date_Naissance#8770, N_Identification_National#8771, N_Secu#8772, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#8773]
(12) Project
Arguments: [IPP#8783, Nom_Usage#8794, Nom_Naissance#8804, Prenom#8814, Sexe-Pat#8769 AS Sexe-Pat#8824, Date_Naissance#8770, N_Identification_National#8771, N_Secu#8772, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#8773]
(13) Project
Arguments: [IPP#8783, Nom_Usage#8794, Nom_Naissance#8804, Prenom#8814, Sexe-Pat#8824, Date_Naissance#8770 AS Date_Naissance#8834, N_Identification_National#8771, N_Secu#8772, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#8773]
(14) Project
Arguments: [IPP#8783, Nom_Usage#8794, Nom_Naissance#8804, Prenom#8814, Sexe-Pat#8824, Date_Naissance#8834, N_Identification_National#8771 AS N_Identification_National#8844, N_Secu#8772, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#8773]
(15) Project
Arguments: [IPP#8783, Nom_Usage#8794, Nom_Naissance#8804, Prenom#8814, Sexe-Pat#8824, Date_Naissance#8834, N_Identification_National#8844, N_Secu#8772 AS N_Secu#8854, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#8773]
(16) Project
Arguments: [IPP#8783, Nom_Usage#8794, Nom_Naissance#8804, Prenom#8814, Sexe-Pat#8824, Date_Naissance#8834, N_Identification_National#8844, N_Secu#8854, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#8773 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#8864]
(17) Project
Arguments: [IPP#8783 AS IPP#8874, Nom_Usage#8794 AS Nom_Usage#8875, Nom_Naissance#8804 AS Nom_Naissance#8876, Prenom#8814 AS Prenom#8877, Sexe-Pat#8824 AS Sexe-Pat#8878, Date_Naissance#8834 AS Date_Naissance#8879, N_Identification_National#8844 AS N_Identification_National#8880, N_Secu#8854 AS N_Secu#8881, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#8864 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#8882]
(18) Project
Arguments: [IPP#8874, Nom_Usage#8875, Nom_Naissance#8876, Prenom#8877, Sexe-Pat#8878, Date_Naissance#8879, N_Identification_National#8880, N_Secu#8881, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#8882]
(19) Project
Arguments: [Date_Naissance#8879 AS DATE_NAISSANCE_388125#8901, Nom_Naissance#8876 AS NOM_NAISSANCE_388122#8902, Nom_Usage#8875 AS NOM_USAGE_388121#8903, N_Identification_National#8880 AS N_IDENTIFICATIO_388126#8904, IPP#8874 AS N_PATIENT_ETABL_388120#8905, N_Secu#8881 AS N_SECURITE_SOCI_388127#8906, Prenom#8877 AS PRENOM_388123#8907, cast(str_replace_extend(Sexe-Pat#8878, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#8909]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#8749, NOM_NAISSANCE_388122#8750, NOM_USAGE_388121#8751, N_IDENTIFICATIO_388126#8752, N_PATIENT_ETABL_388120#8753, N_SECURITE_SOCI_388127#8754, PRENOM_388123#8755, SEXE_388124#8756, str_encrypt(N_PATIENT_ETABL_388120#8753) AS ID_PATIENT_388128#8926, str_encrypt(N_PATIENT_ETABL_388120#8753) AS ID_PATIENT_BIS_388129#8927]