== 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_172820173`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#1142559, UF#1142560, Date entrée#1142561, Heure entrée#1142562, Transport admission#1142563, Niveau CCMU#1142564, Date sortie#1142565, heure sortie#1142566], false
(4) Project
Arguments: [Numéro Séjour#1142559, UF#1142560, Date entrée#1142561, Heure entrée#1142562, Transport admission#1142563, Niveau CCMU#1142564]
(5) Project
Arguments: [Numéro Séjour#1142559 AS Numéro Séjour#1142583, UF#1142560 AS UF#1142584, Date entrée#1142561 AS Date entrée#1142585, Heure entrée#1142562 AS Heure entrée#1142586, Transport admission#1142563 AS Transport admission#1142587, Niveau CCMU#1142564 AS Niveau CCMU#1142588]
(6) Project
Arguments: [Numéro Séjour#1142583, UF#1142584, Date entrée#1142585, Heure entrée#1142586, Transport admission#1142587, Niveau CCMU#1142588]
(7) Project
Arguments: [Niveau CCMU#1142588 AS NIVEAU_CCMU_172214#1142601, Numéro Séjour#1142583 AS NUMEROSEJOUR_172211#1142602, cast(str_remove_space(Transport admission#1142587, cast(ONLY_ONE as string)) as string) AS TRANSPORT_UTILI_172213#1142605, UF#1142584 AS UF_172212#1142604]
(8) Project
Arguments: [NIVEAU_CCMU_172214#1142601, NUMEROSEJOUR_172211#1142602, TRANSPORT_UTILI_172213#1142605, UF_172212#1142604]
(9) View
Arguments: `02_PASSAGE_PATI_172210173`, true
(10) SubqueryAlias
Arguments: 02_PASSAGE_PATI_172210173
(11) Project
Arguments: [NIVEAU_CCMU_172214#1142601 AS 02_PASSAGE_PATI_172210_NIVEAU_CCMU_172214#1142618, NUMEROSEJOUR_172211#1142602 AS 02_PASSAGE_PATI_172210_NUMEROSEJOUR_172211#1142619, TRANSPORT_UTILI_172213#1142605 AS 02_PASSAGE_PATI_172210_TRANSPORT_UTILI_172213#1142620, UF_172212#1142604 AS 02_PASSAGE_PATI_172210_UF_172212#1142621]
(12) Project
Arguments: [cast(02_PASSAGE_PATI_172210_NUMEROSEJOUR_172211#1142619 as string) AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142630, cast(02_PASSAGE_PATI_172210_UF_172212#1142621 as string) AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142631, cast(02_PASSAGE_PATI_172210_TRANSPORT_UTILI_172213#1142620 as string) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142632, cast(02_PASSAGE_PATI_172210_NIVEAU_CCMU_172214#1142618 as string) AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1142633]
(13) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142630 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142638, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142631 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142639, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142632 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142640, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1142633 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1142641]
(14) Filter
Arguments: NOT CASE WHEN isnull(StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142638, cast(# as string))) THEN false ELSE StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142638, cast(# as string)) END
(15) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142638 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142706, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142639 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142707, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142640 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142708, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1142641 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1142709]
(16) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142706 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142715, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142707 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142716, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142708 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142717, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1142709 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1142718]
(17) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142715, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142716, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142717, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1142718, str_remove_space(str_list_get(str_extract_by_regex(COL_7B923915_1CBF_4603_AB03_C432E00454ED#1142718, cast([+\d]+ as string)), cast(0 as bigint)), cast(ALL as string)) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1142723]
(18) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142715 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142729, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142716 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142730, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142717 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142731, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1142723 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1142732]
(19) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142729 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142737, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142730 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142738, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142731 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142739, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1142732 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1142740]
(20) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142737, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142738, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142739, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1142740, 1 AS CONST#1142746]
(21) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142737, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142738, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142739, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1142740, CONST#1142746]
(22) Window
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142737, CONST#1142746 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1142753], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142737], [CONST#1142746 DESC NULLS LAST]
(23) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142737, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142738, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142739, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1142740, CONST#1142746, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1142753, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1142753]
(24) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142737, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142738, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142739, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1142740, CONST#1142746, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1142753]
(25) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142737, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142738, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142739, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1142740, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1142753]
(26) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142737 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142826, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142738 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142827, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142739 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142828, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1142740 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1142829, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1142753 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1142830]
(27) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142826 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142836, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142827 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142837, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142828 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142838, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1142829 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1142839, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1142830 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1142840]
(28) Filter
Arguments: (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1142840 <=> cast(1 as int))
(29) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142836 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1142846, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142837 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1142847, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142838 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1142848, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1142839 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1142849]