chenhan199207 opened a new issue, #3332:
URL: https://github.com/apache/doris-website/issues/3332
Path:/zh-CN/docs/4.x/data-operate/update/unique-update-concurrent-control
Maybe there is a problem on partial column update? The Broker Load is:
LOAD LABEL db1.label1
(
DATA INFILE("hdfs://host:port/user/data/*/test.txt")
INTO TABLE `tbl1`
COLUMNS TERMINATED BY ","
(k1,k2,source_sequence,v1,v2)
ORDER BY source_sequence
)
WITH BROKER 'broker'
(
"username"="user",
"password"="pass"
)
PROPERTIES
(
"timeout" = "3600"
);
it means the file is terminated by ","，and the third column is mapped to
modify_date as the sequence_col, however the input file is:
1 2020-02-22 1 2020-02-22 a
1 2020-02-22 1 2020-03-23 w
i think there are two question:
1.the file has no ',', the TERMINATED should be '\t' or some other
2.the third column is '1,1' ,which obviously mismatch modify_date, and
conflict which the blew explain，i think the correct Broker load should
be"COLUMNS TERMINATED BY "\t"
(k1,k2,v1,source_sequence,v2)"
<!-- Failed to upload "image.png" -->
--
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]
