== 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__187951169`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Code+CIM+10#716422, Libell%C3%A9+long#716423, Date_effet#716424, Date_r%C3%A9vocation#716425, Responsable+MAJ#716426, Source#716427, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716428], false
(4) Project
Arguments: [Code+CIM+10#716422 AS Code CIM 10#716436, Libell%C3%A9+long#716423, Date_effet#716424, Date_r%C3%A9vocation#716425, Responsable+MAJ#716426, Source#716427, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716428]
(5) Project
Arguments: [Code CIM 10#716436, Libell%C3%A9+long#716423 AS Libellé long#716445, Date_effet#716424, Date_r%C3%A9vocation#716425, Responsable+MAJ#716426, Source#716427, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716428]
(6) Project
Arguments: [Code CIM 10#716436, Libellé long#716445, Date_effet#716424 AS Date_effet#716453, Date_r%C3%A9vocation#716425, Responsable+MAJ#716426, Source#716427, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716428]
(7) Project
Arguments: [Code CIM 10#716436, Libellé long#716445, Date_effet#716453, Date_r%C3%A9vocation#716425 AS Date_révocation#716461, Responsable+MAJ#716426, Source#716427, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716428]
(8) Project
Arguments: [Code CIM 10#716436, Libellé long#716445, Date_effet#716453, Date_révocation#716461, Responsable+MAJ#716426 AS Responsable MAJ#716469, Source#716427, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716428]
(9) Project
Arguments: [Code CIM 10#716436, Libellé long#716445, Date_effet#716453, Date_révocation#716461, Responsable MAJ#716469, Source#716427 AS Source#716477, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716428]
(10) Project
Arguments: [Code CIM 10#716436, Libellé long#716445, Date_effet#716453, Date_révocation#716461, Responsable MAJ#716469, Source#716477, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716428 AS DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716485]
(11) Project
Arguments: [Code CIM 10#716436 AS Code CIM 10#716493, Libellé long#716445 AS Libellé long#716494, Date_effet#716453 AS Date_effet#716495, Date_révocation#716461 AS Date_révocation#716496, Responsable MAJ#716469 AS Responsable MAJ#716497, Source#716477 AS Source#716498, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716485 AS DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716499]
(12) Project
Arguments: [Code CIM 10#716493, Libellé long#716494, Date_effet#716495, Date_révocation#716496, Responsable MAJ#716497, Source#716498, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716499]
(13) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#716493, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_187952#716520, str_to_datez(Date_effet#716495, M/d/yy, null, null) AS DATE_EFFET_187954#716515, str_to_datez(Date_révocation#716496, M/d/yy, null, null) AS DATE_REVOCATION_187955#716516, Libellé long#716494 AS LIBELLE_LONG_187953#716517, Responsable MAJ#716497 AS RESPONSABLE_MAJ_187956#716518, Source#716498 AS SOURCE_187957#716519]
(14) Project
Arguments: [CODE_CIM_10_187952#716520, DATE_EFFET_187954#716515, DATE_REVOCATION_187955#716516, LIBELLE_LONG_187953#716517, RESPONSABLE_MAJ_187956#716518, SOURCE_187957#716519, str_remove_space(str_remove_extend(CODE_CIM_10_187952#716520, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_187958#716527]