== 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_161906175`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#2338913, UF#2338914, Date entrée#2338915, Heure entrée#2338916, Transport admission#2338917, Niveau CCMU#2338918, Date sortie#2338919, Heure sortie#2338920], false
(4) Project
Arguments: [Numéro Séjour#2338913, UF#2338914, Date entrée#2338915, Heure entrée#2338916, Transport admission#2338917, Niveau CCMU#2338918]
(5) Project
Arguments: [Numéro Séjour#2338913 AS Numéro Séjour#2338936, UF#2338914 AS UF#2338937, Date entrée#2338915 AS Date entrée#2338938, Heure entrée#2338916 AS Heure entrée#2338939, Transport admission#2338917 AS Transport admission#2338940, Niveau CCMU#2338918 AS Niveau CCMU#2338941]
(6) Project
Arguments: [Numéro Séjour#2338936, UF#2338937, Date entrée#2338938, Heure entrée#2338939, Transport admission#2338940, Niveau CCMU#2338941]
(7) Project
Arguments: [Niveau CCMU#2338941 AS NIVEAU_CCMU_161522#2338954, Numéro Séjour#2338936 AS NUMEROSEJOUR_161519#2338955, cast(str_remove_space(Transport admission#2338940, cast(ONLY_ONE as string)) as string) AS TRANSPORT_UTILI_161521#2338958, UF#2338937 AS UF_161520#2338957]
(8) Project
Arguments: [NIVEAU_CCMU_161522#2338954, NUMEROSEJOUR_161519#2338955, TRANSPORT_UTILI_161521#2338958, UF_161520#2338957]
(9) View
Arguments: `02_PASSAGE_PATI_161518175`, true
(10) SubqueryAlias
Arguments: 02_PASSAGE_PATI_161518175
(11) Project
Arguments: [NIVEAU_CCMU_161522#2338954 AS 02_PASSAGE_PATI_161518_NIVEAU_CCMU_161522#2338971, NUMEROSEJOUR_161519#2338955 AS 02_PASSAGE_PATI_161518_NUMEROSEJOUR_161519#2338972, TRANSPORT_UTILI_161521#2338958 AS 02_PASSAGE_PATI_161518_TRANSPORT_UTILI_161521#2338973, UF_161520#2338957 AS 02_PASSAGE_PATI_161518_UF_161520#2338974]
(12) Project
Arguments: [cast(02_PASSAGE_PATI_161518_NUMEROSEJOUR_161519#2338972 as string) AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2338983, cast(02_PASSAGE_PATI_161518_UF_161520#2338974 as string) AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2338984, cast(02_PASSAGE_PATI_161518_TRANSPORT_UTILI_161521#2338973 as string) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2338985, cast(02_PASSAGE_PATI_161518_NIVEAU_CCMU_161522#2338971 as string) AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2338986]
(13) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2338983 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2338991, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2338984 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2338992, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2338985 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2338993, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2338986 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2338994]
(14) Filter
Arguments: NOT CASE WHEN isnull(StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2338991, cast(# as string))) THEN false ELSE StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2338991, cast(# as string)) END
(15) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2338991 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2338999, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2338992 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2339000, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2338993 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2339001, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2338994 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2339002]
(16) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2338999 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2339007, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2339000 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2339008, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2339001 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2339009, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2339002 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2339010]
(17) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2339007, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2339008, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2339009, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2339010, str_remove_space(str_list_get(str_extract_by_regex(COL_7B923915_1CBF_4603_AB03_C432E00454ED#2339010, cast([+\d]+ as string)), cast(0 as bigint)), cast(ALL as string)) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2339015]
(18) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2339007 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2339021, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2339008 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2339022, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2339009 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2339023, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2339015 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2339024]
(19) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2339021 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2339029, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2339022 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2339030, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2339023 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2339031, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2339024 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2339032]
(20) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2339029, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2339030, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2339031, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2339032, 1 AS CONST#2339038]
(21) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2339029, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2339030, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2339031, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2339032, CONST#2339038]
(22) Window
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2339029, CONST#2339038 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2339045], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2339029], [CONST#2339038 DESC NULLS LAST]
(23) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2339029, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2339030, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2339031, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2339032, CONST#2339038, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2339045, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2339045]
(24) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2339029, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2339030, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2339031, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2339032, CONST#2339038, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2339045]
(25) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2339029, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2339030, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2339031, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2339032, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2339045]
(26) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2339029 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2339057, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2339030 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2339058, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2339031 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2339059, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2339032 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2339060, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2339045 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2339061]
(27) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2339057 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2339120, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2339058 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2339121, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2339059 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2339122, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2339060 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2339123, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2339061 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2339124]
(28) Filter
Arguments: (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2339124 <=> cast(1 as int))
(29) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2339120 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2339183, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2339121 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2339184, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2339122 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2339185, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2339123 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2339186]