== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (29)
+- Filter (28)
+- Project (27)
+- Project (26)
+- Project (25)
+- Project (24)
+- Project (23)
+- Window (22)
+- Project (21)
+- Project (20)
+- Project (19)
+- Project (18)
+- Project (17)
+- Project (16)
+- Project (15)
+- Filter (14)
+- Project (13)
+- Project (12)
+- Project (11)
+- SubqueryAlias (10)
+- View (9)
+- Project (8)
+- Project (7)
+- Project (6)
+- Project (5)
+- Project (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `00_C_PASSAGE_PA_161906170`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#2311209, UF#2311210, Date entrée#2311211, Heure entrée#2311212, Transport admission#2311213, Niveau CCMU#2311214, Date sortie#2311215, Heure sortie#2311216], false
(4) Project
Arguments: [Numéro Séjour#2311209, UF#2311210, Date entrée#2311211, Heure entrée#2311212, Transport admission#2311213, Niveau CCMU#2311214]
(5) Project
Arguments: [Numéro Séjour#2311209 AS Numéro Séjour#2311232, UF#2311210 AS UF#2311233, Date entrée#2311211 AS Date entrée#2311234, Heure entrée#2311212 AS Heure entrée#2311235, Transport admission#2311213 AS Transport admission#2311236, Niveau CCMU#2311214 AS Niveau CCMU#2311237]
(6) Project
Arguments: [Numéro Séjour#2311232, UF#2311233, Date entrée#2311234, Heure entrée#2311235, Transport admission#2311236, Niveau CCMU#2311237]
(7) Project
Arguments: [Niveau CCMU#2311237 AS NIVEAU_CCMU_161522#2311250, Numéro Séjour#2311232 AS NUMEROSEJOUR_161519#2311251, cast(str_remove_space(Transport admission#2311236, cast(ONLY_ONE as string)) as string) AS TRANSPORT_UTILI_161521#2311254, UF#2311233 AS UF_161520#2311253]
(8) Project
Arguments: [NIVEAU_CCMU_161522#2311250, NUMEROSEJOUR_161519#2311251, TRANSPORT_UTILI_161521#2311254, UF_161520#2311253]
(9) View
Arguments: `02_PASSAGE_PATI_161518170`, true
(10) SubqueryAlias
Arguments: 02_PASSAGE_PATI_161518170
(11) Project
Arguments: [NIVEAU_CCMU_161522#2311250 AS 02_PASSAGE_PATI_161518_NIVEAU_CCMU_161522#2311267, NUMEROSEJOUR_161519#2311251 AS 02_PASSAGE_PATI_161518_NUMEROSEJOUR_161519#2311268, TRANSPORT_UTILI_161521#2311254 AS 02_PASSAGE_PATI_161518_TRANSPORT_UTILI_161521#2311269, UF_161520#2311253 AS 02_PASSAGE_PATI_161518_UF_161520#2311270]
(12) Project
Arguments: [cast(02_PASSAGE_PATI_161518_NUMEROSEJOUR_161519#2311268 as string) AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311279, cast(02_PASSAGE_PATI_161518_UF_161520#2311270 as string) AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311280, cast(02_PASSAGE_PATI_161518_TRANSPORT_UTILI_161521#2311269 as string) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311281, cast(02_PASSAGE_PATI_161518_NIVEAU_CCMU_161522#2311267 as string) AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2311282]
(13) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311279 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311287, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311280 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311288, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311281 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311289, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2311282 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2311290]
(14) Filter
Arguments: NOT CASE WHEN isnull(StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311287, cast(# as string))) THEN false ELSE StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311287, cast(# as string)) END
(15) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311287 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311295, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311288 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311296, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311289 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311297, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2311290 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2311298]
(16) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311295 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311303, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311296 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311304, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311297 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311305, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2311298 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2311306]
(17) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311303, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311304, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311305, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2311306, str_remove_space(str_list_get(str_extract_by_regex(COL_7B923915_1CBF_4603_AB03_C432E00454ED#2311306, cast([+\d]+ as string)), cast(0 as bigint)), cast(ALL as string)) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311311]
(18) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311303 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311317, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311304 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311318, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311305 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311319, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311311 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311320]
(19) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311317 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311325, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311318 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311326, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311319 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311327, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311320 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311328]
(20) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311325, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311326, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311327, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311328, 1 AS CONST#2311334]
(21) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311325, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311326, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311327, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311328, CONST#2311334]
(22) Window
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311325, CONST#2311334 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311341], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311325], [CONST#2311334 DESC NULLS LAST]
(23) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311325, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311326, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311327, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311328, CONST#2311334, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311341, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311341]
(24) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311325, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311326, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311327, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311328, CONST#2311334, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311341]
(25) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311325, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311326, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311327, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311328, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311341]
(26) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311325 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311353, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311326 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311354, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311327 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311355, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311328 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311356, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311341 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311357]
(27) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311353 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311363, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311354 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311364, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311355 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311365, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311356 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311366, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311357 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311367]
(28) Filter
Arguments: (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311367 <=> cast(1 as int))
(29) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311363 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311373, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311364 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311374, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311365 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311375, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311366 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311376]