== 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__330092171`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Code+CIM+10#363376, Libell%C3%A9+long#363377, Date_effet#363378, Date_r%C3%A9vocation#363379, Responsable+MAJ#363380, Source#363381, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363382], false
(4) Project
Arguments: [Code+CIM+10#363376 AS Code CIM 10#363390, Libell%C3%A9+long#363377, Date_effet#363378, Date_r%C3%A9vocation#363379, Responsable+MAJ#363380, Source#363381, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363382]
(5) Project
Arguments: [Code CIM 10#363390, Libell%C3%A9+long#363377 AS Libellé long#363399, Date_effet#363378, Date_r%C3%A9vocation#363379, Responsable+MAJ#363380, Source#363381, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363382]
(6) Project
Arguments: [Code CIM 10#363390, Libellé long#363399, Date_effet#363378 AS Date_effet#363407, Date_r%C3%A9vocation#363379, Responsable+MAJ#363380, Source#363381, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363382]
(7) Project
Arguments: [Code CIM 10#363390, Libellé long#363399, Date_effet#363407, Date_r%C3%A9vocation#363379 AS Date_révocation#363415, Responsable+MAJ#363380, Source#363381, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363382]
(8) Project
Arguments: [Code CIM 10#363390, Libellé long#363399, Date_effet#363407, Date_révocation#363415, Responsable+MAJ#363380 AS Responsable MAJ#363423, Source#363381, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363382]
(9) Project
Arguments: [Code CIM 10#363390, Libellé long#363399, Date_effet#363407, Date_révocation#363415, Responsable MAJ#363423, Source#363381 AS Source#363431, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363382]
(10) Project
Arguments: [Code CIM 10#363390, Libellé long#363399, Date_effet#363407, Date_révocation#363415, Responsable MAJ#363423, Source#363431, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363382 AS DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363439]
(11) Project
Arguments: [Code CIM 10#363390 AS Code CIM 10#363447, Libellé long#363399 AS Libellé long#363448, Date_effet#363407 AS Date_effet#363449, Date_révocation#363415 AS Date_révocation#363450, Responsable MAJ#363423 AS Responsable MAJ#363451, Source#363431 AS Source#363452, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363439 AS DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363453]
(12) Project
Arguments: [Code CIM 10#363447, Libellé long#363448, Date_effet#363449, Date_révocation#363450, Responsable MAJ#363451, Source#363452, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363453]
(13) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#363447, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_330093#363474, str_to_datez(Date_effet#363449, M/d/yy, null, null) AS DATE_EFFET_330095#363469, str_to_datez(Date_révocation#363450, M/d/yy, null, null) AS DATE_REVOCATION_330096#363470, Libellé long#363448 AS LIBELLE_LONG_330094#363471, Responsable MAJ#363451 AS RESPONSABLE_MAJ_330097#363472, Source#363452 AS SOURCE_330098#363473]
(14) Project
Arguments: [CODE_CIM_10_330093#363474, DATE_EFFET_330095#363469, DATE_REVOCATION_330096#363470, LIBELLE_LONG_330094#363471, RESPONSABLE_MAJ_330097#363472, SOURCE_330098#363473, str_remove_space(str_remove_extend(CODE_CIM_10_330093#363474, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_330099#363481]