spaces-X opened a new issue #7910: URL: https://github.com/apache/incubator-doris/issues/7910
### 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 0.15 or 0.14 ### What's Wrong? Increase the default bucket num of and then the sql queried this table will encounter error `Index XXX out of bounds for length XXX`. See Reproduce SQL ### What You Expected? The SQL can run normally. ### How to Reproduce? ``` CREATE TABLE `bucket_test` ( `dt` bigint(20) NULL COMMENT "", `id1` bigint(20) NULL COMMENT "", `first_time` varchar(20) MIN NULL COMMENT "", `last_time` varchar(20) MAX NULL COMMENT "" ) ENGINE=OLAP AGGREGATE KEY(`dt`, `id1`) PARTITION BY RANGE(`dt`) ( PARTITION p1 VALUES [("20220101"),("20220201")), partition p2 VALUES [("20211201"),("20220101")) ) DISTRIBUTED BY HASH(`id1`) BUCKETS 1 PROPERTIES ( "replication_num" = "3", "in_memory" = "false", "storage_format" = "V2" ); insert into bucket_test values (20211201,1,"50","50"); insert into bucket_test values (20211201,2,"50","50"); insert into bucket_test values (20211201,3,"50","50"); insert into bucket_test values (20211201,4,"50","50"); alter table bucket_test modify distribution DISTRIBUTED BY HASH(id1) BUCKETS 20 select * from bucket_test where dt = 20211201 and id1 =1; ``` error `Index XXX out of bounds for length XXX`. ### Anything Else? Quick recovery SOP： First, Extract master node query traffic. If not recovered then restart fe-master ### 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: commits-unsubscr...@doris.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
