== 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__152022171`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Code+CIM+10#2307738, Libell%C3%A9+long#2307739, Date_effet#2307740, Date_r%C3%A9vocation#2307741, Responsable+MAJ#2307742, Source#2307743, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307744], false
(4) Project
Arguments: [Code+CIM+10#2307738 AS Code CIM 10#2307752, Libell%C3%A9+long#2307739, Date_effet#2307740, Date_r%C3%A9vocation#2307741, Responsable+MAJ#2307742, Source#2307743, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307744]
(5) Project
Arguments: [Code CIM 10#2307752, Libell%C3%A9+long#2307739 AS Libellé long#2307761, Date_effet#2307740, Date_r%C3%A9vocation#2307741, Responsable+MAJ#2307742, Source#2307743, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307744]
(6) Project
Arguments: [Code CIM 10#2307752, Libellé long#2307761, Date_effet#2307740 AS Date_effet#2307769, Date_r%C3%A9vocation#2307741, Responsable+MAJ#2307742, Source#2307743, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307744]
(7) Project
Arguments: [Code CIM 10#2307752, Libellé long#2307761, Date_effet#2307769, Date_r%C3%A9vocation#2307741 AS Date_révocation#2307777, Responsable+MAJ#2307742, Source#2307743, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307744]
(8) Project
Arguments: [Code CIM 10#2307752, Libellé long#2307761, Date_effet#2307769, Date_révocation#2307777, Responsable+MAJ#2307742 AS Responsable MAJ#2307785, Source#2307743, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307744]
(9) Project
Arguments: [Code CIM 10#2307752, Libellé long#2307761, Date_effet#2307769, Date_révocation#2307777, Responsable MAJ#2307785, Source#2307743 AS Source#2307793, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307744]
(10) Project
Arguments: [Code CIM 10#2307752, Libellé long#2307761, Date_effet#2307769, Date_révocation#2307777, Responsable MAJ#2307785, Source#2307793, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307744 AS DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307801]
(11) Project
Arguments: [Code CIM 10#2307752 AS Code CIM 10#2307809, Libellé long#2307761 AS Libellé long#2307810, Date_effet#2307769 AS Date_effet#2307811, Date_révocation#2307777 AS Date_révocation#2307812, Responsable MAJ#2307785 AS Responsable MAJ#2307813, Source#2307793 AS Source#2307814, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307801 AS DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307815]
(12) Project
Arguments: [Code CIM 10#2307809, Libellé long#2307810, Date_effet#2307811, Date_révocation#2307812, Responsable MAJ#2307813, Source#2307814, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307815]
(13) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#2307809, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_152023#2307836, str_to_datez(Date_effet#2307811, M/d/yy, null, null) AS DATE_EFFET_152025#2307831, str_to_datez(Date_révocation#2307812, M/d/yy, null, null) AS DATE_REVOCATION_152026#2307832, Libellé long#2307810 AS LIBELLE_LONG_152024#2307833, Responsable MAJ#2307813 AS RESPONSABLE_MAJ_152027#2307834, Source#2307814 AS SOURCE_152028#2307835]
(14) Project
Arguments: [CODE_CIM_10_152023#2307836, DATE_EFFET_152025#2307831, DATE_REVOCATION_152026#2307832, LIBELLE_LONG_152024#2307833, RESPONSABLE_MAJ_152027#2307834, SOURCE_152028#2307835, str_remove_space(str_remove_extend(CODE_CIM_10_152023#2307836, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_152029#2307843]