== 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_161906172`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#2476053, UF#2476054, Date entrée#2476055, Heure entrée#2476056, Transport admission#2476057, Niveau CCMU#2476058, Date sortie#2476059, Heure sortie#2476060], false
(4) Project
Arguments: [Numéro Séjour#2476053, UF#2476054, Date entrée#2476055, Heure entrée#2476056, Transport admission#2476057, Niveau CCMU#2476058]
(5) Project
Arguments: [Numéro Séjour#2476053 AS Numéro Séjour#2476076, UF#2476054 AS UF#2476077, Date entrée#2476055 AS Date entrée#2476078, Heure entrée#2476056 AS Heure entrée#2476079, Transport admission#2476057 AS Transport admission#2476080, Niveau CCMU#2476058 AS Niveau CCMU#2476081]
(6) Project
Arguments: [Numéro Séjour#2476076, UF#2476077, Date entrée#2476078, Heure entrée#2476079, Transport admission#2476080, Niveau CCMU#2476081]
(7) Project
Arguments: [Niveau CCMU#2476081 AS NIVEAU_CCMU_161522#2476094, Numéro Séjour#2476076 AS NUMEROSEJOUR_161519#2476095, cast(str_remove_space(Transport admission#2476080, cast(ONLY_ONE as string)) as string) AS TRANSPORT_UTILI_161521#2476098, UF#2476077 AS UF_161520#2476097]
(8) Project
Arguments: [NIVEAU_CCMU_161522#2476094, NUMEROSEJOUR_161519#2476095, TRANSPORT_UTILI_161521#2476098, UF_161520#2476097]
(9) View
Arguments: `02_PASSAGE_PATI_161518172`, true
(10) SubqueryAlias
Arguments: 02_PASSAGE_PATI_161518172
(11) Project
Arguments: [NIVEAU_CCMU_161522#2476094 AS 02_PASSAGE_PATI_161518_NIVEAU_CCMU_161522#2476111, NUMEROSEJOUR_161519#2476095 AS 02_PASSAGE_PATI_161518_NUMEROSEJOUR_161519#2476112, TRANSPORT_UTILI_161521#2476098 AS 02_PASSAGE_PATI_161518_TRANSPORT_UTILI_161521#2476113, UF_161520#2476097 AS 02_PASSAGE_PATI_161518_UF_161520#2476114]
(12) Project
Arguments: [cast(02_PASSAGE_PATI_161518_NUMEROSEJOUR_161519#2476112 as string) AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476123, cast(02_PASSAGE_PATI_161518_UF_161520#2476114 as string) AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476124, cast(02_PASSAGE_PATI_161518_TRANSPORT_UTILI_161521#2476113 as string) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476125, cast(02_PASSAGE_PATI_161518_NIVEAU_CCMU_161522#2476111 as string) AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2476126]
(13) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476123 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476131, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476124 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476132, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476125 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476133, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2476126 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2476134]
(14) Filter
Arguments: NOT CASE WHEN isnull(StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476131, cast(# as string))) THEN false ELSE StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476131, cast(# as string)) END
(15) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476131 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476139, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476132 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476140, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476133 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476141, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2476134 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2476142]
(16) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476139 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476147, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476140 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476148, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476141 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476149, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2476142 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2476150]
(17) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476147, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476148, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476149, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2476150, str_remove_space(str_list_get(str_extract_by_regex(COL_7B923915_1CBF_4603_AB03_C432E00454ED#2476150, cast([+\d]+ as string)), cast(0 as bigint)), cast(ALL as string)) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2476208]
(18) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476147 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476214, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476148 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476215, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476149 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476216, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2476208 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2476217]
(19) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476214 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476222, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476215 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476223, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476216 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476224, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2476217 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2476225]
(20) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476222, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476223, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476224, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2476225, 1 AS CONST#2476231]
(21) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476222, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476223, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476224, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2476225, CONST#2476231]
(22) Window
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476222, CONST#2476231 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2476238], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476222], [CONST#2476231 DESC NULLS LAST]
(23) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476222, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476223, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476224, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2476225, CONST#2476231, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2476238, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2476238]
(24) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476222, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476223, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476224, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2476225, CONST#2476231, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2476238]
(25) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476222, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476223, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476224, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2476225, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2476238]
(26) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476222 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476250, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476223 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476251, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476224 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476252, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2476225 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2476253, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2476238 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2476254]
(27) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476250 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476260, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476251 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476261, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476252 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476262, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2476253 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2476263, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2476254 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2476264]
(28) Filter
Arguments: (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2476264 <=> cast(1 as int))
(29) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476260 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2476270, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476261 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2476271, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476262 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2476272, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2476263 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2476273]