== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (37)
+- Filter (36)
+- GlobalLimit (35)
+- LocalLimit (34)
+- Project (33)
+- Project (32)
+- Project (31)
+- Filter (30)
+- GlobalLimit (29)
+- LocalLimit (28)
+- Project (27)
+- Join (26)
:- Project (16)
: +- Project (15)
: +- Project (14)
: +- SubqueryAlias (13)
: +- View (12)
: +- Project (11)
: +- Project (10)
: +- Project (9)
: +- Project (8)
: +- Project (7)
: +- Project (6)
: +- Project (5)
: +- Project (4)
: +- LogicalRelation (3)
+- Project (25)
+- SubqueryAlias (24)
+- View (23)
+- Project (22)
+- Project (21)
+- Project (20)
+- Project (19)
+- Project (18)
+- LogicalRelation (17)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `01_VERIFICATION_188274168`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Libell%C3%A9#725807, Finess#725808, Type+etab#725809, 09_INFORMATION__187906HEADER_COL_DETAIL_DEPOT#725810], false
(4) Project
Arguments: [Libell%C3%A9#725807 AS Libellé#725816, Finess#725808, Type+etab#725809, 09_INFORMATION__187906HEADER_COL_DETAIL_DEPOT#725810]
(5) Project
Arguments: [Libellé#725816, Finess#725808 AS Finess#725822, Type+etab#725809, 09_INFORMATION__187906HEADER_COL_DETAIL_DEPOT#725810]
(6) Project
Arguments: [Libellé#725816, Finess#725822, Type+etab#725809 AS Type etab#725827, 09_INFORMATION__187906HEADER_COL_DETAIL_DEPOT#725810]
(7) Project
Arguments: [Libellé#725816, Finess#725822, Type etab#725827, 09_INFORMATION__187906HEADER_COL_DETAIL_DEPOT#725810 AS 09_INFORMATION__187906HEADER_COL_DETAIL_DEPOT#725832]
(8) Project
Arguments: [Libellé#725816 AS Libellé#725837, Finess#725822 AS Finess#725838, Type etab#725827 AS Type etab#725839, 09_INFORMATION__187906HEADER_COL_DETAIL_DEPOT#725832 AS 09_INFORMATION__187906HEADER_COL_DETAIL_DEPOT#725840]
(9) Project
Arguments: [Libellé#725837, Finess#725838, Type etab#725839, 09_INFORMATION__187906HEADER_COL_DETAIL_DEPOT#725840]
(10) Project
Arguments: [Finess#725838 AS FINESS_188044#725850, Libellé#725837 AS LIBELLE_188043#725851, Type etab#725839 AS TYPE_ETAB_188045#725852]
(11) Project
Arguments: [FINESS_188044#725850, LIBELLE_188043#725851, TYPE_ETAB_188045#725852, str_extract(FINESS_188044#725850, cast(LEFT as string), cast(2 as bigint)) AS DEPARTEMENTETAB_188046#725856]
(12) View
Arguments: `09_INFORMATION__188042168`, true
(13) SubqueryAlias
Arguments: 09_INFORMATION__188042168
(14) Project
Arguments: [FINESS_188044#725850 AS 09_INFORMATION__188042_FINESS_188044#725977, LIBELLE_188043#725851 AS 09_INFORMATION__188042_LIBELLE_188043#725978, TYPE_ETAB_188045#725852 AS 09_INFORMATION__188042_TYPE_ETAB_188045#725979, DEPARTEMENTETAB_188046#725856 AS 09_INFORMATION__188042_DEPARTEMENTETAB_188046#725980]
(15) Project
Arguments: [cast(09_INFORMATION__188042_LIBELLE_188043#725978 as string) AS COL_402B2A13_7606_4671_A394_0B75C6676EA7#725988, cast(09_INFORMATION__188042_FINESS_188044#725977 as string) AS COL_3962736D_903D_4A11_BD29_2F959542F6D6#725989, cast(09_INFORMATION__188042_TYPE_ETAB_188045#725979 as string) AS COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#725990]
(16) Project
Arguments: [COL_402B2A13_7606_4671_A394_0B75C6676EA7#725988 AS COL_402B2A13_7606_4671_A394_0B75C6676EA7#725994, COL_3962736D_903D_4A11_BD29_2F959542F6D6#725989 AS COL_3962736D_903D_4A11_BD29_2F959542F6D6#725995, COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#725990 AS COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#725996]
(17) LogicalRelation
Arguments: csv, [_c0#725952], false
(18) Project
Arguments: [_c0#725952 AS COLL0#725954]
(19) Project
Arguments: [COLL0#725954 AS COLL0#725957]
(20) Project
Arguments: [COLL0#725957, CREATE_DEPOT_METADATA({"reader_type":"CSV","current_version_mask":"{*rsf*.*,*RSF*.*}","sep":";","quote":"","header":false,"charset":"DEFAULT"}, {"type":"connector.mapping.sftp","user_configured_path":"","local":false,"host":"sftp.adobiscloud.ovh","port":22,"username":"App_250000015","type":"connector.mapping.sftp"}, input_file_name()) AS COLL1#725959]
(21) Project
Arguments: [COLL0#725957 AS LIGNE_REFERENCE_187999#725962, cast(str_if_with_rule(((((((CASE WHEN isnull(StartsWith(COLL0#725957, cast(A as string))) THEN false ELSE StartsWith(COLL0#725957, cast(A as string)) END OR CASE WHEN isnull(StartsWith(COLL0#725957, cast(B as string))) THEN false ELSE StartsWith(COLL0#725957, cast(B as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#725957, cast(C as string))) THEN false ELSE StartsWith(COLL0#725957, cast(C as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#725957, cast(H as string))) THEN false ELSE StartsWith(COLL0#725957, cast(H as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#725957, cast(L as string))) THEN false ELSE StartsWith(COLL0#725957, cast(L as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#725957, cast(M as string))) THEN false ELSE StartsWith(COLL0#725957, cast(M as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#725957, cast(P as string))) THEN false ELSE StartsWith(COLL0#725957, cast(P as string)) END), str_extract_middle(COLL0#725957, cast(2 as bigint), cast(9 as bigint)), cast(null as string)) as string) AS N_FINESS_188001#725966, cast(get_json_object(COLL1#725959, cast($.file as string)) as string) AS SOURCE_188000#725965]
(22) Project
Arguments: [LIGNE_REFERENCE_187999#725962, N_FINESS_188001#725966, SOURCE_188000#725965]
(23) View
Arguments: `01_RSF_187998168`, true
(24) SubqueryAlias
Arguments: 01_RSF_187998168
(25) Project
Arguments: [LIGNE_REFERENCE_187999#725962 AS 01_RSF_187998_LIGNE_REFERENCE_187999#726003, N_FINESS_188001#725966 AS 01_RSF_187998_N_FINESS_188001#726004, SOURCE_188000#725965 AS 01_RSF_187998_SOURCE_188000#726005]
(26) Join
Arguments: LeftOuter, (COL_3962736D_903D_4A11_BD29_2F959542F6D6#725995 = 01_RSF_187998_N_FINESS_188001#726004)
(27) Project
Arguments: [COL_402B2A13_7606_4671_A394_0B75C6676EA7#725994, COL_3962736D_903D_4A11_BD29_2F959542F6D6#725995, COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#725996, 01_RSF_187998_N_FINESS_188001#726004 AS COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#726021]
(28) LocalLimit
Arguments: 5
(29) GlobalLimit
Arguments: 5
(30) Filter
Arguments: isnotnull(COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#726021)
(31) Project
Arguments: [COL_402B2A13_7606_4671_A394_0B75C6676EA7#725994 AS COL_402B2A13_7606_4671_A394_0B75C6676EA7#726026, COL_3962736D_903D_4A11_BD29_2F959542F6D6#725995 AS COL_3962736D_903D_4A11_BD29_2F959542F6D6#726027, COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#725996 AS COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#726028, COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#726021 AS COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#726029]
(32) Project
Arguments: [COL_402B2A13_7606_4671_A394_0B75C6676EA7#726026 AS COL_402B2A13_7606_4671_A394_0B75C6676EA7#726034, COL_3962736D_903D_4A11_BD29_2F959542F6D6#726027 AS COL_3962736D_903D_4A11_BD29_2F959542F6D6#726035, COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#726028 AS COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#726036, COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#726029 AS COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#726037]
(33) Project
Arguments: [COL_402B2A13_7606_4671_A394_0B75C6676EA7#726034, COL_3962736D_903D_4A11_BD29_2F959542F6D6#726035, COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#726036, COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#726037, str_if_with_rule(isnull(COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#726037), cast(0 as string), cast(1 as string)) AS COL_C3964EA1_3B75_4A61_B2EA_1C0E99C03688#726042]
(34) LocalLimit
Arguments: 1
(35) GlobalLimit
Arguments: 1
(36) Filter
Arguments: true
(37) Project
Arguments: [COL_402B2A13_7606_4671_A394_0B75C6676EA7#726034 AS COL_402B2A13_7606_4671_A394_0B75C6676EA7#726048, COL_3962736D_903D_4A11_BD29_2F959542F6D6#726035 AS COL_3962736D_903D_4A11_BD29_2F959542F6D6#726049, COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#726036 AS COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#726050, COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#726037 AS COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#726051, COL_C3964EA1_3B75_4A61_B2EA_1C0E99C03688#726042 AS COL_C3964EA1_3B75_4A61_B2EA_1C0E99C03688#726052]