== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (14)
+- Project (13)
+- Project (12)
+- Project (11)
+- Project (10)
+- Project (9)
+- Project (8)
+- Project (7)
+- Project (6)
+- Project (5)
+- Project (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `DIAGNOSTIC_PE1__172150169`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Code+CIM+10#1151893, Libell%C3%A9+long#1151894, Date_effet#1151895, Date_r%C3%A9vocation#1151896, Responsable+MAJ#1151897, Source#1151898, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151899], false
(4) Project
Arguments: [Code+CIM+10#1151893 AS Code CIM 10#1151940, Libell%C3%A9+long#1151894, Date_effet#1151895, Date_r%C3%A9vocation#1151896, Responsable+MAJ#1151897, Source#1151898, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151899]
(5) Project
Arguments: [Code CIM 10#1151940, Libell%C3%A9+long#1151894 AS Libellé long#1151949, Date_effet#1151895, Date_r%C3%A9vocation#1151896, Responsable+MAJ#1151897, Source#1151898, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151899]
(6) Project
Arguments: [Code CIM 10#1151940, Libellé long#1151949, Date_effet#1151895 AS Date_effet#1151957, Date_r%C3%A9vocation#1151896, Responsable+MAJ#1151897, Source#1151898, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151899]
(7) Project
Arguments: [Code CIM 10#1151940, Libellé long#1151949, Date_effet#1151957, Date_r%C3%A9vocation#1151896 AS Date_révocation#1151965, Responsable+MAJ#1151897, Source#1151898, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151899]
(8) Project
Arguments: [Code CIM 10#1151940, Libellé long#1151949, Date_effet#1151957, Date_révocation#1151965, Responsable+MAJ#1151897 AS Responsable MAJ#1151973, Source#1151898, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151899]
(9) Project
Arguments: [Code CIM 10#1151940, Libellé long#1151949, Date_effet#1151957, Date_révocation#1151965, Responsable MAJ#1151973, Source#1151898 AS Source#1151981, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151899]
(10) Project
Arguments: [Code CIM 10#1151940, Libellé long#1151949, Date_effet#1151957, Date_révocation#1151965, Responsable MAJ#1151973, Source#1151981, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151899 AS DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151989]
(11) Project
Arguments: [Code CIM 10#1151940 AS Code CIM 10#1151997, Libellé long#1151949 AS Libellé long#1151998, Date_effet#1151957 AS Date_effet#1151999, Date_révocation#1151965 AS Date_révocation#1152000, Responsable MAJ#1151973 AS Responsable MAJ#1152001, Source#1151981 AS Source#1152002, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151989 AS DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1152003]
(12) Project
Arguments: [Code CIM 10#1151997, Libellé long#1151998, Date_effet#1151999, Date_révocation#1152000, Responsable MAJ#1152001, Source#1152002, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1152003]
(13) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#1151997, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_172151#1152058, str_to_datez(Date_effet#1151999, M/d/yy, null, null) AS DATE_EFFET_172153#1152053, str_to_datez(Date_révocation#1152000, M/d/yy, null, null) AS DATE_REVOCATION_172154#1152054, Libellé long#1151998 AS LIBELLE_LONG_172152#1152055, Responsable MAJ#1152001 AS RESPONSABLE_MAJ_172155#1152056, Source#1152002 AS SOURCE_172156#1152057]
(14) Project
Arguments: [CODE_CIM_10_172151#1152058, DATE_EFFET_172153#1152053, DATE_REVOCATION_172154#1152054, LIBELLE_LONG_172152#1152055, RESPONSABLE_MAJ_172155#1152056, SOURCE_172156#1152057, str_remove_space(str_remove_extend(CODE_CIM_10_172151#1152058, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_172157#1152065]