4paradigm / OpenMLDB

OpenMLDB is an open-source machine learning database that provides a feature platform computing consistent features for training and inference.
https://openmldb.ai
Apache License 2.0
1.6k stars 320 forks source link

delete pre-agg tables if user going to drop the long window deployment #2308

Open wuyou10206 opened 2 years ago

wuyou10206 commented 2 years ago

Bug Description Long window, delete the procedure after deploy, but the pre aggregated table will not be deleted. If you create a long window with the same name and function again, you will be prompted that the pre aggregated table already exists. image

Expected Behavior When deleting the procedure, the pre aggregated table should be deleted at the same time.

Steps to Reproduce

  1. create table
  2. deploy one long window
  3. drop procedure
  4. deploy long window
aceforeverd commented 2 years ago

True in current version (v0.5.3).

U should delete pre agg tables manually or delete the main table (all related pre-agg tables will be deleted).

Left this as a future enhancement.