== 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_226115168`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#548467, UF#548468, Date entrée#548469, Heure entrée#548470, Transport admission#548471, Niveau CCMU#548472, Date sortie#548473, Heure sortie#548474], false
(4) Project
Arguments: [Numéro Séjour#548467, UF#548468, Date entrée#548469, Heure entrée#548470, Transport admission#548471, Niveau CCMU#548472]
(5) Project
Arguments: [Numéro Séjour#548467 AS Numéro Séjour#548513, UF#548468 AS UF#548514, Date entrée#548469 AS Date entrée#548515, Heure entrée#548470 AS Heure entrée#548516, Transport admission#548471 AS Transport admission#548517, Niveau CCMU#548472 AS Niveau CCMU#548518]
(6) Project
Arguments: [Numéro Séjour#548513, UF#548514, Date entrée#548515, Heure entrée#548516, Transport admission#548517, Niveau CCMU#548518]
(7) Project
Arguments: [Niveau CCMU#548518 AS NIVEAU_CCMU_225626#548541, Numéro Séjour#548513 AS NUMEROSEJOUR_225623#548542, cast(str_remove_space(Transport admission#548517, cast(ONLY_ONE as string)) as string) AS TRANSPORT_UTILI_225625#548550, UF#548514 AS UF_225624#548549]
(8) Project
Arguments: [NIVEAU_CCMU_225626#548541, NUMEROSEJOUR_225623#548542, TRANSPORT_UTILI_225625#548550, UF_225624#548549]
(9) View
Arguments: `02_PASSAGE_PATI_225622168`, true
(10) SubqueryAlias
Arguments: 02_PASSAGE_PATI_225622168
(11) Project
Arguments: [NIVEAU_CCMU_225626#548541 AS 02_PASSAGE_PATI_225622_NIVEAU_CCMU_225626#548576, NUMEROSEJOUR_225623#548542 AS 02_PASSAGE_PATI_225622_NUMEROSEJOUR_225623#548577, TRANSPORT_UTILI_225625#548550 AS 02_PASSAGE_PATI_225622_TRANSPORT_UTILI_225625#548578, UF_225624#548549 AS 02_PASSAGE_PATI_225622_UF_225624#548579]
(12) Project
Arguments: [cast(02_PASSAGE_PATI_225622_NUMEROSEJOUR_225623#548577 as string) AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548588, cast(02_PASSAGE_PATI_225622_UF_225624#548579 as string) AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548589, cast(02_PASSAGE_PATI_225622_TRANSPORT_UTILI_225625#548578 as string) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548590, cast(02_PASSAGE_PATI_225622_NIVEAU_CCMU_225626#548576 as string) AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#548591]
(13) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548588 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548596, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548589 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548597, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548590 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548598, COL_7B923915_1CBF_4603_AB03_C432E00454ED#548591 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#548599]
(14) Filter
Arguments: NOT CASE WHEN isnull(StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548596, cast(# as string))) THEN false ELSE StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548596, cast(# as string)) END
(15) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548596 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548604, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548597 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548605, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548598 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548606, COL_7B923915_1CBF_4603_AB03_C432E00454ED#548599 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#548607]
(16) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548604 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548612, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548605 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548613, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548606 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548614, COL_7B923915_1CBF_4603_AB03_C432E00454ED#548607 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#548615]
(17) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548612, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548613, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548614, COL_7B923915_1CBF_4603_AB03_C432E00454ED#548615, str_remove_space(str_list_get(str_extract_by_regex(COL_7B923915_1CBF_4603_AB03_C432E00454ED#548615, cast([+\d]+ as string)), cast(0 as bigint)), cast(ALL as string)) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#548620]
(18) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548612 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548626, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548613 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548627, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548614 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548628, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#548620 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#548629]
(19) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548626 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548634, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548627 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548635, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548628 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548636, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#548629 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#548637]
(20) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548634, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548635, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548636, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#548637, 1 AS CONST#548643]
(21) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548634, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548635, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548636, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#548637, CONST#548643]
(22) Window
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548634, CONST#548643 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#548650], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548634], [CONST#548643 DESC NULLS LAST]
(23) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548634, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548635, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548636, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#548637, CONST#548643, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#548650, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#548650]
(24) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548634, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548635, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548636, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#548637, CONST#548643, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#548650]
(25) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548634, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548635, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548636, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#548637, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#548650]
(26) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548634 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548662, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548635 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548663, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548636 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548664, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#548637 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#548665, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#548650 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#548666]
(27) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548662 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548672, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548663 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548673, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548664 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548674, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#548665 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#548675, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#548666 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#548676]
(28) Filter
Arguments: (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#548676 <=> cast(1 as int))
(29) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548672 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#548682, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548673 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#548683, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548674 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#548684, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#548675 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#548685]