== 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_203036168`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Libell%C3%A9#1052936, Finess#1052937, Type+etab#1052938, 09_INFORMATION__202852HEADER_COL_DETAIL_DEPOT#1052939], false
(4) Project
Arguments: [Libell%C3%A9#1052936 AS Libellé#1052944, Finess#1052937, Type+etab#1052938, 09_INFORMATION__202852HEADER_COL_DETAIL_DEPOT#1052939]
(5) Project
Arguments: [Libellé#1052944, Finess#1052937 AS Finess#1052950, Type+etab#1052938, 09_INFORMATION__202852HEADER_COL_DETAIL_DEPOT#1052939]
(6) Project
Arguments: [Libellé#1052944, Finess#1052950, Type+etab#1052938 AS Type etab#1052955, 09_INFORMATION__202852HEADER_COL_DETAIL_DEPOT#1052939]
(7) Project
Arguments: [Libellé#1052944, Finess#1052950, Type etab#1052955, 09_INFORMATION__202852HEADER_COL_DETAIL_DEPOT#1052939 AS 09_INFORMATION__202852HEADER_COL_DETAIL_DEPOT#1052960]
(8) Project
Arguments: [Libellé#1052944 AS Libellé#1052965, Finess#1052950 AS Finess#1052966, Type etab#1052955 AS Type etab#1052967, 09_INFORMATION__202852HEADER_COL_DETAIL_DEPOT#1052960 AS 09_INFORMATION__202852HEADER_COL_DETAIL_DEPOT#1052968]
(9) Project
Arguments: [Libellé#1052965, Finess#1052966, Type etab#1052967, 09_INFORMATION__202852HEADER_COL_DETAIL_DEPOT#1052968]
(10) Project
Arguments: [Finess#1052966 AS FINESS_202990#1052977, Libellé#1052965 AS LIBELLE_202989#1052978, Type etab#1052967 AS TYPE_ETAB_202991#1052979]
(11) Project
Arguments: [FINESS_202990#1052977, LIBELLE_202989#1052978, TYPE_ETAB_202991#1052979, str_extract(FINESS_202990#1052977, cast(LEFT as string), cast(2 as bigint)) AS DEPARTEMENTETAB_202992#1052983]
(12) View
Arguments: `09_INFORMATION__202988168`, true
(13) SubqueryAlias
Arguments: 09_INFORMATION__202988168
(14) Project
Arguments: [FINESS_202990#1052977 AS 09_INFORMATION__202988_FINESS_202990#1052992, LIBELLE_202989#1052978 AS 09_INFORMATION__202988_LIBELLE_202989#1052993, TYPE_ETAB_202991#1052979 AS 09_INFORMATION__202988_TYPE_ETAB_202991#1052994, DEPARTEMENTETAB_202992#1052983 AS 09_INFORMATION__202988_DEPARTEMENTETAB_202992#1052995]
(15) Project
Arguments: [cast(09_INFORMATION__202988_LIBELLE_202989#1052993 as string) AS COL_402B2A13_7606_4671_A394_0B75C6676EA7#1053003, cast(09_INFORMATION__202988_FINESS_202990#1052992 as string) AS COL_3962736D_903D_4A11_BD29_2F959542F6D6#1053004, cast(09_INFORMATION__202988_TYPE_ETAB_202991#1052994 as string) AS COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#1053005]
(16) Project
Arguments: [COL_402B2A13_7606_4671_A394_0B75C6676EA7#1053003 AS COL_402B2A13_7606_4671_A394_0B75C6676EA7#1053009, COL_3962736D_903D_4A11_BD29_2F959542F6D6#1053004 AS COL_3962736D_903D_4A11_BD29_2F959542F6D6#1053010, COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#1053005 AS COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#1053011]
(17) LogicalRelation
Arguments: csv, [_c0#1052852], false
(18) Project
Arguments: [_c0#1052852 AS COLL0#1052858]
(19) Project
Arguments: [COLL0#1052858 AS COLL0#1052865]
(20) Project
Arguments: [COLL0#1052865, 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_360000053","type":"connector.mapping.sftp"}, input_file_name()) AS COLL1#1052867]
(21) Project
Arguments: [COLL0#1052865 AS LIGNE_REFERENCE_202945#1052870, cast(str_if_with_rule(((((((CASE WHEN isnull(StartsWith(COLL0#1052865, cast(A as string))) THEN false ELSE StartsWith(COLL0#1052865, cast(A as string)) END OR CASE WHEN isnull(StartsWith(COLL0#1052865, cast(B as string))) THEN false ELSE StartsWith(COLL0#1052865, cast(B as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#1052865, cast(C as string))) THEN false ELSE StartsWith(COLL0#1052865, cast(C as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#1052865, cast(H as string))) THEN false ELSE StartsWith(COLL0#1052865, cast(H as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#1052865, cast(L as string))) THEN false ELSE StartsWith(COLL0#1052865, cast(L as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#1052865, cast(M as string))) THEN false ELSE StartsWith(COLL0#1052865, cast(M as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#1052865, cast(P as string))) THEN false ELSE StartsWith(COLL0#1052865, cast(P as string)) END), str_extract_middle(COLL0#1052865, cast(2 as bigint), cast(9 as bigint)), cast(null as string)) as string) AS N_FINESS_202947#1052882, cast(get_json_object(COLL1#1052867, cast($.file as string)) as string) AS SOURCE_202946#1052877]
(22) Project
Arguments: [LIGNE_REFERENCE_202945#1052870, N_FINESS_202947#1052882, SOURCE_202946#1052877]
(23) View
Arguments: `01_RSF_202944168`, true
(24) SubqueryAlias
Arguments: 01_RSF_202944168
(25) Project
Arguments: [LIGNE_REFERENCE_202945#1052870 AS 01_RSF_202944_LIGNE_REFERENCE_202945#1053018, N_FINESS_202947#1052882 AS 01_RSF_202944_N_FINESS_202947#1053019, SOURCE_202946#1052877 AS 01_RSF_202944_SOURCE_202946#1053020]
(26) Join
Arguments: LeftOuter, (COL_3962736D_903D_4A11_BD29_2F959542F6D6#1053010 = 01_RSF_202944_N_FINESS_202947#1053019)
(27) Project
Arguments: [COL_402B2A13_7606_4671_A394_0B75C6676EA7#1053009, COL_3962736D_903D_4A11_BD29_2F959542F6D6#1053010, COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#1053011, 01_RSF_202944_N_FINESS_202947#1053019 AS COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#1053036]
(28) LocalLimit
Arguments: 5
(29) GlobalLimit
Arguments: 5
(30) Filter
Arguments: isnotnull(COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#1053036)
(31) Project
Arguments: [COL_402B2A13_7606_4671_A394_0B75C6676EA7#1053009 AS COL_402B2A13_7606_4671_A394_0B75C6676EA7#1053041, COL_3962736D_903D_4A11_BD29_2F959542F6D6#1053010 AS COL_3962736D_903D_4A11_BD29_2F959542F6D6#1053042, COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#1053011 AS COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#1053043, COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#1053036 AS COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#1053044]
(32) Project
Arguments: [COL_402B2A13_7606_4671_A394_0B75C6676EA7#1053041 AS COL_402B2A13_7606_4671_A394_0B75C6676EA7#1053049, COL_3962736D_903D_4A11_BD29_2F959542F6D6#1053042 AS COL_3962736D_903D_4A11_BD29_2F959542F6D6#1053050, COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#1053043 AS COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#1053051, COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#1053044 AS COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#1053052]
(33) Project
Arguments: [COL_402B2A13_7606_4671_A394_0B75C6676EA7#1053049, COL_3962736D_903D_4A11_BD29_2F959542F6D6#1053050, COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#1053051, COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#1053052, str_if_with_rule(isnull(COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#1053052), cast(0 as string), cast(1 as string)) AS COL_C3964EA1_3B75_4A61_B2EA_1C0E99C03688#1053057]
(34) LocalLimit
Arguments: 1
(35) GlobalLimit
Arguments: 1
(36) Filter
Arguments: true
(37) Project
Arguments: [COL_402B2A13_7606_4671_A394_0B75C6676EA7#1053049 AS COL_402B2A13_7606_4671_A394_0B75C6676EA7#1053063, COL_3962736D_903D_4A11_BD29_2F959542F6D6#1053050 AS COL_3962736D_903D_4A11_BD29_2F959542F6D6#1053064, COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#1053051 AS COL_1B03A91F_D6E9_4309_A08C_A44F9F036E83#1053065, COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#1053052 AS COL_D23D34B6_9AC6_4DFF_98FC_8F87272749FE#1053066, COL_C3964EA1_3B75_4A61_B2EA_1C0E99C03688#1053057 AS COL_C3964EA1_3B75_4A61_B2EA_1C0E99C03688#1053067]