== 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#1057896, Libell%C3%A9+long#1057897, Responsable+MAJ#1057898, Source#1057899, Date_effet#1057900, Date_r%C3%A9vocation#1057901, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057902], false
(4) Project
Arguments: [Code+CIM+10#1057896 AS Code CIM 10#1057910, Libell%C3%A9+long#1057897, Responsable+MAJ#1057898, Source#1057899, Date_effet#1057900, Date_r%C3%A9vocation#1057901, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057902]
(5) Project
Arguments: [Code CIM 10#1057910, Libell%C3%A9+long#1057897 AS Libellé long#1057919, Responsable+MAJ#1057898, Source#1057899, Date_effet#1057900, Date_r%C3%A9vocation#1057901, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057902]
(6) Project
Arguments: [Code CIM 10#1057910, Libellé long#1057919, Responsable+MAJ#1057898 AS Responsable MAJ#1057927, Source#1057899, Date_effet#1057900, Date_r%C3%A9vocation#1057901, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057902]
(7) Project
Arguments: [Code CIM 10#1057910, Libellé long#1057919, Responsable MAJ#1057927, Source#1057899 AS Source#1057935, Date_effet#1057900, Date_r%C3%A9vocation#1057901, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057902]
(8) Project
Arguments: [Code CIM 10#1057910, Libellé long#1057919, Responsable MAJ#1057927, Source#1057935, Date_effet#1057900 AS Date_effet#1057943, Date_r%C3%A9vocation#1057901, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057902]
(9) Project
Arguments: [Code CIM 10#1057910, Libellé long#1057919, Responsable MAJ#1057927, Source#1057935, Date_effet#1057943, Date_r%C3%A9vocation#1057901 AS Date_révocation#1057951, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057902]
(10) Project
Arguments: [Code CIM 10#1057910, Libellé long#1057919, Responsable MAJ#1057927, Source#1057935, Date_effet#1057943, Date_révocation#1057951, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057902 AS DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057959]
(11) Project
Arguments: [Code CIM 10#1057910 AS Code CIM 10#1057967, Libellé long#1057919 AS Libellé long#1057968, Responsable MAJ#1057927 AS Responsable MAJ#1057969, Source#1057935 AS Source#1057970, Date_effet#1057943 AS Date_effet#1057971, Date_révocation#1057951 AS Date_révocation#1057972, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057959 AS DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057973]
(12) Project
Arguments: [Code CIM 10#1057967, Libellé long#1057968, Responsable MAJ#1057969, Source#1057970, Date_effet#1057971, Date_révocation#1057972, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057973]
(13) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#1057967, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_202981#1057994, Date_effet#1057971 AS DATE_EFFET_202983#1057989, Date_révocation#1057972 AS DATE_REVOCATION_202984#1057990, Libellé long#1057968 AS LIBELLE_LONG_202982#1057991, Responsable MAJ#1057969 AS RESPONSABLE_MAJ_202985#1057992, Source#1057970 AS SOURCE_202986#1057993]
(14) Project
Arguments: [CODE_CIM_10_202981#1057994, DATE_EFFET_202983#1057989, DATE_REVOCATION_202984#1057990, LIBELLE_LONG_202982#1057991, RESPONSABLE_MAJ_202985#1057992, SOURCE_202986#1057993, str_remove_space(str_remove_extend(CODE_CIM_10_202981#1057994, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_202987#1058001]