databend
databend copied to clipboard
feat: task_advice system table
Summary
Add a system table for advice the background serivice:
catalog_name | database_name | table_name | task_type | need_run | task_sql | reason(variant) |
---|---|---|---|---|---|---|
default | db | xx | COMPACT | 1 | optimize table xx compact limit 3 | "{status in json}" |
default | db | xx | AGGREGATING_INDEX | 0 | refresh aggregating index xx_agg_idx limit 10 | "{status in json}" |
default | db | yy | ADD_CLUSTER_KEY | 1 | alter table yy cluster by(col1) | "{status in json}" |