== 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__152022173`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Code+CIM+10#2305343, Libell%C3%A9+long#2305344, Date_effet#2305345, Date_r%C3%A9vocation#2305346, Responsable+MAJ#2305347, Source#2305348, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305349], false
(4) Project
Arguments: [Code+CIM+10#2305343 AS Code CIM 10#2305357, Libell%C3%A9+long#2305344, Date_effet#2305345, Date_r%C3%A9vocation#2305346, Responsable+MAJ#2305347, Source#2305348, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305349]
(5) Project
Arguments: [Code CIM 10#2305357, Libell%C3%A9+long#2305344 AS Libellé long#2305366, Date_effet#2305345, Date_r%C3%A9vocation#2305346, Responsable+MAJ#2305347, Source#2305348, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305349]
(6) Project
Arguments: [Code CIM 10#2305357, Libellé long#2305366, Date_effet#2305345 AS Date_effet#2305374, Date_r%C3%A9vocation#2305346, Responsable+MAJ#2305347, Source#2305348, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305349]
(7) Project
Arguments: [Code CIM 10#2305357, Libellé long#2305366, Date_effet#2305374, Date_r%C3%A9vocation#2305346 AS Date_révocation#2305382, Responsable+MAJ#2305347, Source#2305348, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305349]
(8) Project
Arguments: [Code CIM 10#2305357, Libellé long#2305366, Date_effet#2305374, Date_révocation#2305382, Responsable+MAJ#2305347 AS Responsable MAJ#2305390, Source#2305348, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305349]
(9) Project
Arguments: [Code CIM 10#2305357, Libellé long#2305366, Date_effet#2305374, Date_révocation#2305382, Responsable MAJ#2305390, Source#2305348 AS Source#2305398, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305349]
(10) Project
Arguments: [Code CIM 10#2305357, Libellé long#2305366, Date_effet#2305374, Date_révocation#2305382, Responsable MAJ#2305390, Source#2305398, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305349 AS DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305406]
(11) Project
Arguments: [Code CIM 10#2305357 AS Code CIM 10#2305414, Libellé long#2305366 AS Libellé long#2305415, Date_effet#2305374 AS Date_effet#2305416, Date_révocation#2305382 AS Date_révocation#2305417, Responsable MAJ#2305390 AS Responsable MAJ#2305418, Source#2305398 AS Source#2305419, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305406 AS DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305420]
(12) Project
Arguments: [Code CIM 10#2305414, Libellé long#2305415, Date_effet#2305416, Date_révocation#2305417, Responsable MAJ#2305418, Source#2305419, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305420]
(13) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#2305414, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_152023#2305441, str_to_datez(Date_effet#2305416, M/d/yy, null, null) AS DATE_EFFET_152025#2305436, str_to_datez(Date_révocation#2305417, M/d/yy, null, null) AS DATE_REVOCATION_152026#2305437, Libellé long#2305415 AS LIBELLE_LONG_152024#2305438, Responsable MAJ#2305418 AS RESPONSABLE_MAJ_152027#2305439, Source#2305419 AS SOURCE_152028#2305440]
(14) Project
Arguments: [CODE_CIM_10_152023#2305441, DATE_EFFET_152025#2305436, DATE_REVOCATION_152026#2305437, LIBELLE_LONG_152024#2305438, RESPONSABLE_MAJ_152027#2305439, SOURCE_152028#2305440, str_remove_space(str_remove_extend(CODE_CIM_10_152023#2305441, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_152029#2305448]