luozenglin opened a new issue, #12683: URL: https://github.com/apache/doris/issues/12683
### 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 master ### What's Wrong? `NumberFilteredRows` is not as expected when stream load is set to strict mode ### What You Expected? `NumberFilteredRows` meets expectations ### How to Reproduce? ``` CREATE TABLE `test_stream_load_strict` ( `k1` bigint(20) NULL, `k2` bigint(20) NULL, `v1` tinyint(4) SUM NULL, `v2` tinyint(4) REPLACE NULL, `v3` tinyint(4) REPLACE_IF_NOT_NULL NULL, `v4` smallint(6) REPLACE_IF_NOT_NULL NULL, `v5` int(11) REPLACE_IF_NOT_NULL NULL, `v6` bigint(20) REPLACE_IF_NOT_NULL NULL, `v7` largeint(40) REPLACE_IF_NOT_NULL NULL, `v8` datetime REPLACE_IF_NOT_NULL NULL, `v9` date REPLACE_IF_NOT_NULL NULL, `v10` char(10) REPLACE_IF_NOT_NULL NULL, `v11` varchar(6) REPLACE_IF_NOT_NULL NULL, `v12` decimal(27, 9) REPLACE_IF_NOT_NULL NULL ) ENGINE=OLAP AGGREGATE KEY(`k1`, `k2`) COMMENT 'OLAP' PARTITION BY RANGE(`k1`) (PARTITION partition_a VALUES [("-9223372036854775808"), ("100000")), PARTITION partition_b VALUES [("100000"), ("1000000000")), PARTITION partition_c VALUES [("1000000000"), ("10000000000")), PARTITION partition_d VALUES [("10000000000"), (MAXVALUE))) DISTRIBUTED BY HASH(`k1`, `k2`) BUCKETS 3 PROPERTIES ( "replication_allocation" = "tag.location.default: 1", "in_memory" = "false", "storage_format" = "V2", "disable_auto_compaction" = "false" ); > cat replace_if_not_null_data_some -2 -50 1 \N j curl --location-trusted -u root: -H "label:sdpasdls" -H "timeout:100" -H "partitions: partition_a, partition_b, partition_c, partition_d" -H "columns: k1, k2, v2, v10, v11" -H "strict_mode: true" -H "column_separator:\t" -T replace_if_not_null_data_some http://xxxx:xxxx/api/test_stream_load_strictdb/test_stream_load_strict/_stream_load { "TxnId": 7023, "Label": "sdpasdls", "TwoPhaseCommit": "false", "Status": "Fail", "Message": "too many filtered rows", "NumberTotalRows": 1, "NumberLoadedRows": 0, "NumberFilteredRows": 1, "NumberUnselectedRows": 0, "LoadBytes": 14, "LoadTimeMs": 59, "BeginTxnTimeMs": 1, "StreamLoadPutTimeMs": 4, "ReadDataTimeMs": 0, "WriteDataTimeMs": 50, "CommitAndPublishTimeMs": 0, "ErrorURL": "http://xxxx:xxxx/api/_load_error_log?file=__shard_0/error_log_insert_stmt_fd4d48366b34c332-72f4b5443807dd9b_fd4d48366b34c332_72f4b5443807dd9b"; } ``` ### Anything Else? _No response_ ### Are you willing to submit PR? - [X] 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]
