== 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_388119179`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [N_Patient_Etablissement#27696, Nom_Usage#27697, Nom_Naissance#27698, Prenom#27699, Sexe#27700, Date_Naissance#27701, N_Identification_National#27702, N_Securite_Social#27703], false
(4) Project
Arguments: [N_Patient_Etablissement#27696 AS N_Patient_Etablissement#27720, Nom_Usage#27697 AS Nom_Usage#27721, Nom_Naissance#27698 AS Nom_Naissance#27722, Prenom#27699 AS Prenom#27723, Sexe#27700 AS Sexe#27724, Date_Naissance#27701 AS Date_Naissance#27725, N_Identification_National#27702 AS N_Identification_National#27726, N_Securite_Social#27703 AS N_Securite_Social#27727]
(5) Project
Arguments: [N_Patient_Etablissement#27720, Nom_Usage#27721, Nom_Naissance#27722, Prenom#27723, Sexe#27724, Date_Naissance#27725, N_Identification_National#27726, N_Securite_Social#27727]
(6) Project
Arguments: [Date_Naissance#27725 AS DATE_NAISSANCE_388125#27745, Nom_Naissance#27722 AS NOM_NAISSANCE_388122#27746, Nom_Usage#27721 AS NOM_USAGE_388121#27747, N_Identification_National#27726 AS N_IDENTIFICATIO_388126#27748, N_Patient_Etablissement#27720 AS N_PATIENT_ETABL_388120#27749, N_Securite_Social#27727 AS N_SECURITE_SOCI_388127#27750, Prenom#27723 AS PRENOM_388123#27751, Sexe#27724 AS SEXE_388124#27752]
(7) LogicalRelation
Arguments: parquet, [IPP#27761, Nom_Usage#27762, Nom_Naissance#27763, Prenom#27764, Sexe-Pat#27765, Date_Naissance#27766, N_Identification_National#27767, N_Secu#27768, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#27769], false
(8) Project
Arguments: [IPP#27761 AS IPP#27779, Nom_Usage#27762, Nom_Naissance#27763, Prenom#27764, Sexe-Pat#27765, Date_Naissance#27766, N_Identification_National#27767, N_Secu#27768, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#27769]
(9) Project
Arguments: [IPP#27779, Nom_Usage#27762 AS Nom_Usage#27790, Nom_Naissance#27763, Prenom#27764, Sexe-Pat#27765, Date_Naissance#27766, N_Identification_National#27767, N_Secu#27768, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#27769]
(10) Project
Arguments: [IPP#27779, Nom_Usage#27790, Nom_Naissance#27763 AS Nom_Naissance#27800, Prenom#27764, Sexe-Pat#27765, Date_Naissance#27766, N_Identification_National#27767, N_Secu#27768, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#27769]
(11) Project
Arguments: [IPP#27779, Nom_Usage#27790, Nom_Naissance#27800, Prenom#27764 AS Prenom#27810, Sexe-Pat#27765, Date_Naissance#27766, N_Identification_National#27767, N_Secu#27768, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#27769]
(12) Project
Arguments: [IPP#27779, Nom_Usage#27790, Nom_Naissance#27800, Prenom#27810, Sexe-Pat#27765 AS Sexe-Pat#27820, Date_Naissance#27766, N_Identification_National#27767, N_Secu#27768, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#27769]
(13) Project
Arguments: [IPP#27779, Nom_Usage#27790, Nom_Naissance#27800, Prenom#27810, Sexe-Pat#27820, Date_Naissance#27766 AS Date_Naissance#27830, N_Identification_National#27767, N_Secu#27768, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#27769]
(14) Project
Arguments: [IPP#27779, Nom_Usage#27790, Nom_Naissance#27800, Prenom#27810, Sexe-Pat#27820, Date_Naissance#27830, N_Identification_National#27767 AS N_Identification_National#27840, N_Secu#27768, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#27769]
(15) Project
Arguments: [IPP#27779, Nom_Usage#27790, Nom_Naissance#27800, Prenom#27810, Sexe-Pat#27820, Date_Naissance#27830, N_Identification_National#27840, N_Secu#27768 AS N_Secu#27850, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#27769]
(16) Project
Arguments: [IPP#27779, Nom_Usage#27790, Nom_Naissance#27800, Prenom#27810, Sexe-Pat#27820, Date_Naissance#27830, N_Identification_National#27840, N_Secu#27850, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#27769 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#27860]
(17) Project
Arguments: [IPP#27779 AS IPP#27870, Nom_Usage#27790 AS Nom_Usage#27871, Nom_Naissance#27800 AS Nom_Naissance#27872, Prenom#27810 AS Prenom#27873, Sexe-Pat#27820 AS Sexe-Pat#27874, Date_Naissance#27830 AS Date_Naissance#27875, N_Identification_National#27840 AS N_Identification_National#27876, N_Secu#27850 AS N_Secu#27877, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#27860 AS LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#27878]
(18) Project
Arguments: [IPP#27870, Nom_Usage#27871, Nom_Naissance#27872, Prenom#27873, Sexe-Pat#27874, Date_Naissance#27875, N_Identification_National#27876, N_Secu#27877, LES_PATIENTS_XL_388059HEADER_COL_DETAIL_DEPOT#27878]
(19) Project
Arguments: [Date_Naissance#27875 AS DATE_NAISSANCE_388125#27897, Nom_Naissance#27872 AS NOM_NAISSANCE_388122#27898, Nom_Usage#27871 AS NOM_USAGE_388121#27899, N_Identification_National#27876 AS N_IDENTIFICATIO_388126#27900, IPP#27870 AS N_PATIENT_ETABL_388120#27901, N_Secu#27877 AS N_SECURITE_SOCI_388127#27902, Prenom#27873 AS PRENOM_388123#27903, cast(str_replace_extend(Sexe-Pat#27874, array(cast(1 as string), cast(2 as string)), array(cast(M as string), cast(F as string))) as string) AS SEXE_388124#27905]
(20) Union
Arguments: false, false
(21) Project
Arguments: [DATE_NAISSANCE_388125#27745, NOM_NAISSANCE_388122#27746, NOM_USAGE_388121#27747, N_IDENTIFICATIO_388126#27748, N_PATIENT_ETABL_388120#27749, N_SECURITE_SOCI_388127#27750, PRENOM_388123#27751, SEXE_388124#27752, str_encrypt(N_PATIENT_ETABL_388120#27749) AS ID_PATIENT_388128#27922, str_encrypt(N_PATIENT_ETABL_388120#27749) AS ID_PATIENT_BIS_388129#27923]