== 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__225562167`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Code+CIM+10#519380, Libell%C3%A9+long#519381, Date_effet#519382, Date_r%C3%A9vocation#519383, Responsable+MAJ#519384, Source#519385, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519386], false
(4) Project
Arguments: [Code+CIM+10#519380 AS Code CIM 10#519394, Libell%C3%A9+long#519381, Date_effet#519382, Date_r%C3%A9vocation#519383, Responsable+MAJ#519384, Source#519385, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519386]
(5) Project
Arguments: [Code CIM 10#519394, Libell%C3%A9+long#519381 AS Libellé long#519403, Date_effet#519382, Date_r%C3%A9vocation#519383, Responsable+MAJ#519384, Source#519385, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519386]
(6) Project
Arguments: [Code CIM 10#519394, Libellé long#519403, Date_effet#519382 AS Date_effet#519411, Date_r%C3%A9vocation#519383, Responsable+MAJ#519384, Source#519385, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519386]
(7) Project
Arguments: [Code CIM 10#519394, Libellé long#519403, Date_effet#519411, Date_r%C3%A9vocation#519383 AS Date_révocation#519419, Responsable+MAJ#519384, Source#519385, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519386]
(8) Project
Arguments: [Code CIM 10#519394, Libellé long#519403, Date_effet#519411, Date_révocation#519419, Responsable+MAJ#519384 AS Responsable MAJ#519427, Source#519385, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519386]
(9) Project
Arguments: [Code CIM 10#519394, Libellé long#519403, Date_effet#519411, Date_révocation#519419, Responsable MAJ#519427, Source#519385 AS Source#519435, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519386]
(10) Project
Arguments: [Code CIM 10#519394, Libellé long#519403, Date_effet#519411, Date_révocation#519419, Responsable MAJ#519427, Source#519435, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519386 AS DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519443]
(11) Project
Arguments: [Code CIM 10#519394 AS Code CIM 10#519451, Libellé long#519403 AS Libellé long#519452, Date_effet#519411 AS Date_effet#519453, Date_révocation#519419 AS Date_révocation#519454, Responsable MAJ#519427 AS Responsable MAJ#519455, Source#519435 AS Source#519456, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519443 AS DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519457]
(12) Project
Arguments: [Code CIM 10#519451, Libellé long#519452, Date_effet#519453, Date_révocation#519454, Responsable MAJ#519455, Source#519456, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519457]
(13) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#519451, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_225563#519478, str_to_datez(Date_effet#519453, M/d/yy, null, null) AS DATE_EFFET_225565#519473, str_to_datez(Date_révocation#519454, M/d/yy, null, null) AS DATE_REVOCATION_225566#519474, Libellé long#519452 AS LIBELLE_LONG_225564#519475, Responsable MAJ#519455 AS RESPONSABLE_MAJ_225567#519476, Source#519456 AS SOURCE_225568#519477]
(14) Project
Arguments: [CODE_CIM_10_225563#519478, DATE_EFFET_225565#519473, DATE_REVOCATION_225566#519474, LIBELLE_LONG_225564#519475, RESPONSABLE_MAJ_225567#519476, SOURCE_225568#519477, str_remove_space(str_remove_extend(CODE_CIM_10_225563#519478, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_225569#519485]