== 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_226115169`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#524603, UF#524604, Date entrée#524605, Heure entrée#524606, Transport admission#524607, Niveau CCMU#524608, Date sortie#524609, Heure sortie#524610], false
(4) Project
Arguments: [Numéro Séjour#524603, UF#524604, Date entrée#524605, Heure entrée#524606, Transport admission#524607, Niveau CCMU#524608]
(5) Project
Arguments: [Numéro Séjour#524603 AS Numéro Séjour#524626, UF#524604 AS UF#524627, Date entrée#524605 AS Date entrée#524628, Heure entrée#524606 AS Heure entrée#524629, Transport admission#524607 AS Transport admission#524630, Niveau CCMU#524608 AS Niveau CCMU#524631]
(6) Project
Arguments: [Numéro Séjour#524626, UF#524627, Date entrée#524628, Heure entrée#524629, Transport admission#524630, Niveau CCMU#524631]
(7) Project
Arguments: [Niveau CCMU#524631 AS NIVEAU_CCMU_225626#524644, Numéro Séjour#524626 AS NUMEROSEJOUR_225623#524645, cast(str_remove_space(Transport admission#524630, cast(ONLY_ONE as string)) as string) AS TRANSPORT_UTILI_225625#524648, UF#524627 AS UF_225624#524647]
(8) Project
Arguments: [NIVEAU_CCMU_225626#524644, NUMEROSEJOUR_225623#524645, TRANSPORT_UTILI_225625#524648, UF_225624#524647]
(9) View
Arguments: `02_PASSAGE_PATI_225622169`, true
(10) SubqueryAlias
Arguments: 02_PASSAGE_PATI_225622169
(11) Project
Arguments: [NIVEAU_CCMU_225626#524644 AS 02_PASSAGE_PATI_225622_NIVEAU_CCMU_225626#524661, NUMEROSEJOUR_225623#524645 AS 02_PASSAGE_PATI_225622_NUMEROSEJOUR_225623#524662, TRANSPORT_UTILI_225625#524648 AS 02_PASSAGE_PATI_225622_TRANSPORT_UTILI_225625#524663, UF_225624#524647 AS 02_PASSAGE_PATI_225622_UF_225624#524664]
(12) Project
Arguments: [cast(02_PASSAGE_PATI_225622_NUMEROSEJOUR_225623#524662 as string) AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524673, cast(02_PASSAGE_PATI_225622_UF_225624#524664 as string) AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524674, cast(02_PASSAGE_PATI_225622_TRANSPORT_UTILI_225625#524663 as string) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524675, cast(02_PASSAGE_PATI_225622_NIVEAU_CCMU_225626#524661 as string) AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#524676]
(13) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524673 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524681, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524674 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524682, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524675 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524683, COL_7B923915_1CBF_4603_AB03_C432E00454ED#524676 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#524684]
(14) Filter
Arguments: NOT CASE WHEN isnull(StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524681, cast(# as string))) THEN false ELSE StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524681, cast(# as string)) END
(15) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524681 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524689, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524682 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524690, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524683 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524691, COL_7B923915_1CBF_4603_AB03_C432E00454ED#524684 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#524692]
(16) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524689 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524697, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524690 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524698, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524691 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524699, COL_7B923915_1CBF_4603_AB03_C432E00454ED#524692 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#524700]
(17) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524697, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524698, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524699, COL_7B923915_1CBF_4603_AB03_C432E00454ED#524700, str_remove_space(str_list_get(str_extract_by_regex(COL_7B923915_1CBF_4603_AB03_C432E00454ED#524700, cast([+\d]+ as string)), cast(0 as bigint)), cast(ALL as string)) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524705]
(18) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524697 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524711, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524698 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524712, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524699 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524713, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524705 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524714]
(19) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524711 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524712 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524720, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524713 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524721, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524714 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524722]
(20) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524720, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524721, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524722, 1 AS CONST#524728]
(21) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524720, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524721, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524722, CONST#524728]
(22) Window
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719, CONST#524728 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#524768], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719], [CONST#524728 DESC NULLS LAST]
(23) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524720, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524721, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524722, CONST#524728, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#524768, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#524768]
(24) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524720, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524721, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524722, CONST#524728, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#524768]
(25) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524720, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524721, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524722, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#524768]
(26) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524719 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524813, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524720 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524814, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524721 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524815, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524722 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524816, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#524768 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#524817]
(27) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524813 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524823, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524814 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524824, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524815 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524825, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524816 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524826, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#524817 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#524827]
(28) Filter
Arguments: (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#524827 <=> cast(1 as int))
(29) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524823 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#524833, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524824 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#524834, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524825 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#524835, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524826 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#524836]