Project [COLL0#1189528 AS COL_B706A975_F287_4DC9_B631_A35735FE936F#1189556, get_json_object(COLL1#1189530, $.file) AS COL_6D456B4D_C94A_422F_8C8D_7901B930826A#1189557, str_if_with_rule(((((((CASE WHEN isnull(StartsWith(COLL0#1189528, A)) THEN false ELSE StartsWith(COLL0#1189528, A) END OR CASE WHEN isnull(StartsWith(COLL0#1189528, B)) THEN false ELSE StartsWith(COLL0#1189528, B) END) OR CASE WHEN isnull(StartsWith(COLL0#1189528, C)) THEN false ELSE StartsWith(COLL0#1189528, C) END) OR CASE WHEN isnull(StartsWith(COLL0#1189528, H)) THEN false ELSE StartsWith(COLL0#1189528, H) END) OR CASE WHEN isnull(StartsWith(COLL0#1189528, L)) THEN false ELSE StartsWith(COLL0#1189528, L) END) OR CASE WHEN isnull(StartsWith(COLL0#1189528, M)) THEN false ELSE StartsWith(COLL0#1189528, M) END) OR CASE WHEN isnull(StartsWith(COLL0#1189528, P)) THEN false ELSE StartsWith(COLL0#1189528, P) END), str_extract_middle(COLL0#1189528, 2, 9), null) AS COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#1189558]
Project [_c0#1189523 AS COLL0#1189528, 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_060780897","type":"connector.mapping.sftp"}, input_file_name()) AS COLL1#1189530]
== Physical Plan ==
CollectLimit (4)
+- Project (3)
+- * Project (2)
+- Scan csv (1)
(1) Scan csv
Output [1]: [_c0#1189523]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/RSF_SERVEUR_175680/RSF294001_221026TV.txt]
ReadSchema: struct<_c0:string>
(2) Project [codegen id : 1]
Output [2]: [_c0#1189523 AS COLL0#1189528, 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_060780897","type":"connector.mapping.sftp"}, input_file_name()) AS COLL1#1189530]
Input [1]: [_c0#1189523]
(3) Project
Output [3]: [COLL0#1189528 AS COL_B706A975_F287_4DC9_B631_A35735FE936F#1189556, get_json_object(COLL1#1189530, $.file) AS COL_6D456B4D_C94A_422F_8C8D_7901B930826A#1189557, str_if_with_rule(((((((CASE WHEN isnull(StartsWith(COLL0#1189528, A)) THEN false ELSE StartsWith(COLL0#1189528, A) END OR CASE WHEN isnull(StartsWith(COLL0#1189528, B)) THEN false ELSE StartsWith(COLL0#1189528, B) END) OR CASE WHEN isnull(StartsWith(COLL0#1189528, C)) THEN false ELSE StartsWith(COLL0#1189528, C) END) OR CASE WHEN isnull(StartsWith(COLL0#1189528, H)) THEN false ELSE StartsWith(COLL0#1189528, H) END) OR CASE WHEN isnull(StartsWith(COLL0#1189528, L)) THEN false ELSE StartsWith(COLL0#1189528, L) END) OR CASE WHEN isnull(StartsWith(COLL0#1189528, M)) THEN false ELSE StartsWith(COLL0#1189528, M) END) OR CASE WHEN isnull(StartsWith(COLL0#1189528, P)) THEN false ELSE StartsWith(COLL0#1189528, P) END), str_extract_middle(COLL0#1189528, 2, 9), null) AS COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#1189558]
Input [2]: [COLL0#1189528, COLL1#1189530]
(4) CollectLimit
Input [3]: [COL_B706A975_F287_4DC9_B631_A35735FE936F#1189556, COL_6D456B4D_C94A_422F_8C8D_7901B930826A#1189557, COL_38F08DCE_0F1B_4F1E_9BE4_60C67BA99DC8#1189558]
Arguments: 1500