== 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_226115174`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#519512, UF#519513, Date entrée#519514, Heure entrée#519515, Transport admission#519516, Niveau CCMU#519517, Date sortie#519518, Heure sortie#519519], false
(4) Project
Arguments: [Numéro Séjour#519512, UF#519513, Date entrée#519514, Heure entrée#519515, Transport admission#519516, Niveau CCMU#519517]
(5) Project
Arguments: [Numéro Séjour#519512 AS Numéro Séjour#519535, UF#519513 AS UF#519536, Date entrée#519514 AS Date entrée#519537, Heure entrée#519515 AS Heure entrée#519538, Transport admission#519516 AS Transport admission#519539, Niveau CCMU#519517 AS Niveau CCMU#519540]
(6) Project
Arguments: [Numéro Séjour#519535, UF#519536, Date entrée#519537, Heure entrée#519538, Transport admission#519539, Niveau CCMU#519540]
(7) Project
Arguments: [Niveau CCMU#519540 AS NIVEAU_CCMU_225626#519553, Numéro Séjour#519535 AS NUMEROSEJOUR_225623#519554, cast(str_remove_space(Transport admission#519539, cast(ONLY_ONE as string)) as string) AS TRANSPORT_UTILI_225625#519557, UF#519536 AS UF_225624#519556]
(8) Project
Arguments: [NIVEAU_CCMU_225626#519553, NUMEROSEJOUR_225623#519554, TRANSPORT_UTILI_225625#519557, UF_225624#519556]
(9) View
Arguments: `02_PASSAGE_PATI_225622174`, true
(10) SubqueryAlias
Arguments: 02_PASSAGE_PATI_225622174
(11) Project
Arguments: [NIVEAU_CCMU_225626#519553 AS 02_PASSAGE_PATI_225622_NIVEAU_CCMU_225626#519570, NUMEROSEJOUR_225623#519554 AS 02_PASSAGE_PATI_225622_NUMEROSEJOUR_225623#519571, TRANSPORT_UTILI_225625#519557 AS 02_PASSAGE_PATI_225622_TRANSPORT_UTILI_225625#519572, UF_225624#519556 AS 02_PASSAGE_PATI_225622_UF_225624#519573]
(12) Project
Arguments: [cast(02_PASSAGE_PATI_225622_NUMEROSEJOUR_225623#519571 as string) AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519582, cast(02_PASSAGE_PATI_225622_UF_225624#519573 as string) AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519583, cast(02_PASSAGE_PATI_225622_TRANSPORT_UTILI_225625#519572 as string) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519584, cast(02_PASSAGE_PATI_225622_NIVEAU_CCMU_225626#519570 as string) AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#519585]
(13) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519582 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519590, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519583 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519591, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519584 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519592, COL_7B923915_1CBF_4603_AB03_C432E00454ED#519585 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#519593]
(14) Filter
Arguments: NOT CASE WHEN isnull(StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519590, cast(# as string))) THEN false ELSE StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519590, cast(# as string)) END
(15) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519590 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519598, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519591 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519599, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519592 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519600, COL_7B923915_1CBF_4603_AB03_C432E00454ED#519593 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#519601]
(16) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519598 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519606, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519599 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519607, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519600 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519608, COL_7B923915_1CBF_4603_AB03_C432E00454ED#519601 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#519609]
(17) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519606, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519607, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519608, COL_7B923915_1CBF_4603_AB03_C432E00454ED#519609, str_remove_space(str_list_get(str_extract_by_regex(COL_7B923915_1CBF_4603_AB03_C432E00454ED#519609, cast([+\d]+ as string)), cast(0 as bigint)), cast(ALL as string)) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#519614]
(18) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519606 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519620, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519607 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519621, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519608 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519622, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#519614 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#519623]
(19) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519620 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519628, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519621 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519629, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519622 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519630, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#519623 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#519631]
(20) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519628, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519629, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519630, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#519631, 1 AS CONST#519637]
(21) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519628, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519629, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519630, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#519631, CONST#519637]
(22) Window
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519628, CONST#519637 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#519644], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519628], [CONST#519637 DESC NULLS LAST]
(23) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519628, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519629, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519630, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#519631, CONST#519637, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#519644, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#519644]
(24) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519628, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519629, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519630, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#519631, CONST#519637, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#519644]
(25) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519628, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519629, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519630, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#519631, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#519644]
(26) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519628 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519656, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519629 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519657, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519630 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519658, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#519631 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#519659, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#519644 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#519660]
(27) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519656 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519666, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519657 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519667, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519658 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519668, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#519659 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#519669, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#519660 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#519670]
(28) Filter
Arguments: (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#519670 <=> cast(1 as int))
(29) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519666 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#519676, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519667 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#519677, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519668 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#519678, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#519669 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#519679]