== 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_172820171`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#1118135, UF#1118136, Date entrée#1118137, Heure entrée#1118138, Transport admission#1118139, Niveau CCMU#1118140, Date sortie#1118141, heure sortie#1118142], false
(4) Project
Arguments: [Numéro Séjour#1118135, UF#1118136, Date entrée#1118137, Heure entrée#1118138, Transport admission#1118139, Niveau CCMU#1118140]
(5) Project
Arguments: [Numéro Séjour#1118135 AS Numéro Séjour#1118158, UF#1118136 AS UF#1118159, Date entrée#1118137 AS Date entrée#1118160, Heure entrée#1118138 AS Heure entrée#1118161, Transport admission#1118139 AS Transport admission#1118162, Niveau CCMU#1118140 AS Niveau CCMU#1118163]
(6) Project
Arguments: [Numéro Séjour#1118158, UF#1118159, Date entrée#1118160, Heure entrée#1118161, Transport admission#1118162, Niveau CCMU#1118163]
(7) Project
Arguments: [Niveau CCMU#1118163 AS NIVEAU_CCMU_172214#1118176, Numéro Séjour#1118158 AS NUMEROSEJOUR_172211#1118177, cast(str_remove_space(Transport admission#1118162, cast(ONLY_ONE as string)) as string) AS TRANSPORT_UTILI_172213#1118180, UF#1118159 AS UF_172212#1118179]
(8) Project
Arguments: [NIVEAU_CCMU_172214#1118176, NUMEROSEJOUR_172211#1118177, TRANSPORT_UTILI_172213#1118180, UF_172212#1118179]
(9) View
Arguments: `02_PASSAGE_PATI_172210171`, true
(10) SubqueryAlias
Arguments: 02_PASSAGE_PATI_172210171
(11) Project
Arguments: [NIVEAU_CCMU_172214#1118176 AS 02_PASSAGE_PATI_172210_NIVEAU_CCMU_172214#1118193, NUMEROSEJOUR_172211#1118177 AS 02_PASSAGE_PATI_172210_NUMEROSEJOUR_172211#1118194, TRANSPORT_UTILI_172213#1118180 AS 02_PASSAGE_PATI_172210_TRANSPORT_UTILI_172213#1118195, UF_172212#1118179 AS 02_PASSAGE_PATI_172210_UF_172212#1118196]
(12) Project
Arguments: [cast(02_PASSAGE_PATI_172210_NUMEROSEJOUR_172211#1118194 as string) AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118205, cast(02_PASSAGE_PATI_172210_UF_172212#1118196 as string) AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118206, cast(02_PASSAGE_PATI_172210_TRANSPORT_UTILI_172213#1118195 as string) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118207, cast(02_PASSAGE_PATI_172210_NIVEAU_CCMU_172214#1118193 as string) AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1118208]
(13) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118205 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118213, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118206 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118214, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118207 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118215, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1118208 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1118216]
(14) Filter
Arguments: NOT CASE WHEN isnull(StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118213, cast(# as string))) THEN false ELSE StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118213, cast(# as string)) END
(15) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118213 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118221, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118214 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118222, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118215 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118223, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1118216 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1118224]
(16) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118221 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118229, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118222 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118230, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118223 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118231, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1118224 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1118232]
(17) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118229, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118230, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118231, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1118232, str_remove_space(str_list_get(str_extract_by_regex(COL_7B923915_1CBF_4603_AB03_C432E00454ED#1118232, cast([+\d]+ as string)), cast(0 as bigint)), cast(ALL as string)) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1118237]
(18) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118229 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118243, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118230 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118244, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118231 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118245, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1118237 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1118246]
(19) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118243 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118251, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118244 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118252, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118245 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118253, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1118246 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1118254]
(20) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118251, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118252, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118253, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1118254, 1 AS CONST#1118260]
(21) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118251, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118252, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118253, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1118254, CONST#1118260]
(22) Window
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118251, CONST#1118260 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1118267], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118251], [CONST#1118260 DESC NULLS LAST]
(23) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118251, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118252, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118253, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1118254, CONST#1118260, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1118267, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1118267]
(24) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118251, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118252, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118253, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1118254, CONST#1118260, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1118267]
(25) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118251, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118252, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118253, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1118254, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1118267]
(26) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118251 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118279, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118252 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118280, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118253 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118281, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1118254 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1118282, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1118267 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1118283]
(27) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118279 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118289, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118280 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118290, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118281 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118291, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1118282 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1118292, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1118283 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1118293]
(28) Filter
Arguments: (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1118293 <=> cast(1 as int))
(29) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118289 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1118299, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118290 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1118300, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118291 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1118301, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1118292 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1118302]