== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (16)
+- Project (15)
+- SubqueryAlias (14)
+- View (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: `14_E_SPECIALITE_188248170`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Sp%C3%A9cialit%C3%A9+etab#723079, Code+Etab#723080, Codes+officiels#723081, UF+exclue#723082, 07_SPECIALITE_S_187910HEADER_COL_DETAIL_DEPOT#723083], false
(4) Project
Arguments: [Sp%C3%A9cialit%C3%A9+etab#723079 AS Spécialité etab#723098, Code+Etab#723080, Codes+officiels#723081, UF+exclue#723082, 07_SPECIALITE_S_187910HEADER_COL_DETAIL_DEPOT#723083]
(5) Project
Arguments: [Spécialité etab#723098, Code+Etab#723080 AS Code Etab#723105, Codes+officiels#723081, UF+exclue#723082, 07_SPECIALITE_S_187910HEADER_COL_DETAIL_DEPOT#723083]
(6) Project
Arguments: [Spécialité etab#723098, Code Etab#723105, Codes+officiels#723081 AS Codes officiels#723112, UF+exclue#723082, 07_SPECIALITE_S_187910HEADER_COL_DETAIL_DEPOT#723083]
(7) Project
Arguments: [Spécialité etab#723098, Code Etab#723105, Codes officiels#723112, UF+exclue#723082 AS UF exclue#723119, 07_SPECIALITE_S_187910HEADER_COL_DETAIL_DEPOT#723083]
(8) Project
Arguments: [Spécialité etab#723098, Code Etab#723105, Codes officiels#723112, UF exclue#723119, 07_SPECIALITE_S_187910HEADER_COL_DETAIL_DEPOT#723083 AS 07_SPECIALITE_S_187910HEADER_COL_DETAIL_DEPOT#723130]
(9) Project
Arguments: [Spécialité etab#723098 AS Spécialité etab#723138, Code Etab#723105 AS Code Etab#723139, Codes officiels#723112 AS Codes officiels#723140, UF exclue#723119 AS UF exclue#723141, 07_SPECIALITE_S_187910HEADER_COL_DETAIL_DEPOT#723130 AS 07_SPECIALITE_S_187910HEADER_COL_DETAIL_DEPOT#723142]
(10) Project
Arguments: [Spécialité etab#723138, Code Etab#723139, Codes officiels#723140, UF exclue#723141, 07_SPECIALITE_S_187910HEADER_COL_DETAIL_DEPOT#723142]
(11) Project
Arguments: [Codes officiels#723140 AS CODES_OFFICIELS_188023#723167, Code Etab#723139 AS CODE_ETAB_188022#723168, cast(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité etab#723138, cast(ONLY_ONE as string)), array(cast( as string)), array(cast(- as string)))), cast(UPPER as string)) as string) AS SPECIALITE_ETAB_188021#723179, UF exclue#723141 AS UF_EXCLUE_188024#723170]
(12) Project
Arguments: [CODES_OFFICIELS_188023#723167, CODE_ETAB_188022#723168, SPECIALITE_ETAB_188021#723179, UF_EXCLUE_188024#723170]
(13) View
Arguments: `07_SPECIALITE_S_188020170`, true
(14) SubqueryAlias
Arguments: 07_SPECIALITE_S_188020170
(15) Project
Arguments: [CODES_OFFICIELS_188023#723167 AS 07_SPECIALITE_S_188020_CODES_OFFICIELS_188023#723217, CODE_ETAB_188022#723168 AS 07_SPECIALITE_S_188020_CODE_ETAB_188022#723218, SPECIALITE_ETAB_188021#723179 AS 07_SPECIALITE_S_188020_SPECIALITE_ETAB_188021#723220, UF_EXCLUE_188024#723170 AS 07_SPECIALITE_S_188020_UF_EXCLUE_188024#723221]
(16) Project
Arguments: [cast(07_SPECIALITE_S_188020_SPECIALITE_ETAB_188021#723220 as string) AS COL_7864F170_A63B_4C5B_8D84_6A083A060409#723242, cast(07_SPECIALITE_S_188020_CODE_ETAB_188022#723218 as string) AS COL_AC500846_C5E8_4A5A_8E31_1E2430D6604C#723243, cast(07_SPECIALITE_S_188020_CODES_OFFICIELS_188023#723217 as string) AS COL_CC022172_967F_4E4D_A40E_7F783F4C63E5#723244, cast(07_SPECIALITE_S_188020_UF_EXCLUE_188024#723221 as string) AS COL_6D69497E_86BC_42E2_B7B5_CF0CA0307C51#723245]