== 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__202897167`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Code+CIM+10#1060167, Libell%C3%A9+long#1060168, Date_effet#1060169, Date_r%C3%A9vocation#1060170, Responsable+MAJ#1060171, Source#1060172, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060173], false
(4) Project
Arguments: [Code+CIM+10#1060167 AS Code CIM 10#1060181, Libell%C3%A9+long#1060168, Date_effet#1060169, Date_r%C3%A9vocation#1060170, Responsable+MAJ#1060171, Source#1060172, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060173]
(5) Project
Arguments: [Code CIM 10#1060181, Libell%C3%A9+long#1060168 AS Libellé long#1060190, Date_effet#1060169, Date_r%C3%A9vocation#1060170, Responsable+MAJ#1060171, Source#1060172, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060173]
(6) Project
Arguments: [Code CIM 10#1060181, Libellé long#1060190, Date_effet#1060169 AS Date_effet#1060198, Date_r%C3%A9vocation#1060170, Responsable+MAJ#1060171, Source#1060172, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060173]
(7) Project
Arguments: [Code CIM 10#1060181, Libellé long#1060190, Date_effet#1060198, Date_r%C3%A9vocation#1060170 AS Date_révocation#1060206, Responsable+MAJ#1060171, Source#1060172, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060173]
(8) Project
Arguments: [Code CIM 10#1060181, Libellé long#1060190, Date_effet#1060198, Date_révocation#1060206, Responsable+MAJ#1060171 AS Responsable MAJ#1060214, Source#1060172, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060173]
(9) Project
Arguments: [Code CIM 10#1060181, Libellé long#1060190, Date_effet#1060198, Date_révocation#1060206, Responsable MAJ#1060214, Source#1060172 AS Source#1060222, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060173]
(10) Project
Arguments: [Code CIM 10#1060181, Libellé long#1060190, Date_effet#1060198, Date_révocation#1060206, Responsable MAJ#1060214, Source#1060222, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060173 AS DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060230]
(11) Project
Arguments: [Code CIM 10#1060181 AS Code CIM 10#1060238, Libellé long#1060190 AS Libellé long#1060239, Date_effet#1060198 AS Date_effet#1060240, Date_révocation#1060206 AS Date_révocation#1060241, Responsable MAJ#1060214 AS Responsable MAJ#1060242, Source#1060222 AS Source#1060243, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060230 AS DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060244]
(12) Project
Arguments: [Code CIM 10#1060238, Libellé long#1060239, Date_effet#1060240, Date_révocation#1060241, Responsable MAJ#1060242, Source#1060243, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060244]
(13) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#1060238, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_202898#1060265, str_to_datez(Date_effet#1060240, M/d/yy, null, null) AS DATE_EFFET_202900#1060260, str_to_datez(Date_révocation#1060241, M/d/yy, null, null) AS DATE_REVOCATION_202901#1060261, Libellé long#1060239 AS LIBELLE_LONG_202899#1060262, Responsable MAJ#1060242 AS RESPONSABLE_MAJ_202902#1060263, Source#1060243 AS SOURCE_202903#1060264]
(14) Project
Arguments: [CODE_CIM_10_202898#1060265, DATE_EFFET_202900#1060260, DATE_REVOCATION_202901#1060261, LIBELLE_LONG_202899#1060262, RESPONSABLE_MAJ_202902#1060263, SOURCE_202903#1060264, str_remove_space(str_remove_extend(CODE_CIM_10_202898#1060265, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_202904#1060272]