== 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_176400173`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#1137634, UF#1137635, Date entrée#1137636, Heure entrée#1137637, Transport admission#1137638, Niveau CCMU#1137639, Date sortie#1137640, Heure sortie#1137641], false
(4) Project
Arguments: [Numéro Séjour#1137634, UF#1137635, Date entrée#1137636, Heure entrée#1137637, Transport admission#1137638, Niveau CCMU#1137639]
(5) Project
Arguments: [Numéro Séjour#1137634 AS Numéro Séjour#1137657, UF#1137635 AS UF#1137658, Date entrée#1137636 AS Date entrée#1137659, Heure entrée#1137637 AS Heure entrée#1137660, Transport admission#1137638 AS Transport admission#1137661, Niveau CCMU#1137639 AS Niveau CCMU#1137662]
(6) Project
Arguments: [Numéro Séjour#1137657, UF#1137658, Date entrée#1137659, Heure entrée#1137660, Transport admission#1137661, Niveau CCMU#1137662]
(7) Project
Arguments: [Niveau CCMU#1137662 AS NIVEAU_CCMU_175794#1137675, Numéro Séjour#1137657 AS NUMEROSEJOUR_175791#1137676, cast(str_remove_space(Transport admission#1137661, cast(ONLY_ONE as string)) as string) AS TRANSPORT_UTILI_175793#1137679, UF#1137658 AS UF_175792#1137678]
(8) Project
Arguments: [NIVEAU_CCMU_175794#1137675, NUMEROSEJOUR_175791#1137676, TRANSPORT_UTILI_175793#1137679, UF_175792#1137678]
(9) View
Arguments: `02_PASSAGE_PATI_175790173`, true
(10) SubqueryAlias
Arguments: 02_PASSAGE_PATI_175790173
(11) Project
Arguments: [NIVEAU_CCMU_175794#1137675 AS 02_PASSAGE_PATI_175790_NIVEAU_CCMU_175794#1137693, NUMEROSEJOUR_175791#1137676 AS 02_PASSAGE_PATI_175790_NUMEROSEJOUR_175791#1137694, TRANSPORT_UTILI_175793#1137679 AS 02_PASSAGE_PATI_175790_TRANSPORT_UTILI_175793#1137695, UF_175792#1137678 AS 02_PASSAGE_PATI_175790_UF_175792#1137696]
(12) Project
Arguments: [cast(02_PASSAGE_PATI_175790_NUMEROSEJOUR_175791#1137694 as string) AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137705, cast(02_PASSAGE_PATI_175790_UF_175792#1137696 as string) AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137706, cast(02_PASSAGE_PATI_175790_TRANSPORT_UTILI_175793#1137695 as string) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137707, cast(02_PASSAGE_PATI_175790_NIVEAU_CCMU_175794#1137693 as string) AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1137708]
(13) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137705 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137715, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137706 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137716, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137707 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137717, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1137708 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1137718]
(14) Filter
Arguments: NOT CASE WHEN isnull(StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137715, cast(# as string))) THEN false ELSE StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137715, cast(# as string)) END
(15) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137715 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137726, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137716 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137727, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137717 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137728, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1137718 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1137729]
(16) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137726 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137736, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137727 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137737, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137728 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137738, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1137729 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1137739]
(17) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137736, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137737, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137738, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1137739, str_remove_space(str_list_get(str_extract_by_regex(COL_7B923915_1CBF_4603_AB03_C432E00454ED#1137739, cast([+\d]+ as string)), cast(0 as bigint)), cast(ALL as string)) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137745]
(18) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137736 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137756, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137737 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137757, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137738 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137758, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137745 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137759]
(19) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137756 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137765, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137757 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137766, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137758 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137767, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137759 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137768]
(20) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137765, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137766, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137767, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137768, 1 AS CONST#1137775]
(21) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137765, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137766, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137767, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137768, CONST#1137775]
(22) Window
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137765, CONST#1137775 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137782], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137765], [CONST#1137775 DESC NULLS LAST]
(23) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137765, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137766, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137767, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137768, CONST#1137775, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137782, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137782]
(24) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137765, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137766, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137767, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137768, CONST#1137775, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137782]
(25) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137765, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137766, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137767, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137768, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137782]
(26) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137765 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137800, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137766 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137801, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137767 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137802, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137768 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137803, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137782 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137804]
(27) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137800 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137816, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137801 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137817, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137802 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137818, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137803 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137819, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137804 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137820]
(28) Filter
Arguments: (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1137820 <=> cast(1 as int))
(29) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137816 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1137845, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137817 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1137846, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137818 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1137847, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137819 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1137848]