使用stream load 方式导入csv文件报错 #51034
Unanswered
Recallldian
asked this question in
A - General / Q&A
Replies: 2 comments
-
doris 1.2版本 |
Beta Was this translation helpful? Give feedback.
0 replies
-
建议你使用json格式 |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
报错情况: 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
不清楚为什么无法处理带逗号的情况,我看官方文档使用包围符就行,但是使用了也无法解决
Beta Was this translation helpful? Give feedback.
All reactions