4paradigm / 4paradigm/OpenMLDB

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

Abierto
#2,308 1 comentario 0 reacciones 1 asignado Reclamado por @aceforeverd Ver en GitHub
enhancement storage-engine
Lenguaje dominante
C++
Estrellas
1.7k
Forks
331
Merge medio
12 d 12 h
PR fusionados (30 d)
1

Descripción

**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](https://user-images.githubusercontent.com/18275570/183230570-17b495ed-a706-4591-963b-ca1f70829693.png)

**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

Guía de contribución

Abrir la guía de contribución

Línea de trabajo

Look for code that handles dropping procedures and deleting pre-aggregated tables. The issue mentions long window deployments and pre-aggregated tables. Search for terms like 'pre aggregated table', 'long window', and 'drop procedure' in the codebase. Check the SQL execution path and table lifecycle management. Verify the fix by testing the steps to reproduce: create table, deploy long window, drop procedure, and redeploy.

Escrito por el modelo de indexación a partir del texto del issue.

Evaluación

Stack tecnológico
databases, machine-learning, sql
Área
backend, databases, machine-learning
Tipo de issue
Error
Dificultad
3/5
Tiempo estimado
1-2 días
Estado de actividad
Estancado
Claridad
Bastante claro
Aptitud para principiantes
45/100

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.