== 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__175730169`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Code+CIM+10#1179373, Libell%C3%A9+long#1179374, Date_effet#1179375, Date_r%C3%A9vocation#1179376, Responsable+MAJ#1179377, Source#1179378, DIAGNOSTIC_PE1__175693HEADER_COL_DETAIL_DEPOT#1179379], false
(4) Project
Arguments: [Code+CIM+10#1179373 AS Code CIM 10#1179387, Libell%C3%A9+long#1179374, Date_effet#1179375, Date_r%C3%A9vocation#1179376, Responsable+MAJ#1179377, Source#1179378, DIAGNOSTIC_PE1__175693HEADER_COL_DETAIL_DEPOT#1179379]
(5) Project
Arguments: [Code CIM 10#1179387, Libell%C3%A9+long#1179374 AS Libellé long#1179396, Date_effet#1179375, Date_r%C3%A9vocation#1179376, Responsable+MAJ#1179377, Source#1179378, DIAGNOSTIC_PE1__175693HEADER_COL_DETAIL_DEPOT#1179379]
(6) Project
Arguments: [Code CIM 10#1179387, Libellé long#1179396, Date_effet#1179375 AS Date_effet#1179404, Date_r%C3%A9vocation#1179376, Responsable+MAJ#1179377, Source#1179378, DIAGNOSTIC_PE1__175693HEADER_COL_DETAIL_DEPOT#1179379]
(7) Project
Arguments: [Code CIM 10#1179387, Libellé long#1179396, Date_effet#1179404, Date_r%C3%A9vocation#1179376 AS Date_révocation#1179412, Responsable+MAJ#1179377, Source#1179378, DIAGNOSTIC_PE1__175693HEADER_COL_DETAIL_DEPOT#1179379]
(8) Project
Arguments: [Code CIM 10#1179387, Libellé long#1179396, Date_effet#1179404, Date_révocation#1179412, Responsable+MAJ#1179377 AS Responsable MAJ#1179420, Source#1179378, DIAGNOSTIC_PE1__175693HEADER_COL_DETAIL_DEPOT#1179379]
(9) Project
Arguments: [Code CIM 10#1179387, Libellé long#1179396, Date_effet#1179404, Date_révocation#1179412, Responsable MAJ#1179420, Source#1179378 AS Source#1179428, DIAGNOSTIC_PE1__175693HEADER_COL_DETAIL_DEPOT#1179379]
(10) Project
Arguments: [Code CIM 10#1179387, Libellé long#1179396, Date_effet#1179404, Date_révocation#1179412, Responsable MAJ#1179420, Source#1179428, DIAGNOSTIC_PE1__175693HEADER_COL_DETAIL_DEPOT#1179379 AS DIAGNOSTIC_PE1__175693HEADER_COL_DETAIL_DEPOT#1179436]
(11) Project
Arguments: [Code CIM 10#1179387 AS Code CIM 10#1179444, Libellé long#1179396 AS Libellé long#1179445, Date_effet#1179404 AS Date_effet#1179446, Date_révocation#1179412 AS Date_révocation#1179447, Responsable MAJ#1179420 AS Responsable MAJ#1179448, Source#1179428 AS Source#1179449, DIAGNOSTIC_PE1__175693HEADER_COL_DETAIL_DEPOT#1179436 AS DIAGNOSTIC_PE1__175693HEADER_COL_DETAIL_DEPOT#1179450]
(12) Project
Arguments: [Code CIM 10#1179444, Libellé long#1179445, Date_effet#1179446, Date_révocation#1179447, Responsable MAJ#1179448, Source#1179449, DIAGNOSTIC_PE1__175693HEADER_COL_DETAIL_DEPOT#1179450]
(13) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#1179444, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_175731#1179475, str_to_datez(Date_effet#1179446, M/d/yy, null, null) AS DATE_EFFET_175733#1179470, str_to_datez(Date_révocation#1179447, M/d/yy, null, null) AS DATE_REVOCATION_175734#1179471, Libellé long#1179445 AS LIBELLE_LONG_175732#1179472, Responsable MAJ#1179448 AS RESPONSABLE_MAJ_175735#1179473, Source#1179449 AS SOURCE_175736#1179474]
(14) Project
Arguments: [CODE_CIM_10_175731#1179475, DATE_EFFET_175733#1179470, DATE_REVOCATION_175734#1179471, LIBELLE_LONG_175732#1179472, RESPONSABLE_MAJ_175735#1179473, SOURCE_175736#1179474, str_remove_space(str_remove_extend(CODE_CIM_10_175731#1179475, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_175737#1179486]