== 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_176400173`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#1170829, UF#1170830, Date entrée#1170831, Heure entrée#1170832, Transport admission#1170833, Niveau CCMU#1170834, Date sortie#1170835, Heure sortie#1170836], false
(4) Project
Arguments: [Numéro Séjour#1170829, UF#1170830, Date entrée#1170831, Heure entrée#1170832, Transport admission#1170833, Niveau CCMU#1170834]
(5) Project
Arguments: [Numéro Séjour#1170829 AS Numéro Séjour#1170852, UF#1170830 AS UF#1170853, Date entrée#1170831 AS Date entrée#1170854, Heure entrée#1170832 AS Heure entrée#1170855, Transport admission#1170833 AS Transport admission#1170856, Niveau CCMU#1170834 AS Niveau CCMU#1170857]
(6) Project
Arguments: [Numéro Séjour#1170852, UF#1170853, Date entrée#1170854, Heure entrée#1170855, Transport admission#1170856, Niveau CCMU#1170857]
(7) Project
Arguments: [Niveau CCMU#1170857 AS NIVEAU_CCMU_175794#1170870, Numéro Séjour#1170852 AS NUMEROSEJOUR_175791#1170871, cast(str_remove_space(Transport admission#1170856, cast(ONLY_ONE as string)) as string) AS TRANSPORT_UTILI_175793#1170874, UF#1170853 AS UF_175792#1170873]
(8) Project
Arguments: [NIVEAU_CCMU_175794#1170870, NUMEROSEJOUR_175791#1170871, TRANSPORT_UTILI_175793#1170874, UF_175792#1170873]
(9) View
Arguments: `02_PASSAGE_PATI_175790173`, true
(10) SubqueryAlias
Arguments: 02_PASSAGE_PATI_175790173
(11) Project
Arguments: [NIVEAU_CCMU_175794#1170870 AS 02_PASSAGE_PATI_175790_NIVEAU_CCMU_175794#1170887, NUMEROSEJOUR_175791#1170871 AS 02_PASSAGE_PATI_175790_NUMEROSEJOUR_175791#1170888, TRANSPORT_UTILI_175793#1170874 AS 02_PASSAGE_PATI_175790_TRANSPORT_UTILI_175793#1170889, UF_175792#1170873 AS 02_PASSAGE_PATI_175790_UF_175792#1170890]
(12) Project
Arguments: [cast(02_PASSAGE_PATI_175790_NUMEROSEJOUR_175791#1170888 as string) AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170899, cast(02_PASSAGE_PATI_175790_UF_175792#1170890 as string) AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170900, cast(02_PASSAGE_PATI_175790_TRANSPORT_UTILI_175793#1170889 as string) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170901, cast(02_PASSAGE_PATI_175790_NIVEAU_CCMU_175794#1170887 as string) AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1170902]
(13) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170899 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170907, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170900 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170908, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170901 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170909, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1170902 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1170910]
(14) Filter
Arguments: NOT CASE WHEN isnull(StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170907, cast(# as string))) THEN false ELSE StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170907, cast(# as string)) END
(15) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170907 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170915, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170908 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170916, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170909 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170917, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1170910 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1170918]
(16) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170915 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170923, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170916 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170924, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170917 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170925, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1170918 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1170926]
(17) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170923, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170924, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170925, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1170926, str_remove_space(str_list_get(str_extract_by_regex(COL_7B923915_1CBF_4603_AB03_C432E00454ED#1170926, cast([+\d]+ as string)), cast(0 as bigint)), cast(ALL as string)) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1170931]
(18) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170923 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170937, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170924 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170938, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170925 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170939, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1170931 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1170940]
(19) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170937 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170945, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170938 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170946, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170939 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170947, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1170940 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1170948]
(20) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170945, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170946, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170947, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1170948, 1 AS CONST#1170954]
(21) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170945, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170946, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170947, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1170948, CONST#1170954]
(22) Window
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170945, CONST#1170954 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1170961], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170945], [CONST#1170954 DESC NULLS LAST]
(23) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170945, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170946, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170947, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1170948, CONST#1170954, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1170961, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1170961]
(24) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170945, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170946, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170947, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1170948, CONST#1170954, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1170961]
(25) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170945, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170946, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170947, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1170948, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1170961]
(26) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170945 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170973, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170946 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170974, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170947 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170975, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1170948 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1170976, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1170961 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1170977]
(27) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170973 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170983, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170974 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170984, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170975 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170985, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1170976 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1170986, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1170977 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1170987]
(28) Filter
Arguments: (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1170987 <=> cast(1 as int))
(29) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170983 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1170993, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170984 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1170994, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170985 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1170995, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1170986 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1170996]