4paradigm / 4paradigm/OpenMLDB

pre-aggregation table migration

Open
#1,488 0 comments 0 reactions 1 assignee Claimed by @zhanghaohit View on GitHub
enhancement
Dominant language
C++
Stars
1.7k
Forks
331
Avg merge
12d 12h
Merged PRs (30d)
1

Description

**Describe the feature you'd like**
Pre-aggregation tables should be migrated automatically with base table.

Currently the pre-aggregation tables are co-partitioned with base tables. So if we are going to migrate the base table, we have to migrate the pre-aggregation tables at the same time.

Users can manually check what are the pre-aggregation tables associated with the base table and migrate manually. However it's better to do the migration of pre-aggregation tables automatically.

Contributor guide

Open the contributing guide

Research direction

The issue is about automating migration of co-partitioned pre-aggregation tables when a base table is migrated. Start by locating the table migration logic in the codebase, then identify how pre-aggregation tables are defined and linked to base tables. Understanding the partitioning scheme and the existing migration commands is key. The goal is to extend the migration process to automatically include these dependent tables.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases, machine-learning
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.