== 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_226115167`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#537331, UF#537332, Date entrée#537333, Heure entrée#537334, Transport admission#537335, Niveau CCMU#537336, Date sortie#537337, Heure sortie#537338], false
(4) Project
Arguments: [Numéro Séjour#537331, UF#537332, Date entrée#537333, Heure entrée#537334, Transport admission#537335, Niveau CCMU#537336]
(5) Project
Arguments: [Numéro Séjour#537331 AS Numéro Séjour#537354, UF#537332 AS UF#537355, Date entrée#537333 AS Date entrée#537356, Heure entrée#537334 AS Heure entrée#537357, Transport admission#537335 AS Transport admission#537358, Niveau CCMU#537336 AS Niveau CCMU#537359]
(6) Project
Arguments: [Numéro Séjour#537354, UF#537355, Date entrée#537356, Heure entrée#537357, Transport admission#537358, Niveau CCMU#537359]
(7) Project
Arguments: [Niveau CCMU#537359 AS NIVEAU_CCMU_225626#537372, Numéro Séjour#537354 AS NUMEROSEJOUR_225623#537373, cast(str_remove_space(Transport admission#537358, cast(ONLY_ONE as string)) as string) AS TRANSPORT_UTILI_225625#537376, UF#537355 AS UF_225624#537375]
(8) Project
Arguments: [NIVEAU_CCMU_225626#537372, NUMEROSEJOUR_225623#537373, TRANSPORT_UTILI_225625#537376, UF_225624#537375]
(9) View
Arguments: `02_PASSAGE_PATI_225622167`, true
(10) SubqueryAlias
Arguments: 02_PASSAGE_PATI_225622167
(11) Project
Arguments: [NIVEAU_CCMU_225626#537372 AS 02_PASSAGE_PATI_225622_NIVEAU_CCMU_225626#537389, NUMEROSEJOUR_225623#537373 AS 02_PASSAGE_PATI_225622_NUMEROSEJOUR_225623#537390, TRANSPORT_UTILI_225625#537376 AS 02_PASSAGE_PATI_225622_TRANSPORT_UTILI_225625#537391, UF_225624#537375 AS 02_PASSAGE_PATI_225622_UF_225624#537392]
(12) Project
Arguments: [cast(02_PASSAGE_PATI_225622_NUMEROSEJOUR_225623#537390 as string) AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537401, cast(02_PASSAGE_PATI_225622_UF_225624#537392 as string) AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537402, cast(02_PASSAGE_PATI_225622_TRANSPORT_UTILI_225625#537391 as string) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537403, cast(02_PASSAGE_PATI_225622_NIVEAU_CCMU_225626#537389 as string) AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#537404]
(13) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537401 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537409, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537402 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537410, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537403 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537411, COL_7B923915_1CBF_4603_AB03_C432E00454ED#537404 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#537412]
(14) Filter
Arguments: NOT CASE WHEN isnull(StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537409, cast(# as string))) THEN false ELSE StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537409, cast(# as string)) END
(15) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537409 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537417, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537410 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537418, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537411 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537419, COL_7B923915_1CBF_4603_AB03_C432E00454ED#537412 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#537420]
(16) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537417 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537425, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537418 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537426, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537419 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537427, COL_7B923915_1CBF_4603_AB03_C432E00454ED#537420 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#537428]
(17) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537425, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537426, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537427, COL_7B923915_1CBF_4603_AB03_C432E00454ED#537428, str_remove_space(str_list_get(str_extract_by_regex(COL_7B923915_1CBF_4603_AB03_C432E00454ED#537428, cast([+\d]+ as string)), cast(0 as bigint)), cast(ALL as string)) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#537433]
(18) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537425 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537439, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537426 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537440, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537427 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537441, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#537433 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#537442]
(19) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537439 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537447, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537440 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537448, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537441 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537449, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#537442 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#537450]
(20) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537447, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537448, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537449, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#537450, 1 AS CONST#537456]
(21) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537447, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537448, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537449, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#537450, CONST#537456]
(22) Window
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537447, CONST#537456 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#537463], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537447], [CONST#537456 DESC NULLS LAST]
(23) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537447, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537448, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537449, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#537450, CONST#537456, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#537463, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#537463]
(24) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537447, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537448, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537449, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#537450, CONST#537456, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#537463]
(25) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537447, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537448, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537449, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#537450, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#537463]
(26) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537447 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537475, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537448 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537476, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537449 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537477, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#537450 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#537478, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#537463 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#537479]
(27) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537475 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537485, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537476 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537486, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537477 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537487, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#537478 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#537488, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#537479 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#537489]
(28) Filter
Arguments: (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#537489 <=> cast(1 as int))
(29) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537485 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#537495, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537486 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#537496, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537487 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#537497, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#537488 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#537498]