使用stream load 方式导入csv文件时,按照官网设置包围符和转义符不生效,报错

Viewed 6

报错情况: Reason: actual column number in csv file is more than schema column number.actual number: 378, column separator: [,], line delimiter: [
], schema column number: 374; . src line [1131,'2024-01-29 18:18:24.0',10049370,'578208424251',1988,1,'','notebook','','颜色分类:黄色','nb-yellow',2.0000,1,'2个1箱',0,'KH201907030002',0,'188655-00816','bula','haha',0,'haha',0,\N,\N,\N,\N,\N,\N,\N,\N,\N,\N,'无',0,18,-1,0,0,1,0,'','',0,56,0.0000,'4201-1',1.0000,0.0000,0,32,1.0000,'','','https://img1.baidu.com/it/u=4081766236,921479001&fm=253&fmt=auto&app=138&f=JPEG?w=500&h=500',5.0000,20.0000,20.0000,0.0000,60,'',20.0000,'','显示屏','4201',41,0.0000,1,0,0,2.0000,67,0.0000,7.0000,'gyy666688','123,456','','2024-01-29 18:03:28.0',0.0000,'哈哈哈',0,0,0,'','',1,2,0.0000,0.0000,27.0000,'29775155482d6e303d3db7b96546790a','3718792553','2023-12-15 16:18:10.0','',30,\N,\N,\N,\N,\N,\N,\N,'',\N,'578208424251','笔记本 新品 赠品 测试勿拍【周期购2023-08-10】','notebook','',3,2.0000,'9244933101',0,0,0,0.0000,10.0000,0.0000,'',0,'123','','','3830638324377','颜色分类:橙色 赠品 【周期购2024-07-28】','nb-oranges',33.3000,'2023-12-15 16:18:10.0',0,'','','',0,103,0,0.0000,0.0000,'2024-01-29 18:16:11.0',295,0,0.0000,0.0000,\N,0.0000,0,'我是高筱原',0,0,0,0,8,0.0000,0.0000,6.0000,2,0,1,0,'',61,'ZS202401290037','',1,0,'',0.0000,0,'',1,'',0.0000,75.0000,'',-75.0000,2.0000,1,0.0000,'潘家园11111','北京 北京市 丰台区',110100,0,110106,'北京市 丰台区','15043769554','gyy666688',110000,'','','','+86-1234567','014500',1,59,0,0,0,'',259,'2021081121','3718792553',0.0000,1,2097153,0,2050,'JY202401290073',0.0000,110,1,3,140.0000,330,0,64.0000,1,'2023-08-23 00:00:00',0.0000,0,\N,\N,\N,0.0000,'笔记本 新品 赠品 测试勿拍【周期购2023-08-10】','颜色分类:橙色 赠品 【周期购2024-07-28】',0,0,0.0000,0,1,0.0000,'',0,0,16777216,8,1244,'联想电脑','4201',1,4.0000,0.0000,0.0000,1,0.0000,1,1.0000,0,'123',0.0000,0.0000,1988,'显示屏','9244933101','3718792553',0.0000,0.0000,154,'高筱原的电脑','2021081121',2.0000,0,7033593,\N,\N,\N,\N,\N,\N,\N,\N,'4201,呵呵哈哈哈或,【拆分发货,物流单号ZS202401290037】','123,456',\N,\N,\N,\N,\N,\N,\N,'',0,0,75.0000,64.0000,40.0000,0,0,103,'2024-01-29 18:17:08.0',0,'',0,0,0,6.0000,2,1,0,0,0,0,61,'ZS202401290037','f31f5b44541e50372204c5dd0b32322c',0,103,0,0,0,0,'',0,0,0,'',0,7033593,'JY202401290073',1,110,117278,'CK2024012998',75.0000,64.0000,538976256,398015,0,0,10.0000,0.0000,\N,0,4.0000,0.0000,'123',0,0,1988,10049370,0,1.0000,0,\N,\N,0.0000,'',6.0000,2,0,\N,\N,\N,\N,\N,\N,\N,\N,\N,\N,\N,\N,\N,\N,\N,\N,'东升的tb店铺','wdsTbShop','高筱原的仓库1','20201027',1,1,1,1,1,1];

使用的请求方式:
curl --location-trusted -u "hjsdy_sdas:123sad"
-H "Expect:100-continue" ^
-H "format:csv" ^
-H "column_separator:," ^
-H “trim_double_quotes:true”^
-H "enclose:'" ^
-H "escape:" ^
-T "D:\project3.0\branches\test\cache\doris_csv\doris_2349787311738298263.csv" ^
-XPUT http://12312346:30004/api/hjy_dw/test/_stream_load

不清楚为什么无法处理带逗号的情况,我看官方文档使用包围符和转义符处理能行,但是实际无法导入

doris 版本:1.2

1 Answers