== 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_PE2__330195171`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Code+CIM+10#363489, Libell%C3%A9+long#363490, Responsable+MAJ#363491, Source#363492, Date_effet#363493, Date_r%C3%A9vocation#363494, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363495], false
(4) Project
Arguments: [Code+CIM+10#363489 AS Code CIM 10#363503, Libell%C3%A9+long#363490, Responsable+MAJ#363491, Source#363492, Date_effet#363493, Date_r%C3%A9vocation#363494, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363495]
(5) Project
Arguments: [Code CIM 10#363503, Libell%C3%A9+long#363490 AS Libellé long#363512, Responsable+MAJ#363491, Source#363492, Date_effet#363493, Date_r%C3%A9vocation#363494, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363495]
(6) Project
Arguments: [Code CIM 10#363503, Libellé long#363512, Responsable+MAJ#363491 AS Responsable MAJ#363520, Source#363492, Date_effet#363493, Date_r%C3%A9vocation#363494, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363495]
(7) Project
Arguments: [Code CIM 10#363503, Libellé long#363512, Responsable MAJ#363520, Source#363492 AS Source#363528, Date_effet#363493, Date_r%C3%A9vocation#363494, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363495]
(8) Project
Arguments: [Code CIM 10#363503, Libellé long#363512, Responsable MAJ#363520, Source#363528, Date_effet#363493 AS Date_effet#363536, Date_r%C3%A9vocation#363494, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363495]
(9) Project
Arguments: [Code CIM 10#363503, Libellé long#363512, Responsable MAJ#363520, Source#363528, Date_effet#363536, Date_r%C3%A9vocation#363494 AS Date_révocation#363544, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363495]
(10) Project
Arguments: [Code CIM 10#363503, Libellé long#363512, Responsable MAJ#363520, Source#363528, Date_effet#363536, Date_révocation#363544, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363495 AS DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363552]
(11) Project
Arguments: [Code CIM 10#363503 AS Code CIM 10#363560, Libellé long#363512 AS Libellé long#363561, Responsable MAJ#363520 AS Responsable MAJ#363562, Source#363528 AS Source#363563, Date_effet#363536 AS Date_effet#363564, Date_révocation#363544 AS Date_révocation#363565, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363552 AS DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363566]
(12) Project
Arguments: [Code CIM 10#363560, Libellé long#363561, Responsable MAJ#363562, Source#363563, Date_effet#363564, Date_révocation#363565, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363566]
(13) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#363560, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_330196#363587, Date_effet#363564 AS DATE_EFFET_330198#363582, Date_révocation#363565 AS DATE_REVOCATION_330199#363583, Libellé long#363561 AS LIBELLE_LONG_330197#363584, Responsable MAJ#363562 AS RESPONSABLE_MAJ_330200#363585, Source#363563 AS SOURCE_330201#363586]
(14) Project
Arguments: [CODE_CIM_10_330196#363587, DATE_EFFET_330198#363582, DATE_REVOCATION_330199#363583, LIBELLE_LONG_330197#363584, RESPONSABLE_MAJ_330200#363585, SOURCE_330201#363586, str_remove_space(str_remove_extend(CODE_CIM_10_330196#363587, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_330202#363594]