== 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_172820174`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#1113935, UF#1113936, Date entrée#1113937, Heure entrée#1113938, Transport admission#1113939, Niveau CCMU#1113940, Date sortie#1113941, heure sortie#1113942], false
(4) Project
Arguments: [Numéro Séjour#1113935, UF#1113936, Date entrée#1113937, Heure entrée#1113938, Transport admission#1113939, Niveau CCMU#1113940]
(5) Project
Arguments: [Numéro Séjour#1113935 AS Numéro Séjour#1113958, UF#1113936 AS UF#1113959, Date entrée#1113937 AS Date entrée#1113960, Heure entrée#1113938 AS Heure entrée#1113961, Transport admission#1113939 AS Transport admission#1113962, Niveau CCMU#1113940 AS Niveau CCMU#1113963]
(6) Project
Arguments: [Numéro Séjour#1113958, UF#1113959, Date entrée#1113960, Heure entrée#1113961, Transport admission#1113962, Niveau CCMU#1113963]
(7) Project
Arguments: [Niveau CCMU#1113963 AS NIVEAU_CCMU_172214#1113976, Numéro Séjour#1113958 AS NUMEROSEJOUR_172211#1113977, cast(str_remove_space(Transport admission#1113962, cast(ONLY_ONE as string)) as string) AS TRANSPORT_UTILI_172213#1113980, UF#1113959 AS UF_172212#1113979]
(8) Project
Arguments: [NIVEAU_CCMU_172214#1113976, NUMEROSEJOUR_172211#1113977, TRANSPORT_UTILI_172213#1113980, UF_172212#1113979]
(9) View
Arguments: `02_PASSAGE_PATI_172210174`, true
(10) SubqueryAlias
Arguments: 02_PASSAGE_PATI_172210174
(11) Project
Arguments: [NIVEAU_CCMU_172214#1113976 AS 02_PASSAGE_PATI_172210_NIVEAU_CCMU_172214#1113993, NUMEROSEJOUR_172211#1113977 AS 02_PASSAGE_PATI_172210_NUMEROSEJOUR_172211#1113994, TRANSPORT_UTILI_172213#1113980 AS 02_PASSAGE_PATI_172210_TRANSPORT_UTILI_172213#1113995, UF_172212#1113979 AS 02_PASSAGE_PATI_172210_UF_172212#1113996]
(12) Project
Arguments: [cast(02_PASSAGE_PATI_172210_NUMEROSEJOUR_172211#1113994 as string) AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114005, cast(02_PASSAGE_PATI_172210_UF_172212#1113996 as string) AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114006, cast(02_PASSAGE_PATI_172210_TRANSPORT_UTILI_172213#1113995 as string) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114007, cast(02_PASSAGE_PATI_172210_NIVEAU_CCMU_172214#1113993 as string) AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1114008]
(13) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114005 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114013, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114006 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114014, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114007 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114015, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1114008 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1114016]
(14) Filter
Arguments: NOT CASE WHEN isnull(StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114013, cast(# as string))) THEN false ELSE StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114013, cast(# as string)) END
(15) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114013 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114021, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114014 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114022, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114015 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114023, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1114016 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1114024]
(16) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114021 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114029, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114022 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114030, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114023 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114031, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1114024 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1114032]
(17) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114029, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114030, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114031, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1114032, str_remove_space(str_list_get(str_extract_by_regex(COL_7B923915_1CBF_4603_AB03_C432E00454ED#1114032, cast([+\d]+ as string)), cast(0 as bigint)), cast(ALL as string)) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1114037]
(18) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114029 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114043, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114030 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114044, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114031 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114045, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1114037 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1114046]
(19) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114043 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114051, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114044 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114052, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114045 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114053, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1114046 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1114054]
(20) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114051, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114052, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114053, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1114054, 1 AS CONST#1114060]
(21) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114051, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114052, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114053, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1114054, CONST#1114060]
(22) Window
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114051, CONST#1114060 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1114067], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114051], [CONST#1114060 DESC NULLS LAST]
(23) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114051, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114052, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114053, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1114054, CONST#1114060, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1114067, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1114067]
(24) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114051, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114052, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114053, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1114054, CONST#1114060, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1114067]
(25) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114051, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114052, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114053, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1114054, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1114067]
(26) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114051 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114079, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114052 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114080, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114053 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114081, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1114054 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1114082, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1114067 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1114083]
(27) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114079 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114089, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114080 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114090, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114081 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114091, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1114082 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1114092, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1114083 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1114093]
(28) Filter
Arguments: (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1114093 <=> cast(1 as int))
(29) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114089 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1114099, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114090 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1114100, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114091 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1114101, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1114092 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1114102]