== 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_172820170`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#1163097, UF#1163098, Date entrée#1163099, Heure entrée#1163100, Transport admission#1163101, Niveau CCMU#1163102, Date sortie#1163103, heure sortie#1163104], false
(4) Project
Arguments: [Numéro Séjour#1163097, UF#1163098, Date entrée#1163099, Heure entrée#1163100, Transport admission#1163101, Niveau CCMU#1163102]
(5) Project
Arguments: [Numéro Séjour#1163097 AS Numéro Séjour#1163120, UF#1163098 AS UF#1163121, Date entrée#1163099 AS Date entrée#1163122, Heure entrée#1163100 AS Heure entrée#1163123, Transport admission#1163101 AS Transport admission#1163124, Niveau CCMU#1163102 AS Niveau CCMU#1163125]
(6) Project
Arguments: [Numéro Séjour#1163120, UF#1163121, Date entrée#1163122, Heure entrée#1163123, Transport admission#1163124, Niveau CCMU#1163125]
(7) Project
Arguments: [Niveau CCMU#1163125 AS NIVEAU_CCMU_172214#1163138, Numéro Séjour#1163120 AS NUMEROSEJOUR_172211#1163139, cast(str_remove_space(Transport admission#1163124, cast(ONLY_ONE as string)) as string) AS TRANSPORT_UTILI_172213#1163142, UF#1163121 AS UF_172212#1163141]
(8) Project
Arguments: [NIVEAU_CCMU_172214#1163138, NUMEROSEJOUR_172211#1163139, TRANSPORT_UTILI_172213#1163142, UF_172212#1163141]
(9) View
Arguments: `02_PASSAGE_PATI_172210170`, true
(10) SubqueryAlias
Arguments: 02_PASSAGE_PATI_172210170
(11) Project
Arguments: [NIVEAU_CCMU_172214#1163138 AS 02_PASSAGE_PATI_172210_NIVEAU_CCMU_172214#1163155, NUMEROSEJOUR_172211#1163139 AS 02_PASSAGE_PATI_172210_NUMEROSEJOUR_172211#1163156, TRANSPORT_UTILI_172213#1163142 AS 02_PASSAGE_PATI_172210_TRANSPORT_UTILI_172213#1163157, UF_172212#1163141 AS 02_PASSAGE_PATI_172210_UF_172212#1163158]
(12) Project
Arguments: [cast(02_PASSAGE_PATI_172210_NUMEROSEJOUR_172211#1163156 as string) AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163167, cast(02_PASSAGE_PATI_172210_UF_172212#1163158 as string) AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163168, cast(02_PASSAGE_PATI_172210_TRANSPORT_UTILI_172213#1163157 as string) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163169, cast(02_PASSAGE_PATI_172210_NIVEAU_CCMU_172214#1163155 as string) AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1163170]
(13) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163167 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163175, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163168 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163176, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163169 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163177, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1163170 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1163178]
(14) Filter
Arguments: NOT CASE WHEN isnull(StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163175, cast(# as string))) THEN false ELSE StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163175, cast(# as string)) END
(15) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163175 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163183, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163176 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163184, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163177 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163185, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1163178 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1163186]
(16) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163183 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163191, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163184 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163192, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163185 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163193, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1163186 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1163194]
(17) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163191, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163192, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163193, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1163194, str_remove_space(str_list_get(str_extract_by_regex(COL_7B923915_1CBF_4603_AB03_C432E00454ED#1163194, cast([+\d]+ as string)), cast(0 as bigint)), cast(ALL as string)) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1163199]
(18) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163191 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163205, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163192 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163206, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163193 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163207, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1163199 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1163208]
(19) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163205 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163213, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163206 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163214, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163207 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163215, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1163208 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1163216]
(20) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163213, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163214, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163215, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1163216, 1 AS CONST#1163222]
(21) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163213, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163214, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163215, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1163216, CONST#1163222]
(22) Window
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163213, CONST#1163222 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1163229], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163213], [CONST#1163222 DESC NULLS LAST]
(23) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163213, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163214, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163215, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1163216, CONST#1163222, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1163229, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1163229]
(24) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163213, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163214, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163215, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1163216, CONST#1163222, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1163229]
(25) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163213, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163214, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163215, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1163216, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1163229]
(26) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163213 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163241, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163214 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163242, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163215 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163243, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1163216 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1163244, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1163229 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1163245]
(27) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163241 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163251, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163242 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163252, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163243 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163253, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1163244 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1163254, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1163245 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1163255]
(28) Filter
Arguments: (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1163255 <=> cast(1 as int))
(29) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163251 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1163261, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163252 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1163262, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163253 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1163263, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1163254 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1163264]