== 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__161541176`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Code+CIM+10#2483902, Libell%C3%A9+long#2483903, Responsable+MAJ#2483904, Source#2483905, Date_effet#2483906, Date_r%C3%A9vocation#2483907, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483908], false
(4) Project
Arguments: [Code+CIM+10#2483902 AS Code CIM 10#2483916, Libell%C3%A9+long#2483903, Responsable+MAJ#2483904, Source#2483905, Date_effet#2483906, Date_r%C3%A9vocation#2483907, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483908]
(5) Project
Arguments: [Code CIM 10#2483916, Libell%C3%A9+long#2483903 AS Libellé long#2483925, Responsable+MAJ#2483904, Source#2483905, Date_effet#2483906, Date_r%C3%A9vocation#2483907, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483908]
(6) Project
Arguments: [Code CIM 10#2483916, Libellé long#2483925, Responsable+MAJ#2483904 AS Responsable MAJ#2483933, Source#2483905, Date_effet#2483906, Date_r%C3%A9vocation#2483907, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483908]
(7) Project
Arguments: [Code CIM 10#2483916, Libellé long#2483925, Responsable MAJ#2483933, Source#2483905 AS Source#2483941, Date_effet#2483906, Date_r%C3%A9vocation#2483907, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483908]
(8) Project
Arguments: [Code CIM 10#2483916, Libellé long#2483925, Responsable MAJ#2483933, Source#2483941, Date_effet#2483906 AS Date_effet#2483949, Date_r%C3%A9vocation#2483907, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483908]
(9) Project
Arguments: [Code CIM 10#2483916, Libellé long#2483925, Responsable MAJ#2483933, Source#2483941, Date_effet#2483949, Date_r%C3%A9vocation#2483907 AS Date_révocation#2483957, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483908]
(10) Project
Arguments: [Code CIM 10#2483916, Libellé long#2483925, Responsable MAJ#2483933, Source#2483941, Date_effet#2483949, Date_révocation#2483957, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483908 AS DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483965]
(11) Project
Arguments: [Code CIM 10#2483916 AS Code CIM 10#2483973, Libellé long#2483925 AS Libellé long#2483974, Responsable MAJ#2483933 AS Responsable MAJ#2483975, Source#2483941 AS Source#2483976, Date_effet#2483949 AS Date_effet#2483977, Date_révocation#2483957 AS Date_révocation#2483978, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483965 AS DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483979]
(12) Project
Arguments: [Code CIM 10#2483973, Libellé long#2483974, Responsable MAJ#2483975, Source#2483976, Date_effet#2483977, Date_révocation#2483978, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483979]
(13) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#2483973, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_161542#2484000, Date_effet#2483977 AS DATE_EFFET_161544#2483995, Date_révocation#2483978 AS DATE_REVOCATION_161545#2483996, Libellé long#2483974 AS LIBELLE_LONG_161543#2483997, Responsable MAJ#2483975 AS RESPONSABLE_MAJ_161546#2483998, Source#2483976 AS SOURCE_161547#2483999]
(14) Project
Arguments: [CODE_CIM_10_161542#2484000, DATE_EFFET_161544#2483995, DATE_REVOCATION_161545#2483996, LIBELLE_LONG_161543#2483997, RESPONSABLE_MAJ_161546#2483998, SOURCE_161547#2483999, str_remove_space(str_remove_extend(CODE_CIM_10_161542#2484000, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_161548#2484007]