== 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_161906173`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#2348128, UF#2348129, Date entrée#2348130, Heure entrée#2348131, Transport admission#2348132, Niveau CCMU#2348133, Date sortie#2348134, Heure sortie#2348135], false
(4) Project
Arguments: [Numéro Séjour#2348128, UF#2348129, Date entrée#2348130, Heure entrée#2348131, Transport admission#2348132, Niveau CCMU#2348133]
(5) Project
Arguments: [Numéro Séjour#2348128 AS Numéro Séjour#2348159, UF#2348129 AS UF#2348160, Date entrée#2348130 AS Date entrée#2348161, Heure entrée#2348131 AS Heure entrée#2348162, Transport admission#2348132 AS Transport admission#2348163, Niveau CCMU#2348133 AS Niveau CCMU#2348164]
(6) Project
Arguments: [Numéro Séjour#2348159, UF#2348160, Date entrée#2348161, Heure entrée#2348162, Transport admission#2348163, Niveau CCMU#2348164]
(7) Project
Arguments: [Niveau CCMU#2348164 AS NIVEAU_CCMU_161522#2348188, Numéro Séjour#2348159 AS NUMEROSEJOUR_161519#2348189, cast(str_remove_space(Transport admission#2348163, cast(ONLY_ONE as string)) as string) AS TRANSPORT_UTILI_161521#2348192, UF#2348160 AS UF_161520#2348191]
(8) Project
Arguments: [NIVEAU_CCMU_161522#2348188, NUMEROSEJOUR_161519#2348189, TRANSPORT_UTILI_161521#2348192, UF_161520#2348191]
(9) View
Arguments: `02_PASSAGE_PATI_161518173`, true
(10) SubqueryAlias
Arguments: 02_PASSAGE_PATI_161518173
(11) Project
Arguments: [NIVEAU_CCMU_161522#2348188 AS 02_PASSAGE_PATI_161518_NIVEAU_CCMU_161522#2348214, NUMEROSEJOUR_161519#2348189 AS 02_PASSAGE_PATI_161518_NUMEROSEJOUR_161519#2348215, TRANSPORT_UTILI_161521#2348192 AS 02_PASSAGE_PATI_161518_TRANSPORT_UTILI_161521#2348216, UF_161520#2348191 AS 02_PASSAGE_PATI_161518_UF_161520#2348217]
(12) Project
Arguments: [cast(02_PASSAGE_PATI_161518_NUMEROSEJOUR_161519#2348215 as string) AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348226, cast(02_PASSAGE_PATI_161518_UF_161520#2348217 as string) AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348227, cast(02_PASSAGE_PATI_161518_TRANSPORT_UTILI_161521#2348216 as string) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348228, cast(02_PASSAGE_PATI_161518_NIVEAU_CCMU_161522#2348214 as string) AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2348229]
(13) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348226 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348244, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348227 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348245, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348228 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348246, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2348229 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2348247]
(14) Filter
Arguments: NOT CASE WHEN isnull(StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348244, cast(# as string))) THEN false ELSE StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348244, cast(# as string)) END
(15) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348244 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348261, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348245 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348262, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348246 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348263, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2348247 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2348264]
(16) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348261 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348273, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348262 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348274, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348263 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348275, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2348264 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2348276]
(17) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348273, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348274, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348275, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2348276, str_remove_space(str_list_get(str_extract_by_regex(COL_7B923915_1CBF_4603_AB03_C432E00454ED#2348276, cast([+\d]+ as string)), cast(0 as bigint)), cast(ALL as string)) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2348284]
(18) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348273 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348297, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348274 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348298, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348275 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348299, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2348284 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2348300]
(19) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348297 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348307, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348298 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348308, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348299 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348309, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2348300 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2348310]
(20) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348307, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348308, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348309, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2348310, 1 AS CONST#2348320]
(21) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348307, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348308, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348309, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2348310, CONST#2348320]
(22) Window
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348307, CONST#2348320 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2348337], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348307], [CONST#2348320 DESC NULLS LAST]
(23) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348307, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348308, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348309, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2348310, CONST#2348320, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2348337, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2348337]
(24) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348307, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348308, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348309, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2348310, CONST#2348320, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2348337]
(25) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348307, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348308, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348309, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2348310, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2348337]
(26) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348307 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348360, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348308 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348361, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348309 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348362, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2348310 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2348363, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2348337 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2348364]
(27) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348360 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348382, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348361 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348383, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348362 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348384, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2348363 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2348385, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2348364 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2348386]
(28) Filter
Arguments: (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2348386 <=> cast(1 as int))
(29) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348382 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2348392, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348383 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2348393, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348384 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2348394, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2348385 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2348395]