liutang123 commented on issue #64122:
URL: https://github.com/apache/doris/issues/64122#issuecomment-4628813039
```
CREATE TABLE tbl_del_big (
k INT NOT NULL,
v VARCHAR(64) NULL
)
UNIQUE KEY(k)
DISTRIBUTED BY HASH(k) BUCKETS 64
PROPERTIES (
"replication_num" = "1",
"enable_unique_key_merge_on_write" = "true"
);
INSERT INTO tbl_del_big SELECT number, NULL FROM numbers("number"="2000000");
INSERT INTO tbl_del_big SELECT number * 64 + 1, 'x' FROM
numbers("number"="1");
DELETE FROM tbl_del_big WHERE k % 2 = 0 AND v IS NULL;
SELECT SLEEP(70);
ANALYZE TABLE tbl_del_big (v) WITH SAMPLE PERCENT 1 WITH SYNC;
```
error:
```
ERROR 1105 (HY000): RuntimeException, msg: java.lang.RuntimeException:
Failed to analyze following columns:[v] Reasons: java.lang.RuntimeException:
ColStatsData is invalid, skip analyzing.
('1778652589664--1-v',0,1774839303529,1778652589664,-1,'v',null,3000001,0,1562400,'x','x',0,'2026-06-05
14:24:35')
```
--
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]
