== 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_172820175`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#1146639, UF#1146640, Date entrée#1146641, Heure entrée#1146642, Transport admission#1146643, Niveau CCMU#1146644, Date sortie#1146645, heure sortie#1146646], false
(4) Project
Arguments: [Numéro Séjour#1146639, UF#1146640, Date entrée#1146641, Heure entrée#1146642, Transport admission#1146643, Niveau CCMU#1146644]
(5) Project
Arguments: [Numéro Séjour#1146639 AS Numéro Séjour#1146714, UF#1146640 AS UF#1146715, Date entrée#1146641 AS Date entrée#1146716, Heure entrée#1146642 AS Heure entrée#1146717, Transport admission#1146643 AS Transport admission#1146718, Niveau CCMU#1146644 AS Niveau CCMU#1146719]
(6) Project
Arguments: [Numéro Séjour#1146714, UF#1146715, Date entrée#1146716, Heure entrée#1146717, Transport admission#1146718, Niveau CCMU#1146719]
(7) Project
Arguments: [Niveau CCMU#1146719 AS NIVEAU_CCMU_172214#1146732, Numéro Séjour#1146714 AS NUMEROSEJOUR_172211#1146733, cast(str_remove_space(Transport admission#1146718, cast(ONLY_ONE as string)) as string) AS TRANSPORT_UTILI_172213#1146736, UF#1146715 AS UF_172212#1146735]
(8) Project
Arguments: [NIVEAU_CCMU_172214#1146732, NUMEROSEJOUR_172211#1146733, TRANSPORT_UTILI_172213#1146736, UF_172212#1146735]
(9) View
Arguments: `02_PASSAGE_PATI_172210175`, true
(10) SubqueryAlias
Arguments: 02_PASSAGE_PATI_172210175
(11) Project
Arguments: [NIVEAU_CCMU_172214#1146732 AS 02_PASSAGE_PATI_172210_NIVEAU_CCMU_172214#1146749, NUMEROSEJOUR_172211#1146733 AS 02_PASSAGE_PATI_172210_NUMEROSEJOUR_172211#1146750, TRANSPORT_UTILI_172213#1146736 AS 02_PASSAGE_PATI_172210_TRANSPORT_UTILI_172213#1146751, UF_172212#1146735 AS 02_PASSAGE_PATI_172210_UF_172212#1146752]
(12) Project
Arguments: [cast(02_PASSAGE_PATI_172210_NUMEROSEJOUR_172211#1146750 as string) AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146761, cast(02_PASSAGE_PATI_172210_UF_172212#1146752 as string) AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146762, cast(02_PASSAGE_PATI_172210_TRANSPORT_UTILI_172213#1146751 as string) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146763, cast(02_PASSAGE_PATI_172210_NIVEAU_CCMU_172214#1146749 as string) AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1146764]
(13) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146761 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146769, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146762 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146770, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146763 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146771, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1146764 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1146772]
(14) Filter
Arguments: NOT CASE WHEN isnull(StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146769, cast(# as string))) THEN false ELSE StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146769, cast(# as string)) END
(15) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146769 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146803, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146770 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146804, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146771 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146805, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1146772 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1146806]
(16) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146803 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146837, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146804 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146838, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146805 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146839, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1146806 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1146840]
(17) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146837, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146838, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146839, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1146840, str_remove_space(str_list_get(str_extract_by_regex(COL_7B923915_1CBF_4603_AB03_C432E00454ED#1146840, cast([+\d]+ as string)), cast(0 as bigint)), cast(ALL as string)) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1146845]
(18) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146837 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146851, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146838 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146852, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146839 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146853, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1146845 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1146854]
(19) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146851 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146859, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146852 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146860, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146853 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146861, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1146854 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1146862]
(20) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146859, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146860, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146861, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1146862, 1 AS CONST#1146868]
(21) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146859, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146860, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146861, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1146862, CONST#1146868]
(22) Window
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146859, CONST#1146868 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1146877], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146859], [CONST#1146868 DESC NULLS LAST]
(23) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146859, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146860, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146861, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1146862, CONST#1146868, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1146877, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1146877]
(24) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146859, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146860, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146861, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1146862, CONST#1146868, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1146877]
(25) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146859, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146860, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146861, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1146862, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1146877]
(26) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146859 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146889, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146860 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146890, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146861 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146891, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1146862 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1146892, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1146877 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1146893]
(27) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146889 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146926, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146890 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146927, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146891 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146928, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1146892 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1146929, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1146893 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1146930]
(28) Filter
Arguments: (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1146930 <=> cast(1 as int))
(29) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146926 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1146936, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146927 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1146937, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146928 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1146938, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1146929 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1146939]