== 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_176400167`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#1137238, UF#1137239, Date entrée#1137240, Heure entrée#1137241, Transport admission#1137242, Niveau CCMU#1137243, Date sortie#1137244, Heure sortie#1137245], false
(4) Project
Arguments: [Numéro Séjour#1137238, UF#1137239, Date entrée#1137240, Heure entrée#1137241, Transport admission#1137242, Niveau CCMU#1137243]
(5) Project
Arguments: [Numéro Séjour#1137238 AS Numéro Séjour#1137261, UF#1137239 AS UF#1137262, Date entrée#1137240 AS Date entrée#1137263, Heure entrée#1137241 AS Heure entrée#1137264, Transport admission#1137242 AS Transport admission#1137265, Niveau CCMU#1137243 AS Niveau CCMU#1137266]
(6) Project
Arguments: [Numéro Séjour#1137261, UF#1137262, Date entrée#1137263, Heure entrée#1137264, Transport admission#1137265, Niveau CCMU#1137266]
(7) Project
Arguments: [Niveau CCMU#1137266 AS NIVEAU_CCMU_175794#1137279, Numéro Séjour#1137261 AS NUMEROSEJOUR_175791#1137280, cast(str_remove_space(Transport admission#1137265, cast(ONLY_ONE as string)) as string) AS TRANSPORT_UTILI_175793#1137283, UF#1137262 AS UF_175792#1137282]
(8) Project
Arguments: [NIVEAU_CCMU_175794#1137279, NUMEROSEJOUR_175791#1137280, TRANSPORT_UTILI_175793#1137283, UF_175792#1137282]
(9) View
Arguments: `02_PASSAGE_PATI_175790167`, true
(10) SubqueryAlias
Arguments: 02_PASSAGE_PATI_175790167
(11) Project
Arguments: [NIVEAU_CCMU_175794#1137279 AS 02_PASSAGE_PATI_175790_NIVEAU_CCMU_175794#1137296, NUMEROSEJOUR_175791#1137280 AS 02_PASSAGE_PATI_175790_NUMEROSEJOUR_175791#1137297, TRANSPORT_UTILI_175793#1137283 AS 02_PASSAGE_PATI_175790_TRANSPORT_UTILI_175793#1137298, UF_175792#1137282 AS 02_PASSAGE_PATI_175790_UF_175792#1137299]
(12) Project
Arguments: [cast(02_PASSAGE_PATI_175790_NUMEROSEJOUR_175791#1137297 as string) AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137308, cast(02_PASSAGE_PATI_175790_UF_175792#1137299 as string) AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137309, cast(02_PASSAGE_PATI_175790_TRANSPORT_UTILI_175793#1137298 as string) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137310, cast(02_PASSAGE_PATI_175790_NIVEAU_CCMU_175794#1137296 as string) AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1137311]
(13) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137308 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137316, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137309 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137317, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137310 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137318, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1137311 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1137319]
(14) Filter
Arguments: NOT CASE WHEN isnull(StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137316, cast(# as string))) THEN false ELSE StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137316, cast(# as string)) END
(15) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137316 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137324, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137317 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137325, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137318 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137326, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1137319 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1137327]
(16) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137324 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137332, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137325 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137333, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137326 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137334, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1137327 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1137335]
(17) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137332, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137333, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137334, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1137335, str_remove_space(str_list_get(str_extract_by_regex(COL_7B923915_1CBF_4603_AB03_C432E00454ED#1137335, cast([+\d]+ as string)), cast(0 as bigint)), cast(ALL as string)) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137340]
(18) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137332 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137346, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137333 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137347, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137334 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137348, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137340 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137349]
(19) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137346 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137354, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137347 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137355, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137348 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137356, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137349 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137357]
(20) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137354, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137355, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137356, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137357, 1 AS CONST#1137363]
(21) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137354, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137355, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137356, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137357, CONST#1137363]
(22) Window
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137354, CONST#1137363 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137370], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137354], [CONST#1137363 DESC NULLS LAST]
(23) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137354, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137355, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137356, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137357, CONST#1137363, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137370, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137370]
(24) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137354, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137355, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137356, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137357, CONST#1137363, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137370]
(25) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137354, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137355, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137356, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137357, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137370]
(26) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137354 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137382, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137355 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137383, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137356 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137384, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137357 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137385, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137370 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137386]
(27) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137382 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137392, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137383 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137393, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137384 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137394, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137385 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137395, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137386 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137396]
(28) Filter
Arguments: (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137396 <=> cast(1 as int))
(29) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137392 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137402, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137393 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137403, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137394 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137404, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137395 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137405]