== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (8)
+- Project (7)
+- Project (6)
+- Project (5)
+- Project (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `01_RSF_202944172`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [_c0#1202398], false
(4) Project
Arguments: [_c0#1202398 AS COLL0#1202400]
(5) Project
Arguments: [COLL0#1202400 AS COLL0#1202403]
(6) Project
Arguments: [COLL0#1202403, 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#1202405]
(7) Project
Arguments: [COLL0#1202403 AS LIGNE_REFERENCE_202945#1202408, cast(str_if_with_rule(((((((CASE WHEN isnull(StartsWith(COLL0#1202403, cast(A as string))) THEN false ELSE StartsWith(COLL0#1202403, cast(A as string)) END OR CASE WHEN isnull(StartsWith(COLL0#1202403, cast(B as string))) THEN false ELSE StartsWith(COLL0#1202403, cast(B as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#1202403, cast(C as string))) THEN false ELSE StartsWith(COLL0#1202403, cast(C as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#1202403, cast(H as string))) THEN false ELSE StartsWith(COLL0#1202403, cast(H as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#1202403, cast(L as string))) THEN false ELSE StartsWith(COLL0#1202403, cast(L as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#1202403, cast(M as string))) THEN false ELSE StartsWith(COLL0#1202403, cast(M as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#1202403, cast(P as string))) THEN false ELSE StartsWith(COLL0#1202403, cast(P as string)) END), str_extract_middle(COLL0#1202403, cast(2 as bigint), cast(9 as bigint)), cast(null as string)) as string) AS N_FINESS_202947#1202412, cast(get_json_object(COLL1#1202405, cast($.file as string)) as string) AS SOURCE_202946#1202411]
(8) Project
Arguments: [LIGNE_REFERENCE_202945#1202408, N_FINESS_202947#1202412, SOURCE_202946#1202411]