apache / apache/paimon

[Feature] Support for Repair Procedure for JDBC catalog

Open
#7,287 0 comments 0 reactions 0 assignees View on GitHub
enhancement
Dominant language
Java
Stars
3.4k
Forks
1.4k
Avg merge
1d 11h
Merged PRs (30d)
396

Description

### Search before asking

- [x] I searched in the [issues](https://github.com/apache/paimon/issues) and found nothing similar.

### Motivation

There is a repair procedure that supports syncing tables inside a filesystem to HiveCatalog. Similar needs to be supported for JdbcCatalog. This enables migration to JdbcCatalog easier. For repairs, I would only be interested in creation of the database/tables and would avoid deletion, as typos in warehouse path can lead to deletion inside Jdbc Catalogs.

### Solution

Implementing the repairDatabase and repairTable methods.

### Anything else?

_No response_

### Are you willing to submit a PR?

- [x] I'm willing to submit a PR!

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by locating the repairDatabase and repairTable methods and then read the existing filesystem-to-HiveCatalog repair procedure for its behavior. Compare that flow with JdbcCatalog; done means supporting database and table creation while avoiding deletion during repairs.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
database
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.