== 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_161906176`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#2311398, UF#2311399, Date entrée#2311400, Heure entrée#2311401, Transport admission#2311402, Niveau CCMU#2311403, Date sortie#2311404, Heure sortie#2311405], false
(4) Project
Arguments: [Numéro Séjour#2311398, UF#2311399, Date entrée#2311400, Heure entrée#2311401, Transport admission#2311402, Niveau CCMU#2311403]
(5) Project
Arguments: [Numéro Séjour#2311398 AS Numéro Séjour#2311421, UF#2311399 AS UF#2311422, Date entrée#2311400 AS Date entrée#2311423, Heure entrée#2311401 AS Heure entrée#2311424, Transport admission#2311402 AS Transport admission#2311425, Niveau CCMU#2311403 AS Niveau CCMU#2311426]
(6) Project
Arguments: [Numéro Séjour#2311421, UF#2311422, Date entrée#2311423, Heure entrée#2311424, Transport admission#2311425, Niveau CCMU#2311426]
(7) Project
Arguments: [Niveau CCMU#2311426 AS NIVEAU_CCMU_161522#2311439, Numéro Séjour#2311421 AS NUMEROSEJOUR_161519#2311440, cast(str_remove_space(Transport admission#2311425, cast(ONLY_ONE as string)) as string) AS TRANSPORT_UTILI_161521#2311443, UF#2311422 AS UF_161520#2311442]
(8) Project
Arguments: [NIVEAU_CCMU_161522#2311439, NUMEROSEJOUR_161519#2311440, TRANSPORT_UTILI_161521#2311443, UF_161520#2311442]
(9) View
Arguments: `02_PASSAGE_PATI_161518176`, true
(10) SubqueryAlias
Arguments: 02_PASSAGE_PATI_161518176
(11) Project
Arguments: [NIVEAU_CCMU_161522#2311439 AS 02_PASSAGE_PATI_161518_NIVEAU_CCMU_161522#2311456, NUMEROSEJOUR_161519#2311440 AS 02_PASSAGE_PATI_161518_NUMEROSEJOUR_161519#2311457, TRANSPORT_UTILI_161521#2311443 AS 02_PASSAGE_PATI_161518_TRANSPORT_UTILI_161521#2311458, UF_161520#2311442 AS 02_PASSAGE_PATI_161518_UF_161520#2311459]
(12) Project
Arguments: [cast(02_PASSAGE_PATI_161518_NUMEROSEJOUR_161519#2311457 as string) AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311468, cast(02_PASSAGE_PATI_161518_UF_161520#2311459 as string) AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311469, cast(02_PASSAGE_PATI_161518_TRANSPORT_UTILI_161521#2311458 as string) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311470, cast(02_PASSAGE_PATI_161518_NIVEAU_CCMU_161522#2311456 as string) AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2311471]
(13) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311468 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311476, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311469 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311477, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311470 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311478, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2311471 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2311479]
(14) Filter
Arguments: NOT CASE WHEN isnull(StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311476, cast(# as string))) THEN false ELSE StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311476, cast(# as string)) END
(15) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311476 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311484, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311477 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311485, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311478 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311486, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2311479 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2311487]
(16) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311484 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311492, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311485 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311493, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311486 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311494, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2311487 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#2311495]
(17) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311492, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311493, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311494, COL_7B923915_1CBF_4603_AB03_C432E00454ED#2311495, str_remove_space(str_list_get(str_extract_by_regex(COL_7B923915_1CBF_4603_AB03_C432E00454ED#2311495, cast([+\d]+ as string)), cast(0 as bigint)), cast(ALL as string)) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311500]
(18) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311492 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311506, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311493 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311507, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311494 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311508, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311500 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311509]
(19) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311506 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311514, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311507 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311515, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311508 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311516, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311509 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311517]
(20) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311514, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311515, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311516, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311517, 1 AS CONST#2311523]
(21) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311514, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311515, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311516, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311517, CONST#2311523]
(22) Window
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311514, CONST#2311523 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311530], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311514], [CONST#2311523 DESC NULLS LAST]
(23) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311514, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311515, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311516, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311517, CONST#2311523, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311530, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311530]
(24) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311514, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311515, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311516, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311517, CONST#2311523, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311530]
(25) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311514, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311515, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311516, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311517, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311530]
(26) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311514 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311542, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311515 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311543, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311516 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311544, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311517 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311545, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311530 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311546]
(27) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311542 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311552, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311543 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311553, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311544 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311554, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311545 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311555, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311546 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311556]
(28) Filter
Arguments: (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#2311556 <=> cast(1 as int))
(29) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311552 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#2311562, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311553 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#2311563, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311554 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#2311564, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311555 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#2311565]