== 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__187951173`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Code+CIM+10#719344, Libell%C3%A9+long#719345, Date_effet#719346, Date_r%C3%A9vocation#719347, Responsable+MAJ#719348, Source#719349, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#719350], false
(4) Project
Arguments: [Code+CIM+10#719344 AS Code CIM 10#719358, Libell%C3%A9+long#719345, Date_effet#719346, Date_r%C3%A9vocation#719347, Responsable+MAJ#719348, Source#719349, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#719350]
(5) Project
Arguments: [Code CIM 10#719358, Libell%C3%A9+long#719345 AS Libellé long#719367, Date_effet#719346, Date_r%C3%A9vocation#719347, Responsable+MAJ#719348, Source#719349, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#719350]
(6) Project
Arguments: [Code CIM 10#719358, Libellé long#719367, Date_effet#719346 AS Date_effet#719375, Date_r%C3%A9vocation#719347, Responsable+MAJ#719348, Source#719349, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#719350]
(7) Project
Arguments: [Code CIM 10#719358, Libellé long#719367, Date_effet#719375, Date_r%C3%A9vocation#719347 AS Date_révocation#719383, Responsable+MAJ#719348, Source#719349, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#719350]
(8) Project
Arguments: [Code CIM 10#719358, Libellé long#719367, Date_effet#719375, Date_révocation#719383, Responsable+MAJ#719348 AS Responsable MAJ#719391, Source#719349, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#719350]
(9) Project
Arguments: [Code CIM 10#719358, Libellé long#719367, Date_effet#719375, Date_révocation#719383, Responsable MAJ#719391, Source#719349 AS Source#719399, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#719350]
(10) Project
Arguments: [Code CIM 10#719358, Libellé long#719367, Date_effet#719375, Date_révocation#719383, Responsable MAJ#719391, Source#719399, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#719350 AS DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#719407]
(11) Project
Arguments: [Code CIM 10#719358 AS Code CIM 10#719415, Libellé long#719367 AS Libellé long#719416, Date_effet#719375 AS Date_effet#719417, Date_révocation#719383 AS Date_révocation#719418, Responsable MAJ#719391 AS Responsable MAJ#719419, Source#719399 AS Source#719420, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#719407 AS DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#719421]
(12) Project
Arguments: [Code CIM 10#719415, Libellé long#719416, Date_effet#719417, Date_révocation#719418, Responsable MAJ#719419, Source#719420, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#719421]
(13) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#719415, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_187952#719442, str_to_datez(Date_effet#719417, M/d/yy, null, null) AS DATE_EFFET_187954#719437, str_to_datez(Date_révocation#719418, M/d/yy, null, null) AS DATE_REVOCATION_187955#719438, Libellé long#719416 AS LIBELLE_LONG_187953#719439, Responsable MAJ#719419 AS RESPONSABLE_MAJ_187956#719440, Source#719420 AS SOURCE_187957#719441]
(14) Project
Arguments: [CODE_CIM_10_187952#719442, DATE_EFFET_187954#719437, DATE_REVOCATION_187955#719438, LIBELLE_LONG_187953#719439, RESPONSABLE_MAJ_187956#719440, SOURCE_187957#719441, str_remove_space(str_remove_extend(CODE_CIM_10_187952#719442, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_187958#719449]