== 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_226115170`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#545663, UF#545664, Date entrée#545665, Heure entrée#545666, Transport admission#545667, Niveau CCMU#545668, Date sortie#545669, Heure sortie#545670], false
(4) Project
Arguments: [Numéro Séjour#545663, UF#545664, Date entrée#545665, Heure entrée#545666, Transport admission#545667, Niveau CCMU#545668]
(5) Project
Arguments: [Numéro Séjour#545663 AS Numéro Séjour#545695, UF#545664 AS UF#545696, Date entrée#545665 AS Date entrée#545697, Heure entrée#545666 AS Heure entrée#545698, Transport admission#545667 AS Transport admission#545699, Niveau CCMU#545668 AS Niveau CCMU#545700]
(6) Project
Arguments: [Numéro Séjour#545695, UF#545696, Date entrée#545697, Heure entrée#545698, Transport admission#545699, Niveau CCMU#545700]
(7) Project
Arguments: [Niveau CCMU#545700 AS NIVEAU_CCMU_225626#545720, Numéro Séjour#545695 AS NUMEROSEJOUR_225623#545721, cast(str_remove_space(Transport admission#545699, cast(ONLY_ONE as string)) as string) AS TRANSPORT_UTILI_225625#545724, UF#545696 AS UF_225624#545723]
(8) Project
Arguments: [NIVEAU_CCMU_225626#545720, NUMEROSEJOUR_225623#545721, TRANSPORT_UTILI_225625#545724, UF_225624#545723]
(9) View
Arguments: `02_PASSAGE_PATI_225622170`, true
(10) SubqueryAlias
Arguments: 02_PASSAGE_PATI_225622170
(11) Project
Arguments: [NIVEAU_CCMU_225626#545720 AS 02_PASSAGE_PATI_225622_NIVEAU_CCMU_225626#545763, NUMEROSEJOUR_225623#545721 AS 02_PASSAGE_PATI_225622_NUMEROSEJOUR_225623#545764, TRANSPORT_UTILI_225625#545724 AS 02_PASSAGE_PATI_225622_TRANSPORT_UTILI_225625#545765, UF_225624#545723 AS 02_PASSAGE_PATI_225622_UF_225624#545766]
(12) Project
Arguments: [cast(02_PASSAGE_PATI_225622_NUMEROSEJOUR_225623#545764 as string) AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545781, cast(02_PASSAGE_PATI_225622_UF_225624#545766 as string) AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545782, cast(02_PASSAGE_PATI_225622_TRANSPORT_UTILI_225625#545765 as string) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545783, cast(02_PASSAGE_PATI_225622_NIVEAU_CCMU_225626#545763 as string) AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#545784]
(13) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545781 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545789, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545782 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545790, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545783 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545791, COL_7B923915_1CBF_4603_AB03_C432E00454ED#545784 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#545792]
(14) Filter
Arguments: NOT CASE WHEN isnull(StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545789, cast(# as string))) THEN false ELSE StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545789, cast(# as string)) END
(15) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545789 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545797, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545790 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545798, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545791 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545799, COL_7B923915_1CBF_4603_AB03_C432E00454ED#545792 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#545800]
(16) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545797 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545812, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545798 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545813, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545799 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545814, COL_7B923915_1CBF_4603_AB03_C432E00454ED#545800 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#545815]
(17) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545812, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545813, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545814, COL_7B923915_1CBF_4603_AB03_C432E00454ED#545815, str_remove_space(str_list_get(str_extract_by_regex(COL_7B923915_1CBF_4603_AB03_C432E00454ED#545815, cast([+\d]+ as string)), cast(0 as bigint)), cast(ALL as string)) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#545820]
(18) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545812 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545826, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545813 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545827, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545814 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545828, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#545820 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#545829]
(19) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545826 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545827 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545843, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545828 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545844, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#545829 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#545845]
(20) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545843, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545844, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#545845, 1 AS CONST#545851]
(21) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545843, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545844, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#545845, CONST#545851]
(22) Window
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842, CONST#545851 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#545858], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842], [CONST#545851 DESC NULLS LAST]
(23) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545843, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545844, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#545845, CONST#545851, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#545858, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#545858]
(24) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545843, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545844, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#545845, CONST#545851, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#545858]
(25) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545843, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545844, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#545845, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#545858]
(26) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545842 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545879, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545843 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545880, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545844 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545881, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#545845 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#545882, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#545858 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#545883]
(27) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545879 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545898, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545880 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545899, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545881 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545900, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#545882 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#545901, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#545883 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#545902]
(28) Filter
Arguments: (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#545902 <=> cast(1 as int))
(29) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545898 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#545909, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545899 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#545910, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545900 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#545911, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#545901 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#545912]