== 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_176400167`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#1174552, UF#1174553, Date entrée#1174554, Heure entrée#1174555, Transport admission#1174556, Niveau CCMU#1174557, Date sortie#1174558, Heure sortie#1174559], false
(4) Project
Arguments: [Numéro Séjour#1174552, UF#1174553, Date entrée#1174554, Heure entrée#1174555, Transport admission#1174556, Niveau CCMU#1174557]
(5) Project
Arguments: [Numéro Séjour#1174552 AS Numéro Séjour#1174592, UF#1174553 AS UF#1174593, Date entrée#1174554 AS Date entrée#1174594, Heure entrée#1174555 AS Heure entrée#1174595, Transport admission#1174556 AS Transport admission#1174596, Niveau CCMU#1174557 AS Niveau CCMU#1174597]
(6) Project
Arguments: [Numéro Séjour#1174592, UF#1174593, Date entrée#1174594, Heure entrée#1174595, Transport admission#1174596, Niveau CCMU#1174597]
(7) Project
Arguments: [Niveau CCMU#1174597 AS NIVEAU_CCMU_175794#1174610, Numéro Séjour#1174592 AS NUMEROSEJOUR_175791#1174611, cast(str_remove_space(Transport admission#1174596, cast(ONLY_ONE as string)) as string) AS TRANSPORT_UTILI_175793#1174614, UF#1174593 AS UF_175792#1174613]
(8) Project
Arguments: [NIVEAU_CCMU_175794#1174610, NUMEROSEJOUR_175791#1174611, TRANSPORT_UTILI_175793#1174614, UF_175792#1174613]
(9) View
Arguments: `02_PASSAGE_PATI_175790167`, true
(10) SubqueryAlias
Arguments: 02_PASSAGE_PATI_175790167
(11) Project
Arguments: [NIVEAU_CCMU_175794#1174610 AS 02_PASSAGE_PATI_175790_NIVEAU_CCMU_175794#1174645, NUMEROSEJOUR_175791#1174611 AS 02_PASSAGE_PATI_175790_NUMEROSEJOUR_175791#1174646, TRANSPORT_UTILI_175793#1174614 AS 02_PASSAGE_PATI_175790_TRANSPORT_UTILI_175793#1174647, UF_175792#1174613 AS 02_PASSAGE_PATI_175790_UF_175792#1174648]
(12) Project
Arguments: [cast(02_PASSAGE_PATI_175790_NUMEROSEJOUR_175791#1174646 as string) AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174657, cast(02_PASSAGE_PATI_175790_UF_175792#1174648 as string) AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174658, cast(02_PASSAGE_PATI_175790_TRANSPORT_UTILI_175793#1174647 as string) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174659, cast(02_PASSAGE_PATI_175790_NIVEAU_CCMU_175794#1174645 as string) AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1174660]
(13) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174657 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174665, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174658 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174666, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174659 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174667, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1174660 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1174668]
(14) Filter
Arguments: NOT CASE WHEN isnull(StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174665, cast(# as string))) THEN false ELSE StartsWith(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174665, cast(# as string)) END
(15) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174665 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174673, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174666 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174674, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174667 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174675, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1174668 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1174676]
(16) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174673 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174681, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174674 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174682, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174675 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174683, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1174676 AS COL_7B923915_1CBF_4603_AB03_C432E00454ED#1174684]
(17) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174681, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174682, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174683, COL_7B923915_1CBF_4603_AB03_C432E00454ED#1174684, str_remove_space(str_list_get(str_extract_by_regex(COL_7B923915_1CBF_4603_AB03_C432E00454ED#1174684, cast([+\d]+ as string)), cast(0 as bigint)), cast(ALL as string)) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1174689]
(18) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174681 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174695, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174682 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174696, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174683 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174697, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1174689 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1174698]
(19) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174695 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174703, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174696 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174704, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174697 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174705, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1174698 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1174706]
(20) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174703, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174704, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174705, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1174706, 1 AS CONST#1174727]
(21) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174703, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174704, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174705, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1174706, CONST#1174727]
(22) Window
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174703, CONST#1174727 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1174738], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174703], [CONST#1174727 DESC NULLS LAST]
(23) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174703, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174704, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174705, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1174706, CONST#1174727, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1174738, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1174738]
(24) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174703, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174704, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174705, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1174706, CONST#1174727, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1174738]
(25) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174703, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174704, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174705, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1174706, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1174738]
(26) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174703 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174759, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174704 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174760, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174705 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174761, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1174706 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1174762, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1174738 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1174763]
(27) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174759 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174769, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174760 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174770, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174761 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174771, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1174762 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1174772, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1174763 AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1174773]
(28) Filter
Arguments: (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#1174773 <=> cast(1 as int))
(29) Project
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174769 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#1174799, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174770 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#1174800, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174771 AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#1174801, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1174772 AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#1174802]