lide-reed opened a new issue, #14098: URL: https://github.com/apache/doris/issues/14098
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Version The branch of branch-1.2-lts with following commit. commit 57e248e09b9c929cd4a0e52e198e11ca84c928ef Author: Xin Liao <liaoxin...@126.com> Date: Mon Oct 24 21:16:38 2022 +0800 [feature-wip](unique-key-merge-on-write) check whether the partition column is a key column when create table for MOW table (#13490) ### What's Wrong? mysql -h127.0.0.1 -uadmin -P9030 -Dtpch_1t -e 'select count(*) from lineitem;' count(*) 5339973878 curl --location-trusted -u admin:xxx -H 'column_separator:|' -H 'columns: l_orderkey, l_partkey, l_suppkey, l_linenumber, l_quantity, l_extendedprice, l_discount, l_tax, l_returnflag,l_linestatus, l_shipdate,l_commitdate,l_receiptdate,l_shipinstruct,l_shipmode,l_comment,temp' -T /data/tpch-tools/bin/tpch-data/lineitem/lineitem.tbl.9 http://172.16.48.76:8030/api/tpch_1t/lineitem/_stream_load % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 0 7714M 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 100 7714M 100 484 100 7714M 3 60.4M 0:02:41 0:02:07 0:00:34 05279976513 { "TxnId": 8438, "Label": "0fe42540-5693-44c9-97d5-4fb6ed5c5596", "TwoPhaseCommit": "false", "Status": "Success", "Message": "OK", "NumberTotalRows": 60005303, "NumberLoadedRows": 60005303, "NumberFilteredRows": 0, "NumberUnselectedRows": 0, "LoadBytes": 8089288459, "LoadTimeMs": 127485, "BeginTxnTimeMs": 0, "StreamLoadPutTimeMs": 0, "ReadDataTimeMs": 115732, "WriteDataTimeMs": 127466, "CommitAndPublishTimeMs": 15 } ----loaded /data/tpch-tools/bin/tpch-data/lineitem/lineitem.tbl.9 mysql -h127.0.0.1 -uadmin -P9030 -Dtpch_1t -e 'select count(*) from lineitem;' count(*) 16199937543 ### What You Expected? mysql -h127.0.0.1 -uadmin -P9030 -Dtpch_1t -e 'select count(*) from lineitem;' count(*) 5399979181 ### How to Reproduce? Create the Database and tables by tpch-tools in the code repository of Doris-1.2-lts, and then generate data with the scale of 1000 and 100 files. In the end, you can load data (you can modify the script only load lineitem and print count(*) after loading each time) so you can get the wrong result as following: 导入 | 行数 | 导入后count(*) | 导入后count(*) | 备注 -- | -- | -- | -- | -- 批次 | 应有结果 | 实际的结果 ... | ... | ... | ... | 此处连续导入1-85批次，每次导入后count(*)结果都正确 86 | 60007541 | 5159955335 | 5159955335 | 结果相符 87 | 60010970 | 5219966305 | 5219966305 | 结果相符 88 | 60010208 | 5279976513 | 5279976513 | 结果相符 89 | 59997365 | 5339973878 | 5339973878 | 结果相符 90 | 60005303 | 5399979181 | 16199937543 | 开始出错！相当于5399979181 x 3 91 | 60001584 | 5459980765 | 16379942295 | 错误，相当于5459980765 x 3 92 | 60004278 | 5519985043 | 16559955129 | 错误同上 93 | 59985988 | 5579971031 | 16739913093 | 错误同上 94 | 60006505 | 5639977536 | 16919932608 | 错误同上 95 | 59995948 | 5699973484 | 17099920452 | 错误同上 96 | 60001892 | 5759975376 | 17279926128 | 错误同上 97 | 60013641 | 5819989017 | 17459967051 | 错误同上 98 | 60007174 | 5879996191 | 17639988573 | 错误同上 99 | 59991125 | 5939987316 | 17819961948 | 错误同上 100 | 60002393 | 5999989709 | 17999969127 | 错误同上，相当于5999989709 x 3 ### 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
