daikon12 opened a new issue, #22718:
URL: https://github.com/apache/doris/issues/22718

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no 
similar issues.
   
   
   ### Version
   
   apache-doris-2.0-beta-bin-x64.tar.gz
   
   ### What's Wrong?
   
   通过csv文件更新表中4列数据,报错,说是列数不匹配,schema中是5列
   建表语句:
   CREATE TABLE `t_unique` (
     `dayno` date NOT NULL,
     `id` int(11) NOT NULL,
     `d1` text NULL,
     `d2` text NULL,
     `m1` int(11) NULL,
     `m2` int(11) NULL,
     `m3` bigint(20) NULL
   ) ENGINE=OLAP
   UNIQUE KEY(`dayno`, `id`)
   COMMENT 'OLAP'
   DISTRIBUTED BY HASH(`id`) BUCKETS 1
   PROPERTIES (
   "replication_allocation" = "tag.location.default: 1",
   "storage_format" = "V2",
   "enable_unique_key_merge_on_write" = "true",
   "light_schema_change" = "true",
   "deprecated_dynamic_schema" = "true",
   "disable_auto_compaction" = "false",
   "enable_single_replica_compaction" = "false"
   );
   
   导入语句
   curl  --location-trusted -u root: -H "partial_columns:true" -H 
"column_separator:,"  -H "enableDelete:false" -H "columns:dayno,id,d1,d2" -T 
/tmp/test.csv http://127.0.0.1:6030/api/demo/t_unique/_stream_load
   报错信息:
   Reason: actual column number in csv file is  less than  schema column 
number.actual number: 4, column separator: [,], line delimiter: [], schema 
column number: 5; . src line [2023-08-01,1,d1_v,d2_v];
   
   ### What You Expected?
   
   期待当提交和schema列数和实际数据列数匹配时,更新成功
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to