== 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_172197176`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [_c0#1172850], false
(4) Project
Arguments: [_c0#1172850 AS COLL0#1172852]
(5) Project
Arguments: [COLL0#1172852 AS COLL0#1172855]
(6) Project
Arguments: [COLL0#1172855, 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_610780074","type":"connector.mapping.sftp"}, input_file_name()) AS COLL1#1172857]
(7) Project
Arguments: [COLL0#1172855 AS LIGNE_REFERENCE_172198#1172860, cast(str_if_with_rule(((((((CASE WHEN isnull(StartsWith(COLL0#1172855, cast(A as string))) THEN false ELSE StartsWith(COLL0#1172855, cast(A as string)) END OR CASE WHEN isnull(StartsWith(COLL0#1172855, cast(B as string))) THEN false ELSE StartsWith(COLL0#1172855, cast(B as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#1172855, cast(C as string))) THEN false ELSE StartsWith(COLL0#1172855, cast(C as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#1172855, cast(H as string))) THEN false ELSE StartsWith(COLL0#1172855, cast(H as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#1172855, cast(L as string))) THEN false ELSE StartsWith(COLL0#1172855, cast(L as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#1172855, cast(M as string))) THEN false ELSE StartsWith(COLL0#1172855, cast(M as string)) END) OR CASE WHEN isnull(StartsWith(COLL0#1172855, cast(P as string))) THEN false ELSE StartsWith(COLL0#1172855, cast(P as string)) END), str_extract_middle(COLL0#1172855, cast(2 as bigint), cast(9 as bigint)), cast(null as string)) as string) AS N_FINESS_172200#1172864, cast(get_json_object(COLL1#1172857, cast($.file as string)) as string) AS SOURCE_172199#1172863]
(8) Project
Arguments: [LIGNE_REFERENCE_172198#1172860, N_FINESS_172200#1172864, SOURCE_172199#1172863]