256 Star 676 Fork 495

GVPopenGauss / openGauss-server

 / 详情

COPY命令导入最后一个字段带分隔符的数据异常

Backlog
Bug
Opened this issue  
2021-10-21 12:37

我有一个文本数据,里边存的是固定分隔符分隔的数据,且最后一个字段后也有分隔符,数据文件如下:
输入图片说明

在官方文档中发现copy有个EOL属性,可以指定文件换行符样式
输入图片说明

所以我使用copy命令且指定了EOL属性进行数据导入,命令执行出现异常如下
输入图片说明

我指定的EOL的值中并没有报错信息中提示的字符,不知道这个异常是怎么回事?

我要导入这种格式的文件我应该怎么使用copy命令?或者有别的导入方法?(文件可能很大)

Comments (1)

heyddo created缺陷
heyddo set related repository to openGauss/openGauss-server
Expand operation logs

Hey @heyddo , Welcome to openGauss Community.
All of the projects in openGauss Community are maintained by @opengauss-bot .
That means the developers can comment below every pull request or issue to trigger Bot Commands.
Please follow instructions at https://gitee.com/opengauss/community/blob/master/contributors/command.en.md to find the details.

zhangxubo added
 
sig/sqlengine
label

Sign in to comment

Status
Assignees
Projects
Milestones
Pull Requests
Successfully merging a pull request will close this issue.
Branches
Planed to start   -   Planed to end
-
Top level
Priority
Duration (hours)
Confirm
参与者(2)
5622128 opengauss bot 1581905080 4799517 heyddo 1578974683
C++
1
https://git.oschina.net/opengauss/openGauss-server.git
git@git.oschina.net:opengauss/openGauss-server.git
opengauss
openGauss-server
openGauss-server

Search

182229 41614e54 1850385 182230 7885ed45 1850385