cambyzju opened a new issue, #55272: URL: https://github.com/apache/doris/issues/55272
### 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 2.1.x 3.0.x ### What's Wrong? "[ANALYSIS_ERROR]TStatus: errCode = 2, detailMessage = can not cast from origin type varchar(65533) to target type=invalid_type" ### What You Expected? stream load successfullly ### How to Reproduce? 1. create table + mv + drop column: ``` create table test_for_bug (k1 int, v1 int, v2 string) duplicate key(k1) properties("replication_num"="1"); create materialized view test_for_bug_uv as select k1,count(v2) from test_for_bug group by k1; alter table test_for_bug drop column v1; ``` 2. prepare data for stream load: ``` % cat test.csv 3|4 ``` 3. trigger stream load: ``` curl --location-trusted -u root: \ -H "Expect:100-continue" \ -H "column_separator:|" \ -H "columns:k1,v2" \ -T test.csv \ -XPUT http://127.0.0.1:8030/api/example_db/test_for_bug/_stream_load ``` We got following error message: ``` { "TxnId": 3051, "Label": "13f9caf1-00f4-40ff-a8be-727974dbcd32", "Comment": "", "TwoPhaseCommit": "false", "Status": "Fail", "Message": "[ANALYSIS_ERROR]TStatus: errCode = 2, detailMessage = can not cast from origin type varchar(65533) to target type=invalid_type", "NumberTotalRows": 0, "NumberLoadedRows": 0, "NumberFilteredRows": 0, "NumberUnselectedRows": 0, "LoadBytes": 0, "LoadTimeMs": 0, "BeginTxnTimeMs": 0, "StreamLoadPutTimeMs": 1, "ReadDataTimeMs": 0, "WriteDataTimeMs": 0, "ReceiveDataTimeMs": 0, "CommitAndPublishTimeMs": 0 } ``` ### 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]
