时间戳

首页 > 解决方案 > 雪花：错误：找到字符 '\u0086'' 而不是字段分隔符 ','

snowflake-cloud-data-platform - 雪花：错误：找到字符 '\u0086'' 而不是字段分隔符 ','

问题描述

尝试复制命令将文件加载到雪花中

无法弄清楚问题

错误：

ERROR - 100065 (22000): 01975398-0686-457e-0000-029178372dae: Found character '\u009d' instead of field delimiter ','
      File '/STAGEDW/2020-10-01/report_2020_05_20200702114836.gz', line 292, character 90
      Row 288 starts at line 291, column "TRANSIENT_STAGE_TABLE"[2]

文件格式是

{"TYPE":"CSV","RECORD_DELIMITER":"\n","FIELD_DELIMITER":",","FILE_EXTENSION":null,"SKIP_HEADER":1,"DATE_FORMAT":"AUTO","TIME_FORMAT":"AUTO","TIMESTAMP_FORMAT":"AUTO","BINARY_FORMAT":"HEX","ESCAPE":"NONE","ESCAPE_UNENCLOSED_FIELD":"\\","TRIM_SPACE":true,"FIELD_OPTIONALLY_ENCLOSED_BY":"\"","NULL_IF":[""],"COMPRESSION":"AUTO","ERROR_ON_COLUMN_COUNT_MISMATCH":true,"VALIDATE_UTF8":true,"SKIP_BLANK_LINES":false,"REPLACE_INVALID_CHARACTERS":false,"EMPTY_FIELD_AS_NULL":true,"SKIP_BYTE_ORDER_MARK":true,"ENCODING":"UTF8"}

在此处输入图像描述

当我将 ENCODING = 'iso-8859-1' 和 FIELD_OPTIONALLY_ENCLOSED_BY 设置为 NONE 时，下面是它显示的内容

在此处输入图像描述

标签： snowflake-cloud-data-platform

解决方案

On observing error message it's seems failing for encoding issue, Could you please try include ENCODING = 'iso-8859-1' parameter in file format.

If possible please share the sample record I will give a try on this.

推荐阅读