== 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__202980168`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Code+CIM+10#1055512, Libell%C3%A9+long#1055513, Responsable+MAJ#1055514, Source#1055515, Date_effet#1055516, Date_r%C3%A9vocation#1055517, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055518], false
(4) Project
Arguments: [Code+CIM+10#1055512 AS Code CIM 10#1055526, Libell%C3%A9+long#1055513, Responsable+MAJ#1055514, Source#1055515, Date_effet#1055516, Date_r%C3%A9vocation#1055517, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055518]
(5) Project
Arguments: [Code CIM 10#1055526, Libell%C3%A9+long#1055513 AS Libellé long#1055535, Responsable+MAJ#1055514, Source#1055515, Date_effet#1055516, Date_r%C3%A9vocation#1055517, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055518]
(6) Project
Arguments: [Code CIM 10#1055526, Libellé long#1055535, Responsable+MAJ#1055514 AS Responsable MAJ#1055543, Source#1055515, Date_effet#1055516, Date_r%C3%A9vocation#1055517, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055518]
(7) Project
Arguments: [Code CIM 10#1055526, Libellé long#1055535, Responsable MAJ#1055543, Source#1055515 AS Source#1055551, Date_effet#1055516, Date_r%C3%A9vocation#1055517, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055518]
(8) Project
Arguments: [Code CIM 10#1055526, Libellé long#1055535, Responsable MAJ#1055543, Source#1055551, Date_effet#1055516 AS Date_effet#1055559, Date_r%C3%A9vocation#1055517, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055518]
(9) Project
Arguments: [Code CIM 10#1055526, Libellé long#1055535, Responsable MAJ#1055543, Source#1055551, Date_effet#1055559, Date_r%C3%A9vocation#1055517 AS Date_révocation#1055567, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055518]
(10) Project
Arguments: [Code CIM 10#1055526, Libellé long#1055535, Responsable MAJ#1055543, Source#1055551, Date_effet#1055559, Date_révocation#1055567, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055518 AS DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055575]
(11) Project
Arguments: [Code CIM 10#1055526 AS Code CIM 10#1055583, Libellé long#1055535 AS Libellé long#1055584, Responsable MAJ#1055543 AS Responsable MAJ#1055585, Source#1055551 AS Source#1055586, Date_effet#1055559 AS Date_effet#1055587, Date_révocation#1055567 AS Date_révocation#1055588, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055575 AS DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055589]
(12) Project
Arguments: [Code CIM 10#1055583, Libellé long#1055584, Responsable MAJ#1055585, Source#1055586, Date_effet#1055587, Date_révocation#1055588, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055589]
(13) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#1055583, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_202981#1055610, Date_effet#1055587 AS DATE_EFFET_202983#1055605, Date_révocation#1055588 AS DATE_REVOCATION_202984#1055606, Libellé long#1055584 AS LIBELLE_LONG_202982#1055607, Responsable MAJ#1055585 AS RESPONSABLE_MAJ_202985#1055608, Source#1055586 AS SOURCE_202986#1055609]
(14) Project
Arguments: [CODE_CIM_10_202981#1055610, DATE_EFFET_202983#1055605, DATE_REVOCATION_202984#1055606, LIBELLE_LONG_202982#1055607, RESPONSABLE_MAJ_202985#1055608, SOURCE_202986#1055609, str_remove_space(str_remove_extend(CODE_CIM_10_202981#1055610, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_202987#1055617]