wangbo opened a new issue #2671: Batch Operate Rollup table in Doris URL: https://github.com/apache/incubator-doris/issues/2671 **Current Problem** Currently user can only execute add/drop/cancel rollup stmt one by one; When there are many rollup to deal with,user need to submit many stmt,it is not convenient to use; We can support batch operate for rollup stmt,so user can batch add many rollup table in one alter stmt. **Design Goal** * batch add rollup table ``` alter table table2 add rollup r2(event_day,siteid),add rollup r1(siteid,username); ``` * batch drop rollup table ``` alter table table2 drop rollup r2,drop rollup r1; ``` * batch cancel rollup job ``` cancel alter table rollup from topic_lineorder; ``` This is already supported,I think batch cancel job in table granularity is enough; Additionally, we need a new api to support cancel particular alter rollup job when there are many running alter rollup jobs; * cancel particular alter rollup job ``` cancel alter table rollup from table2 (12345,12346); ``` "12345,12346" is alter job id; **Some Question** 1. Whether concurrently executing alter rollup job? Yes;But need to limit job's concurrent size; Alter task in same BE executes sequentially,but alter task in different BE execute concurrently. By default, set job's concurrent size to 1. 2. What do we do when pre-check status is out-of-date and causes task failed? User execute new stmt to retry; Before submit a alter job,Doris will check replica's status, such as whether the replica is normal; In the batch submit situation,Doris doing pre-check when batch submit alter job,but when the task actually begins working,the status maybe already out-of-date,such as the replica's status is not normal.In this situation,I think user retry manually is ok.
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
